解决方案 »
- 求个当月金币解决方案,怎么统计本月的金币到总金币里,一个月汇总一次
- 在线考试系统
- ASP.NET中如何控制显示隐藏控件
- 单IP 限制连接数
- exec('alter table Role_total add '+@DB+' nvarchar(50) null')这句不知问题在哪里?
- 如何设置GetProductsItems方法返回SqlDataReader改成返回DataTable
- 帮我设计一下主页实现方式
- 加多100分,求刚才问题的答案(如何筛选DataTable中的记录)
- (Lostinet)迷失网络-闪电论坛 - 0.0.4.2 测试版发布(只放两天)
- 请问怎么调试asp.net的脚本?
- SQL 分组查询问题
- 关于.net 转 JAVA
{
string username = Request["txtName"];
string userpwd = Request["txtPassword"];
DateTime UserTime = DateTime.Now;
using (SqlConnection strcon = new SqlConnection(MonitoringSystemConfiguration.DbConnectionString))
{
using (SqlCommand scd = new SqlCommand("select id,enabled,operation as ff from s_user where login_name='" + username + "' and password='" + new RSA(System.Text.Encoding.Unicode.GetString(Convert.FromBase64String(ConfigurationManager.AppSettings["privateKey"]))).Encrypt(userpwd) + "'", strcon))
{
strcon.Open();
SqlDataReader reader = scd.ExecuteReader();
if (reader.Read())
{
int id = reader.GetInt32(0);
bool count = reader.GetBoolean(1);
int role = reader.GetInt16(2);
reader.Close();
if (count)
{
Session["UserId"] = id;
Session["txtName"] = username;
Session["txtPassword"] = userpwd;
Session["operation"] = role; string N_IP; N_IP = Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
if (N_IP == null || N_IP == "")
{
N_IP = Request.ServerVariables["REMOTE_ADDR"];
} scd.CommandText = "insert into d_loging (UserID,IP,UserTime)values(@N_User,@N_IP,@UserTime)";
SqlParameter para = new SqlParameter("@username", SqlDbType.VarChar, 20);
para.Value = username;
scd.Parameters.Add(para);
para = new SqlParameter("@N_User", SqlDbType.Int);
para.Value = id;
scd.Parameters.Add(para);
para = new SqlParameter("@N_IP", SqlDbType.VarChar, 30);
para.Value = N_IP;
scd.Parameters.Add(para);
para = new SqlParameter("@UserTime", SqlDbType.DateTime);
para.Value = UserTime;
scd.Parameters.Add(para);
scd.ExecuteNonQuery(); string tt = " qminoa = window.open('index.aspx" + "'"
+ ",'','toolbar=no,menubar=no,titlebar=yes,location=no,scrollbars=no,directories=no,resizable=yes,status=yes,fullscreen=no,top=0;left=0,width=900,height=700');";
Response.Write("<script language=javascript>");
Response.Write(tt);
Response.Write("qminoa.moveTo(0,0);");
Response.Write("qminoa.resizeTo(screen.availWidth,screen.availHeight);");
Response.Write("window.opener=null;");
Response.Write("window.close();");
Response.Write("</script>");
}
else
{
Response.Write("<script>alert('该用户已经被禁用,请联系管理员!');history.back()</script>");
return;
}
}
else
{
Response.Write("<script>alert('用户名或者密码错误,请重新输入!');history.back()</script>");
return;
}
}
}
http://bbs.csdn.net/topics/390058757
看看这两篇,都是关于快钱支付提示这个错误的问题。希望对你有帮助。
*****************************************************************************
签名档: http://feiyun0112.cnblogs.com/