/// <summary>
/// 注册用户
/// </summary>
/// <param name="users"></param>
/// <returns></returns>
public static int InsertUser(BillModel.Users users)
{
string sqlstr = "insert Users values(@UName, @UPhone, @UPwd)";
SqlParameter[] p =
{
new SqlParameter("@UName", users.Uname),
new SqlParameter("@UPhone", users.Uphone),
new SqlParameter("@UPwd", users.Upwd)
};
return(DBHepler.ExecuteNonQuery(sqlstr, p));
}
/// <summary>
/// 查询用户
/// </summary>
/// <returns></returns>
public static List <BillModel.Users> GetUsers()
{
List <BillModel.Users> modelList = new List <BillModel.Users>();
string sqlstr = "select * from Users ";
SqlDataReader dr = DBHepler.ExecuteReader(sqlstr);
BillModel.Users model = null;
while (dr.Read())
{
model = new BillModel.Users();
model.UserID = (int)dr["UserID"];
model.Uname = dr["UName"].ToString();
model.Upwd = dr["UPwd"].ToString();
model.Uphone = dr["Uphone"].ToString();
modelList.Add(model);
}
dr.Close();
return(modelList);
}
public void ProcessRequest(HttpContext context)
{
//context.Response.ContentType = "text/plain";
//context.Response.Write("Hello World");
//string id = context.Request["ID"];
//List<dslfajal> modellist = new List<dslfajal>();
////讲数据序列化为json格式字符
//DataContractJsonSerializer json = new DataContractJsonSerializer(modellist.GetType());
////调用前端成功回调函数，并返回数据
//json.WriteObject(context.Response.OutputStream, modelliist);
string pwd = context.Request["pwd"];
string name = context.Request["name"];
string phone = context.Request["phone"];
try
{
BillModel.Users user = new BillModel.Users();
user.Upwd = pwd;
user.Uphone = phone;
user.Uname = name;
if (BillBLL.UsersBll.InsertUser(user) > 0)
{
context.Response.Write(1);
return;
}
else
{
context.Response.Write(0);
return;
}
}
catch (Exception)
{
throw;
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
//context.Response.Write("Hello World");
string LoginName = context.Request["Name"];
string PassWord = context.Request["Pwd"];
//context.Response.Write(LoginName+PassWord);
context.Session["User"] = null;
BillModel.Users users = null;
try
{
users = BillDAL.UsersDal.GetUsers().Where(U => U.Uphone == LoginName && U.Upwd == PassWord).First();
context.Session["User"] = users;
context.Response.Write(1);
return;
}
catch (Exception)
{
context.Response.Write(0);
return;
}
}
/// <summary>
/// 用户注册
/// </summary>
/// <param name="users"></param>
/// <returns></returns>
public static int InsertUser(BillModel.Users users)
{
return(BillDAL.UsersDal.InsertUser(users));
}
