/// <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)); }