public List<PromotionAmountDiscountQuery> Query(PromotionAmountDiscountQuery query, out int totalCount, string eventtype) { try { List<PromotionAmountDiscountQuery> _list = _padDao.Query(query, out totalCount, eventtype); if (_list.Count > 0) { ShopClassDao _scDao = new ShopClassDao(connStr); VipUserGroupDao _vugDao = new VipUserGroupDao(connStr); SiteDao _sDao = new SiteDao(connStr); foreach (PromotionAmountDiscountQuery item in _list) { if (item.class_id != 0) { item.class_name = _scDao.QueryStore(item.class_id).FirstOrDefault().class_name; } if (item.brand_id != 0) { item.brand_name = _vendorBrandDao.GetProductBrand(new VendorBrand { Brand_Id = Convert.ToUInt32(item.brand_id) }).Brand_Name; } if (item.group_id != 0) { item.group_name = _vugDao.GetModelById(Convert.ToUInt32(item.group_id)).group_name; } string[] arrySite = item.siteId.Split(','); foreach (string i in arrySite) { if (i != "" && i != "0") { item.site += _sDao.Query(new Site { Site_Id = Convert.ToUInt32(i) }).FirstOrDefault().Site_Name + ","; } } item.site = item.site.TrimEnd(','); item.isallclass = GetProductFromProCatSetAsCid(item.category_id, 999999); } } return _list; } catch (Exception ex) { throw new Exception("PromotionsAmountDiscountMgr-->Query-->" + ex.Message, ex); } }
public HttpResponseBase DiscountZheList() { List<PromotionAmountDiscountQuery> store = new List<PromotionAmountDiscountQuery>(); string json = string.Empty; try { PromotionAmountDiscountQuery query = new PromotionAmountDiscountQuery(); query.Start = Convert.ToInt32(Request.Params["start"] ?? "0"); if (!string.IsNullOrEmpty(Request.Params["limit"])) { query.Limit = Convert.ToInt32(Request.Params["limit"]); } if (!string.IsNullOrEmpty(Request.Params["expiredSel"])) { query.expired = Convert.ToInt32(Request.Params["expiredSel"]); } if (!string.IsNullOrEmpty(Request.Params["isurl"])) { query.url_by = Convert.ToInt32(Request.Params["isurl"]); } else { query.url_by = -1; } query.event_type = "M1"; int totalCount = 0; store = _promoAmountDiscountMgr.Query(query, out totalCount, query.event_type); foreach (var item in store) { if (item.banner_image != "") { item.banner_image = imgServerPath + promoPath + item.banner_image; } else { item.banner_image = defaultImg; } } IsoDateTimeConverter timeConverter = new IsoDateTimeConverter(); //这里使用自定义日期格式,如果不使用的话,默认是ISO8601格式 timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss"; //listUser是准备转换的对象 json = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(store, Formatting.Indented, timeConverter) + "}";//返回json數據 } catch (Exception ex) { Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); json = "{success:false,totalCount:0,data:[]}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
/// <summary> /// 查詢數據 /// </summary> /// <param name="query">查詢參數</param> /// <param name="totalCount">查詢出來的數量</param> /// <param name="eventtype"></param> /// <returns>返回列表所需數據</returns> public List<PromotionAmountDiscountQuery> Query(PromotionAmountDiscountQuery query, out int totalCount, string eventtype) { query.Replace4MySQL(); StringBuilder condition = new StringBuilder(); StringBuilder TempCol = new StringBuilder(); try { TempCol.Append(@"select CONCAT(pad.event_type ,right(CONCAT('00000000',pad.id),6)) as 'event_id',pad.url_by, pad.id, pad.name,pad.active*1 as 'active', pad.event_desc ,pad.class_id,pad.brand_id,pad.amount,pad.quantity,pad.discount,pad.product_id, pc.category_id,pc.banner_image,pc.category_link_url 'category_link_url',pad.group_id,tp.parameterName 'devicename', pad.condition_id,uc.condition_name,pad.vendor_coverage,pad.site as 'siteId',pad.start 'startdate',pad.end 'enddate',pad.muser,mu.user_username "); condition.Append(" from promotions_amount_discount pad LEFT JOIN manage_user mu ON pad.muser=mu.user_id "); condition.Append(" left join product_category pc on pc.category_id=pad.category_id "); condition.Append(" left join user_condition uc on uc.condition_id =pad.condition_id "); condition.Append(" left join (select parameterCode,parameterName from t_parametersrc where parameterType='device' ) tp on tp.parameterCode=pad.device "); condition.AppendFormat(" where pad.status=1 "); if (query.url_by != -1) { condition.AppendFormat(" and pad.url_by = '{0}' ", query.url_by); } if (query.id > 0) { condition.AppendFormat(" and pad.id = '{0}' ", query.id); } if (eventtype != "") { if (eventtype == "M1") { condition.AppendFormat(" and (pad.event_type='{0}' OR pad.event_type='') ", eventtype); } else { condition.AppendFormat(" and pad.event_type='{0}' ", eventtype); } } if (query.expired == 0)//是未過期 { condition.AppendFormat(" and pad.end >= '{0}' ", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); } else if (query.expired == 1) { condition.AppendFormat(" and pad.end < '{0}' ", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); } condition.AppendFormat(" ORDER BY pad.id desc "); totalCount = 0; if (query.IsPage) { System.Data.DataTable _dt = _access.getDataTable("select count(pad.id) as totalCount " + condition.ToString()); if (_dt != null && _dt.Rows.Count > 0) { totalCount = Convert.ToInt32(_dt.Rows[0]["totalCount"]); } condition.AppendFormat(" limit {0},{1}", query.Start, query.Limit); } TempCol.Append(condition.ToString()); return _access.getDataTableForObj<PromotionAmountDiscountQuery>(TempCol.ToString()); } catch (Exception ex) { throw new Exception("PromotionsAmountDiscountDao-->Query-->" + ex.Message + TempCol.ToString(), ex); } }