public int DeleteKeyWords(DisableKeywordsQuery query) { int result = 0; string sql = string.Empty; int dk_id=0; try { string[] arrID = query.ids.Split(','); foreach (var id in arrID) { if (int.TryParse(id, out dk_id)) { sql = _dkDao.DeleteKeyWords(id); result = _dbAccess.execCommand(sql); if (result > 0) { continue; } } else { return result; } } return result; } catch (Exception ex) { throw new Exception("DisableKeywordsDao-->DeleteKeyWords-->" + ex.Message, ex); } }
public DataTable GetKeyWordsList(DisableKeywordsQuery query,out int totalCount) { try { DataTable store = new DataTable(); store = _dkDao.GetKeyWordsList(query,out totalCount); return store; } catch (Exception ex) { throw new Exception("DisableKeywordsDao-->GetKeyWordsList-->" + ex.Message, ex); } }
public int UpdateKeyWords(DisableKeywordsQuery query) { int result = 0; try { string sql = _dkDao.UpdateKeyWords(query); result = _dbAccess.execCommand(sql); return result; } catch (Exception ex) { throw new Exception("DisableKeywordsDao-->AddKeyWords-->" + ex.Message, ex); } }
public string AddKeyWords(DisableKeywordsQuery query) { StringBuilder strSql = new StringBuilder(); query.Replace4MySQL(); try { strSql.AppendFormat(@"INSERT INTO disable_keywords(dk_string,user_id,dk_created) VALUES ('{0}','{1}',NOW());", query.dk_string, query.user_id); return strSql.ToString(); } catch (Exception ex) { throw new Exception("DisableKeywordsDao-->AddKeyWords-->" + ex.Message + strSql.ToString(), ex); } }
public DataTable GetKeyWordsList(DisableKeywordsQuery query,out int totalCount) { StringBuilder strSql = new StringBuilder(); StringBuilder count = new StringBuilder(); DataTable store = new DataTable(); totalCount = 0; try { strSql.AppendFormat(@"SELECT dk_id,dk_string,u.user_username as user_name,dk_created,dk_modified,dk_active from disable_keywords dk,manage_user u WHERE u.user_id = dk.user_id"); count.AppendFormat(@"select count(dk_id) as totalCount from disable_keywords WHERE 1=1"); if (query.end != DateTime.MinValue && query.start != DateTime.MinValue) { strSql.AppendFormat(" AND dk_created BETWEEN '{0}' AND '{1}'", Common.CommonFunction.DateTimeToString(query.start), Common.CommonFunction.DateTimeToString(query.end)); count.AppendFormat(" AND dk_created BETWEEN '{0}' AND '{1}'", Common.CommonFunction.DateTimeToString(query.start), Common.CommonFunction.DateTimeToString(query.end)); } if (query.search_text != "") { strSql.AppendFormat(" AND dk_string LIKE N'%{0}%'", query.search_text); count.AppendFormat(" AND dk_string LIKE N'%{0}%'", query.search_text); } if (query.IsPage) { DataTable dt = _dbAccess.getDataTable(count.ToString()); if (dt != null && dt.Rows.Count > 0) { totalCount = Convert.ToInt32(dt.Rows[0][0]); } } strSql.AppendFormat(" order by dk_id desc limit {0},{1}", query.Start, query.Limit); store = _dbAccess.getDataTable(strSql.ToString()); return store; } catch (Exception ex) { throw new Exception("DisableKeywordsDao-->GetKeyWordsList-->" + ex.Message + strSql.ToString(), ex); } }
public string UpdateStatus(DisableKeywordsQuery query) { string josn; string sql=""; try { if (query.dk_active == 0) { query.dk_active = 1; } else { query.dk_active = 0; } sql = _dkDao.UpdateStatus(query); if (_dbAccess.execCommand(sql)>0) { josn = "{success:true}"; } else { josn = "{success:false}"; } return josn; } catch (Exception ex) { throw new Exception("DisableKeywordsDao-->UpdateStatus-->" + ex.Message + sql, ex); } }
public string UpdateKeyWords(DisableKeywordsQuery query) { query.Replace4MySQL(); StringBuilder strSql = new StringBuilder(); try { strSql.AppendFormat(@"UPDATE disable_keywords SET dk_string='{0}' WHERE dk_id='{1}'", query.dk_string, query.dk_id); return strSql.ToString(); } catch (Exception ex) { throw new Exception("DisableKeywordsDao-->UpdateKeyWords-->" + ex.Message + strSql.ToString(), ex); } }
public string UpdateStatus(DisableKeywordsQuery query) { StringBuilder strSql = new StringBuilder(); try { strSql.AppendFormat(@"Update disable_keywords set dk_active='{1}' WHERE dk_id={0}", query.dk_id, query.dk_active); return strSql.ToString(); } catch (Exception ex) { throw new Exception("DisableKeywordsDao-->UpdateStatus-->" + ex.Message + strSql.ToString(), ex); } }
public HttpResponseBase UpdateStats() { string json = string.Empty; try { _dkMgr = new DisableKeywordsMgr(mySqlConnectionString); DisableKeywordsQuery query = new DisableKeywordsQuery(); if (!string.IsNullOrEmpty(Request.Params["id"])) { query.dk_id = Convert.ToInt32(Request.Params["id"]); } if (!string.IsNullOrEmpty(Request.Params["active"])) { query.dk_active = Convert.ToInt32(Request.Params["active"]); } json = _dkMgr.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 DeleteKeyWords() { string json = string.Empty; int result = 0; _dkMgr = new DisableKeywordsMgr(mySqlConnectionString); try { DisableKeywordsQuery query = new DisableKeywordsQuery(); if (!string.IsNullOrEmpty(Request.Params["ids"])) { query.ids = Request.Params["ids"].ToString(); } result = _dkMgr.DeleteKeyWords(query); if (result > 0) { json = "{success:true,msg:\'1\'}"; } 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}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
public HttpResponseBase AddOrEdit() { string json = string.Empty; int result = 0; _dkMgr = new DisableKeywordsMgr(mySqlConnectionString); try { DisableKeywordsQuery query = new DisableKeywordsQuery(); #region 編輯 if (!string.IsNullOrEmpty(Request.Params["dk_id"])) { query.dk_string = Request.Params["dk_string"].ToString().Replace("\\", "\\\\"); query.dk_id = Convert.ToInt32(Request.Params["dk_id"]); result = _dkMgr.UpdateKeyWords(query); if (result > 0) { json = "{success:true,msg:\'1\'}"; } else { json = "{success:false}"; } } #endregion #region 新增 else { query.dk_string = Request.Params["dk_string"].ToString().Replace("\\", "\\\\"); query.user_id = Convert.ToInt32((System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString()); query.dk_created = DateTime.Now; result = _dkMgr.AddKeyWords(query); if (result > 0) { json = "{success:true,msg:\'0\'}"; } else { json = "{success:false}"; } } #endregion } 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}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
public HttpResponseBase GetKeyWordsList() { string json = string.Empty; int totalCount = 0; DisableKeywordsQuery query = new DisableKeywordsQuery(); query.Start = Convert.ToInt32(Request.Params["start"] ?? "0");//用於分頁的變量 query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "20");//用於分頁的變量 try { if (!string.IsNullOrEmpty(Request.Params["starttime"]) && !string.IsNullOrEmpty(Request.Params["endtime"])) { query.start = Convert.ToDateTime(Request.Params["starttime"]); query.end = Convert.ToDateTime(Request.Params["endtime"]); } if (!string.IsNullOrEmpty(Request.Params["text"])) { query.search_text = Request.Params["text"].ToString().Replace("\\", "\\\\"); } _dkMgr = new DisableKeywordsMgr(mySqlConnectionString); DataTable store = _dkMgr.GetKeyWordsList(query, out totalCount); 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:false,totalCount:0,data:[]}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }