17,740
社区成员
发帖
与我相关
我的任务
分享
private void login(string userid, string password)
{
if ((Strings.Trim(userid).Length <= 0) & (Strings.Trim(password).Length > 0))
{
ClassShared.aspShowMessagebox("用户名和密码不能为空!", "-1", false);
}
else
{
string sql = "select top 1 * from sys_user where userid=@v0";
SqlConnection cN = null;
DataSet set = base.mZSF.GetDataSet(sql, new SqlDbType[] { SqlDbType.NVarChar }, new string[] { userid }, ref cN, 0, 0, "@V");
if (set.Tables[0].Rows.Count <= 0)
{
ClassShared.aspShowMessagebox("用户名不存在!", "-1", false);
}
else if (!ClassPwd.encryptBIZpassword(password).Equals(Convert.ToString(RuntimeHelpers.GetObjectValue(set.Tables[0].Rows[0]["password"]))))
{
ClassShared.aspShowMessagebox("密码不正确!", "-1", false);
}
else
{
int num = (int) Math.Round(Conversion.Val(Convert.ToString(RuntimeHelpers.GetObjectValue(set.Tables[0].Rows[0]["id"]))));
ClassUser.userLoginCount = (int) Math.Round((double) (Conversion.Val(Convert.ToString(RuntimeHelpers.GetObjectValue(set.Tables[0].Rows[0]["logincount"]))) + 1.0));
sql = ("update sys_user set last_login=CURRENT_TIMESTAMP,logincount=" + ClassUser.userLoginCount.ToString()) + " where id=" + Conversions.ToString(num);
cN = null;
base.mZSF.ExecuteCommand(sql, null, null, ref cN, "@V");
string expression = Convert.ToString(RuntimeHelpers.GetObjectValue(set.Tables[0].Rows[0]["pagelast"]));
if (Information.IsDate(expression))
{
ClassUser.currentUserTemplatePageLast = Conversions.ToDate(expression);
}
else
{
ClassUser.currentUserTemplatePageLast = DateAndTime.Now.AddYears(-1);
}
ClassUser.userFlag = ClassUser.convertUserGradeToType(Convert.ToString(RuntimeHelpers.GetObjectValue(set.Tables[0].Rows[0]["grade"])));
ClassUser.currentMemberLevel = (int) Math.Round(Conversion.Val(Convert.ToString(RuntimeHelpers.GetObjectValue(set.Tables[0].Rows[0]["mlevel"]))));
ClassUser.currentUserid = Convert.ToString(RuntimeHelpers.GetObjectValue(set.Tables[0].Rows[0]["userid"]));
ClassUser.currentUserNumericID = num;
ClassUser.lastLoginTime = Convert.ToString(RuntimeHelpers.GetObjectValue(set.Tables[0].Rows[0]["last_login"]));
ClassUser.registerTime = Convert.ToString(RuntimeHelpers.GetObjectValue(set.Tables[0].Rows[0]["first_login"]));
ClassUser.currentuserMSNID = Convert.ToString(RuntimeHelpers.GetObjectValue(set.Tables[0].Rows[0]["msnid"]));
this.Response.Redirect("default.aspx");
}
}
}