public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
//实例化一个对象
Model.HKSJ_USERS users = new Model.HKSJ_USERS();
//获取ID信息
//ID: RowUpdateUserID[0].ID,
//UserName: $("#txtUpdateUserName").val(),
//LoginName: $("#txtUpdateLoginName").val(),
//Password: $("#txtUpdatePassword").val(),
//Plane: $("#txtUpdatePlane").val(),
//Phone: $("#txtUpdatePhone").val(),
//Email: $("#txtUpdateEmail").val(),
//CardNo: $("#txtUpdateCardNo").val()
users.ID = context.Request["ID"] == null ? 0 : Convert.ToInt32(context.Request["ID"]);
users.UserName = context.Request["UserName"];
users.LoginName = context.Request["LoginName"];
users.PassWord = context.Request["Password"];
users.Plane = context.Request["Plane"];
users.phone = context.Request["Phone"];
users.Mail = context.Request["Email"];
users.cardNo = context.Request["CardNo"];
//进行修改实现功能
if (userService.Update(users))
{
context.Response.Write("OK");
}
else
{
context.Response.Write("error");
}
}
public void ProcessRequest(HttpContext context)
{
BLL.HKSJ_USERS userServices = new BLL.HKSJ_USERS();
context.Response.ContentType = "text/plain";
//获取参数实现用户的添加
Model.HKSJ_USERS users = new Model.HKSJ_USERS();
//UserName，LoginName，Password，Plane，Phone，Email，CardNo;
users.UserName = context.Request["UserName"];
users.LoginName = context.Request["LoginName"];
users.PassWord = context.Request["Password"];
users.Plane = context.Request["Plane"];
users.phone = context.Request["Phone"];
users.Mail = context.Request["Email"];
users.cardNo = context.Request["CardNo"];
//实现给数据库中添加数据
if (userServices.Add(users) > 0)
{
context.Response.Write("OK");
}
else
{
context.Response.Write("error");
}
}
public Model.HKSJ_USERS GetLoginUser(string loginName, string userPwd)
{
//ID, UserName, LoginName, PassWord, Plane, phone, Mail, cardNo
Model.HKSJ_USERS user = new Model.HKSJ_USERS();
string sql = "select ID, UserName, LoginName, PassWord, Plane, phone, Mail, cardNo from HKSJ_USERS where LoginName=@LoginName and PassWord=@PassWord";
SqlParameter[] paras = new SqlParameter[] {
new SqlParameter("@LoginName", loginName),
new SqlParameter("@PassWord", userPwd)
};
using (SqlDataReader reader = DbHelperSQL.ExecuteReader(sql, paras))
{
if (reader.Read())
{
user.ID = int.Parse(reader["ID"].ToString());
user.LoginName = reader["LoginName"] == DBNull.Value ? string.Empty : reader["LoginName"].ToString();
user.UserName = reader["UserName"] == DBNull.Value ? string.Empty : reader["UserName"].ToString();
user.cardNo = reader["cardNo"] == DBNull.Value ? string.Empty : reader["cardNo"].ToString();
user.Mail = reader["Mail"] == DBNull.Value ? string.Empty : reader["Mail"].ToString();
user.PassWord = reader["PassWord"] == DBNull.Value ? string.Empty : reader["PassWord"].ToString();
user.phone = reader["phone"] == DBNull.Value ? string.Empty : reader["phone"].ToString();
user.Plane = reader["Plane"] == DBNull.Value ? string.Empty : reader["Plane"].ToString();
}
}
return(user);
}
public LoginResult GetUserLoginUserModel(string loginName, string userPwd)
{
//先对用户名或密码是否为空判断
if (string.IsNullOrEmpty(loginName))
{
return(LoginResult.userIsNull);
}
if (string.IsNullOrEmpty(userPwd))
{
return(LoginResult.pwdIsNull);
}
//用户名密码不为空就到数据库中查询
Model.HKSJ_USERS user = dal.GetLoginUser(loginName);
//对返回的结果进行判断
if (user.LoginName == null)
{
return(LoginResult.userNotExist);
}
else if (userPwd != user.PassWord)
{
return(LoginResult.pwdError);
}
else
{
return(LoginResult.OK);
}
}
public List <Model.HKSJ_USERS> GetPageSizeNav(int pageIndex, int pageSize, out int totalCount)
{
//new一个SqlDataAdapter对象
using (SqlDataAdapter adapter = new SqlDataAdapter())
{
//构造链接字符串
using (SqlConnection conn = new SqlConnection(DbHelperSQL.connectionString))
{
//创建并执行数据源参数
adapter.SelectCommand = conn.CreateCommand();
//定义使用存储过程
adapter.SelectCommand.CommandText = "p_GetPageUSERS";
adapter.SelectCommand.CommandType = CommandType.StoredProcedure;
//设置输入参数
adapter.SelectCommand.Parameters.Add(new SqlParameter("@pageIndex", pageIndex));
adapter.SelectCommand.Parameters.Add(new SqlParameter("@pageSize", pageSize));
//设置输出参数
SqlParameter parameterout = new SqlParameter("@totalCount", SqlDbType.Int);
parameterout.Direction = ParameterDirection.Output;
adapter.SelectCommand.Parameters.Add(parameterout);
//将数据源对象填充到表中
DataTable dt = new DataTable();
adapter.Fill(dt);
//获取输出参数
totalCount = Convert.ToInt32(parameterout.Value);
//循环遍历表中的数据源对象
List <Model.HKSJ_USERS> userproject = new List <Model.HKSJ_USERS>();
foreach (DataRow row in dt.Rows)
{
Model.HKSJ_USERS user = new Model.HKSJ_USERS();
//获取表中的所有对象显示输出
user.ID = Convert.ToInt32(row["ID"].ToString());
user.UserName = row["UserName"] == DBNull.Value ? "" : row["UserName"].ToString();
user.LoginName = row["LoginName"] == DBNull.Value ? "" : row["LoginName"].ToString();
user.PassWord = row["PassWord"] == DBNull.Value ? "" : row["PassWord"].ToString();
user.Plane = row["Plane"] == DBNull.Value ? "" : row["Plane"].ToString();
user.phone = row["phone"] == DBNull.Value ? "" : row["phone"].ToString();
user.Mail = row["Mail"] == DBNull.Value ? "" : row["Mail"].ToString();
user.cardNo = row["cardNo"] == DBNull.Value ? "" : row["cardNo"].ToString();
userproject.Add(user);
}
return(userproject);
}
}
}
protected void btnLogin_Click(object sender, ImageClickEventArgs e)
{
#region 验证码判断
//先取得验证码，判断验证码是否正确，如果不正确就不用到数据库中查找内容了
string code = Session["ValidateCode"] == null ? string.Empty : Session["ValidateCode"].ToString();
string fromCode = Request["txtCode"];
if (code != fromCode)
{
//名字保留
userName = Request["txtClientID"];
//提醒用户
ErrorMsg = "验证码有误！";
return;
}
#endregion
#region 获取提交过来的用户信息，到数据库查询
string strLoginName = Request["txtClientID"].Trim();
string strUserPwd = Request["txtPassword"];
BLL.HKSJ_USERS userInfoService = new BLL.HKSJ_USERS();
Model.HKSJ_USERS user = new Model.HKSJ_USERS();
LoginResult result = userInfoService.GetUserLoginUserModel(strLoginName, strUserPwd);
//判断返回结果
if (result == LoginResult.userIsNull)
{
Js = "<script>alert('用户名不能为空！')</script>";
return;
}
else if (result == LoginResult.pwdIsNull)
{
Js = "<script>alert('密码不能为空！')</script>";
return;
}
else if (result == LoginResult.userNotExist)
{
Js = "<script>alert('用户名不存在！')</script>";
//名字保留
userName = Request["txtClientID"];
return;
}
else if (result == LoginResult.pwdError)
{
Js = "<script>alert('密码错误！')</script>";
//名字保留
userName = Request["txtClientID"];
return;
}
else if (result == LoginResult.OK)
{
//验证通过后把用户名保存到session里面
Session["user"] = user;
//把登录成功的用户名保存到cookie中
if (!String.IsNullOrEmpty(strLoginName))
{
Response.Cookies["userName"].Value = strLoginName;
Response.Cookies["userName"].Expires = DateTime.Now.AddDays(5);
}
//验证都通过，转到后台页面
Response.Redirect("~/admin/users/adminUser.html");
}
else
{
Js = "<script>alert('未知错误！')</script>";
return;
}
#endregion
}
