/// <summary> /// 取消電子報 /// </summary> /// <returns></returns> public HttpResponseBase CancelEdm() { string json = "{success:false}"; uint update_id = 0; uint vid = 0; try { string mail = string.Empty; if (!string.IsNullOrEmpty(Request.Params["mail"])) { mail = Request.Params["mail"].ToString().Trim(); } _IEdmContentMgr = new EdmContentMgr(mySqlConnectionString); update_id = Convert.ToUInt32((System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString()); int i = _IEdmContentMgr.CancelEdm(mail, update_id, out vid); if (i > 0) { json = "{success:true}"; } else if (i == -1) { json = "{success:false,msg:\'0\'}"; //郵箱不存在,不可取消電子報 } else if (i == -2) { json = "{success:false,msg:\'1\'}";//郵箱沒有對應的用戶 } else if (i == -3) { //DataTable dt = new DataTable(); //dt.Columns.Add("vid"); //DataRow dr = new DataRow(); //dr[0] = vid.ToString(); //dt.Rows.Add(dr); json = "{success:false,msg:\'2\',vid:\'" + vid + "\'}";//郵箱已加入黑名單且狀態為解除 } else if (i == -4) { json = "{success:false,msg:\'3\'}";//郵箱已加入黑名單且狀態為鎖定 } else if (i == -5) { json = "{success:false,msg:\'4\'}";//郵箱無法取消電子報 } } 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); } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }