public JsonResult DeleteById() { SphinxExcludeQuery query = new SphinxExcludeQuery(); if (!string.IsNullOrEmpty(Request.Params["rid"])) { query.product_ids = Request.Params["rid"].TrimEnd(','); } try { sphinxExcludeMgr = new SphinxExcludeMgr(SqlConnectionString); if (sphinxExcludeMgr.DeleteModel(query) > 0) { return Json(new { success = "true" }); } else { return Json(new { 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); return Json(new { success = "false" }); } }
public HttpResponseBase GetSphinxExclude() { string json = string.Empty; try { SphinxExcludeQuery query = new SphinxExcludeQuery(); query.Start = string.IsNullOrEmpty(Request.Params["start"]) ? 0 : int.Parse(Request.Params["start"]); query.Limit = string.IsNullOrEmpty(Request.Params["limit"]) ? 25 : int.Parse(Request.Params["limit"]); query.product_name = string.IsNullOrEmpty(Request.Params["productname"]) ? "" : Request.Params["productname"].Trim(); System.Text.RegularExpressions.Regex rex = new System.Text.RegularExpressions.Regex(@"^\d+$"); string oid = Request.Params["oid"].Trim(); if (oid != "") { if (rex.IsMatch(oid)) { query.product_id = int.Parse(oid); } else { query.product_id = -1; } } DateTime datetime; if (DateTime.TryParse(Request.Params["time_start"], out datetime)) { query.created_start = DateTime.Parse(datetime.ToString("yyyy-MM-dd HH:mm:ss")); } if (DateTime.TryParse(Request.Params["time_end"], out datetime)) { query.created_end = DateTime.Parse(datetime.ToString("yyyy-MM-dd HH:mm:ss")); } int totalCount = 0; sphinxExcludeMgr = new SphinxExcludeMgr(SqlConnectionString); List<SphinxExcludeQuery> list = sphinxExcludeMgr.GetList(query, out totalCount); IsoDateTimeConverter timeConverter = new IsoDateTimeConverter(); //这里使用自定义日期格式,如果不使用的话,默认是ISO8601格式 timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss"; json = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(list, 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; }
public JsonResult SphinxExcludeSave() { SphinxExcludeQuery query = new SphinxExcludeQuery(); query.kuser = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString(); query.kdate = DateTime.Now; string pid = Request.Params["pid"].Trim(); query.product_id_old = int.Parse(pid); if (!string.IsNullOrEmpty(Request.Params["productid"].Trim())) { query.product_id = int.Parse(Request.Params["productid"].Trim()); } try { sphinxExcludeMgr = new SphinxExcludeMgr(SqlConnectionString); if (pid == "0") { int row = sphinxExcludeMgr.InsertModel(query); if (row == 1) { return Json(new { success = "true" }); } else { return Json(new { success = row }); } } else { int row = sphinxExcludeMgr.UpdateModel(query); if (row == 1) { return Json(new { success = "true" }); } else { return Json(new { success = row }); } } } 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); return Json(new { success = "false" }); } }
public HttpResponseBase RemoveSystemKeyWord() { string json = string.Empty; ///返回的状态 int state = 0; List<SphinxKeywordQuery> stores = new List<SphinxKeywordQuery>(); SphinxExcludeQuery query = new SphinxExcludeQuery(); seMgr = new SphinxExcludeMgr(SqlConnectionString); try { if (!string.IsNullOrEmpty(Request.Params["Product_Id"])) { query.product_id=Convert.ToInt32( Request.Params["Product_Id"]); } query.kdate = DateTime.Now; state = seMgr.InsertModel(query); IsoDateTimeConverter timeConverter = new IsoDateTimeConverter(); //这里使用自定义日期格式,如果不使用的话,默认是ISO8601格式 timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss"; json = "{success:true,state:" + state + "}";//返回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}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }