/// <summary>
/// 根据用户名找购物车
/// </summary>
/// <param name="UserId"></param>
/// <param name="PrdNo"></param>
public static DataTable GetCartDt(string UserId)
{
string sql = @"SELECT s.*,p.mainImg,p.newPrice AS prdPrice FROM shoppingCart s JOIN Product p on s.prdNo=p.prdNo where userId=@userId and settleStt=0 ";
SqlParameter[] parameter = { new SqlParameter("@userId", UserId) };
return(DBHelper.ExecuteDatable(sql, CommandType.Text, parameter));
}
/// <summary>
/// 根据用户名找购物车
/// </summary>
/// <param name="UserId"></param>
/// <param name="PrdNo"></param>
public static List <MODEL.ShoppingCart> ListCart(string UserId)
{
string sql = @"SELECT * FROM shoppingCart where userId=@userId settleStt=0 ";
SqlParameter[] parameter = { new SqlParameter("@userId", UserId) };
return(Common.ConvertHelper <MODEL.ShoppingCart> .ConvertToList(DBHelper.ExecuteDatable(sql, CommandType.Text, parameter)));
}
/// <summary>
/// 查询所以商品
/// </summary>
/// <returns></returns>
public static List <Product> GetAllProduct()
{
string sql = @"select * from PRODUCT WHERE prdStation=1 ";
DataTable dt = DBHelper.ExecuteDatable(sql, CommandType.Text);
if (dt.Rows.Count > 0)
{
return(Common.ConvertHelper <Product> .ConvertToList(dt));
}
else
{
return(null);
}
}
/// <summary>
/// 根据编号和名称获取商品
/// </summary>
/// <param name="prd"></param>
/// <returns></returns>
public static List <Product> GetPrdByNameOrNo(string prd)
{
string sql = @"select * from PRODUCT WHERE PRDNO LIKE '%@prd%' ORD PRDNAME like '%@prd%' and prdStation=1 ";
DataTable dt = DBHelper.ExecuteDatable(sql, CommandType.Text, new SqlParameter("@prd", prd));
if (dt.Rows.Count > 0)
{
return(Common.ConvertHelper <Product> .ConvertToList(dt));
}
else
{
return(null);
}
}
/// <summary>
/// 获取商品分页数据
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="total"></param>
/// <returns></returns>
public static List <Product> GetPagingPrd(int pageIndex, int pageSize, out int total)
{
DataTable dt = new DataTable();
SqlParameter[] parameter = new SqlParameter[3];
parameter[0] = new SqlParameter("@pageIndex", pageIndex);
parameter[1] = new SqlParameter("@pageSize", pageSize);
SqlParameter totalParameter = new SqlParameter("@total", SqlDbType.Int);
totalParameter.Direction = ParameterDirection.Output;
parameter[2] = totalParameter;
dt = DBHelper.ExecuteDatable("P_loadPrdPageData", CommandType.StoredProcedure, parameter);
total = (int)totalParameter.Value;
List <Product> pagePrd = Common.ConvertHelper <Product> .ConvertToList(dt);
return(pagePrd);
}
public static List <Product> GetPrdList(string prdType, string orderBy, string AscOrDesc, int pageIndex, int pageSize, out int total)
{
DataTable dt = new DataTable();
SqlParameter[] parameter = new SqlParameter[6];
parameter[0] = new SqlParameter("@prdType", prdType);
parameter[1] = new SqlParameter("@orderBy", orderBy);
parameter[2] = new SqlParameter("@AscOrDesc", AscOrDesc);
parameter[3] = new SqlParameter("@pageIndex", pageIndex);
parameter[4] = new SqlParameter("@pageSize", pageSize);
SqlParameter totalParameter = new SqlParameter("@total", SqlDbType.Int);
totalParameter.Direction = ParameterDirection.Output;
parameter[5] = totalParameter;
dt = DBHelper.ExecuteDatable("P_loadPrdPageDataBySearch", CommandType.StoredProcedure, parameter);
total = (int)totalParameter.Value;
List <Product> pagePrd = Common.ConvertHelper <Product> .ConvertToList(dt);
return(pagePrd);
}