/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Model.t_log_login model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into t_log_login(");
strSql.Append("ID,UserID,IPAddress,LoginDate,LastLogin,ClientInfo)");
strSql.Append(" values (");
strSql.Append("@ID,@UserID,@IPAddress,@LoginDate,@LastLogin,@ClientInfo)");
MySqlParameter[] parameters =
{
new MySqlParameter("@ID", MySqlDbType.VarChar, 36),
new MySqlParameter("@UserID", MySqlDbType.VarChar, 36),
new MySqlParameter("@IPAddress", MySqlDbType.VarChar, 20),
new MySqlParameter("@LoginDate", MySqlDbType.DateTime),
new MySqlParameter("@LastLogin", MySqlDbType.DateTime),
new MySqlParameter("@ClientInfo", MySqlDbType.VarChar, 255)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.UserID;
parameters[2].Value = model.IPAddress;
parameters[3].Value = model.LoginDate;
parameters[4].Value = model.LastLogin;
parameters[5].Value = model.ClientInfo;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.t_log_login DataRowToModel(DataRow row)
{
Model.t_log_login model = new Model.t_log_login();
if (row != null)
{
if (row["ID"] != null)
{
model.ID = row["ID"].ToString();
}
if (row["UserID"] != null)
{
model.UserID = row["UserID"].ToString();
}
if (row["IPAddress"] != null)
{
model.IPAddress = row["IPAddress"].ToString();
}
if (row["LoginDate"] != null && row["LoginDate"].ToString() != "")
{
model.LoginDate = DateTime.Parse(row["LoginDate"].ToString());
}
if (row["LastLogin"] != null && row["LastLogin"].ToString() != "")
{
model.LastLogin = DateTime.Parse(row["LastLogin"].ToString());
}
if (row["ClientInfo"] != null)
{
model.ClientInfo = row["ClientInfo"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.t_log_login model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update t_log_login set ");
strSql.Append("UserID=@UserID,");
strSql.Append("IPAddress=@IPAddress,");
strSql.Append("LoginDate=@LoginDate,");
strSql.Append("LastLogin=@LastLogin,");
strSql.Append("ClientInfo=@ClientInfo");
strSql.Append(" where ID=@ID ");
MySqlParameter[] parameters =
{
new MySqlParameter("@UserID", MySqlDbType.VarChar, 36),
new MySqlParameter("@IPAddress", MySqlDbType.VarChar, 20),
new MySqlParameter("@LoginDate", MySqlDbType.DateTime),
new MySqlParameter("@LastLogin", MySqlDbType.DateTime),
new MySqlParameter("@ClientInfo", MySqlDbType.VarChar, 255),
new MySqlParameter("@ID", MySqlDbType.VarChar, 36)
};
parameters[0].Value = model.UserID;
parameters[1].Value = model.IPAddress;
parameters[2].Value = model.LoginDate;
parameters[3].Value = model.LastLogin;
parameters[4].Value = model.ClientInfo;
parameters[5].Value = model.ID;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.t_log_login GetModel(string ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,UserID,IPAddress,LoginDate,LastLogin,ClientInfo from t_log_login ");
strSql.Append(" where ID=@ID ");
MySqlParameter[] parameters =
{
new MySqlParameter("@ID", MySqlDbType.VarChar, 36)
};
parameters[0].Value = ID;
Model.t_log_login model = new Model.t_log_login();
DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/*
* /// <summary>
* /// 分页获取数据列表
* /// </summary>
* public DataSet GetList(int PageSize,int PageIndex,string strWhere)
* {
* MySqlParameter[] parameters = {
* new MySqlParameter("@tblName", MySqlDbType.VarChar, 255),
* new MySqlParameter("@fldName", MySqlDbType.VarChar, 255),
* new MySqlParameter("@PageSize", MySqlDbType.Int32),
* new MySqlParameter("@PageIndex", MySqlDbType.Int32),
* new MySqlParameter("@IsReCount", MySqlDbType.Bit),
* new MySqlParameter("@OrderType", MySqlDbType.Bit),
* new MySqlParameter("@strWhere", MySqlDbType.VarChar,1000),
* };
* parameters[0].Value = "t_rol_user";
* parameters[1].Value = "ID";
* parameters[2].Value = PageSize;
* parameters[3].Value = PageIndex;
* parameters[4].Value = 0;
* parameters[5].Value = 0;
* parameters[6].Value = strWhere;
* return DbHelperMySQL.RunProcedure("UP_GetRecordByPage",parameters,"ds");
* }*/
#endregion BasicMethod
#region ExtensionMethod
public Model.t_rol_user Login(string userName, string userPwd, Model.t_log_login logModel)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" call P_ROL_UserLogin (");
strSql.Append("?UserName,?UserPwd,?ID,?IPAddress,?LoginDate,?ClientInfo)");
MySqlParameter[] parameters =
{
new MySqlParameter("?UserName", MySqlDbType.VarChar, 255),
new MySqlParameter("?UserPwd", MySqlDbType.VarChar, 255),
new MySqlParameter("?ID", MySqlDbType.VarChar, 36),
new MySqlParameter("?IPAddress", MySqlDbType.VarChar, 20),
new MySqlParameter("?LoginDate", MySqlDbType.DateTime),
new MySqlParameter("?ClientInfo", MySqlDbType.VarChar, 255)
};
parameters[0].Value = userName;
parameters[1].Value = userPwd;
parameters[2].Value = logModel.ID;
parameters[3].Value = logModel.IPAddress;
parameters[4].Value = logModel.LoginDate;
parameters[5].Value = logModel.ClientInfo;
Model.t_rol_user model = new Model.t_rol_user();
DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["ID"] != null)
{
model.ID = ds.Tables[0].Rows[0]["ID"].ToString();
}
if (ds.Tables[0].Rows[0]["Username"] != null)
{
model.Username = ds.Tables[0].Rows[0]["Username"].ToString();
}
if (ds.Tables[0].Rows[0]["Password"] != null)
{
model.Password = ds.Tables[0].Rows[0]["Password"].ToString();
}
if (ds.Tables[0].Rows[0]["FirstName"] != null)
{
model.FirstName = ds.Tables[0].Rows[0]["FirstName"].ToString();
}
if (ds.Tables[0].Rows[0]["LastName"] != null)
{
model.LastName = ds.Tables[0].Rows[0]["LastName"].ToString();
}
if (ds.Tables[0].Rows[0]["Mobile"] != null)
{
model.Mobile = ds.Tables[0].Rows[0]["Mobile"].ToString();
}
if (ds.Tables[0].Rows[0]["TelNum"] != null)
{
model.TelNum = ds.Tables[0].Rows[0]["TelNum"].ToString();
}
if (ds.Tables[0].Rows[0]["Address"] != null)
{
model.Address = ds.Tables[0].Rows[0]["Address"].ToString();
}
if (ds.Tables[0].Rows[0]["Country"] != null)
{
model.Country = ds.Tables[0].Rows[0]["Country"].ToString();
}
if (ds.Tables[0].Rows[0]["CreatedDate"] != null && ds.Tables[0].Rows[0]["CreatedDate"].ToString() != "")
{
model.CreatedDate = DateTime.Parse(ds.Tables[0].Rows[0]["CreatedDate"].ToString());
}
if (ds.Tables[0].Rows[0]["IsValid"] != null && ds.Tables[0].Rows[0]["IsValid"].ToString() != "")
{
model.IsValid = int.Parse(ds.Tables[0].Rows[0]["IsValid"].ToString());
}
if (ds.Tables[0].Rows[0]["RoleID"] != null)
{
model.RoleID = ds.Tables[0].Rows[0]["RoleID"].ToString();
}
return(model);
}
else
{
return(null);
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.Buffer = true;
context.Response.ExpiresAbsolute = DateTime.Now.AddDays(-1);
context.Response.AddHeader("pragma", "no-cache");
context.Response.AddHeader("cache-control", "");
context.Response.CacheControl = "no-cache";
context.Response.ContentType = "text/plain";
string strUserName = StringClass.EncodeString(context.Request.Form["txtUserName"].Trim());
string strOldPwd = StringClass.EncodeString(context.Request.Form["txtUserPwd"]);
string strUserPwd = StringClass.EncryptPassword(context.Request.Form["txtUserPwd"], StringClass.PasswordFormat.MD5_32);
bool IsRemember = context.Request.Form["remember"] != null ? true : false;
if (String.IsNullOrEmpty(strUserName))
{
context.Response.Write("Please enter your email as user name！");
return;
}
else
{
strUserName = StringClass.RemoveSQL(strUserName.ToLower());
}
if (String.IsNullOrEmpty(strOldPwd))
{
context.Response.Write("Please enter your password！");
return;
}
else
{
strUserPwd = StringClass.EncryptPassword(strOldPwd, StringClass.PasswordFormat.MD5_32).ToLower();
}
if (context.Session["ValidateCode"] != null)
{
if (context.Request.Form["txtUserVal"].Trim() != context.Session["ValidateCode"].ToString())
{
context.Response.Write("Validation Code is not correct！");
return;
}
}
string error = "";
Model.t_log_login loginLog = new Model.t_log_login();
loginLog.ID = Guid.NewGuid().ToString().ToLower();
loginLog.LoginDate = DateTime.Now;
loginLog.IPAddress = context.Request.ServerVariables["REMOTE_ADDR"] != null ? context.Request.ServerVariables["REMOTE_ADDR"].Trim() : "";
loginLog.ClientInfo = context.Request.ServerVariables["Http_User_Agent"];
Model.t_rol_user user = (new BLL.t_rol_user()).Login(strUserName, strUserPwd, loginLog);
if (user != null && user.Password.ToLower() == strUserPwd.ToLower())
{
if (user.IsValid > 0)
{
try
{
HttpCookie Cookie = new HttpCookie("UserCookie");
if (IsRemember)
{
Cookie.Expires = DateTime.Now.AddDays(7);
}
else
{
Cookie.Expires = DateTime.Now.AddDays(-1);
}
Random ra = new Random();
string cookieValue = FileDecrypt.Encrypt(user.ID + "&" + user.Username, "", ra);
Cookie.Values.Add("cookieValue", cookieValue);
context.Response.Cookies.Add(Cookie);
}
catch { }
}
else
{
error = "This user has been disabled！";
context.Response.Write(error);
return;
}
context.Session["User"] = user;
}
else
{
error = "Your username or passowrd is incorrect！";
context.Response.Write(error);
return;
}
string roleName = "";
BLL.t_rol_role roleBll = new BLL.t_rol_role();
DataSet roleNameDS = roleBll.GetRoleNameByRoleID(user.RoleID);
if (roleNameDS.Tables[0].Rows.Count != 0)
{
roleName = roleNameDS.Tables[0].Rows[0]["RoleName"].ToString();
}
else
{
context.Response.Write("Failed to get the role.");
}
if (roleName == "System Administrator")
{
context.Response.Write("<script language='javascript'>window.location.href='/../Views/Admin/index.aspx';</script>");
}
if (roleName == "User")
{
user = null;
loginLog = null;
context.Response.Write("<script language='javascript'>window.location.href='/../Views/index.aspx';</script>");
}
}
/// <summary>
/// User Login
/// </summary>
/// <param name="userName"></param>
/// <param name="userPwd"></param>
/// <param name="model"></param>
/// <returns></returns>
public Model.t_rol_user Login(string userName, string userPwd, Model.t_log_login model)
{
return(dal.Login(userName, userPwd, model));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.t_log_login model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Model.t_log_login model)
{
return(dal.Add(model));
}
