/// <summary>
/// 获取数据列表
/// </summary>
/// <param name="strWhere"></param>
/// <returns></returns>
public UserInfoEnity GetNews()
{
string sql = "SELECT * FROM [dbo].[UserInfo]";
try
{
SqlDataReader reader = SQLHelper.GetReader(sql);
if (reader.Read())
{
UserInfoEnity user = new UserInfoEnity();
user.u_account = (int)reader["u_account"];
user.u_name = (string)reader["u_name"];
user.u_password = (string)reader["u_password"];
user.u_privilege = (int)reader["u_privilege"];
user.u_sex = (string)reader["u_sex"];
reader.Close();
return(user);
}
else
{
reader.Close();
return(null);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
/// <summary>
/// 返回数据列表
/// </summary>
/// <param name="safeSql"></param>
/// <returns></returns>
public List <UserInfoEnity> GetNewsBySql(string safeSql)
{
List <UserInfoEnity> list = new List <UserInfoEnity>();
try
{
DataTable table = SQLHelper.GetTable(safeSql);
foreach (DataRow row in table.Rows)
{
UserInfoEnity user = new UserInfoEnity();
user.u_account = (int)row["u_account"];
user.u_name = (string)row["u_name"];
user.u_password = (string)row["u_password"];
//user.u_privilege = (int)row["u_privilege"];
user.u_sex = (string)row["u_sex"];
list.Add(user);
}
return(list);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
/// <summary>
/// 获取数据列表
/// </summary>
/// <param name="strWhere"></param>
/// <returns></returns>
public List <UserInfoEnity> GetList()
{
List <UserInfoEnity> list = new List <UserInfoEnity>();
//SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["restaurantSys"].ToString());
string sql = "select t1.u_account,t1.u_name,t1.u_password,t1.u_sex,t2.p_name from UserInfo t1 inner join User_Privilege t2 on t1.u_privilege = t2.p_id ";
SqlDataReader sdr = SQLHelper.ExecuteReader(sql);
while (sdr.Read())
{
UserInfoEnity u = new UserInfoEnity(Convert.ToInt32(sdr[0]), sdr[1].ToString(), sdr[2].ToString(), sdr[3].ToString(), sdr[4].ToString());
list.Add(u);
}
return(list);
}
public void ProcessRequest(HttpContext context)
{
UserInfoEnity ui = new UserInfoEnity();
ui.Xq = context.Request["xq"];
ui.Username = context.Request["username"];
ui.Tel = context.Request["tel"];
ui.Idcard = context.Request["idcard"];
ui.Carnum = context.Request["carnum"];
ui.Addr = context.Request["addr"];
ui.Isidentical = context.Request["identical"];
ui.Isempty = context.Request["isempty"];
ui.Isoutcoming = context.Request["isoutcoming"];
ui.Relationship = context.Request["relationship"];
ui.Imageurl = context.Request["imageurl"];
ui.Inserttime = DateTime.Now.ToString();
MSG msg = new MSG();
DBOpration db = new DBOpration();
bool checkidcard = db.CheckIDCard(ui.Idcard);
if (checkidcard)
{
int result = db.InsertInfo(ui);
if (result == 1)
{
msg.Code = "200";
}
else
{
msg.Code = "300";
msg.Msg = "新增失败";
}
}
else
{
msg.Code = "301";
msg.Msg = "新增失败，身份证号重复";
}
context.Response.ContentType = "text/plain";
context.Response.Write(JsonHelper.GetJson <MSG>(msg));
}
