/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(CdHotelManage.Model.Users model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Users set ");
strSql.Append("username=@username,");
strSql.Append("passwords=@passwords,");
strSql.Append("user_type=@user_type,");
strSql.Append("pubdate=@pubdate");
strSql.Append(" where userid=@userid ");
SqlParameter[] parameters =
{
new SqlParameter("@username", SqlDbType.NVarChar, 100),
new SqlParameter("@passwords", SqlDbType.NVarChar, 100),
new SqlParameter("@user_type", SqlDbType.Int, 4),
new SqlParameter("@pubdate", SqlDbType.DateTime),
new SqlParameter("@userid", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.username;
parameters[1].Value = model.passwords;
parameters[2].Value = model.user_type;
parameters[3].Value = model.pubdate;
parameters[4].Value = model.userid;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public CdHotelManage.Model.Users DataRowToModel(DataRow row)
{
CdHotelManage.Model.Users model = new CdHotelManage.Model.Users();
if (row != null)
{
if (row["userid"] != null)
{
model.userid = row["userid"].ToString();
DAL.UserInfo dal = new UserInfo();
model.UserInfoModel = dal.DataRowToModel(row);
}
if (row["username"] != null)
{
model.username = row["username"].ToString();
}
if (row["passwords"] != null)
{
model.passwords = row["passwords"].ToString();
}
if (row["user_type"] != null && row["user_type"].ToString() != "")
{
model.user_type = int.Parse(row["user_type"].ToString());
DAL.userType dal = new userType();
model.UserTypeModel = dal.DataRowToModel(row);
}
if (row["pubdate"] != null && row["pubdate"].ToString() != "")
{
model.pubdate = DateTime.Parse(row["pubdate"].ToString());
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(CdHotelManage.Model.Users model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Users(");
strSql.Append("userid,username,passwords,user_type,pubdate)");
strSql.Append(" values (");
strSql.Append("@userid,@username,@passwords,@user_type,@pubdate)");
SqlParameter[] parameters =
{
new SqlParameter("@userid", SqlDbType.NVarChar, 50),
new SqlParameter("@username", SqlDbType.NVarChar, 100),
new SqlParameter("@passwords", SqlDbType.NVarChar, 100),
new SqlParameter("@user_type", SqlDbType.Int, 4),
new SqlParameter("@pubdate", SqlDbType.DateTime)
};
parameters[0].Value = model.userid;
parameters[1].Value = model.username;
parameters[2].Value = model.passwords;
parameters[3].Value = model.user_type;
parameters[4].Value = model.pubdate;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据(手机端)
/// </summary>
public bool UpdateInfo(CdHotelManage.Model.Users model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Users set ");
strSql.Append("username=@username");
strSql.Append(" where userid=@userid ");
SqlParameter[] parameters =
{
new SqlParameter("@username", SqlDbType.NVarChar, 100),
new SqlParameter("@userid", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.username;
parameters[1].Value = model.userid;
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.Users user = userbll.GetModel(userid);
string returnurl = Request.QueryString["returnurl"].ToString();
Response.Redirect(returnurl);
}
else
{
Response.Redirect("index.aspx");
}
}
/// <summary>
/// 根据用户名和密码返回用户
/// </summary>
public CdHotelManage.Model.Users GetUserByLogin(string username, string pwd)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("Select * From Users Where ");
strSql.Append("username=@username And ");
strSql.Append("passwords=@passwords");
SqlParameter[] parameters =
{
new SqlParameter("@username", SqlDbType.VarChar, 100),
new SqlParameter("@passwords", SqlDbType.VarChar, 100)
};
parameters[0].Value = username;
parameters[1].Value = pwd;
CdHotelManage.Model.Users model = new CdHotelManage.Model.Users();
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]["passwords"] != null && ds.Tables[0].Rows[0]["passwords"].ToString() != "")
{
model.passwords = ds.Tables[0].Rows[0]["passwords"].ToString();
}
if (ds.Tables[0].Rows[0]["user_type"] != null && ds.Tables[0].Rows[0]["user_type"].ToString() != "")
{
model.user_type = int.Parse(ds.Tables[0].Rows[0]["user_type"].ToString());
}
if (ds.Tables[0].Rows[0]["pubdate"] != null && ds.Tables[0].Rows[0]["pubdate"].ToString() != "")
{
model.pubdate = Convert.ToDateTime(ds.Tables[0].Rows[0]["pubdate"].ToString());
}
return(model);
}
else
{
return(null);
}
}
protected void btnLogin_Click(object sender, EventArgs e)
{
try
{
if (IsValid)
{
CdHotelManage.Model.Users WapUser = userbll.CheckUser(this.txtname.Text.Trim(), this.txtpwd.Text.Trim());
if (WapUser != null)
{
Session["WapUser"] = WapUser;
userid = WapUser.userid;
ToPage();
}
else
{
lblMessage.Text = "用户名或密码不正确！";
}
}
}
catch
{
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public CdHotelManage.Model.Users GetModel(string userid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * from Users left join UserInfo on Users.userid=UserInfo.userID left join userType on UserInfo.typeid=userType.typeid ");
strSql.Append(" where Users.userid=@userid ");
SqlParameter[] parameters =
{
new SqlParameter("@userid", SqlDbType.NVarChar, 50)
};
parameters[0].Value = userid;
CdHotelManage.Model.Users model = new CdHotelManage.Model.Users();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
