private void HandleOrder(int id) { ShowShop.BLL.Order.Orders ordersbll = new ShowShop.BLL.Order.Orders(); ShowShop.Model.Order.Orders ordersModel = ordersbll.GetModel(id); if (ordersModel != null) { ShowShop.BLL.Order.OrderProduct orderProductbll = new ShowShop.BLL.Order.OrderProduct(); DataTable orderProductDT = orderProductbll.GetListOrderProduct(id.ToString()); ShowShop.BLL.Member.MemberAccount memberaccountbll = new ShowShop.BLL.Member.MemberAccount(); ShowShop.Model.Member.MemberAccount memberaccounModel = memberaccountbll.GetModel(ordersModel.UserId); // ShowShop.BLL.Product.ProductSpecification spebll = new ShowShop.BLL.Product.ProductSpecification(); decimal DonateIntegral = 0; if (orderProductDT.Rows.Count > 0) { ShowShop.BLL.Product.ProductInfo productinfoBll = new ShowShop.BLL.Product.ProductInfo(); for (int i = 0; i < orderProductDT.Rows.Count; i++) { ShowShop.Model.Product.ProductInfo productInfoModel = productinfoBll.GetModel(Convert.ToInt32(orderProductDT.Rows[i]["ProId"].ToString())); if (productInfoModel != null) { // DonateIntegral += Convert.ToDecimal(productInfoModel.pro_DonateIntegral); // productinfoBll.Amend(productInfoModel.pro_ID, "pro_SaleNum", productInfoModel.pro_SaleNum + Convert.ToInt32(orderProductDT.Rows[i]["ProNum"].ToString())); if (!string.IsNullOrEmpty(orderProductDT.Rows[i]["Specification"].ToString())) { // List<ShowShop.Model.Product.ProductSpecification> spcList = spebll.GetSpecification(" and ProductId=" + orderProductDT.Rows[i]["ProId"].ToString() + " and Specifications='" + orderProductDT.Rows[i]["Specification"].ToString() + "'"); // if (spcList.Count > 0) // { // spebll.Amend(spcList[0].Id, "ProductStock", Convert.ToInt32(spcList[0].ProductStock) - Convert.ToInt32(orderProductDT.Rows[i]["ProNum"].ToString())); // } } else { //if (Convert.ToInt32(productInfoModel.pro_Stock) >= Convert.ToInt32(orderProductDT.Rows[i]["ProNum"].ToString())) { // productinfoBll.Amend(productInfoModel.pro_ID, "pro_Stock", Convert.ToInt32(productInfoModel.pro_Stock) - Convert.ToInt32(orderProductDT.Rows[i]["ProNum"].ToString())); } } } } //购买商品赠送积分 if (memberaccounModel != null) { if (DonateIntegral > 0) { if (memberaccountbll.Amend(memberaccounModel.UID, "Points", memberaccounModel.Points + DonateIntegral) > 0) { ShowShop.BLL.Member.Integral integralBll = new ShowShop.BLL.Member.Integral(); ShowShop.Model.Member.Integral integral = new ShowShop.Model.Member.Integral(); integral.Userid = memberaccounModel.UID; integral.OrderId = ordersModel.OrderId; integral.IntegralClass = 1; integral.IntegralNum = memberaccounModel.Points + DonateIntegral; integral.GainDate = Convert.ToDateTime(System.DateTime.Now); integral.NoteDate = Convert.ToDateTime(System.DateTime.Now); integral.NoteName = "系统"; integral.Remark = "购买商品后赠送的积分"; integral.IntegralStatus = 0; integral.Origin = "订单"; integralBll.Add(integral); } } } } } }
/// <summary> /// 根据条件查集合 按获得积分时间排序 /// </summary> /// <param name="where"></param> /// <returns></returns> public List<ShowShop.Model.Member.Integral> GetListByWhere(string where) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from [yxs_integral] "); if(where!=null&&where!=""){ strSql.Append(" where "+where+" "); } strSql.Append(" order by GainDate Desc"); List<ShowShop.Model.Member.Integral> lists = new List<ShowShop.Model.Member.Integral>(); using(SqlDataReader reader=ChangeHope.DataBase.SQLServerHelper.ExecuteReader(strSql.ToString())) { while(reader.Read()) { ShowShop.Model.Member.Integral model = new ShowShop.Model.Member.Integral(); model.Id=(int)reader["id"]; model.Userid = (int)reader["userId"]; model.OrderId =(string)reader["orderid"]; model.IntegralClass = (int)reader["integralClass"]; model.Origin = (string)reader["origin"]; model.IntegralNum = Convert.ToDecimal(reader["integral"]); model.GainDate = Convert.ToDateTime(reader["gainDate"]); model.NoteDate = Convert.ToDateTime(reader["noteDate"]); model.NoteName = (string)reader["noteName"]; model.Remark = (string)reader["remark"]; model.IntegralStatus = (int)reader["integralStatus"]; lists.Add(model); } } return lists; }