/// <summary>
/// 查看某一邮件信息
/// </summary>
/// <param name="sw"></param>
/// <returns></returns>
public static E_RECEIVE_Model getModel(E_RECEIVE_SW sw)
{
DataTable dt = BaseDT.E_RECEIVE.getDT(sw);//列表
E_RECEIVE_Model m = new E_RECEIVE_Model();
if (dt.Rows.Count > 0)
{
int i = 0;
m.ERID = dt.Rows[i]["ERID"].ToString();
m.BYEMAILID = dt.Rows[i]["BYEMAILID"].ToString();
m.RECEIVETYPE = dt.Rows[i]["RECEIVETYPE"].ToString();
m.EMAILRECEIVESTATUS = dt.Rows[i]["EMAILRECEIVESTATUS"].ToString();
m.EMAILSENDTIME = ClsSwitch.SwitTM(dt.Rows[i]["EMAILSENDTIME"].ToString());
m.EMAILRECEIVETIME = ClsSwitch.SwitTM(dt.Rows[i]["EMAILRECEIVETIME"].ToString());
m.SubjectModel = E_SUBJECTCls.getModel(new E_SUBJECT_SW {
EMAILID = m.BYEMAILID
});
m.FileModel = E_FILECls.getListModel(new E_File_SW {
BYEMAILID = m.BYEMAILID
});
if (m.EMAILRECEIVESTATUS == "0")//未读
{
BaseDT.E_RECEIVE.Mdy(new E_RECEIVE_Model {
EMAILRECEIVESTATUS = "1",
EMAILRECEIVETIME = ClsSwitch.SwitTM(DateTime.Now),
ERID = m.ERID
});
}
}
dt.Clear();
dt.Dispose();
return(m);
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="sw"></param>
/// <returns></returns>
public static IEnumerable <E_RECEIVE_Model> getListModel(E_RECEIVE_SW sw)
{
DataTable dt = BaseDT.E_RECEIVE.getDT(sw);//列表
var result = new List <E_RECEIVE_Model>();
for (int i = 0; i < dt.Rows.Count; i++)
{
E_RECEIVE_Model m = new E_RECEIVE_Model();
m.ERID = dt.Rows[i]["ERID"].ToString();
m.BYEMAILID = dt.Rows[i]["BYEMAILID"].ToString();
m.RECEIVETYPE = dt.Rows[i]["RECEIVETYPE"].ToString();
m.EMAILRECEIVESTATUS = dt.Rows[i]["EMAILRECEIVESTATUS"].ToString();
m.EMAILSENDTIME = ClsSwitch.SwitTM(dt.Rows[i]["EMAILSENDTIME"].ToString());
m.EMAILRECEIVETIME = ClsSwitch.SwitTM(dt.Rows[i]["EMAILRECEIVETIME"].ToString());
m.SubjectModel = E_SUBJECTCls.getModel(new E_SUBJECT_SW {
EMAILID = m.BYEMAILID
});
m.FileModel = E_FILECls.getListModel(new E_File_SW {
BYEMAILID = m.BYEMAILID
});
if (m.EMAILRECEIVESTATUS == "0")//未读
{
BaseDT.E_RECEIVE.Mdy(new E_RECEIVE_Model
{
EMAILRECEIVESTATUS = "1",
EMAILRECEIVETIME = ClsSwitch.SwitTM(DateTime.Now),
ERID = m.ERID
});
}
result.Add(m);
}
dt.Clear();
dt.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);
}
