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