protected void btnLogin_Click(object sender, EventArgs e)
{
if (IsValid)
{
if (Session["CheckCode"] != null)
{
if (txtSN.Text == Session["CheckCode"].ToString())
{
CdHotelManage.Model.AccountsUsers User = aubll.CheckUser(this.txtName.Text.Trim(), this.txtPwd.Text.Trim());
if (User != null)
{
//Session["User"] = User;
string ubaseid = User.UserID;
Session["User"] = User;
userid = User.UserID;
ToPage();
}
else
{
lblMessage.Text = "用户名或密码不正确！";
}
}
else
{
lblMessage.Text = "验证码错误！";
return;
}
}
else
{
lblMessage.Text = "请输入验证码！";
return;
}
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(CdHotelManage.Model.AccountsUsers model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Accounts_Users set ");
strSql.Append("UserName=@UserName,");
strSql.Append("Password=@Password,");
strSql.Append("TrueName=@TrueName,");
strSql.Append("Sex=@Sex,");
strSql.Append("Phone=@Phone,");
strSql.Append("Email=@Email,");
strSql.Append("EmployeeID=@EmployeeID,");
strSql.Append("DepartmentID=@DepartmentID,");
strSql.Append("Activity=@Activity,");
strSql.Append("UserType=@UserType,");
strSql.Append("Style=@Style");
strSql.Append(" where UserID=@UserID");
SqlParameter[] parameters =
{
new SqlParameter("@UserID", SqlDbType.NVarChar, 50),
new SqlParameter("@UserName", SqlDbType.VarChar, 50),
new SqlParameter("@Password", SqlDbType.NVarChar, 50),
new SqlParameter("@TrueName", SqlDbType.VarChar, 50),
new SqlParameter("@Sex", SqlDbType.Char, 2),
new SqlParameter("@Phone", SqlDbType.VarChar, 20),
new SqlParameter("@Email", SqlDbType.VarChar, 100),
new SqlParameter("@EmployeeID", SqlDbType.Int, 4),
new SqlParameter("@DepartmentID", SqlDbType.VarChar, 15),
new SqlParameter("@Activity", SqlDbType.Bit, 1),
new SqlParameter("@UserType", SqlDbType.Char, 2),
new SqlParameter("@Style", SqlDbType.Int, 4)
};
parameters[0].Value = model.UserID;
parameters[1].Value = model.UserName;
parameters[2].Value = model.Password;
parameters[3].Value = model.TrueName;
parameters[4].Value = model.Sex;
parameters[5].Value = model.Phone;
parameters[6].Value = model.Email;
parameters[7].Value = model.EmployeeID;
parameters[8].Value = model.DepartmentID;
parameters[9].Value = model.Activity;
parameters[10].Value = model.UserType;
parameters[11].Value = model.Style;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(CdHotelManage.Model.AccountsUsers model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Accounts_Users(");
strSql.Append("UserID,UserName,Password,TrueName,Sex,Phone,Email,EmployeeID,DepartmentID,Activity,UserType,Style)");
strSql.Append(" values (");
strSql.Append("@UserID,@UserName,@Password,@TrueName,@Sex,@Phone,@Email,@EmployeeID,@DepartmentID,@Activity,@UserType,@Style)");
SqlParameter[] parameters =
{
new SqlParameter("@UserID", SqlDbType.NVarChar, 50),
new SqlParameter("@UserName", SqlDbType.VarChar, 50),
new SqlParameter("@Password", SqlDbType.NVarChar, 50),
new SqlParameter("@TrueName", SqlDbType.VarChar, 50),
new SqlParameter("@Sex", SqlDbType.Char, 2),
new SqlParameter("@Phone", SqlDbType.VarChar, 20),
new SqlParameter("@Email", SqlDbType.VarChar, 100),
new SqlParameter("@EmployeeID", SqlDbType.Int, 4),
new SqlParameter("@DepartmentID", SqlDbType.VarChar, 15),
new SqlParameter("@Activity", SqlDbType.Bit, 1),
new SqlParameter("@UserType", SqlDbType.Char, 2),
new SqlParameter("@Style", SqlDbType.Int, 4)
};
parameters[0].Value = model.UserID;
parameters[1].Value = model.UserName;
parameters[2].Value = model.Password;
parameters[3].Value = model.TrueName;
parameters[4].Value = model.Sex;
parameters[5].Value = model.Phone;
parameters[6].Value = model.Email;
parameters[7].Value = model.EmployeeID;
parameters[8].Value = model.DepartmentID;
parameters[9].Value = model.Activity;
parameters[10].Value = model.UserType;
parameters[11].Value = model.Style;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
private void ToPage()
{
if (Request.QueryString["returnurl"] != null)
{
CdHotelManage.Model.AccountsUsers user = aubll.GetModel(userid);
user.LastLoginIP = GetIP();
user.LastLoginTime = DateTime.Now;
aubll.Update(user);
string returnurl = Request.QueryString["returnurl"].ToString();
Response.Redirect(returnurl);
}
else
{
CdHotelManage.Model.AccountsUsers user = aubll.GetModel(userid);
if (Request.Browser.Cookies == true)
{
if (Request.Cookies["ip"] == null)
{
HttpCookie ip = new HttpCookie("ip");
ip.Value = user.LastLoginIP;
ip.Expires = DateTime.Now.AddDays(1);
Response.Cookies.Add(ip);
Request.Cookies.Set(ip);
}
}
if (Request.Browser.Cookies == true)
{
if (Request.Cookies["date"] == null)
{
HttpCookie date = new HttpCookie("date");
date.Value = user.Email;
date.Expires = DateTime.Now.AddDays(1);
Response.Cookies.Add(date);
Request.Cookies.Set(date);
}
}
user.LastLoginIP = GetIP();
user.LastLoginTime = DateTime.Now;
aubll.Update(user);
Response.Redirect("/User/default.htm?account=" + userid ?? string.Empty);
}
}
/// <summary>
/// 根据编号得到一个对象实体
/// </summary>
public CdHotelManage.Model.AccountsUsers GetModelByNum(string num)
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 UserID,UserName,Password,TrueName,Sex,Phone,Email,EmployeeID,DepartmentID,Activity,UserType,Style from Accounts_Users ");
strSql.Append(" where TrueName=@TrueName");
SqlParameter[] parameters =
{
new SqlParameter("@TrueName", SqlDbType.VarChar, 50)
};
parameters[0].Value = num;
CdHotelManage.Model.AccountsUsers model = new CdHotelManage.Model.AccountsUsers();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["UserID"] != null && ds.Tables[0].Rows[0]["UserID"].ToString() != "")
{
model.UserID = ds.Tables[0].Rows[0]["UserID"].ToString();
}
if (ds.Tables[0].Rows[0]["UserName"] != null && ds.Tables[0].Rows[0]["UserName"].ToString() != "")
{
model.UserName = ds.Tables[0].Rows[0]["UserName"].ToString();
}
if (ds.Tables[0].Rows[0]["Password"] != null && ds.Tables[0].Rows[0]["Password"].ToString() != "")
{
model.Password = ds.Tables[0].Rows[0]["Password"].ToString();
}
if (ds.Tables[0].Rows[0]["TrueName"] != null && ds.Tables[0].Rows[0]["TrueName"].ToString() != "")
{
model.TrueName = ds.Tables[0].Rows[0]["TrueName"].ToString();
}
if (ds.Tables[0].Rows[0]["Sex"] != null && ds.Tables[0].Rows[0]["Sex"].ToString() != "")
{
model.Sex = ds.Tables[0].Rows[0]["Sex"].ToString();
}
if (ds.Tables[0].Rows[0]["Phone"] != null && ds.Tables[0].Rows[0]["Phone"].ToString() != "")
{
model.Phone = ds.Tables[0].Rows[0]["Phone"].ToString();
}
if (ds.Tables[0].Rows[0]["Email"] != null && ds.Tables[0].Rows[0]["Email"].ToString() != "")
{
model.Email = ds.Tables[0].Rows[0]["Email"].ToString();
}
if (ds.Tables[0].Rows[0]["EmployeeID"] != null && ds.Tables[0].Rows[0]["EmployeeID"].ToString() != "")
{
model.EmployeeID = int.Parse(ds.Tables[0].Rows[0]["EmployeeID"].ToString());
}
if (ds.Tables[0].Rows[0]["DepartmentID"] != null && ds.Tables[0].Rows[0]["DepartmentID"].ToString() != "")
{
model.DepartmentID = ds.Tables[0].Rows[0]["DepartmentID"].ToString();
}
if (ds.Tables[0].Rows[0]["Activity"] != null && ds.Tables[0].Rows[0]["Activity"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["Activity"].ToString() == "1") || (ds.Tables[0].Rows[0]["Activity"].ToString().ToLower() == "true"))
{
model.Activity = true;
}
else
{
model.Activity = false;
}
}
if (ds.Tables[0].Rows[0]["UserType"] != null && ds.Tables[0].Rows[0]["UserType"].ToString() != "")
{
model.UserType = ds.Tables[0].Rows[0]["UserType"].ToString();
}
if (ds.Tables[0].Rows[0]["Style"] != null && ds.Tables[0].Rows[0]["Style"].ToString() != "")
{
model.Style = int.Parse(ds.Tables[0].Rows[0]["Style"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 根据用户名和密码返回用户
/// </summary>
public CdHotelManage.Model.AccountsUsers GetUserByLogin(string username, string pwd)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("Select * From Accounts_Users Where ");
strSql.Append("UserName=@UserName And ");
strSql.Append("Password=@Password");
SqlParameter[] parameters =
{
new SqlParameter("@UserName", SqlDbType.VarChar, 50),
new SqlParameter("@Password", SqlDbType.VarChar, 50)
};
parameters[0].Value = username;
parameters[1].Value = pwd;
CdHotelManage.Model.AccountsUsers model = new CdHotelManage.Model.AccountsUsers();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["UserID"] != null && ds.Tables[0].Rows[0]["UserID"].ToString() != "")
{
model.UserID = ds.Tables[0].Rows[0]["UserID"].ToString();
}
if (ds.Tables[0].Rows[0]["UserName"] != null && ds.Tables[0].Rows[0]["UserName"].ToString() != "")
{
model.UserName = ds.Tables[0].Rows[0]["UserName"].ToString();
}
if (ds.Tables[0].Rows[0]["Password"] != null && ds.Tables[0].Rows[0]["Password"].ToString() != "")
{
model.Password = ds.Tables[0].Rows[0]["Password"].ToString();
}
if (ds.Tables[0].Rows[0]["TrueName"] != null && ds.Tables[0].Rows[0]["TrueName"].ToString() != "")
{
model.TrueName = ds.Tables[0].Rows[0]["TrueName"].ToString();
}
if (ds.Tables[0].Rows[0]["Sex"] != null && ds.Tables[0].Rows[0]["Sex"].ToString() != "")
{
model.Sex = ds.Tables[0].Rows[0]["Sex"].ToString();
}
if (ds.Tables[0].Rows[0]["Phone"] != null && ds.Tables[0].Rows[0]["Phone"].ToString() != "")
{
model.Phone = ds.Tables[0].Rows[0]["Phone"].ToString();
}
if (ds.Tables[0].Rows[0]["Email"] != null && ds.Tables[0].Rows[0]["Email"].ToString() != "")
{
model.Email = ds.Tables[0].Rows[0]["Email"].ToString();
}
if (ds.Tables[0].Rows[0]["EmployeeID"] != null && ds.Tables[0].Rows[0]["EmployeeID"].ToString() != "")
{
model.EmployeeID = int.Parse(ds.Tables[0].Rows[0]["EmployeeID"].ToString());
}
if (ds.Tables[0].Rows[0]["DepartmentID"] != null && ds.Tables[0].Rows[0]["DepartmentID"].ToString() != "")
{
model.DepartmentID = ds.Tables[0].Rows[0]["DepartmentID"].ToString();
}
if (ds.Tables[0].Rows[0]["Activity"] != null && ds.Tables[0].Rows[0]["Activity"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["Activity"].ToString() == "1") || (ds.Tables[0].Rows[0]["Activity"].ToString().ToLower() == "true"))
{
model.Activity = true;
}
else
{
model.Activity = false;
}
}
if (ds.Tables[0].Rows[0]["UserType"] != null && ds.Tables[0].Rows[0]["UserType"].ToString() != "")
{
model.UserType = ds.Tables[0].Rows[0]["UserType"].ToString();
}
if (ds.Tables[0].Rows[0]["Style"] != null && ds.Tables[0].Rows[0]["Style"].ToString() != "")
{
model.Style = int.Parse(ds.Tables[0].Rows[0]["Style"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(CdHotelManage.Model.AccountsUsers model)
{
return(AccountBridge.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(CdHotelManage.Model.AccountsUsers model)
{
return(AccountBridge.Add(model));
}