





























1。通用部分
2.调用部分
private bool GetUserNameMenuName(ref string strUsers,ref string strMenuNames)
{
string strSQLUserName = string.Format("Select UserName FROM TBL_AccessUser Where RoleID = {0} ",H_RoleID);
string strSQLMenu = GetMenuSQL(H_AccessXml);
string strSQL = string.Format("{0} ; {1} ",strSQLUserName,strSQLMenu);
DataSet ds = DataProvider.RunSelect(strSQL);
if (ds == null || ds.Tables.Count <= 0 || ds.Tables[0].Rows.Count == 0 )
return false;
foreach(DataRow dr in ds.Tables[0].Rows)
{
if(strUsers != "")
strUsers += ",";
strUsers += dr["UserName"].ToString().Trim();
}
int icount = 1;
foreach(DataRow dr in ds.Tables[1].Rows)
{
string strMenuName = dr["MenuName"].ToString().Trim();
if (strMenuName != "")
{
if (icount % 5 == 1)
strMenuNames += string.Format("<TR><TD>{0}</TD><TD>",strMenuName); //头
else if (icount % 5 == 0)
strMenuNames += string.Format("{0}</TD></TR>",strMenuName); //尾
else
strMenuNames += string.Format("{0}</TD><TD>",strMenuName); //中间
icount ++;
}
}
return strUsers.Trim() != "";
}

private string GetMessage()
{
StringBuilder sbEmailMsg = new StringBuilder("");
string strUser = "";
string strMenuNames = "";
if (GetUserNameMenuName(ref strUser,ref strMenuNames))
{
sbEmailMsg.Append("<TABLE width='600' bgColor='#e0ecff'><caption>");
sbEmailMsg.Append("<caption style='FONT-SIZE: 20pt;COLOR: #f7f7f7; PADDING-TOP: 5px; BACKGROUND-COLOR: #4a3c8c'>权限角色修改记录</caption>");
sbEmailMsg.Append("<TR><TD width='20%'></TD><TD width='20%'></TD><TD width='20%'></TD><TD width='20%'></TD><TD width='20%'></TD></TR>");
sbEmailMsg.Append(string.Format("<TR><TD ColSpan=5>{0}的权限有变动,新权限为:</TD></TR>{1}</TABLE>",strUser,strMenuNames));
}
return sbEmailMsg.ToString();
}

private bool DoSendMail()
{
string strSubject = "角色修改";
string strMessage = GetMessage();
return EmailCommonFun.EmailSend(strSubject,strMessage);
}
此内容由惯性聚合(RSS阅读器)自动聚合整理,仅供阅读参考。 原文来自 — 版权归原作者所有。