/// <summary>
/// 用username,pwd,typeid登录
/// </summary>
/// <param name="name"></param>
/// <param name="pwd"></param>
/// <param name="typeid"></param>
/// <returns>USER对象</returns>
public RoadSolution.Model.User Login(string name, string pwd, string typeid)
{
RoadSolution.Model.User u = dal.GetByNamePwdTypeid(name, pwd, typeid);
if (u == null)
{
return(null);
}
return(u);
}
public static void RegisterUser(string Username, string Password, string TypeID)
{
RoadSolution.BLL.User ubll = new RoadSolution.BLL.User();
RoadSolution.Model.User u = new RoadSolution.Model.User();
u.Username = Username;
u.Password = Password;
u.TypeID = TypeID;
u.UserID = Guid.NewGuid().ToString();
ubll.Add(u);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(RoadSolution.Model.User model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update User set ");
strSql.Append("TypeID='" + model.TypeID + "',");
strSql.Append("Username='******',");
strSql.Append("Password='******'");
strSql.Append(" where UserID='" + model.UserID + "'");
DbHelperSQL.ExecuteSql(strSql.ToString());
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//把JSON对象转为USER对象
System.Web.Script.Serialization.JavaScriptSerializer jss = new
System.Web.Script.Serialization.JavaScriptSerializer();
string userjson = Session["userJSON"].ToString();
//JavaScriptSerializer的反序列化函数
RoadSolution.Model.User user = jss.Deserialize <RoadSolution.Model.User>(userjson);
//USERNAME发给页面的LABLE
LblUsername.Text = user.Username;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public string Add(RoadSolution.Model.User model)
{
//model.UserID = GetMaxId().ToString();
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [User](");
strSql.Append("UserID,TypeID,Username,Password");
strSql.Append(")");
strSql.Append(" values (");
strSql.Append("'" + model.UserID + "',");
strSql.Append("'" + model.TypeID + "',");
strSql.Append("'" + model.Username + "',");
strSql.Append("'" + model.Password + "'");
strSql.Append(")");
DbHelperSQL.ExecuteSql(strSql.ToString());
return(model.UserID);
}
/// <summary>
/// 用名字+密码+账户类型，查用户
/// </summary>
/// <param name="name"></param>
/// <param name="pwd"></param>
/// <param name="typeid"></param>
/// <returns></returns>
public RoadSolution.Model.User GetByNamePwdTypeid(string name, string pwd, string typeid)
{
string strSql = String.Format(
"select * from [User] where [Username]='{0}' and [Password]='{1}' and [TypeID]='{2}'",
name, pwd, typeid
);
RoadSolution.Model.User u = new RoadSolution.Model.User();
DataSet ds = DbHelperSQL.Query(strSql);
if (ds.Tables[0].Rows.Count <= 0)
{
return(null);
}
u.Username = ds.Tables[0].Rows[0]["Username"].ToString();
u.Password = ds.Tables[0].Rows[0]["Password"].ToString();
u.UserID = ds.Tables[0].Rows[0]["UserID"].ToString();
u.TypeID = ds.Tables[0].Rows[0]["TypeID"].ToString();
return(u);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public RoadSolution.Model.User GetModel(string UserID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from User ");
strSql.Append(" where UserID='" + UserID + "'");
RoadSolution.Model.User model = new RoadSolution.Model.User();
DataSet ds = DbHelperSQL.Query(strSql.ToString());
model.UserID = UserID;
if (ds.Tables[0].Rows.Count > 0)
{
model.TypeID = ds.Tables[0].Rows[0]["TypeID"].ToString();
model.Username = ds.Tables[0].Rows[0]["Username"].ToString();
model.Password = ds.Tables[0].Rows[0]["Password"].ToString();
return(model);
}
else
{
return(null);
}
}
protected void btnLogin_Click(object sender, EventArgs e)
{
//存USERNAME,PWD,TYPEID
string strname = uname.Text.Trim();
string strpwd = pwd.Text.Trim();
string tID = DLType.SelectedValue;
//执行LOGIN,判断是否取到值
RoadSolution.Model.User u = userbll.Login(strname, strpwd, tID);
if (u == null)
{
parname.InnerHtml = "无用户或密码错误";
return;
}
//把USER对象转为JSON对象
System.Web.Script.Serialization.JavaScriptSerializer jss = new
System.Web.Script.Serialization.JavaScriptSerializer();
string ujson = jss.Serialize(u);//JavaScriptSerializer的序列化函数
Session["userJSON"] = ujson;
//string url = "";
//RoadSolution.DBUtils.PostParseJsonUtil.HttpPost(url, ujson);
Response.Redirect("~/main.html");
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(RoadSolution.Model.User model)
{
dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public string Add(RoadSolution.Model.User model)
{
return(dal.Add(model));
}
