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