public string UpdateStatus(EdmGroupNewQuery query) // add by yachao1120j 2015-9-21 { string josn; string sql = ""; try { if (query.enabled == 0) { query.enabled = 1; } else { query.enabled = 0; } sql = _edmgroupdao.UpdateStatus(query); if (_dbAccess.execCommand(sql) > 0) { josn = "{success:true}"; } else { josn = "{success:false}"; } return josn; } catch (Exception ex) { throw new Exception("EdmGroupNewMgr-->UpdateStatus-->" + ex.Message + sql, ex); } }
} // add by yachao1120j 2015-9-21 public string UpdateStatus(EdmGroupNewQuery query) // add by yachao1120j 2015-9-21 { StringBuilder strSql = new StringBuilder(); try { strSql.AppendFormat(@"Update edm_group_new set enabled='{0}' WHERE group_id={1}", query.enabled, query.group_id); return strSql.ToString(); } catch (Exception ex) { throw new Exception("EdmGroupNewDao-->UpdateStatus-->" + ex.Message + strSql.ToString(), ex); } }
//插入信息 public int EdmGroupNewInsert(EdmGroupNewQuery query) { StringBuilder sql = new StringBuilder(); query.Replace4MySQL(); try { sql.Append("insert into edm_group_new (group_name, is_member_edm,trial_url, sort_order,description,group_createdate,group_create_userid,group_update_userid)values "); sql.AppendFormat("('{0}','{1}','{2}','{3}','{4}',NOW(),'{5}','{6}')", query.group_name, query.is_member_edm,query.trial_url, query.sort_order, query.description,query.group_create_userid,query.group_update_userid); return _access.execCommand(sql.ToString()); } catch (Exception ex) { throw new Exception("EdmGroupNewDao-->EdmGroupNewInsert-->" + sql.ToString() + ex.Message); } }
//判断是新增 还是 编辑 public int SaveEdmGroupNewAdd(EdmGroupNewQuery query) { try { if (query.group_id == 0)//新增 { return _edmgroupdao.EdmGroupNewInsert(query); } else//編輯 { return _edmgroupdao.EdmGroupNewUpdate(query); } } catch (Exception ex) { throw new Exception("EdmGroupNewMgr-->SaveEdmGroupNewAdd-->" + ex.Message); } }
public List<EdmGroupNewQuery> GetEdmGroupNewList(EdmGroupNewQuery query, out int totalCount) { StringBuilder str = new StringBuilder(); StringBuilder strcont = new StringBuilder(); totalCount = 0; try { str.AppendFormat(" select group_id,group_name,is_member_edm,trial_url,enabled,sort_order,description from edm_group_new egn "); strcont.AppendFormat(" where 1=1 "); strcont.AppendFormat(" and egn.group_name like '%{0}%'", query.group_name); strcont.Append(" order by enabled desc, is_member_edm desc, sort_order "); str.Append(strcont); if (query.IsPage) { StringBuilder strpage = new StringBuilder();// StringBuilder strcontpage = new StringBuilder(); strpage.AppendFormat("SELECT count(biao.group_id) as totalCount FROM(select egn.group_id from edm_group_new egn "); strpage.Append(strcont); strpage.AppendFormat(")as biao "); DataTable _dt = _access.getDataTable(strpage.Append(strcontpage).ToString()); if (_dt.Rows.Count > 0) { totalCount = Convert.ToInt32(_dt.Rows[0]["totalCount"]); str.AppendFormat(" limit {0},{1}", query.Start, query.Limit); } } return _access.getDataTableForObj<EdmGroupNewQuery>(str.ToString());// 獲取查詢記錄 } catch (Exception ex) { throw new Exception("EdmGroupNewDao-->GetEdmGroupNewList-->" + ex.Message); } } // add by yachao1120j 2015-9-21
public List<EdmGroupNewQuery> GetEdmGroupNewList(EdmGroupNewQuery query, out int totalCount) // add by yachao1120j 2015-9-21 { try { List<EdmGroupNewQuery> store = new List<EdmGroupNewQuery>(); store = _edmgroupdao.GetEdmGroupNewList(query, out totalCount); foreach(var item in store) { if (item.is_member_edm == 0) { item.is_member_edm_string = ""; } if (item.is_member_edm == 1) { item.is_member_edm_string = "會員電子報"; } } return store; } catch (Exception ex) { throw new Exception("EdmGroupNewMgr->GetEdmGroupNewList" + ex.Message); } }
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 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 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; }
//更新信息 public int EdmGroupNewUpdate(EdmGroupNewQuery query) { StringBuilder sql = new StringBuilder(); query.Replace4MySQL(); try { sql.AppendFormat("update edm_group_new set group_name = '{0}', is_member_edm = '{1}', trial_url='{2}',sort_order = '{3}',description='{4}',group_update_userid='{5}' where group_id='{6}' ", query.group_name, query.is_member_edm, query.trial_url, query.sort_order, query.description,query.group_update_userid, query.group_id); return _access.execCommand(sql.ToString()); } catch (Exception ex) { throw new Exception("EdmGroupNewDao-->EdmGroupNewUpdate-->" + sql.ToString() + ex.Message); } }