public HttpResponseBase GetOrderUserReduce() { string json = string.Empty; List<PromotionsAmountReduceMemberQuery> store = new List<PromotionsAmountReduceMemberQuery>(); PromotionsAmountReduceMemberQuery query = new PromotionsAmountReduceMemberQuery(); try { int totalCount = 0; query.Start = Convert.ToInt32(Request.Params["start"] ?? "0"); query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25"); if (!string.IsNullOrEmpty(Request.Params["select_type"]))//查詢條件 { query.select_type = Request.Params["select_type"]; } if (!string.IsNullOrEmpty(Request.Params["search_con"]))//查詢內容 { query.search_con = Request.Params["search_con"]; } if (!string.IsNullOrEmpty(Request.Params["reduce_id"])) { query.reduce_id = Convert.ToInt32(Request.Params["reduce_id"]); } if (!string.IsNullOrEmpty(Request.Params["date"])) { query.search_date = Convert.ToInt32(Request.Params["date"]); } if (!string.IsNullOrEmpty(Request.Params["start_time"])) { query.start_time = Convert.ToDateTime(Request.Params["start_time"]); } if (!string.IsNullOrEmpty(Request.Params["end_time"])) { query.end_time = Convert.ToDateTime(Request.Params["end_time"]); } if (!string.IsNullOrEmpty(Request.Params["group_id"])) { query.group_id = Convert.ToInt32(Request.Params["group_id"]); } if (!string.IsNullOrEmpty(Request.Params["type"])) { query.type = Convert.ToInt32(Request.Params["type"]); } _IOrderUserMgr = new OrderUserReduceMgr(mySqlConnectionString); store = _IOrderUserMgr.GetOrderUserReduce(query, out totalCount); foreach (var item in store) { item.suser_reg_date = CommonFunction.GetNetTime(item.user_reg_date); } IsoDateTimeConverter timeConverter = new IsoDateTimeConverter(); timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss"; json = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(store, Formatting.Indented, timeConverter) + "}"; } 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:true,totalCount:0,data:[]}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
public HttpResponseBase GetPromotionsAmoutReduce() { string json = string.Empty; List<PromotionsAmountReduceMemberQuery> store = new List<PromotionsAmountReduceMemberQuery>(); PromotionsAmountReduceMemberQuery PAM = new PromotionsAmountReduceMemberQuery(); try { _IOrderUserMgr = new OrderUserReduceMgr(mySqlConnectionString); store = _IOrderUserMgr.GetReduceStore(); PAM.id = 0; PAM.name = "所有減免活動"; store.Insert(0, PAM); json = "{success:true,data:" + JsonConvert.SerializeObject(store, Formatting.Indented) + "}"; } 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:true,totalCount:0,data:[]}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
public HttpResponseBase GetVipUserGroup() { string json = string.Empty; List<VipUserGroup> store = new List<VipUserGroup>(); VipUserGroup vu = new VipUserGroup(); try { _IOrderUserMgr = new OrderUserReduceMgr(mySqlConnectionString); store = _IOrderUserMgr.GetVipUserGroupStore(); vu.group_id = 0; vu.group_name = "所有群組會員"; store.Insert(0, vu); json = "{success:true,data:" + JsonConvert.SerializeObject(store, Formatting.Indented) + "}"; } 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:true,totalCount:0,data:[]}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }