/// <summary>
/// 查询所有用户
/// </summary>
/// <returns></returns>
public static List <UserInfoModel> GetList()
{
string sql = "select * from UserInfo";
DataTable dt = DBHelper.GetDataTableBySql(sql);
List <UserInfoModel> list = new List <UserInfoModel>();
if (dt != null && dt.Rows.Count >= 1)
{
foreach (DataRow item in dt.Rows)
{
UserInfoModel user = new UserInfoModel();
user.UserID = int.Parse(item["UserID"].ToString());
user.UserName = item["UserName"].ToString();
user.UserPwd = item["UserPwd"].ToString();
user.Age = int.Parse(item["Age"].ToString());
user.QQ = item["QQ"].ToString();
user.Phone = item["Phone"].ToString();
user.Address = item["Address"].ToString();
user.CreateTime = DateTime.Now;
user.UserType = item["UserType"].ToString();
list.Add(user);
}
return(list);
}
else
{
return(null);
}
}
/// <summary>
/// 查询所有产品列表
/// </summary>
/// <returns></returns>
public static List <UserInfoModel> GETselect()
{
string sql = string.Format(@"select * from Product");
DataTable dt = DBHelper.GetDataTableBySql(sql);
List <UserInfoModel> list = new List <UserInfoModel>();
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow item in dt.Rows)
{
UserInfoModel m = new UserInfoModel();
m.ProductID = int.Parse(item["ProductID"].ToString());
m.ProductName = item["ProductName"].ToString();
m.ProductPic = item["ProductPic"].ToString();
m.ProductPrice = decimal.Parse(item["ProductPrice"].ToString());
m.ProductDesc = item["ProductDesc"].ToString();
m.ClassID = int.Parse(item["ClassID"].ToString());
m.AddTime = DateTime.Parse(item["AddTime"].ToString());
list.Add(m);
}
return(list);
}
else
{
return(null);
}
}
/// <summary>
/// 分页
/// </summary>
/// <returns></returns>
public static List <UserInfoModel> GETselectPageSize(int pageSize, int pageIndex)
{
string sql = string.Format(@"select top {0} * from Product where ProductID not in
(select top {1} ProductID from Product order by ProductID)
order by ProductID", pageSize, pageSize * (pageIndex - 1));
DataTable dt = DBHelper.GetDataTableBySql(sql);
List <UserInfoModel> plist = new List <UserInfoModel>();
for (int i = 0; i < dt.Rows.Count; i++)
{
UserInfoModel p = new UserInfoModel();
p.ProductID = int.Parse(dt.Rows[i]["ProductID"].ToString());
p.ProductName = dt.Rows[i]["ProductName"].ToString();
p.ProductPic = dt.Rows[i]["ProductPic"].ToString();
p.ProductPrice = decimal.Parse(dt.Rows[i]["ProductPrice"].ToString());
p.ProductDesc = dt.Rows[i]["ProductDesc"].ToString();
p.AddTime = DateTime.Parse(dt.Rows[i]["AddTime"].ToString());
plist.Add(p);
}
return(plist);
}
/// <summary>
/// 根据类别查询
/// </summary>
/// <param name="pageSize"></param>
/// <param name="pageIndex"></param>
/// <param name="ClassId"></param>
/// <returns></returns>
public static List <UserInfoModel> SelectByCid(int ClassId)
{
string sql = string.Format(@"select * from Product where ClassID={0}", ClassId);
DataTable dt = DBHelper.GetDataTableBySql(sql);
List <UserInfoModel> plist = new List <UserInfoModel>();
for (int i = 0; i < dt.Rows.Count; i++)
{
UserInfoModel p = new UserInfoModel();
p.ProductID = int.Parse(dt.Rows[i]["ProductID"].ToString());
p.ProductName = dt.Rows[i]["ProductName"].ToString();
p.ProductPic = dt.Rows[i]["ProductPic"].ToString();
p.ClassID = int.Parse(dt.Rows[i]["ClassId"].ToString());
p.ProductPrice = decimal.Parse(dt.Rows[i]["ProductPrice"].ToString());
p.ProductDesc = dt.Rows[i]["ProductDesc"].ToString();
p.AddTime = DateTime.Parse(dt.Rows[i]["AddTime"].ToString());
plist.Add(p);
}
return(plist);
}
/// <summary>
/// 查询所有的类别
/// </summary>
/// <returns></returns>
public static DataTable GetProClass()
{
string sql = "select * from ProductClass";
return(DBHelper.GetDataTableBySql(sql));
}
