public static List <ProductEntity> GetSaleProductsListToList(string weixinid, string search, string cityName, string price)
{
int count = 0;
//ProductEntityList list_products = new ProductEntityList();
//var dt = CommodityService.GetSaleProductsListIndex(weixinid, out count, 1, 99, "", "");
//list_products.ProductEntity_List = ProductEntity.ConvertProductEntityIndexListMall(dt);
//list_products.Count = count;
//ViewData["products"] = list_products.ProductEntity_List;
ProductEntityList list_products = new ProductEntityList();
var dt = CommodityService.GetSaleProductsListIndex(weixinid, out count, 1, 99, "ProductName", search, cityName, price);
list_products.ProductEntity_List = ProductEntity.ConvertProductEntityIndexListMall(dt);
//list_products.ProductEntity_List = SaleProduct.GetSaleProductsListIndexA(weixinid, out count, 1, 99, "", "");
list_products.Count = count;
list_products.ProductEntity_List = TravelAgencyCommon.ProductListDo(list_products.ProductEntity_List);
list_products.ProductEntity_List = list_products.ProductEntity_List.Where(c => c.List_SaleProducts_TC.Count > 0).ToList();
return(list_products.ProductEntity_List);
}
/// <summary>
/// 订单表、订单详细表插入数据
/// </summary>
/// <param name="weixinID"></param>
/// <param name="userweixinID"></param>
/// <param name="hotelId"></param>
/// <param name="remark"></param>
/// <param name="LinkMan"></param>
/// <param name="LinkPhone"></param>
/// <param name="AddressType"></param>
/// <param name="Address"></param>
/// <returns></returns>
public string InsertOrder(string weixinID, string userweixinID, string hotelId, string remark, string LinkMan, string LinkPhone, string AddressType, string Address, string ExpressFee, string CouponId, string CouponMoney)
{
ShoppingCartService cartService = new ShoppingCartService();
CommodityService commodityService = new CommodityService();
//计算订单总金额
var shoppingCarDataTable = cartService.GetDataByUserId(hotelId, userweixinID);
double sum = 0;
int needPoints = 0;
int canPoints = 1;
if (shoppingCarDataTable.Rows.Count > 0)
{
lock (this)
{
string orderid = "D" + DateTime.Now.ToString("yyMMddHHmmss") + new Random().Next(100, 0x3e7);
string sql = @"INSERT INTO [WeiXin].[dbo].[SupermarketOrderDetail_Levi]
([OrderId]
,[weixinID]
,[HotelId]
,[CommodityId]
,[Total]
,[Name]
,[ImagePath]
,[ImageList]
,[Price]
,[PurchasePoints]
,[CanPurchase]
)
VALUES
(@OrderId
,@weixinID
,@HotelId
,@CommodityId
,@Total
,@Name
,@ImagePath
,@ImageList
,@Price
,@PurchasePoints
,@CanPurchase
)";
foreach (DataRow data in shoppingCarDataTable.Rows)
{
SQLHelper.Run_SQL(sql, SQLHelper.GetCon(), new Dictionary <string, DBParam>()
{
{ "OrderId", new DBParam()
{
ParamValue = orderid
} },
{ "weixinID", new DBParam()
{
ParamValue = weixinID
} },
{ "HotelId", new DBParam()
{
ParamValue = hotelId
} },
{ "CommodityId", new DBParam()
{
ParamValue = data["CommodityId"].ToString()
} },
{ "Total", new DBParam()
{
ParamValue = data["Total"].ToString()
} },
{ "Name", new DBParam()
{
ParamValue = data["Name"].ToString()
} },
{ "ImagePath", new DBParam()
{
ParamValue = data["ImagePath"].ToString()
} },
{ "ImageList", new DBParam()
{
ParamValue = data["ImageList"].ToString()
} },
{ "Price", new DBParam()
{
ParamValue = data["Price"].ToString()
} },
{ "PurchasePoints", new DBParam()
{
ParamValue = data["PurchasePoints"].ToString()
} },
{ "CanPurchase", new DBParam()
{
ParamValue = data["CanPurchase"].ToString()
} }
});
//减少库存
int isTrue = commodityService.ReduceStock(data["CommodityId"].ToString(), int.Parse(data["Total"].ToString()));
if (isTrue == 0)
{
return("");
}
//计算总金额
sum += double.Parse(data["Price"].ToString()) * int.Parse(data["Total"].ToString());
if (int.Parse(data["CanPurchase"].ToString()) == 0)
{
canPoints = 0;
}
else
{
needPoints += int.Parse(data["PurchasePoints"].ToString()) * int.Parse(data["Total"].ToString());
}
}
sum += double.Parse(ExpressFee);
if (!string.IsNullOrWhiteSpace(CouponId))
{
sum -= double.Parse(CouponMoney);
var coupon = new CouPon();
int couponUpate = coupon.UpdateCouponEmploy(CouponId, orderid);
if (couponUpate == 0)
{
return("");
}
}
int insert = InsertOrderToDB(orderid, weixinID, userweixinID, hotelId, sum, remark, LinkMan, LinkPhone, AddressType, Address, ExpressFee, canPoints.ToString(), needPoints.ToString(), CouponId, CouponMoney);
if (insert == 0)
{
return("");
}
return(orderid);
}
}
else
{
return("");
}
}
