protected void Button1_Click1(object sender, EventArgs e)
{
administatorsModel administatorsModel = new administatorsModel();
administatorsModel.midName = username.Value;
if (newpassword2.Value == userpassword.Value)
{
administatorsModel.mpassword = userpassword.Value;
}
else
{
JSHelper.Alert(this, "两次密码输入不一致");
}
administatorsModel.mphone = txtphone.Value;
administatorsModel.mailbox = email.Value;
Admin_BLL.administratorBLL administratorBLL = new Admin_BLL.administratorBLL();
int count = administratorBLL.insert(administatorsModel);
if (count > 0)
{
JSHelper.Alert(this, "添加成功");
RepeaterList();
}
else
{
JSHelper.Alert(this, "添加失败");
}
}
public int Updateadministators(administatorsModel administators, string SessionName)
{
string sql = @"update administators set midName=@midName,mphone=@mphone,mailbox=@mailbox,Age=@Age,Sex=@Sex where midName=@SessionName";
SqlParameter[] parmt = { new SqlParameter("@midName", administators.midName),
new SqlParameter("@mphone", administators.mphone),
new SqlParameter("@mailbox", administators.mailbox),
new SqlParameter("@Age", administators.Age),
new SqlParameter("@Sex", administators.Sex),
new SqlParameter("@SessionName", SessionName) };
return(Convert.ToInt32(SQLHelper.ExecuteNonQuery(sql, parmt)));
}
public int insert(administatorsModel administators)
{
string sql = "insert administators values(@midName,@mpassword,@mphone,getdate(),@mailbox,1,24,0)";
SqlParameter[] parameters =
{
new SqlParameter("@midName", administators.midName),
new SqlParameter("@mpassword", administators.mpassword),
new SqlParameter("@mphone", administators.mphone),
new SqlParameter("@mailbox", administators.mailbox)
};
return(SQLHelper.ExecuteNonQuery(sql, parameters));
}
public void QuerymidName()
{
string Name = Session["Name"].ToString();
Admin_BLL.admin_infoBLL infoBLL = new Admin_BLL.admin_infoBLL();
administatorsModel model = infoBLL.QuerymidName(Name);
IdmidName.Value = model.midName;
IdSex.Value = model.Sex.ToString();
IdAge.Value = model.Age.ToString();
Idmphone.Value = model.mphone;
Idmailbox.Value = model.mailbox;
IdAddtime.Value = model.Addtime.ToString();
}
protected void UPdateEdit_Click(object sender, EventArgs e)
{
string SessionName = Session["Name"].ToString();
administatorsModel model = new administatorsModel();
model.midName = IdmidName.Value;
model.Sex = Convert.ToInt32(IdSex.Value);
model.Age = Convert.ToInt32(IdAge.Value);
model.mphone = Idmphone.Value;
model.mailbox = Idmailbox.Value;
Admin_BLL.admin_infoBLL infoBLL = new Admin_BLL.admin_infoBLL();
int count = infoBLL.Updateadministators(model, SessionName);
if (count > 0)
{
JSHelper.Alert(this, "修改成功");
}
}
public List <administatorsModel> administators(string Name, string Addtime)
{
StringBuilder stringBuilder = new StringBuilder("select* from administators");
List <SqlParameter> sqlParameters = new List <SqlParameter>();
List <string> whereList = new List <string>();
if (!string.IsNullOrWhiteSpace(Addtime) && DateTime.TryParse(Addtime, out DateTime addtime))
{
whereList.Add("Addtime>@Addtime");
sqlParameters.Add(new SqlParameter("@Addtime", addtime));
}
if (!string.IsNullOrWhiteSpace(Name))
{
whereList.Add("midName=@midName");
sqlParameters.Add(new SqlParameter("@midName", Name));
}
if (whereList.Count > 0)
{
string pj = string.Join(" and ", whereList.ToArray());
stringBuilder.Append($" where {pj}");
}
List <administatorsModel> models = new List <administatorsModel>();
SqlDataReader reader = SQLHelper.ExecuteReader(stringBuilder.ToString(), sqlParameters.ToArray());
if (reader.HasRows)
{
while (reader.Read())
{
administatorsModel model = new administatorsModel();
model.mid = Convert.ToInt32(reader["mid"]);
model.midName = reader["midName"].ToString();
model.mpassword = reader["mpassword"].ToString();
model.mphone = reader["mphone"].ToString();
model.Addtime = Convert.ToDateTime(reader["Addtime"]);
model.mailbox = reader["mailbox"].ToString();
model.State = Convert.ToInt32(reader["State"]);
models.Add(model);
}
reader.Close();
}
return(models);
}
public void ProcessRequest(HttpContext context)
{
string Name = context.Request.QueryString["Username"];
string pwd = context.Request.QueryString["pwd"];
if (string.IsNullOrWhiteSpace(Name))
{
context.Response.Write("用户名不能为空");
return;
}
if (string.IsNullOrWhiteSpace(pwd))
{
context.Response.Write("密码不能为空");
return;
}
LoginBLL loginBLL = new LoginBLL();
administatorsModel result = loginBLL.Login(Name, pwd);
if (result.midName != null && result.mpassword != null)
{
context.Session["Name"] = result.midName;
context.Session["Mid"] = result.mid;
int Id = result.mid;
string Name2 = result.midName;
string Ip = GetAddressIP();
LoginHistoryBLL historyBLL = new LoginHistoryBLL();
historyBLL.insert(Id, Name2, Ip);
context.Response.Write("成功");
}
else
{
context.Response.Write("用户名或密码输入错误");
}
context.Response.ContentType = "text/plain";
}
public administatorsModel Login(string Name, string Pwd)
{
string sql = "select *from administators where midName=@Name and mpassword=@pwd and State=0";
SqlParameter[] parameters =
{
new SqlParameter("@Name", Name),
new SqlParameter("@pwd", Pwd),
};
administatorsModel model = new administatorsModel();
SqlDataReader sdr = SQLHelper.ExecuteReader(sql, parameters);
if (sdr.HasRows)
{
while (sdr.Read())
{
model.midName = sdr["midName"].ToString();
model.mpassword = sdr["mpassword"].ToString();
model.mid = Convert.ToInt32(sdr["mid"]);
}
}
return(model);
}
public int Updateadministators(administatorsModel administators, string SessionName)
{
Admin_DAL.admin_infoDAL infoDAL = new Admin_DAL.admin_infoDAL();
return(infoDAL.Updateadministators(administators, SessionName));
}
public int insert(administatorsModel administators)
{
Admin_DAL.administratorDAL administratorDAL = new Admin_DAL.administratorDAL();
return(administratorDAL.insert(administators));
}
