/// <summary>
/// 更新商品信息
/// </summary>
/// <param name="model"></param>
/// <param name="errMsg"></param>
/// <returns></returns>
public static bool Update(ProductInfo model, out string errMsg)
{
return(BaseBll <ProductInfo> .Update(model.SellerId, model, out errMsg));
}
/// <summary>
/// 插入商品信息Model，返回新增商品编号
/// </summary>
/// <param name="model"></param>
/// <param name="productId"></param>
/// <param name="errMsg"></param>
/// <returns></returns>
public static bool Insert(ProductInfo model, out int productId, out string errMsg)
{
productId = BaseBll <ProductInfo> .InsertWithReturnId(model, out errMsg);
return(productId > 0);
}
/// <summary>
/// 根据买家Id，商品类别，返回指定卖家上线商品信息列表
/// BuyerProductView不是表记录，而是业务封装视图。
/// gongjun@2016-12-05
/// </summary>
/// <param name="buyerId"></param>
/// <param name="sellerId"></param>
/// <returns></returns>
public static List <BuyerProductView> GetBuyerProductView(int buyerId, int sellerId)
{
//xieguanheng 增加字段 SellerId 的返回 20161231
var list = new List <BuyerProductView>();
var sql = "Select T1.[SellerId],T1.[ClassId], T1.ProductId,[ProductCode],[ProductFullName],[ProductShortName],ProductUnit"
+ ",[Picture1],[Picture2],[Picture3],[Picture4],[Picture5],[Picture6]"
+ ",T2.[Price1],T2.[MinOrder1],T2.[MaxOrder1],T2.IsNew,T2.IsPromotion,T3.[ProductQuantity]"
+ " From [dbo].[ProductInfo] T1"
+ " Left Join [SellerProductOnlineCustomerStrategy] T2"
+ " On T1.[ProductId]= T2.[ProductId]"
+ " Inner Join [BuyerShoppingCart] T3"
+ " On T1.[ProductId]=T3.[ProductId]"
+ string.Format("Where T1.[SellerId]= {0} And T2.BuyerId = {1}"
, sellerId, buyerId)
+ " And [SaleStartDate]<GETDATE() And[SaleEndDate]>GETDATE()";
var dt = BaseBll <object> .ExecuteDataTable(sql, GetConnectionString(sellerId));
if (dt.Rows.Count == 0)
{
sql = "Select T1.[SellerId],T1.[ClassId], T1.ProductId,[ProductCode],[ProductFullName],[ProductShortName],ProductUnit"
+ ",[Picture1],[Picture2],[Picture3],[Picture4],[Picture5],[Picture6]"
+ ",T2.[Price1],T2.[MinOrder1],T2.[MaxOrder1],T2.IsNew,T2.IsPromotion,T3.[ProductQuantity]"
+ " From [dbo].[ProductInfo] T1"
+ " Left Join [SellerProductOnline] T2"
+ " On T1.[ProductId]= T2.[ProductId]"
+ " Inner Join [BuyerShoppingCart] T3"
+ " On T1.[ProductId]=T3.[ProductId]"
+ string.Format("Where T1.[SellerId]= {0} And T2.SaleState=1"
, sellerId)
+ " And [SaleStartDate]<GETDATE() And[SaleEndDate]>GETDATE()";
dt = BaseBll <object> .ExecuteDataTable(sql, GetConnectionString(sellerId));
}
foreach (DataRow row in dt.Rows)
{
var view = new BuyerProductView();
view.SellerId = Convert.ToInt32(row["SellerId"]);
view.ClassId = Convert.ToInt32(row["ClassId"]);
view.ProductId = Convert.ToInt32(row["ProductId"]);
view.ProductCode = row["ProductCode"].ToString();
view.ProductFullName = row["ProductFullName"].ToString();
view.ProductShortName = row["ProductShortName"].ToString();
view.ProductUnit = row["ProductUnit"].ToString();
view.Picture1 = Convert.ToInt32(row["Picture1"]);
view.Picture2 = Convert.ToInt32(row["Picture2"]);
view.Picture3 = Convert.ToInt32(row["Picture3"]);
view.Picture4 = Convert.ToInt32(row["Picture4"]);
view.Picture5 = Convert.ToInt32(row["Picture5"]);
view.Price1 = Convert.ToSingle(row["Price1"]);
view.MinOrder1 = Convert.ToInt16(row["MinOrder1"]);
view.MaxOrder1 = Convert.ToInt32(row["MaxOrder1"]);
view.IsNew = Convert.ToBoolean(row["IsNew"]);
view.IsPromotion = Convert.ToBoolean(row["IsPromotion"]);
try
{
view.ProductQuantity = Convert.ToInt32(row["ProductQuantity"]);
}
catch (Exception ex)
{
view.ProductQuantity = 0;
}
list.Add(view);
}
return(list);
}
public static List <BuyerShoppingCartViewModel> GetBuyerShoppingCartViewModels(int buyerId, out string msg)
{
string sql = "select c.*,s.CompanyName as SellerName,p.ProductFullName as ProductName,p.ProductUnit as ProductUnit,p.Price1 as Price from BuyerShoppingCart c ,SellerInfo s,ProductInfo p where c.SellerId=s.SellerId and c.ProductId =p.ProductId and c.BuyerId =" + buyerId;
return(BaseBll <BuyerShoppingCartViewModel> .GetList(sql, GetConnectionString(buyerId), out msg).ToList());
}
/// <summary>
/// 返回指定买家关联卖家的Id列表
/// xieguanheng@2016-12-29
/// </summary>
/// <param name="buyerId"></param>
/// <param name="errMsg"></param>
/// <returns></returns>
public static List <SellerInfo> GetSellerList(int buyerId, out string errMsg)
{
var sql = string.Format("Select a.* From [SellerInfo] a, [SellerCustomerInfo] b Where a.SellerId=b.SellerId and [BuyerId]={0}", buyerId);
return(BaseBll <SellerInfo> .GetList(sql, GetConnectionString(buyerId), out errMsg));
}