/// <summary> /// 删除 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Del(SendMessage_Model m) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("delete EM_MESSAGE"); sb.AppendFormat(" where EM_MESSAGEID= '{0}'", ClsSql.EncodeSql(m.EM_MESSAGEID)); bool bln = DataBaseClass.ExeSql(sb.ToString()); if (bln == true) { return(new Message(true, "删除成功!", "")); } else { return(new Message(false, "删除失败,请检查各输入框是否正确!", "")); } }
/// <summary> /// 获取列表 /// </summary> /// <param name="sw"></param> /// <returns></returns> public static IEnumerable <SendMessage_Model> getModelList(EM_Message_SW sw) { var result = new List <SendMessage_Model>(); DataTable dt = BaseDT.EM_Message.getDT(sw);//列表 for (int i = 0; i < dt.Rows.Count; i++) { SendMessage_Model m = new SendMessage_Model(); m.EM_MESSAGEID = dt.Rows[i]["EM_MESSAGEID"].ToString(); m.MessageContent = dt.Rows[i]["TMPCONTENT"].ToString(); m.ORDERBY = dt.Rows[i]["ORDERBY"].ToString(); result.Add(m); } dt.Clear(); dt.Dispose(); return(result); }
/// <summary> /// 根据查询条件获取某一条用户信息记录,用于修改、删除、用户登录验证 /// </summary> /// <param name="sw">参见模型</param> /// <returns>参见模型</returns> public static SendMessage_Model getModel(EM_Message_SW sw) { var result = new List <SendMessage_Model>(); DataTable dt = BaseDT.EM_Message.getDT(sw);//列表 SendMessage_Model m = new SendMessage_Model(); if (dt.Rows.Count > 0) { int i = 0; m.EM_MESSAGEID = dt.Rows[i]["EM_MESSAGEID"].ToString(); m.MessageContent = dt.Rows[i]["TMPCONTENT"].ToString(); m.ORDERBY = dt.Rows[i]["ORDERBY"].ToString(); } dt.Clear(); dt.Dispose(); return(m); }
/// <summary> /// 模板修改 /// </summary> /// <param name="m"></param> /// <returns></returns> public static Message Mdy(SendMessage_Model m) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("UPDATE EM_MESSAGE"); sb.AppendFormat(" set "); sb.AppendFormat("TMPCONTENT={0}", ClsSql.saveNullField(m.MessageContent)); sb.AppendFormat(",ORDERBY={0}", ClsSql.saveNullField(m.ORDERBY)); sb.AppendFormat(" where EM_MESSAGEID= '{0}'", ClsSql.EncodeSql(m.EM_MESSAGEID)); bool bln = DataBaseClass.ExeSql(sb.ToString()); if (bln == true) { return(new Message(true, "修改成功!", m.EM_MESSAGEID)); } else { return(new Message(false, "修改失败,请检查各输入框是否正确!", "")); } }
/// <summary> /// 短信发送 /// </summary> /// <param name="m"></param> /// <returns></returns> public static Message SEND(SendMessage_Model m) { string name = SystemCls.getCookieInfo().trueName; string title = m.MessageTitle; string MessageName = m.MessageName; string phone = m.PHONE; if (string.IsNullOrEmpty(phone)) { return(new Message(false, "该成员未录入号码", m.URL)); } string phonelist = ""; string[] arr = m.PHONE.Split(','); string[] brr = arr.Where(s => !string.IsNullOrEmpty(s)).ToArray(); List <string> list = new List <string>(); foreach (string eachString in brr)//去掉重复的手机号码 { if (!list.Contains(eachString)) { list.Add(eachString); } } brr = list.ToArray(); for (int i = 0; i < brr.Length; i++) { if (i == brr.Length - 1) { phonelist += brr[i]; } else { phonelist += brr[i] + ","; } } string content = m.MessageContent; var ms = SmsHelp.SmsCom.SendMsg(content, phonelist); return(new Message(ms.Success, ms.Msg, m.URL)); }
/// <summary> /// 增、删 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Manager(SendMessage_Model m) { if (m.Opmethod == "Add") { Message msgUser = BaseDT.EM_Message.Add(m); SmsHelp.SmsCom.SmsTemplateModify(m.MessageContent, ""); return(new Message(msgUser.Success, msgUser.Msg, msgUser.Url)); } if (m.Opmethod == "Del") { //SystemCls.LogSave("5", "通知公告:" + m.INFOTITLE, ClsStr.getModelContent(m)); Message msgUser = BaseDT.EM_Message.Del(m); return(new Message(msgUser.Success, msgUser.Msg, msgUser.Url)); } if (m.Opmethod == "Mdy") { Message msgUser = BaseDT.EM_Message.Mdy(m); return(new Message(msgUser.Success, msgUser.Msg, msgUser.Url)); } return(new Message(false, "无效操作", "")); }
/// <summary> /// 模板添加 /// </summary> /// <param name="m"></param> /// <returns></returns> public static Message Add(SendMessage_Model m) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("INSERT INTO EM_MESSAGE( TMPCONTENT, ORDERBY)"); sb.AppendFormat("VALUES("); sb.AppendFormat("{0}", ClsSql.saveNullField(m.MessageContent)); //sb.AppendFormat(",{0}", ClsSql.saveNullField(m.MessageContent)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.ORDERBY)); sb.AppendFormat(")"); bool bln = DataBaseClass.ExeSql(sb.ToString()); if (bln == true) { return(new Message(true, "添加成功!", "")); } else { return(new Message(false, "添加失败!", "")); } }
/// <summary> /// 根据组织机构获取短信发送tree字符串 /// </summary> /// <param name="phonelist"></param> /// <param name="name"></param> /// <returns></returns> public static SendMessage_Model getOrgno(string phonelist, string name) { var s = ""; DataTable dt = BaseDT.T_SYS_ORG_LINK.getDT(new T_SYS_ORG_LINK_SW { PHONE = phonelist, keys = name }); //列表 DataTable dtipuser = BaseDT.T_IPSFR_USER.getDT(new T_IPSFR_USER_SW { PHONELIST = phonelist, HNAME = name }); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { T_SYS_ORG_LINK_Model m = new T_SYS_ORG_LINK_Model(); m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString(); s += m.BYORGNO + "|" + "1" + ","; } } if (dtipuser.Rows.Count > 0) { for (int i = 0; i < dtipuser.Rows.Count; i++) { T_SYS_ORG_LINK_Model m = new T_SYS_ORG_LINK_Model(); m.BYORGNO = dtipuser.Rows[i]["BYORGNO"].ToString(); s += m.BYORGNO + "|" + "2" + ","; } } s = s.TrimEnd(','); SendMessage_Model m1 = new SendMessage_Model(); m1.BYORGNOLIST = s; dt.Clear(); dt.Dispose(); dtipuser.Clear(); dtipuser.Dispose(); return(m1); }
/// <summary> /// 根据组织机构获取短信发送tree字符串 /// </summary> /// <param name="orgno"></param> /// <param name="type"></param> /// <returns></returns> public static SendMessage_Model getstr(string orgno, string type) { var s = ""; var d = ""; var dt = new DataTable(); var dtvillage = new DataTable(); var dtipuser = new DataTable(); if (orgno == "1") { dt = BaseDT.T_SYS_ORG_LINK.getDT(new T_SYS_ORG_LINK_SW { BYORGNO = SystemCls.getCurUserOrgNo() }); //列表 } else if (orgno == "2") { dtipuser = BaseDT.T_IPSFR_USER.getDT(new T_IPSFR_USER_SW { BYORGNO = SystemCls.getCurUserOrgNo() }); } else { if (PublicCls.OrgIsShi(orgno) == false && PublicCls.OrgIsXian(orgno) == false && PublicCls.OrgIsZhen(orgno) == false) { dtvillage = BaseDT.T_SYS_ORG_CWH.getVillagecComDT(new T_SYS_ORG_CWH_SW { CWHID = orgno }); } else { dtvillage = BaseDT.T_SYS_ORG_CWH.getVillagecComDT(new T_SYS_ORG_CWH_SW { BYORGNO = orgno }); dt = BaseDT.T_SYS_ORG_LINK.getDT(new T_SYS_ORG_LINK_SW { BYORGNO = orgno }); //列表 dtipuser = BaseDT.T_IPSFR_USER.getDT(new T_IPSFR_USER_SW { BYORGNO = orgno }); } } if (type == "1") { if (PublicCls.OrgIsShi(orgno) == false && PublicCls.OrgIsXian(orgno) == false && PublicCls.OrgIsZhen(orgno) == false) { for (int i = 0; i < dtvillage.Rows.Count; i++) { T_SYS_ORG_LINK_Model m = new T_SYS_ORG_LINK_Model(); m.NAME = dtvillage.Rows[i]["NAME"].ToString(); m.PHONE = dtvillage.Rows[i]["PHONE"].ToString(); s += m.NAME + ","; d += m.PHONE + ","; } } else { for (int i = 0; i < dt.Rows.Count; i++) { T_SYS_ORG_LINK_Model m = new T_SYS_ORG_LINK_Model(); m.NAME = dt.Rows[i]["NAME"].ToString(); m.PHONE = dt.Rows[i]["PHONE"].ToString(); s += m.NAME + ","; d += m.PHONE + ","; } for (int i = 0; i < dtvillage.Rows.Count; i++) { T_SYS_ORG_LINK_Model m = new T_SYS_ORG_LINK_Model(); m.NAME = dtvillage.Rows[i]["NAME"].ToString(); m.PHONE = dtvillage.Rows[i]["PHONE"].ToString(); s += m.NAME + ","; d += m.PHONE + ","; } } } if (type == "2") { for (int i = 0; i < dtipuser.Rows.Count; i++) { T_SYS_ORG_LINK_Model m = new T_SYS_ORG_LINK_Model(); m.NAME = dtipuser.Rows[i]["HNAME"].ToString(); m.PHONE = dtipuser.Rows[i]["PHONE"].ToString(); s += m.NAME + ","; d += m.PHONE + ","; } } s = s.TrimEnd(','); d = d.TrimEnd(','); SendMessage_Model m1 = new SendMessage_Model(); m1.PHONELIST = d; m1.NAMELIST = s; dt.Clear(); dt.Dispose(); dtvillage.Clear(); dtvillage.Dispose(); dtipuser.Clear(); dtipuser.Dispose(); return(m1); }