/// <summary> /// 增加一条数据 /// </summary> public int Add(M_td_adminuser model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into hx_td_adminuser("); strSql.Append("adminuser,userpass,state,datetime,trueName,email,province,city,tel,phone_number,lastLoginTime,lastLoginIP,loginTimes,worknum,sex,department_id,area_id)"); strSql.Append(" values ("); strSql.Append("@adminuser,@userpass,@state,@datetime,@trueName,@email,@province,@city,@tel,@phone_number,@lastLoginTime,@lastLoginIP,@loginTimes,@worknum,@sex,@department_id,@area_id)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@adminuser", SqlDbType.VarChar, 50), new SqlParameter("@userpass", SqlDbType.VarChar, 50), new SqlParameter("@state", SqlDbType.Int, 4), new SqlParameter("@datetime", SqlDbType.DateTime), new SqlParameter("@trueName", SqlDbType.VarChar, 50), new SqlParameter("@email", SqlDbType.VarChar, 50), new SqlParameter("@province", SqlDbType.VarChar, 20), new SqlParameter("@city", SqlDbType.VarChar, 20), new SqlParameter("@tel", SqlDbType.VarChar, 20), new SqlParameter("@phone_number", SqlDbType.VarChar, 20), new SqlParameter("@lastLoginTime", SqlDbType.DateTime), new SqlParameter("@lastLoginIP", SqlDbType.VarChar, 50), new SqlParameter("@loginTimes", SqlDbType.Int, 4), new SqlParameter("@worknum", SqlDbType.VarChar, 50), new SqlParameter("@sex", SqlDbType.VarChar, 10), new SqlParameter("@department_id", SqlDbType.Int, 4), new SqlParameter("@area_id", SqlDbType.Int, 4) }; parameters[0].Value = model.adminuser; parameters[1].Value = model.userpass; parameters[2].Value = model.state; parameters[3].Value = model.datetime; parameters[4].Value = model.trueName; parameters[5].Value = model.email; parameters[6].Value = model.province; parameters[7].Value = model.city; parameters[8].Value = model.tel; parameters[9].Value = model.phone_number; parameters[10].Value = model.lastLoginTime; parameters[11].Value = model.lastLoginIP; parameters[12].Value = model.loginTimes; parameters[13].Value = model.worknum; parameters[14].Value = model.sex; parameters[15].Value = model.department_id; parameters[16].Value = model.area_id; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public M_td_adminuser GetModel(int adminuserid) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 adminuserid,adminuser,userpass,state,datetime,trueName,email,province,city,tel,phone_number,lastLoginTime,lastLoginIP,loginTimes,worknum,sex,department_id,area_id from hx_td_adminuser "); strSql.Append(" where adminuserid=@adminuserid"); SqlParameter[] parameters = { new SqlParameter("@adminuserid", SqlDbType.Int, 4) }; parameters[0].Value = adminuserid; M_td_adminuser model = new M_td_adminuser(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
public ActionResult DoLogin(string txtUserName, string txtPassword, string txtCheckCode) { B_td_adminuser o = new B_td_adminuser(); M_td_adminuser p = new M_td_adminuser(); B_td_LoginInfo b1 = new B_td_LoginInfo(); M_td_LoginInfo m1 = new M_td_LoginInfo(); string username1 = null; string userpass1 = null; string code = null; if (Request.Form["txtUserName"] != null) { username1 = Utils.CheckSQLHtml(Request.Form["txtUserName"].ToString()); } if (Request.Form["txtPassword"] != null) { userpass1 = Utils.CheckSQLHtml(Request.Form["txtPassword"].ToString()); } if (Request.Form["txtCheckCode"] != null) { code = Utils.CheckSQLHtml(Request.Form["txtCheckCode"].ToString()); } userpass1 = Utils.MD5(userpass1); #region 检查验证码 if (Session["CheckCode"] != null) { if (code != Session["CheckCode"].ToString()) { //CommonOperate.Show_Msg("验证码不正确"); //Response.End(); return(Content(StringAlert.Alert("验证码不正确"), "text/html")); } else { } } else { //CommonOperate.Show_Msg("验证码过期"); //Response.End(); return(Content(StringAlert.Alert("验证码过期"), "text/html")); } #endregion string ip = Utils.GetRealIP(); int adminuserid = o.Check_userpass(username1, userpass1, ip); if (adminuserid > 0) { p = o.GetModel(adminuserid); Session["username"] = p.adminuser.ToString(); Session["userid_gpt"] = p.adminuserid.ToString(); //Session["area"] = p.Areacode.ToString(); //Session["purview"] = p.Purview.ToString(); Session["adminuserid"] = adminuserid.ToString(); ///添加登录日志 m1.AdminUserName = username1; m1.Pwd = "***"; m1.LoginSuccess = 1; m1.LoginIP = Request.UserHostAddress; b1.Add(m1); //Response.Redirect("Deflault.aspx"); return(RedirectToAction("Index", "default")); } else { ///添加登录日志 m1.AdminUserName = username1; m1.Pwd = userpass1; m1.LoginSuccess = 0; m1.LoginIP = Request.UserHostAddress; b1.Add(m1); //Response.Redirect("login.aspx"); return(RedirectToAction("Index", "Login")); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(M_td_adminuser model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(M_td_adminuser model) { return(dal.Add(model)); }
/// <summary> /// 得到一个对象实体 /// </summary> public M_td_adminuser DataRowToModel(DataRow row) { M_td_adminuser model = new M_td_adminuser(); if (row != null) { if (row["adminuserid"] != null && row["adminuserid"].ToString() != "") { model.adminuserid = int.Parse(row["adminuserid"].ToString()); } if (row["adminuser"] != null) { model.adminuser = row["adminuser"].ToString(); } if (row["userpass"] != null) { model.userpass = row["userpass"].ToString(); } if (row["state"] != null && row["state"].ToString() != "") { model.state = int.Parse(row["state"].ToString()); } if (row["datetime"] != null && row["datetime"].ToString() != "") { model.datetime = DateTime.Parse(row["datetime"].ToString()); } if (row["trueName"] != null) { model.trueName = row["trueName"].ToString(); } if (row["email"] != null) { model.email = row["email"].ToString(); } if (row["province"] != null) { model.province = row["province"].ToString(); } if (row["city"] != null) { model.city = row["city"].ToString(); } if (row["tel"] != null) { model.tel = row["tel"].ToString(); } if (row["phone_number"] != null) { model.phone_number = row["phone_number"].ToString(); } if (row["lastLoginTime"] != null && row["lastLoginTime"].ToString() != "") { model.lastLoginTime = DateTime.Parse(row["lastLoginTime"].ToString()); } if (row["lastLoginIP"] != null) { model.lastLoginIP = row["lastLoginIP"].ToString(); } if (row["loginTimes"] != null && row["loginTimes"].ToString() != "") { model.loginTimes = int.Parse(row["loginTimes"].ToString()); } if (row["worknum"] != null) { model.worknum = row["worknum"].ToString(); } if (row["sex"] != null) { model.sex = row["sex"].ToString(); } if (row["department_id"] != null && row["department_id"].ToString() != "") { model.department_id = int.Parse(row["department_id"].ToString()); } if (row["area_id"] != null && row["area_id"].ToString() != "") { model.area_id = int.Parse(row["area_id"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(M_td_adminuser model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update hx_td_adminuser set "); strSql.Append("adminuser=@adminuser,"); strSql.Append("userpass=@userpass,"); strSql.Append("state=@state,"); strSql.Append("datetime=@datetime,"); strSql.Append("trueName=@trueName,"); strSql.Append("email=@email,"); strSql.Append("province=@province,"); strSql.Append("city=@city,"); strSql.Append("tel=@tel,"); strSql.Append("phone_number=@phone_number,"); strSql.Append("lastLoginTime=@lastLoginTime,"); strSql.Append("lastLoginIP=@lastLoginIP,"); strSql.Append("loginTimes=@loginTimes,"); strSql.Append("worknum=@worknum,"); strSql.Append("sex=@sex,"); strSql.Append("department_id=@department_id,"); strSql.Append("area_id=@area_id"); strSql.Append(" where adminuserid=@adminuserid"); SqlParameter[] parameters = { new SqlParameter("@adminuser", SqlDbType.VarChar, 50), new SqlParameter("@userpass", SqlDbType.VarChar, 50), new SqlParameter("@state", SqlDbType.Int, 4), new SqlParameter("@datetime", SqlDbType.DateTime), new SqlParameter("@trueName", SqlDbType.VarChar, 50), new SqlParameter("@email", SqlDbType.VarChar, 50), new SqlParameter("@province", SqlDbType.VarChar, 20), new SqlParameter("@city", SqlDbType.VarChar, 20), new SqlParameter("@tel", SqlDbType.VarChar, 20), new SqlParameter("@phone_number", SqlDbType.VarChar, 20), new SqlParameter("@lastLoginTime", SqlDbType.DateTime), new SqlParameter("@lastLoginIP", SqlDbType.VarChar, 50), new SqlParameter("@loginTimes", SqlDbType.Int, 4), new SqlParameter("@worknum", SqlDbType.VarChar, 50), new SqlParameter("@sex", SqlDbType.VarChar, 10), new SqlParameter("@department_id", SqlDbType.Int, 4), new SqlParameter("@area_id", SqlDbType.Int, 4), new SqlParameter("@adminuserid", SqlDbType.Int, 4) }; parameters[0].Value = model.adminuser; parameters[1].Value = model.userpass; parameters[2].Value = model.state; parameters[3].Value = model.datetime; parameters[4].Value = model.trueName; parameters[5].Value = model.email; parameters[6].Value = model.province; parameters[7].Value = model.city; parameters[8].Value = model.tel; parameters[9].Value = model.phone_number; parameters[10].Value = model.lastLoginTime; parameters[11].Value = model.lastLoginIP; parameters[12].Value = model.loginTimes; parameters[13].Value = model.worknum; parameters[14].Value = model.sex; parameters[15].Value = model.department_id; parameters[16].Value = model.area_id; parameters[17].Value = model.adminuserid; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }