#region//查询
/// <summary>
/// 查询
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public DataTable Search(string info)
{
string sql = "select * from " + info;
DataTable dt = db.GetDataTable(sql);
return dt;
}
public DataTable Search(string info, int userId)
{
string sql = "select * from " + info + " where Username=" + userId;
DataTable dt = db.GetDataTable(sql);
return dt;
}
#endregion
#region//找回密码
/// <summary>
/// 找回密码
/// </summary>
/// <returns></returns>
public DataTable FindPsw(string name, string tel, string addr)
{
string sql = "select * from Customer where CName='" + name + "' and CTel='" + tel + "' and CAddr='" + addr + "'";
return db.GetDataTable(sql);
}
#endregion
#region//添加管理员
public Result InsertAdmin(AdminModel amodel)
{
Result result = new Result();
try
{
string sql = "insert into Admin([AID],[APsw],[AName],[ASex],[APower])" +
"values('{0}','{1}','{2}','{3}',{4})";
sql = string.Format(sql, amodel.Id, amodel.PassWord, amodel.Name, amodel.Sex, 1);
db.ExecuteNonQuery(sql);
result.code = true;
result.Info = "添加成功";
}
catch (Exception ex)
{
result.code = false;
result.Info = ex.Message;
}
return result;
}
#endregion