Пример #1
0
        public HttpResponseBase AddCallid()
        {
            List<MailGroupMapQuery> list = new List<MailGroupMapQuery>();
            MailGroupMapQuery query = new MailGroupMapQuery();
            string json = string.Empty;
            _IMailGroupMgr = new MailGroupMgr(mySqlConnectionString);
            try
            {
                if (!string.IsNullOrEmpty(Request.Form["groupId"]))
                {
                    query.group_id = Int32.Parse(Request.Form["groupId"]);
                }
                if (!string.IsNullOrEmpty(Request.Form["callid"]))
                {
                    string[] callid = Request.Form["callid"].IndexOf(",") != -1 ? Request.Form["callid"].Split(',') : new string[] { Request.Form["callid"] };

                    _IMailGroupMgr.DeleteMailMap(query.group_id);
                    for (int i = 0; i < callid.Length; i++)
                    {
                        query = new MailGroupMapQuery();
                        query.group_id = Int32.Parse(Request.Form["groupId"]);
                        query.user_id = Convert.ToInt32(callid[i]);
                        query.create_time = DateTime.Now;
                        query.update_time = query.create_time;
                        query.create_user = (Session["caller"] as Caller).user_id;
                        query.update_user = (Session["caller"] as Caller).user_id;
                        query.status = _IMailGroupMgr.GetStatus(query.user_id);
                        list.Add(query);
                    }
                    if (_IMailGroupMgr.SaveMailMap(list))
                    {
                        json = "{success:true,msg:\"新增成功\"}";
                    }
                    else
                    {
                        json = "{success:true,msg:\"新增失败\"}";
                    }
                }
                else
                {

                    if (_IMailGroupMgr.DeleteMailMap(query.group_id) > 0)
                    {
                        json = "{success:true,msg:\"人员已清空\"}";
                    }
                    else
                    {
                        json = "{success:true,msg:\"人员已清空\"}";
                    }
                }
            }
            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:true,msg:\"新增失败\"}";
            }
            this.Response.Clear();
            this.Response.Write(json);
            this.Response.End();
            return this.Response;
        }
Пример #2
0
        //add by wwei0216w 2015/4/9
        public HttpResponseBase GetMemberInfo()
        {
            string json = "";
            MailGroupMapQuery query = new MailGroupMapQuery();
            try
            {

                if (!string.IsNullOrEmpty(Request.Form["rowId"]))
                {
                    query.group_id = Convert.ToInt32(Request.Form["rowId"]);
                    query.status = 1;
                    _IMailGroupMgr = new MailGroupMgr(mySqlConnectionString);
                    var list = _IMailGroupMgr.QueryUserInfo(query);
                    //StringBuilder sb = new StringBuilder("[");
                    //sb.Append("{rowId:" + query.group_id + ",groupName:\"" + list[0].group_name + "\",item:[");
                    //foreach(MailGroupMapQuery mm in list)
                    //{
                    //    sb.Append("{user_name:\"" + mm.user_mail + "\",row_id:" + mm.row_id + "}");
                    //}
                    //sb.Append("]}");
                    //sb.Append("]");
                    //json = sb.ToString().Replace("}{", "},{");

                    json = "{items:" + JsonConvert.SerializeObject(list) + "}";
                }
            }
            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;
        }
Пример #3
0
 public string QueryUserById()
 {
     string json = string.Empty;
     MailGroupMapQuery query = new MailGroupMapQuery();
     try
     {
         if (!string.IsNullOrEmpty(Request.Form["groupId"]))
         {
             query.group_id = Convert.ToInt32(Request.Form["groupId"]);
         }
         query.status = 1;
         _IMailGroupMgr = new MailGroupMgr(mySqlConnectionString);
         json = _IMailGroupMgr.QueryUserById(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 = "[]";
     }
     return json;
 }
Пример #4
0
        public JsonResult UpMailGroupStatus()
        {
            string json = string.Empty;
            try
            {
                MailGroupQuery query = new MailGroupQuery();
                if (!string.IsNullOrEmpty(Request.Params["id"]))
                {
                    query.row_id = Convert.ToInt32(Request.Params["id"]);
                }
                if (!string.IsNullOrEmpty(Request.Params["active"]))
                {
                    query.status = Convert.ToInt32(Request.Params["active"]);
                }
                query.update_time = DateTime.Now;
                query.update_user = (Session["caller"] as Caller).user_id;
                _IMailGroupMgr = new MailGroupMgr(mySqlConnectionString);
                if (_IMailGroupMgr.UpMailGroupStatus(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" });
            }
        }
Пример #5
0
 public HttpResponseBase DeleteMailGroup()
 {
     string json = string.Empty;
     MailGroupQuery query = null;
     _IMailGroupMgr = new MailGroupMgr(mySqlConnectionString);
     List<MailGroupQuery> list = new List<MailGroupQuery>();
     try
     {
         if (!string.IsNullOrEmpty(Request.Form["rowID"]))
         {
             string rowIDs = Request.Form["rowID"];
             if (rowIDs.IndexOf("|") != -1)
             {
                 foreach (string id in rowIDs.Split('|'))
                 {
                     if (!string.IsNullOrEmpty(id))
                     {
                         query = new MailGroupQuery();
                         query.row_id = Convert.ToInt32(id);
                         list.Add(query);
                     }
                 }
             }
             if (_IMailGroupMgr.DeleteMailGroup(list))
             {
                 json = "{success:true}";
             }
             else
             {
                 json = "{failure: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 = "{failure:true}";
     }
     this.Response.Clear();
     this.Response.Write(json);
     this.Response.End();
     return this.Response;
 }
Пример #6
0
 public HttpResponseBase SaveMailGroup()
 {
     MailGroupQuery query = new MailGroupQuery();
     string json = string.Empty;
     try
     {
         if (!string.IsNullOrEmpty(Request.Params["row_id"]))
         {
             query.row_id = Convert.ToInt32(Request.Params["row_id"]);
         }
         if (!string.IsNullOrEmpty(Request.Params["groupName"]))
         {
             query.group_name = Request.Params["groupName"];
         }
         if (!string.IsNullOrEmpty(Request.Params["groupCode"]))
         {
             query.group_code = Request.Params["groupCode"];
         }
         if (!string.IsNullOrEmpty(Request.Params["remark"]))
         {
             query.remark = Request.Params["remark"];
         }
         query.create_time = DateTime.Now;
         query.update_time = query.create_time;
         query.create_user = (Session["caller"] as Caller).user_id;
         query.update_user = (Session["caller"] as Caller).user_id;
         query.status = 1;
         _IMailGroupMgr = new MailGroupMgr(mySqlConnectionString);
         int result = _IMailGroupMgr.SaveMailGroup(query);
         if (result > 0)
         {
             json = "{success:true}";
         }
         else if (result == -1)//羣組或編碼重複
         {
             json = "{failure:true,msg:'-1'}";
         }
         else
         {
             json = "{failure:true,msg:'0'}";
         }
     }
     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 = "{failure:true,msg:'0'}";
     }
     this.Response.Clear();
     this.Response.Write(json);
     this.Response.End();
     return this.Response;
 }
Пример #7
0
 public HttpResponseBase MailGroupList()
 {
     string json = string.Empty;
     MailGroupQuery query = new MailGroupQuery();
     if (!string.IsNullOrEmpty(Request["isPage"]))
         query.IsPage = bool.Parse(Request["isPage"]);
     List<MailGroupQuery> store = new List<MailGroupQuery>();
     _IMailGroupMgr = new MailGroupMgr(mySqlConnectionString);
     int totalCount = 0;
     try
     {
         query.status = 1;
         query.Start = Convert.ToInt32(Request.Params["start"] ?? "0");
         query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25");
         store = _IMailGroupMgr.MailGroupList(query, out totalCount);
         json = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(store, Formatting.Indented) + "}";
     }
     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 = "{failure:true}";
     }
     this.Response.Clear();
     this.Response.Write(json);
     this.Response.End();
     return this.Response;
 }