public HttpResponseBase UpdateStats() { string json = string.Empty; try { edmgroupmgr = new EdmGroupNewMgr(mySqlConnectionString); EdmGroupNewQuery query = new EdmGroupNewQuery(); if (!string.IsNullOrEmpty(Request.Params["id"])) { query.group_id = Convert.ToInt32(Request.Params["id"]); } if (!string.IsNullOrEmpty(Request.Params["active"])) { query.enabled = Convert.ToInt32(Request.Params["active"]); } json = edmgroupmgr.UpdateStatus(query); } 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; }
public HttpResponseBase SaveEdmGroupNewAdd() //add by yachao1120j 2015-9-22 { string json = string.Empty; try { EdmGroupNewQuery query = new EdmGroupNewQuery(); edmgroupmgr = new EdmGroupNewMgr(mySqlConnectionString); if (!string.IsNullOrEmpty(Request.Params["group_id"])) { query.group_id = Convert.ToInt32(Request.Params["group_id"]); } if (!string.IsNullOrEmpty(Request.Params["group_name"])) { query.group_name = Request.Params["group_name"]; } if (!string.IsNullOrEmpty(Request.Params["is_member_edm"])) { query.is_member_edm = Convert.ToInt32(Request.Params["is_member_edm"]); } if (!string.IsNullOrEmpty(Request.Params["trial_url"])) { query.trial_url = Request.Params["trial_url"]; } if (!string.IsNullOrEmpty(Request.Params["sort_order"])) { query.sort_order = Convert.ToInt32(Request.Params["sort_order"]); } if (!string.IsNullOrEmpty(Request.Params["description"])) { query.description = Request.Params["description"]; } query.group_create_userid = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id; query.group_update_userid = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id; int _dt = edmgroupmgr.SaveEdmGroupNewAdd(query); if (_dt > 0) { json = "{success:true}"; } else { json = "{success:false}"; } } 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 Response; }
public HttpResponseBase GetEdmGroupNewList()// add by yachao1120j 2015-9-21 { string json = string.Empty; int totalcount = 0; try { EdmGroupNewQuery query = new EdmGroupNewQuery(); query.Start = Convert.ToInt32(Request.Params["start"] ?? "0"); query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25"); edmgroupmgr = new EdmGroupNewMgr(mySqlConnectionString); if (!string.IsNullOrEmpty(Request.Params["group_name_list"])) { query.group_name = Request.Params["group_name_list"]; } List<EdmGroupNewQuery> list = edmgroupmgr.GetEdmGroupNewList(query, out totalcount); IsoDateTimeConverter timeConverter = new IsoDateTimeConverter(); timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss"; // timeConverter.DateTimeFormat = "yyyy-MM-dd"; json = "{success:true,totalCount:" + totalcount + ",data:" + JsonConvert.SerializeObject(list, 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:false,totalCount:0,data:[]}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return Response; }