public HttpResponseBase AddorEdit() { string json = string.Empty; _emailBlockListMgr = new EmailBlockListMgr(mySqlConnectionString); try { EmailBlockListQuery query = new EmailBlockListQuery(); query.block_update_userid = Convert.ToInt32((System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString()); if (!string.IsNullOrEmpty(Request.Params["reason"])) { query.block_reason = Request.Params["reason"].ToString().Replace("\\", "\\\\"); ; query.block_create_userid = query.block_update_userid; if (!string.IsNullOrEmpty(Request.Params["email_address"])) { query.email_address = Request.Params["email_address"].ToString().Replace("\\", "\\\\"); ; } int i = _emailBlockListMgr.Add(query); if (i > 0) { json = "{success:true}"; } else if (i == -1) { json = "{success:false,msg:\'0\'}"; //郵箱已添加過 } } else { if (!string.IsNullOrEmpty(Request.Params["block_reason"])) { query.block_reason = Request.Params["block_reason"].ToString().Replace("\\", "\\\\"); ; } if (!string.IsNullOrEmpty(Request.Params["email_address"])) { query.email_address = Request.Params["email_address"].ToString(); } int i = _emailBlockListMgr.Update(query); if (i > 0) { json = "{success:true}"; } } } 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,data:[]}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
public HttpResponseBase UnBlock() { string json = string.Empty; bool result = false; try { _emailBlockListMgr = new EmailBlockListMgr(mySqlConnectionString); EmailBlockLogQuery query = new EmailBlockLogQuery(); if (!string.IsNullOrEmpty(Request.Params["email_address"])) { query.email_address = Request.Params["email_address"].ToString(); } if (!string.IsNullOrEmpty(Request.Params["unblock_reason"])) { query.unblock_reason = Request.Params["unblock_reason"].ToString().Replace("\\", "\\\\"); ; } query.unblock_create_userid = Convert.ToInt32((System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString()); result = _emailBlockListMgr.UnBlock(query); if (result) { json = "{success:true}"; } } 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,data:[]}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
public HttpResponseBase GetEmailBlockList() { string json = string.Empty; try { _emailBlockListMgr = new EmailBlockListMgr(mySqlConnectionString); DataTable store = new DataTable(); EmailBlockListQuery query = new EmailBlockListQuery(); if (!string.IsNullOrEmpty(Request.Params["email"])) { query.email_address = Request.Params["email"]; } store = _emailBlockListMgr.GetEmailBlockList(query); if (store != null) { IsoDateTimeConverter timeConverter = new IsoDateTimeConverter(); timeConverter.DateTimeFormat = "yyyy-MM-dd"; json = "{success:true" + ",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,data:[]}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }