/// <summary>
/// 检测用户输入的登录用户名与密码是否一直
/// </summary>
/// <param name="aUserName"></param>
/// <param name="aPwd"></param>
/// <param name="isExpire">过期</param>
/// <returns></returns>
protected bool CheckUserLogin(string aUserName, string aPwd, out bool isExpire)
{
isExpire = false;
string aTmpPwdMd5 = this.DoMd5(aPwd);
try
{
string con = ConfigContext.GetInstance().DataBaseSettingProvider.SimpleManagerConnstring;
string sSqlExist = "select * from GameOA.dbo.OA_User where UserName=@aUserName";
SqlParameter[] paramsLogin = new SqlParameter[1];
paramsLogin[0] = SqlParamHelper.MakeInParam("@aUserName", SqlDbType.VarChar, 0, aUserName);
using (SqlDataReader loginReader = SqlHelper.ExecuteReader(con, CommandType.Text, sSqlExist, paramsLogin))
{
if (loginReader == null)
{
return false;
}
else
{
if (loginReader.HasRows && loginReader.Read())
{
DateTime expireDate = ConvertHelper.ToDateTime(loginReader["pwdmodifydate"]);
if (expireDate.AddDays(oa_changepwd_day) < DateTime.Now)//30天过期
{
isExpire = true;
}
if (Convert.ToString(loginReader["UserPassword"]) == aTmpPwdMd5)
{
BaseCookie oBaseSession = new BaseCookie();
oBaseSession.SaveCookie(loginReader, 4 * 60);
string sql = @"INSERT INTO [GameOA].[dbo].[LoginLog]([LoginIP],[LoginID],[LoginTime])VALUES(@LoginIP,@LoginID,getdate())";
string LoginIP = HttpContext.Current.Request.ServerVariables["REMOTE_ADDR"];
SqlParameter[] paramsList = new SqlParameter[]{
SqlParamHelper.MakeInParam("@LoginIP", SqlDbType.VarChar, 0, LoginIP),
SqlParamHelper.MakeInParam("@LoginID", SqlDbType.VarChar, 20, aUserName)
};
SqlHelper.ExecuteNonQuery(con, CommandType.Text, sql, paramsList);
return true;
}
else
{
return false;
}
}
else
{
return false;
}
}
}
}
catch
{
return false;
}
}
/// <summary>
/// 检测用户输入的登录用户名与密码是否一直
/// </summary>
/// <param name="aUserName"></param>
/// <param name="aPwd"></param>
/// <param name="isExpire">过期</param>
/// <returns></returns>
protected bool CheckUserLogin(string aUserName, string aPwd, out bool isExpire)
{
isExpire = false;
string aTmpPwdMd5 = this.DoMd5(aPwd);
try
{
string con = ConfigContext.GetInstance().DataBaseSettingProvider.SimpleManagerConnstring;
string sSqlExist = "select * from GameOA.dbo.OA_User where UserName=@aUserName";
SqlParameter[] paramsLogin = new SqlParameter[1];
paramsLogin[0] = SqlParamHelper.MakeInParam("@aUserName", SqlDbType.VarChar, 0, aUserName);
using (SqlDataReader loginReader = SqlHelper.ExecuteReader(con, CommandType.Text, sSqlExist, paramsLogin))
{
if (loginReader == null)
{
return(false);
}
else
{
if (loginReader.HasRows && loginReader.Read())
{
DateTime expireDate = ConvertHelper.ToDateTime(loginReader["pwdmodifydate"]);
if (expireDate.AddDays(oa_changepwd_day) < DateTime.Now)//30天过期
{
isExpire = true;
}
if (Convert.ToString(loginReader["UserPassword"]) == aTmpPwdMd5)
{
BaseCookie oBaseSession = new BaseCookie();
oBaseSession.SaveCookie(loginReader, 4 * 60);
string sql = @"INSERT INTO [GameOA].[dbo].[LoginLog]([LoginIP],[LoginID],[LoginTime])VALUES(@LoginIP,@LoginID,getdate())";
string LoginIP = HttpContext.Current.Request.ServerVariables["REMOTE_ADDR"];
SqlParameter[] paramsList = new SqlParameter[] {
SqlParamHelper.MakeInParam("@LoginIP", SqlDbType.VarChar, 0, LoginIP),
SqlParamHelper.MakeInParam("@LoginID", SqlDbType.VarChar, 20, aUserName)
};
SqlHelper.ExecuteNonQuery(con, CommandType.Text, sql, paramsList);
return(true);
}
else
{
return(false);
}
}
else
{
return(false);
}
}
}
}
catch
{
return(false);
}
}
protected void DoLogOut()
{
BaseCookie oBaseCookie = new BaseCookie();
oBaseCookie.CleanCookie();
}
protected void DoLogOut()
{
BaseCookie oBaseCookie = new BaseCookie();
oBaseCookie.CleanCookie();
}
