/// <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); }