/// <summary>
/// 修改
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Mdy(E_SUBJECT_Model m)
{
//if (string.IsNullOrEmpty(m.EMAILTITLE))
// return new Message(false, "请输入主题", "");
//if (string.IsNullOrEmpty(m.EMAILRECUSERLIST))
// return new Message(false, "请选择收件人", "");
StringBuilder sb = new StringBuilder();
sb.AppendFormat("UPDATE E_SUBJECT set ");
sb.AppendFormat(" EMAILTITLE='{0}'", ClsSql.EncodeSql(m.EMAILTITLE));
sb.AppendFormat(",EMAILSTATUS='{0}'", ClsSql.EncodeSql(m.EMAILSTATUS));
sb.AppendFormat(",EMAILSENDUSERID='{0}'", ClsSql.EncodeSql(m.EMAILSENDUSERID));
sb.AppendFormat(",EMAILTIME='{0}'", ClsSql.EncodeSql(m.EMAILTIME));
sb.AppendFormat(",EMAILCONTENT='{0}'", ClsSql.EncodeSql(m.EMAILCONTENT));
sb.AppendFormat(",EMAILRECUSERLIST='{0}'", ClsSql.EncodeSql(m.EMAILRECUSERLIST));
sb.AppendFormat(",EMAILCOPYUSERLIST='{0}'", ClsSql.EncodeSql(m.EMAILCOPYUSERLIST));
sb.AppendFormat(",EMAILSECRETUSERLIST='{0}'", ClsSql.EncodeSql(m.EMAILSECRETUSERLIST));
sb.AppendFormat(" where EMAILID= '{0}'", ClsSql.EncodeSql(m.EMAILID));
bool bln = DataBaseClass.ExeSql(sb.ToString());
if (bln == true)
{
return(new Message(true, "更新成功!", ""));
}
else
{
return(new Message(false, "更新失败!", ""));
}
}
/// <summary>
/// 没有附件添加
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Add(E_SUBJECT_Model m)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("INSERT INTO E_SUBJECT(EMAILTITLE,EMAILSTATUS,EMAILSENDUSERID, EMAILTIME, EMAILCONTENT,EMAILRECUSERLIST, EMAILCOPYUSERLIST, EMAILSECRETUSERLIST)");
sb.AppendFormat("VALUES(");
sb.AppendFormat("'{0}'", ClsSql.EncodeSql(m.EMAILTITLE));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.EMAILSTATUS));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.EMAILSENDUSERID));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.EMAILTIME));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.EMAILCONTENT));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.EMAILRECUSERLIST));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.EMAILCOPYUSERLIST));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.EMAILSECRETUSERLIST));
sb.AppendFormat(")");
bool bln = DataBaseClass.ExeSql(sb.ToString());
if (bln == true)
{
return(new Message(true, "操作成功!", ""));
}
else
{
return(new Message(false, "操作失败!", ""));
}
}
/// <summary>
/// 增加--返回值
/// </summary>
/// <param name="m"></param>
/// <returns></returns>
public static string AddReturn(E_SUBJECT_Model m)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("INSERT INTO E_SUBJECT(EMAILTITLE,EMAILSTATUS,EMAILSENDUSERID, EMAILTIME, EMAILCONTENT,EMAILRECUSERLIST, EMAILCOPYUSERLIST, EMAILSECRETUSERLIST)");
sb.AppendFormat("VALUES(");
sb.AppendFormat("'{0}'", ClsSql.EncodeSql(m.EMAILTITLE));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.EMAILSTATUS));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.EMAILSENDUSERID));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.EMAILTIME));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.EMAILCONTENT));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.EMAILRECUSERLIST));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.EMAILCOPYUSERLIST));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.EMAILSECRETUSERLIST));
sb.AppendFormat(") select @@identity");
return(DataBaseClass.ReturnSqlField(sb.ToString()));
}
/// <summary>
/// 删除 只能删除草稿 对于已发送邮件需要更改状态为已删除
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Del(E_SUBJECT_Model m)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("delete E_SUBJECT ");
sb.AppendFormat(" where EMAILID in({0})", ClsSql.EncodeSql(m.EMAILID));
bool bln = DataBaseClass.ExeSql(sb.ToString());
if (bln == true)
{
return(new Message(true, "删除成功!", ""));
}
else
{
return(new Message(false, "删除失败!", ""));
}
}
/// <summary>
/// 多条修改
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message SendMdy(E_SUBJECT_Model m)//涉及到多条记录的修改；已发送的列表
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("UPDATE E_SUBJECT set ");
sb.AppendFormat("EMAILSTATUS='{0}'", ClsSql.EncodeSql(m.EMAILSTATUS));
sb.AppendFormat(" where EMAILID in({0})", ClsSql.EncodeSql(m.EMAILID));
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 <E_SUBJECT_Model> getListModel(E_SUBJECT_SW sw)
{
DataTable dt = BaseDT.E_SUBJECT.getDT(sw);//列表
var result = new List <E_SUBJECT_Model>();
for (int i = 0; i < dt.Rows.Count; i++)
{
E_SUBJECT_Model m = new E_SUBJECT_Model();
m.EMAILID = dt.Rows[i]["EMAILID"].ToString();
m.EMAILTITLE = dt.Rows[i]["EMAILTITLE"].ToString();
m.EMAILSTATUS = dt.Rows[i]["EMAILSTATUS"].ToString();
m.EMAILSENDUSERID = dt.Rows[i]["EMAILSENDUSERID"].ToString();
m.EMAILCONTENT = dt.Rows[i]["EMAILCONTENT"].ToString();
m.EMAILRECUSERLIST = dt.Rows[i]["EMAILRECUSERLIST"].ToString();
m.EMAILCOPYUSERLIST = dt.Rows[i]["EMAILCOPYUSERLIST"].ToString();
m.EMAILSECRETUSERLIST = dt.Rows[i]["EMAILSECRETUSERLIST"].ToString();
m.EMAILTIME = ClsSwitch.SwitTM(dt.Rows[i]["EMAILTIME"].ToString());
result.Add(m);
}
dt.Clear();
dt.Dispose();
return(result);
}
/// <summary>
/// 通过id获取匹配
/// </summary>
/// <param name="sw"></param>
/// <returns></returns>
public static string getOptionByEMAILID(E_SUBJECT_SW sw)
{
StringBuilder sb = new StringBuilder();
E_SUBJECT_Model m = getModel(sw);
string userList = "";
if (string.IsNullOrEmpty(sw.getReceiveType) == true || sw.getReceiveType == "0")
{
userList = m.EMAILRECUSERLIST;
}
if (sw.getReceiveType == "1")
{
userList = m.EMAILCOPYUSERLIST;
}
if (sw.getReceiveType == "2")
{
userList = m.EMAILSECRETUSERLIST;
}
if (string.IsNullOrEmpty(userList) == false)
{
userList = "," + userList + ",";//,1,2,3,11,
IEnumerable <T_SYSSEC_IPSUSER_Pager_Model> UM = T_SYSSEC_IPSUSERCls.getListModel(new T_SYSSEC_IPSUSER_SW {
});
foreach (var v in UM)
{
if (userList.Contains("," + v.USERID + ","))
{
sb.AppendFormat("<option value=\"{0}\" selected='selected'>{1}</option>", v.USERID, v.USERNAME + "<" + v.ORGNAME + ">");
}
else
{
sb.AppendFormat("<option value=\"{0}\">{1}</option>", v.USERID, v.USERNAME + "<" + v.ORGNAME + ">");
}
}
}
return(sb.ToString());
}
/// <summary>
/// 获取列表分页
/// </summary>
/// <param name="sw"></param>
/// <param name="total"></param>
/// <returns></returns>
public static IEnumerable <E_SUBJECT_Model> getListModelPager(E_SUBJECT_SW sw, out int total)
{
var result = new List <E_SUBJECT_Model>();
DataTable dt = BaseDT.E_SUBJECT.getDT(sw, out total);
DataTable dtUser = BaseDT.T_SYSSEC_USER.getDT(new T_SYSSEC_IPSUSER_SW {
});
for (int i = 0; i < dt.Rows.Count; i++)
{
E_SUBJECT_Model m = new E_SUBJECT_Model();
m.EMAILID = dt.Rows[i]["EMAILID"].ToString();
m.EMAILTITLE = dt.Rows[i]["EMAILTITLE"].ToString();
m.EMAILSTATUS = dt.Rows[i]["EMAILSTATUS"].ToString();
m.EMAILSENDUSERID = dt.Rows[i]["EMAILSENDUSERID"].ToString();
//m.EMAILSENDUSERName = BaseDT.T_SYSSEC_USER.getName(dtUser, m.EMAILSENDUSERID);
m.EMAILSENDUSERName = T_SYSSEC_IPSUSERCls.getUserCombString(new T_SYSSEC_IPSUSER_SW {
USERID = m.EMAILSENDUSERID, formatUserStr = "<font color=red>[userName]</font><[orgName]>", splitUserStr = ","
});
m.EMAILCONTENT = dt.Rows[i]["EMAILCONTENT"].ToString();
m.EMAILTIME = ClsSwitch.SwitTM(dt.Rows[i]["EMAILTIME"].ToString());
m.EMAILRECUSERLIST = dt.Rows[i]["EMAILRECUSERLIST"].ToString();//发送人
//m.EMAILRECUSERNameLIST = T_SYSSEC_IPSUSERCls.getUserCombString(new T_SYSSEC_IPSUSER_SW { USERID = m.EMAILRECUSERLIST, formatUserStr = "[userName]<[orgName]>", splitUserStr = "," });// BaseDT.T_SYSSEC_USER.getNameByUserList(dtUser, m.EMAILRECUSERLIST);
m.EMAILRECUSERNameLIST = T_SYSSEC_IPSUSERCls.getUserCombString(new T_SYSSEC_IPSUSER_SW {
USERID = m.EMAILRECUSERLIST, formatUserStr = "<font color=red>[userName]</font><[orgName]>", splitUserStr = ","
});
m.EMAILCOPYUSERLIST = dt.Rows[i]["EMAILCOPYUSERLIST"].ToString(); //抄送人
m.EMAILCOPYUSERNameLIST = BaseDT.T_SYSSEC_USER.getNameByUserList(dtUser, m.EMAILCOPYUSERLIST);
m.EMAILSECRETUSERLIST = dt.Rows[i]["EMAILSECRETUSERLIST"].ToString(); //密送人
m.EMAILSECRETUSERNameLIST = BaseDT.T_SYSSEC_USER.getNameByUserList(dtUser, m.EMAILSECRETUSERLIST);
result.Add(m);
}
dt.Clear();
dt.Dispose();
dtUser.Clear();
dtUser.Dispose();
return(result);
}
/// <summary>
/// 获取某一邮件信息
/// </summary>
/// <param name="sw"></param>
/// <returns></returns>
public static E_SUBJECT_Model getModel(E_SUBJECT_SW sw)
{
DataTable dt = BaseDT.E_SUBJECT.getDT(sw);
DataTable dtUser = BaseDT.T_SYSSEC_USER.getDT(new T_SYSSEC_IPSUSER_SW {
});
E_SUBJECT_Model m = new E_SUBJECT_Model();
if (dt.Rows.Count > 0)
{
int i = 0;
m.EMAILID = dt.Rows[i]["EMAILID"].ToString();
m.EMAILTITLE = dt.Rows[i]["EMAILTITLE"].ToString();
m.EMAILSTATUS = dt.Rows[i]["EMAILSTATUS"].ToString();
m.EMAILSENDUSERID = dt.Rows[i]["EMAILSENDUSERID"].ToString();
//m.EMAILSENDUSERName = BaseDT.T_SYSSEC_USER.getName(dtUser, m.EMAILSENDUSERID);
//m.EMAILSENDUSERName = BaseDT.T_SYSSEC_USER.getNameByUserList(dtUser, m.EMAILSENDUSERID);
m.EMAILSENDUSERName = T_SYSSEC_IPSUSERCls.getUserCombString(new T_SYSSEC_IPSUSER_SW {
USERID = m.EMAILSENDUSERID, formatUserStr = "<font color=red>[userName]</font><[orgName]>", splitUserStr = ","
});
m.EMAILCONTENT = dt.Rows[i]["EMAILCONTENT"].ToString();
m.EMAILTIME = ClsSwitch.SwitTM(dt.Rows[i]["EMAILTIME"].ToString());
m.EMAILRECUSERLIST = dt.Rows[i]["EMAILRECUSERLIST"].ToString();//收件人
//m.EMAILRECUSERNameLIST = BaseDT.T_SYSSEC_USER.getNameByUserList(dtUser, m.EMAILRECUSERLIST);
m.EMAILRECUSERNameLIST = T_SYSSEC_IPSUSERCls.getUserCombString(new T_SYSSEC_IPSUSER_SW {
USERID = m.EMAILRECUSERLIST, formatUserStr = "<font color=red>[userName]</font><[orgName]>", splitUserStr = ","
});
if (string.IsNullOrEmpty(m.EMAILRECUSERLIST))
{
m.EMAILSECRETUSERLIST = "0";
}
m.EMAILRECUSERLIST1 = T_SYSSEC_IPSUSERCls.getUserCombString(new T_SYSSEC_IPSUSER_SW {
USERID = m.EMAILRECUSERLIST, formatUserStr = "[userName]", splitUserStr = ","
});
m.EMAILCOPYUSERLIST = dt.Rows[i]["EMAILCOPYUSERLIST"].ToString();//抄送人
if (string.IsNullOrEmpty(m.EMAILCOPYUSERLIST))
{
m.EMAILCOPYUSERLIST = "0";
}
m.EMAILCOPYUSERNameLIST = T_SYSSEC_IPSUSERCls.getUserCombString(new T_SYSSEC_IPSUSER_SW {
USERID = m.EMAILCOPYUSERLIST, formatUserStr = "<font color=red>[userName]</font><[orgName]>", splitUserStr = ","
});
m.EMAILCOPYUSERLIST1 = T_SYSSEC_IPSUSERCls.getUserCombString(new T_SYSSEC_IPSUSER_SW {
USERID = m.EMAILCOPYUSERLIST, formatUserStr = "[userName]", splitUserStr = ","
});
//m.EMAILCOPYUSERNameLIST = BaseDT.T_SYSSEC_USER.getNameByUserList(dtUser, m.EMAILCOPYUSERLIST);
m.EMAILSECRETUSERLIST = dt.Rows[i]["EMAILSECRETUSERLIST"].ToString();//密送人
if (string.IsNullOrEmpty(m.EMAILSECRETUSERLIST))
{
m.EMAILSECRETUSERLIST = "0";
}
m.EMAILSECRETUSERNameLIST = T_SYSSEC_IPSUSERCls.getUserCombString(new T_SYSSEC_IPSUSER_SW {
USERID = m.EMAILSECRETUSERLIST, formatUserStr = "<font color=red>[userName]</font><[orgName]>", splitUserStr = ","
});
m.EMAILSECRETUSERLIST1 = T_SYSSEC_IPSUSERCls.getUserCombString(new T_SYSSEC_IPSUSER_SW {
USERID = m.EMAILSECRETUSERLIST, formatUserStr = "[userName]", splitUserStr = ","
});
m.FileModel = E_FILECls.getListModel(new E_File_SW {
BYEMAILID = m.EMAILID
});
}
dt.Clear();
dt.Dispose();
dtUser.Clear();
dtUser.Dispose();
return(m);
}
/// <summary>
/// 增加获取主键
/// </summary>
/// <param name="m"></param>
/// <returns></returns>
public static string AddReturn(E_SUBJECT_Model m)
{
return(BaseDT.E_SUBJECT.AddReturn(m));
}
/// <summary>
/// 增、删
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Manager(E_SUBJECT_Model m)
{
if (m.opMethod == "Add")//保存为草稿
{
//没有附件
if (string.IsNullOrEmpty(m.EMAILID) == true)
{
Message msg = BaseDT.E_SUBJECT.Add(m);
//获取主题ID
string EMAILid = BaseDT.E_SUBJECT.getID(new E_SUBJECT_SW {
EMAILSENDUSERID = m.EMAILSENDUSERID, EMAILTIME = m.EMAILTIME
});
if (msg.Success == true)
{
return(new Message(msg.Success, "草稿保存成功!", m.returnUrl));
}
else
{
return(new Message(msg.Success, "草稿保存失败,请重试!", m.returnUrl));
}
}
//有附件的情况更新库
if (string.IsNullOrEmpty(m.EMAILID) == false)
{
Message msg = BaseDT.E_SUBJECT.Mdy(m);
if (msg.Success == true)
{
return(new Message(msg.Success, "草稿保存成功!", m.returnUrl));
}
else
{
return(new Message(msg.Success, "草稿保存失败,请重试!", m.returnUrl));
}
}
}
if (m.opMethod == "AddToSend")//草稿直接发送
{
#region 草稿直接发送
BaseDT.E_SUBJECT.Mdy(m);//主题表 修改为已发送
if (string.IsNullOrEmpty(m.EMAILRECUSERLIST) == false)
{
//接收信息表中录入数据 接收人
string[] arr = m.EMAILRECUSERLIST.Split(',');
for (int i = 0; i < arr.Length; i++)
{
BaseDT.E_RECEIVE.Add(new E_RECEIVE_Model
{
BYEMAILID = m.EMAILID,
RECEIVETYPE = "0", //接收人类别
RECEIVEUSERID = arr[i], //接收人序号
EMAILRECEIVESTATUS = "0", //接收状态
EMAILSENDTIME = m.EMAILTIME
});
}
}
if (string.IsNullOrEmpty(m.EMAILCOPYUSERLIST) == false)
{
//接收信息表中录入数据 抄送人
string[] arr = m.EMAILCOPYUSERLIST.Split(',');
for (int i = 0; i < arr.Length; i++)
{
BaseDT.E_RECEIVE.Add(new E_RECEIVE_Model
{
BYEMAILID = m.EMAILID,
RECEIVETYPE = "1", //接收人类别
RECEIVEUSERID = arr[i], //接收人序号
EMAILRECEIVESTATUS = "0", //接收状态
EMAILSENDTIME = m.EMAILTIME
});
}
}
if (string.IsNullOrEmpty(m.EMAILSECRETUSERLIST) == false)
{
//接收信息表中录入数据 密送人
string[] arr = m.EMAILSECRETUSERLIST.Split(',');
for (int i = 0; i < arr.Length; i++)
{
BaseDT.E_RECEIVE.Add(new E_RECEIVE_Model
{
BYEMAILID = m.EMAILID,
RECEIVETYPE = "2", //接收人类别
RECEIVEUSERID = arr[i], //接收人序号
EMAILRECEIVESTATUS = "0", //接收状态
EMAILSENDTIME = m.EMAILTIME
});
}
}
#endregion
#region 发送短信
string name = SystemCls.getCookieInfo().trueName;
string time = PublicClassLibrary.ClsSwitch.SwitTM(DateTime.Now.ToString());
string title = m.EMAILTITLE;
string userlist = m.EMAILRECUSERLIST + "," + m.EMAILCOPYUSERLIST + "," + m.EMAILSECRETUSERLIST;
string[] crr = userlist.Split(',');
string[] drr = crr.Where(s => !string.IsNullOrEmpty(s)).ToArray(); //去掉空的用户id
string userlist1 = ""; //定义一个去掉空的uselist
for (int i = 0; i < drr.Length; i++)
{
if (i == drr.Length - 1)
{
userlist1 += drr[i];
}
else
{
userlist1 += drr[i] + ",";
}
}
string phone = ""; //通过userlist获取手机号码
string phone1 = ""; //定义一个去掉空的号码
if (string.IsNullOrEmpty(userlist1) == false)
{
phone = BaseDT.T_SYSSEC_IPSUSER.getphone(new T_SYSSEC_IPSUSER_SW {
USERID = userlist1
});
string[] jrr = phone.Split(',');
string[] brr = jrr.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)
{
phone1 += brr[i];
}
else
{
phone1 += brr[i] + ",";
}
}
}
string content = "您好:" + name + "在" + time + "给您发一封主题「" + title + "」邮件,请登陆森林保护信息指挥系统查阅!";
SmsHelp.SmsCom.SendMsg(content, phone1);
return(new Message(true, "发送成功!", m.returnUrl));
#endregion
}
if (m.opMethod == "Send")//发送
{
//没有附件
if (string.IsNullOrEmpty(m.EMAILID) == true)
{
//未保存为草稿，直接发送
BaseDT.E_SUBJECT.Add(m);//主题表ADD
//获取主题ID
string EMAILid = BaseDT.E_SUBJECT.getID(new E_SUBJECT_SW {
EMAILSENDUSERID = m.EMAILSENDUSERID, EMAILTIME = m.EMAILTIME
});
if (string.IsNullOrEmpty(m.EMAILRECUSERLIST) == false)
{
//接收信息表中录入数据 接收人
string[] arr = m.EMAILRECUSERLIST.Split(',');
for (int i = 0; i < arr.Length; i++)
{
BaseDT.E_RECEIVE.Add(new E_RECEIVE_Model
{
BYEMAILID = EMAILid,
RECEIVETYPE = "0", //接收人类别
RECEIVEUSERID = arr[i], //接收人序号
EMAILRECEIVESTATUS = "0", //接收状态
EMAILSENDTIME = m.EMAILTIME
});
}
}
if (string.IsNullOrEmpty(m.EMAILCOPYUSERLIST) == false)
{
//接收信息表中录入数据 抄送人
string[] arr = m.EMAILCOPYUSERLIST.Split(',');
for (int i = 0; i < arr.Length; i++)
{
BaseDT.E_RECEIVE.Add(new E_RECEIVE_Model
{
BYEMAILID = EMAILid,
RECEIVETYPE = "1", //接收人类别
RECEIVEUSERID = arr[i], //接收人序号
EMAILRECEIVESTATUS = "0", //接收状态
EMAILSENDTIME = m.EMAILTIME
});
}
}
if (string.IsNullOrEmpty(m.EMAILSECRETUSERLIST) == false)
{
//接收信息表中录入数据 密送人
string[] arr = m.EMAILSECRETUSERLIST.Split(',');
for (int i = 0; i < arr.Length; i++)
{
BaseDT.E_RECEIVE.Add(new E_RECEIVE_Model
{
BYEMAILID = EMAILid,
RECEIVETYPE = "2", //接收人类别
RECEIVEUSERID = arr[i], //接收人序号
EMAILRECEIVESTATUS = "0", //接收状态
EMAILSENDTIME = m.EMAILTIME
});
}
}
//发送短信
string name = SystemCls.getCookieInfo().trueName;
string time = PublicClassLibrary.ClsSwitch.SwitTM(DateTime.Now.ToString());
string title = m.EMAILTITLE;
string userlist = m.EMAILRECUSERLIST + "," + m.EMAILCOPYUSERLIST + "," + m.EMAILSECRETUSERLIST;
string[] crr = userlist.Split(',');
string[] drr = crr.Where(s => !string.IsNullOrEmpty(s)).ToArray(); //去掉空的用户id
string userlist1 = ""; //定义一个去掉空的uselist
for (int i = 0; i < drr.Length; i++)
{
if (i == drr.Length - 1)
{
userlist1 += drr[i];
}
else
{
userlist1 += drr[i] + ",";
}
}
string phone = ""; //通过userlist获取手机号码
string phone1 = ""; //定义一个去掉空的号码
if (string.IsNullOrEmpty(userlist1) == false)
{
phone = BaseDT.T_SYSSEC_IPSUSER.getphone(new T_SYSSEC_IPSUSER_SW {
USERID = userlist1
});
string[] jrr = phone.Split(',');
string[] brr = jrr.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)
{
phone1 += brr[i];
}
else
{
phone1 += brr[i] + ",";
}
}
}
string content = "您好:" + name + "在" + time + "给您发一封主题「" + title + "」邮件,请登陆森林保护信息指挥系统查阅!";
SmsHelp.SmsCom.SendMsg(content, phone1);
return(new Message(true, "发送成功", m.returnUrl));
}
//有附件的情况更新库
if (string.IsNullOrEmpty(m.EMAILID) == false)
{
BaseDT.E_SUBJECT.Mdy(m);
if (string.IsNullOrEmpty(m.EMAILRECUSERLIST) == false)
{
//接收信息表中录入数据 接收人
string[] arr = m.EMAILRECUSERLIST.Split(',');
for (int i = 0; i < arr.Length; i++)
{
BaseDT.E_RECEIVE.Add(new E_RECEIVE_Model
{
BYEMAILID = m.EMAILID,
RECEIVETYPE = "0", //接收人类别
RECEIVEUSERID = arr[i], //接收人序号
EMAILRECEIVESTATUS = "0", //接收状态
EMAILSENDTIME = m.EMAILTIME
});
}
}
if (string.IsNullOrEmpty(m.EMAILCOPYUSERLIST) == false)
{
//接收信息表中录入数据 抄送人
string[] arr = m.EMAILCOPYUSERLIST.Split(',');
for (int i = 0; i < arr.Length; i++)
{
BaseDT.E_RECEIVE.Add(new E_RECEIVE_Model
{
BYEMAILID = m.EMAILID,
RECEIVETYPE = "1", //接收人类别
RECEIVEUSERID = arr[i], //接收人序号
EMAILRECEIVESTATUS = "0", //接收状态
EMAILSENDTIME = m.EMAILTIME
});
}
}
if (string.IsNullOrEmpty(m.EMAILSECRETUSERLIST) == false)
{
//接收信息表中录入数据 密送人
string[] arr = m.EMAILSECRETUSERLIST.Split(',');
for (int i = 0; i < arr.Length; i++)
{
BaseDT.E_RECEIVE.Add(new E_RECEIVE_Model
{
BYEMAILID = m.EMAILID,
RECEIVETYPE = "2", //接收人类别
RECEIVEUSERID = arr[i], //接收人序号
EMAILRECEIVESTATUS = "0", //接收状态
EMAILSENDTIME = m.EMAILTIME
});
}
//发送短信
string name = SystemCls.getCookieInfo().trueName;
string time = PublicClassLibrary.ClsSwitch.SwitTM(DateTime.Now.ToString());
string title = m.EMAILTITLE;
string userlist = m.EMAILRECUSERLIST + "," + m.EMAILCOPYUSERLIST + "," + m.EMAILSECRETUSERLIST;
string[] crr = userlist.Split(',');
string[] drr = crr.Where(s => !string.IsNullOrEmpty(s)).ToArray(); //去掉空的用户id
string userlist1 = ""; //定义一个去掉空的uselist
for (int i = 0; i < drr.Length; i++)
{
if (i == drr.Length - 1)
{
userlist1 += drr[i];
}
else
{
userlist1 += drr[i] + ",";
}
}
string phone = ""; //通过userlist获取手机号码
string phone1 = ""; //定义一个去掉空的号码
if (string.IsNullOrEmpty(userlist1) == false)
{
phone = BaseDT.T_SYSSEC_IPSUSER.getphone(new T_SYSSEC_IPSUSER_SW {
USERID = userlist1
});
string[] jrr = phone.Split(',');
string[] brr = jrr.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)
{
phone1 += brr[i];
}
else
{
phone1 += brr[i] + ",";
}
}
}
string content = "您好:" + name + "在" + time + "给您发一封主题「" + title + "」邮件,请登陆森林保护信息指挥系统查阅!";
SmsHelp.SmsCom.SendMsg(content, phone1);
}
return(new Message(true, "发送成功!", m.returnUrl));
}
}
if (m.opMethod == "Mdy") //草稿箱的时候修改
{
Message msg = BaseDT.E_SUBJECT.Mdy(m);
return(new Message(msg.Success, msg.Msg, m.returnUrl));
}
if (m.opMethod == "SendMdy") //涉及到多条记录的修改；已发送的列表
{
Message msg = BaseDT.E_SUBJECT.SendMdy(m);
return(new Message(msg.Success, msg.Msg, m.returnUrl));
}
if (m.opMethod == "Del")
{
Message msgUser = BaseDT.E_SUBJECT.Del(m);
return(new Message(msgUser.Success, msgUser.Msg, m.returnUrl));
}
return(new Message(false, "无效操作!", ""));
}
