protected override ApplyRD ProcessRequest(APIRequest <ApplyRP> pRequest) { var rd = new ApplyRD(); FromSetting fs = new FromSetting(); fs.SMTPServer = "smtp.exmail.qq.com"; fs.SendFrom = "*****@*****.**"; fs.UserName = "******"; fs.Password = "******"; string mailTo = "*****@*****.**"; string[] s = new string[1]; var para = pRequest.Parameters; var loggingSessionInfo = new SessionManager().CurrentUserLoginInfo; T_CTW_LEventThemeBLL bllTheme = new T_CTW_LEventThemeBLL(loggingSessionInfo); T_CTW_LEventThemeEntity entityTheme = bllTheme.GetByID(para.ThemeId); DataSet dsCustomer = bllTheme.GetCustomerInfo(); if (dsCustomer.Tables[0] == null) { rd.errCode = 1; rd.errMsg = "商户信息不存在!"; return(rd); } t_customerEntity entityCustomer = DataTableToObject.ConvertToObject <t_customerEntity>(dsCustomer.Tables[0].Rows[0]); if (entityTheme != null) { string strSubject = "活动申请"; string strBody = "商户名称:" + entityCustomer.customer_name + "<br/>联系人:" + entityCustomer.customer_contacter + "<br/>联系方式:" + entityCustomer.customer_tel + "<br/>活动名称:" + entityTheme.ThemeName + "<br/>申请时间:" + DateTime.Now; Mail.SendMail(fs, mailTo, strSubject, strBody, s); rd.errCode = 0; } return(rd); }
/// <summary> /// 更新 /// </summary> /// <param name="pEntity">实体实例</param> /// <param name="pTran">事务实例,可为null,如果为null,则不使用事务来更新</param> public void Update(t_customerEntity pEntity, IDbTransaction pTran) { _currentDAO.Update(pEntity, pTran); }
public object GetDetailByParameters(GetPanicbuyingItemDetailReqPara para, string userId) { LoggingSessionInfo loggingSessionInfo = this.CurrentUserInfo as LoggingSessionInfo; var detail = GetByEventIDAndItemID(para.eventId, para.itemId); if (detail == null) { throw new Exception("未找到相关活动商品信息"); } #region 照片列表 var imagebll = new ObjectImagesBLL(loggingSessionInfo); var tempImageList = imagebll.GetObjectImagesByObjectId(para.itemId); var imagelist = tempImageList.Select(t => new { imageId = t.ImageId, imageUrl = t.ImageURL, imageUrlThumb = GetImageUrl(t.ImageURL, "_120"), imageUrlMiddle = GetImageUrl(t.ImageURL, "_240"), imageUrlBig = GetImageUrl(t.ImageURL, "_480") }).ToArray(); #endregion #region sku列表 var skubll = new SkuService(loggingSessionInfo); var ds = skubll.GetItemSkuListByEventId(para.itemId, para.eventId); var skulist = ds.Tables[0].AsEnumerable().Select(t => new { skuId = t["skuId"].ToString(), skuProp1 = t["skuProp1"].ToString(), skuProp2 = t["skuProp2"].ToString(), price = t["price"] is DBNull ? 0 : Double.Parse(t["price"].ToString()), salesPrice = t["salesPrice"] is DBNull ? 0 : Double.Parse(t["salesPrice"].ToString()), //price = t["price"] is DBNull ? "0" : Double.Parse(t["price"].ToString()).ToString("0.##"), //salesPrice = t["salesPrice"] is DBNull ? "0" : Double.Parse(t["salesPrice"].ToString()).ToString("0.##"), discountRate = string.IsNullOrEmpty(t["discountRate"].ToString()) ? "0" : t["discountRate"].ToString(),//折扣 integral = string.IsNullOrEmpty(t["integral"].ToString()) ? "0" : t["integral"].ToString(), //qty = Convert.ToInt32(t["qty"] is DBNull ? "0" : t["qty"]), //overQty = Convert.ToInt32(t["overQty"] is DBNull ? "0" : t["overQty"]) }).ToArray(); #endregion #region 购买用户列表 var inoutbll = new T_InoutBLL(loggingSessionInfo); var dsSalesUsers = inoutbll.GetItemEventSalesUserList(para.itemId, para.eventId); var salesUserList = dsSalesUsers.Tables[0].AsEnumerable().Select(t => new { userId = t["userId"].ToString(), imageURL = t["imageURL"].ToString() }).ToArray(); #endregion #region 门店信息 object storeInfo = null; var dsStore = inoutbll.GetEventStoreByItemAndEvent(para.itemId, para.eventId); if (dsStore.Tables[0].Rows.Count > 0) { var row = dsStore.Tables[0].Rows[0]; storeInfo = new { storeId = row["storeid"], storeName = row["storeName"], address = row["address"], imageURL = row["imageURL"], phone = row["phone"], storeCount = row["storeCount"] }; } #endregion #region 品牌信息 var dsBrand = inoutbll.GetItemBrandInfo(para.itemId); object brandInfo = null; if (dsBrand.Tables[0].Rows.Count > 0) { var row = dsBrand.Tables[0].Rows[0]; brandInfo = new { brandId = row["brandId"], brandLogoURL = row["brandLogoURL"], brandName = row["brandName"], brandEngName = row["brandEngName"] }; } #endregion #region sku信息 IList <object> skuInfoList = new List <object>(); object skuInfo = null; if (skulist.Count() > 0) { for (int i = skulist.Count() - 1; i >= 0; i--) { var sku = skulist[i]; var info = skubll.GetSkuInfoById(sku.skuId); skuInfoList.Add(new { skuId = sku.skuId, prop1DetailId = info.prop_1_id, prop2DetailId = info.prop_2_id }); if (i == 0) { skuInfo = new { skuId = sku.skuId, prop1DetailId = info.prop_1_id, prop2DetailId = info.prop_2_id }; } } } #endregion #region 属性信息 IList <prop1Info> prop1List = new List <prop1Info>(); object prop1 = null; //update by wzq 20140724 if (skulist.Count() > 0) { for (int c = skulist.Count() - 1; c >= 0; c--) { var dsProp = inoutbll.GetItemProp1List(skulist[c].skuId); //var dsProp = inoutbll.GetItemProp1List(para.itemId); if (dsProp.Tables[0].Rows.Count > 0) { prop1List.Add(dsProp.Tables[0].AsEnumerable().Select(t => new prop1Info { skuId = "" + t["skuId"], prop1DetailId = "" + t["prop1DetailId"], prop1DetailName = "" + t["prop1DetailName"], stock = Convert.ToInt32(string.IsNullOrWhiteSpace("" + t["stock"]) == true ? 0 : t["stock"]), salesCount = Convert.ToInt32(string.IsNullOrWhiteSpace("" + t["salesCount"]) == true ? 0 : t["salesCount"]) }).First()); } if (c == 0) { prop1 = dsProp.Tables[0].AsEnumerable().Select(t => new { skuId = "" + t["skuId"], prop1DetailId = "" + t["prop1DetailId"], prop1DetailName = "" + t["prop1DetailName"], stock = Convert.ToInt32(string.IsNullOrWhiteSpace("" + t["stock"]) == true ? 0 : t["stock"]), salesCount = Convert.ToInt32(string.IsNullOrWhiteSpace("" + t["salesCount"]) == true ? 0 : t["salesCount"]) }).First(); } } prop1List = prop1List.GroupBy(t => new { t.prop1DetailId, t.prop1DetailName }).Select(n => new prop1Info { skuId = n.Max(t => t.skuId), prop1DetailId = n.Key.prop1DetailId, prop1DetailName = n.Key.prop1DetailName, stock = n.Sum(t => t.stock), salesCount = n.Sum(t => t.salesCount) }).ToList(); } #endregion #region 限购处理 int canBuyCount = -1; //可购买数量 int singlePurchaseQty = GetEventItemInfo(para.eventId.ToString(), para.itemId); //活动商品限购数量 if (!string.IsNullOrEmpty(userId)) { if (singlePurchaseQty > 0) { //会员采购数量 int purchaseCount = GetVipPurchaseQty(userId, para.eventId, para.itemId); canBuyCount = singlePurchaseQty - purchaseCount; } } #endregion #region 获取商户信息 add by Henry 2014-10-10 var customerBll = new t_customerBLL(loggingSessionInfo); var customerBasicSettingBll = new CustomerBasicSettingBLL(loggingSessionInfo); t_customerEntity customerEntity = customerBll.GetByCustomerID(loggingSessionInfo.CurrentUser.customer_id); //获取商户名称 var customerInfo = new { CustomerName = customerEntity == null ? "" : customerEntity.customer_name, //商户名称 ImageURL = customerBasicSettingBll.GetSettingValueByCode("AppLogo"), //商户Logo CustomerMobile = customerBasicSettingBll.GetSettingValueByCode("CustomerMobile") }; #endregion var content = new { #region 组织属性 itemId = detail.ItemID, itemName = detail.ItemName, salesPersonCount = detail.SalesPersonCount, useInfo = detail.UseInfo, tel = detail.Tel, endTime = detail.EndTime.Value.To19FormatString(), offersTips = detail.OffersTips, prop1Name = detail.Prop1Name, prop2Name = detail.Prop2Name, itemCategoryName = detail.ItemCategoryName, itemCategoryId = detail.ItemCategoryID, itemIntroduce = detail.ItemIntroduce, itemParaIntroduce = detail.ItemParaIntroduce, //salesCount = detail.MonthSalesCount.HasValue ? detail.MonthSalesCount.Value.ToString("0.##") : "0", salesCount = detail.SalesCount, //销量 update by Henry 2014-11-12 beginLineSecond = GetBeginLineSecond(detail.BeginTime.Value), deadlineTime = detail.deadlineTime, discountRate = detail.DiscountRate == null ? 0 : Convert.ToDecimal((detail.DiscountRate / 10).Value.ToString("0.0")),//update by Henry 2014-10-20 addedTime = detail.AddTime.Value.To19FormatString(), deadlineSecond = detail.RemainingSec, beginTime = detail.BeginTime.Value.To19FormatString(), qty = detail.Qty, overQty = detail.RemainingQty, stopReason = detail.StopReason, status = detail.Status, eventId = detail.EventId, eventTypeID = detail.EventTypeID, imageList = imagelist, skuList = skulist, //数组 skuInfoList = skuInfoList, //数组 salesUserList = salesUserList, storeInfo = storeInfo, brandInfo = brandInfo, skuInfo = skuInfo, prop1List = prop1List, //数组 prop1 = prop1, //object canBuyCount = canBuyCount, singlePurchaseQty = singlePurchaseQty, serviceDescription = detail.ServiceDescription, itemSortId = detail.ItemSortId, CustomerInfo = customerInfo #endregion }; return(content); }
/// <summary> /// 创建一个新实例 /// </summary> /// <param name="pEntity">实体实例</param> public void Create(t_customerEntity pEntity) { _currentDAO.Create(pEntity); }
/// <summary> /// 分页根据实体条件查询实体 /// </summary> /// <param name="pQueryEntity">以实体形式传入的参数</param> /// <param name="pOrderBys">排序组合</param> /// <returns>符合条件的实体集</returns> public PagedQueryResult <t_customerEntity> PagedQueryByEntity(t_customerEntity pQueryEntity, OrderBy[] pOrderBys, int pPageSize, int pCurrentPageIndex) { return(_currentDAO.PagedQueryByEntity(pQueryEntity, pOrderBys, pPageSize, pCurrentPageIndex)); }
/// <summary> /// 根据实体条件查询实体 /// </summary> /// <param name="pQueryEntity">以实体形式传入的参数</param> /// <param name="pOrderBys">排序组合</param> /// <returns>符合条件的实体集</returns> public t_customerEntity[] QueryByEntity(t_customerEntity pQueryEntity, OrderBy[] pOrderBys) { return(_currentDAO.QueryByEntity(pQueryEntity, pOrderBys)); }
/// <summary> /// 删除 /// </summary> /// <param name="pEntity"></param> public void Delete(t_customerEntity pEntity) { _currentDAO.Delete(pEntity); }
/// <summary> /// 更新 /// </summary> /// <param name="pEntity">实体实例</param> public void Update(t_customerEntity pEntity) { _currentDAO.Update(pEntity); }