/// <summary> /// 获取数据 /// </summary> /// <param name="sw"></param> /// <returns></returns> public static DataTable getDT(E_SUBJECT_SW sw) { StringBuilder sb = new StringBuilder(); sb.AppendFormat(" FROM E_SUBJECT a"); sb.AppendFormat(" WHERE 1=1"); if (string.IsNullOrEmpty(sw.EMAILID) == false) { sb.AppendFormat(" AND EMAILID = '{0}'", ClsSql.EncodeSql(sw.EMAILID)); } if (string.IsNullOrEmpty(sw.EMAILTIME) == false) { sb.AppendFormat(" AND EMAILTIME = '{0}'", ClsSql.EncodeSql(sw.EMAILTIME)); } if (string.IsNullOrEmpty(sw.EMAILTITLE) == false) { sb.AppendFormat(" AND EMAILTITLE like '%{0}%'", ClsSql.EncodeSql(sw.EMAILTITLE)); } if (string.IsNullOrEmpty(sw.EMAILSENDUSERID) == false) { sb.AppendFormat(" AND EMAILSENDUSERID ='{0}'", ClsSql.EncodeSql(sw.EMAILSENDUSERID)); } if (string.IsNullOrEmpty(sw.EMAILSTATUS) == false)//状态 { sb.AppendFormat(" AND EMAILSTATUS = '{0}'", ClsSql.EncodeSql(sw.EMAILSTATUS)); } string sql = "SELECT EMAILID, EMAILTITLE, EMAILSTATUS, EMAILSENDUSERID, EMAILTIME, EMAILCONTENT, EMAILRECUSERLIST, EMAILCOPYUSERLIST, EMAILSECRETUSERLIST" + sb.ToString() + " order by EMAILTIME DESC"; DataSet ds = DataBaseClass.FullDataSet(sql); return(ds.Tables[0]); }
/// <summary> /// 获取邮件主题ID /// </summary> /// <param name="sw"></param> /// <returns></returns> public static string getID(E_SUBJECT_SW sw) { DataTable dt = getDT(sw); string EMAILid = ""; if (dt.Rows.Count > 0) { EMAILid = dt.Rows[0]["EMAILID"].ToString(); } dt.Clear(); dt.Dispose(); return(EMAILid); }
/// <summary> /// 获取分页数据 /// </summary> /// <param name="sw"></param> /// <param name="total"></param> /// <returns></returns> public static DataTable getDT(E_SUBJECT_SW sw, out int total) { StringBuilder sb = new StringBuilder(); sb.AppendFormat(" FROM E_SUBJECT a"); sb.AppendFormat(" WHERE 1=1"); if (string.IsNullOrEmpty(sw.EMAILID) == false) { sb.AppendFormat(" AND EMAILID = '{0}'", ClsSql.EncodeSql(sw.EMAILID)); } if (string.IsNullOrEmpty(sw.EMAILTITLE) == false) { sb.AppendFormat(" AND EMAILTITLE like '%{0}%'", ClsSql.EncodeSql(sw.EMAILTITLE)); } if (string.IsNullOrEmpty(sw.EMAILSENDUSERID) == false) { sb.AppendFormat(" AND EMAILSENDUSERID ='{0}'", ClsSql.EncodeSql(sw.EMAILSENDUSERID)); } if (string.IsNullOrEmpty(sw.EMAILSTATUS) == false)//状态 { sb.AppendFormat(" AND EMAILSTATUS = '{0}'", ClsSql.EncodeSql(sw.EMAILSTATUS)); } //if (string.IsNullOrEmpty(sw.RECEIVEUSERID))//接收人序号不为空,获取收件箱 //{ //} string sql = "SELECT EMAILID, EMAILTITLE, EMAILSTATUS, EMAILSENDUSERID, EMAILTIME, EMAILCONTENT, EMAILRECUSERLIST, EMAILCOPYUSERLIST, EMAILSECRETUSERLIST" + sb.ToString() + " order by EMAILTIME DESC"; string sqlC = "select count(1) " + sb.ToString(); total = int.Parse(DataBaseClass.ReturnSqlField(sqlC)); sw.curPage = PagerCls.getCurPage(new PagerSW { curPage = sw.curPage, pageSize = sw.pageSize, rowCount = total }); DataSet ds = DataBaseClass.FullDataSet(sql, (sw.curPage - 1) * sw.pageSize, sw.pageSize, "a"); return(ds.Tables[0]); }
/// <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); }