BugTracker部署好之后，发现增加bug不能mail提醒。于是补上这个功能记录在此，方法是次要的，主要是找到地方。需要3步。吐槽下Asp的代码风格看的真心蛋疼....
一、发送mail（主要是找到位置）
1.在App_Code中加入MailHelper.cs .
using System;
using System.Net.Mail; public class MailHelper
{
/// <summary>
/// 异步发送邮件
/// </summary>
/// <param name="toMails"></param>
/// <param name="subject"></param>
/// <param name="content"></param>
public static void SystemSendMail(string toMails, string subject, string content)
{ Action invokeAction = () => WebMailTo(toMails, subject, content);
invokeAction.BeginInvoke(Callback, invokeAction); } private static void Callback(IAsyncResult ar)
{
var action = ar.AsyncState as Action;
if (action != null) action.EndInvoke(ar);
} /// <summary>
/// Webs the mail to.
/// </summary>
/// <param name="toEmails">To emails.</param>
/// <param name="subject">The subject.</param>
/// <param name="emailText">The email text.</param>
/// <returns><c>true</c> if XXXX, <c>false</c> otherwise</returns>
public static bool WebMailTo(string toEmails, string subject, string emailText)
{
#region 此处参数使用时根据需要替换成自己的
const string server = "172.17.xxx.95"; //此处代表Mail Server地址
const string formEmail = xxxxx.xxx@xxx.com.cn"; //此处代表系统发邮件的时候的发件人地址
const string formDispayName = "BugTracker"; //系统发件人的显示名称
const string formPassword = "xxxxx"; //此处代表系统发邮件的时候的发件人的密码
const string formDomain = "xxxwj"; //域名
#endregion const string systermtxt = "<br/>该邮件为系统自动发送，请勿回复！详情请点击" + "<a href='http://cnwj6iapc016:84/'>这里~</a>";
var mailMessage = new MailMessage { IsBodyHtml = true };
mailMessage.To.Add(toEmails);
mailMessage.From = new MailAddress(formEmail, formDispayName);
mailMessage.Subject = subject;
mailMessage.Body = emailText + systermtxt;//此处可以传递一个html
mailMessage.Priority = MailPriority.High;
var client = new SmtpClient
{
Host = server,
UseDefaultCredentials = false,
Credentials = new System.Net.NetworkCredential(formEmail, formPassword, formDomain),
DeliveryMethod = SmtpDeliveryMethod.Network,
EnableSsl = false
};
bool isSendOk;
try
{
client.Send(mailMessage);//发送Mail
isSendOk = true; }
catch (Exception)
{ isSendOk = false;
}
return isSendOk;
}
}
2.给在App_Code的dbutil.cs加入个功能函数。
public static string GetStringById(int id,StringType stringType)
{
using (SqlConnection conn = get_sqlconnection())
{
var sql = "";
switch (stringType)
{
case StringType.Email:
sql = "select us_email from users where us_id=" + id;
break;
case StringType.ProjectDefaultUserId:
sql = "select pj_default_user from projects where pj_id=" + id;
break;
case StringType.UserName:
sql = "select us_username from users where us_id=" + id;
break;
}
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(sql, conn);
int c = da.Fill(ds, "table");
DataRow[] dr = ds.Tables[].Select();
conn.Close();
return c != ? dr[][].ToString() : "";
}
} public enum StringType
{
Email,
ProjectDefaultUserId,
UserName
}
3.在App_Code的bug.cs中修改insert_bug 方法。
sql = sql.Replace("$short_desc", short_desc.Replace("'", "''"));
sql = sql.Replace("$tags", tags.Replace("'", "''"));
sql = sql.Replace("$reported_user", Convert.ToString(security.user.usid));
sql = sql.Replace("$project", Convert.ToString(projectid));
sql = sql.Replace("$org", Convert.ToString(orgid));
sql = sql.Replace("$category", Convert.ToString(categoryid));
sql = sql.Replace("$priority", Convert.ToString(priorityid));
sql = sql.Replace("$status", Convert.ToString(statusid));
sql = sql.Replace("$assigned_user", Convert.ToString(assigned_to_userid));
sql = sql.Replace("$udf", Convert.ToString(udfid));
sql = sql.Replace("$pcd1", project_custom_dropdown_value1);
sql = sql.Replace("$pcd2", project_custom_dropdown_value2);
sql = sql.Replace("$pcd3", project_custom_dropdown_value3);
// 发送mail 这里才是补充的代码。
var str = string.Format("<div style='padding:20px;border:2px solid green'>{0}维护了与你相关的新的Bug,详细情况请登录Bug管理系统</div>", security.user.username);
var pid = DbUtil.GetStringById(projectid, StringType.ProjectDefaultUserId);
if (pid == "")
{
pid = "";
}
var defaultuserid = Convert.ToInt16(pid);
if (defaultuserid != )
{
MailHelper.SystemSendMail(DbUtil.GetStringById(defaultuserid, StringType.Email), "BugTracker:你有新的bug了", str);
}
if (defaultuserid != assigned_to_userid)
{
MailHelper.SystemSendMail(DbUtil.GetStringById(assigned_to_userid, StringType.Email), "BugTracker:你有新的bug了", str);
}
这样子就ok了。增加不过的时候，会发送给抄送人和工程负责人。
同理，如果要在评论更显得 时候也加入mail通知。评论对应的数据库中的表是bug_posts. 插入的方法在App_Code/bug.cs中的
public static int insert_comment（.....） 方法中。
在return之前加入下面的代码：
sql = sql.Replace("$cc", cc.Replace("'", "''"));
sql = sql.Replace("$internal", btnet.Util.bool_to_string(internal_only));
DataRow[] drs = DbUtil.GetBugDataRows(bugid);
if (drs.Count() != )
{
var buguserId = Convert.ToInt16(drs[]["bg_reported_user"]);// 发布bug的人
var bugassigneduserId = Convert.ToInt16(drs[]["bg_assigned_to_user"]);//bug抄送的人
var projectId = Convert.ToInt16(drs[]["bg_project"]);
const string titile = "Bug有新的评论";
var bugdesc = drs[]["bg_short_desc"].ToString();
var content = string.Format("<div style='padding:20px;border:3px solid blueviolet;'>Bug {0}(Id :{1})有新的评论：<br/><p style='color:gray;font-size:small;background: #ffffe0'>{2}</p></div>", bugdesc, bugid, comment_formated.Replace("'", "''"));
if (this_usid != buguserId)//避免是同一人 而重复发送。
{
MailHelper.SystemSendMail(DbUtil.GetStringById(buguserId,StringType.Email),titile,content);
}
if (bugassigneduserId != && this_usid != bugassigneduserId)//避免是同一人 而重复发送。
{
MailHelper.SystemSendMail(DbUtil.GetStringById(bugassigneduserId, StringType.Email), titile, content);
}
if (projectId != )
{
var pduid =Convert.ToInt16(DbUtil.GetStringById(projectId, StringType.ProjectDefaultUserId)) ;
if (pduid != && this_usid != pduid && pduid != bugassigneduserId)//避免是同一人 而重复发送。
{
MailHelper.SystemSendMail(DbUtil.GetStringById(pduid, StringType.Email), titile, content);
}
}
}
另外需要在dbutil.cs中加入一些方法
public static string GetStringById(int id,StringType stringType)
{
using (SqlConnection conn = get_sqlconnection())
{
var sql = "";
switch (stringType)
{
case StringType.Email:
sql = "select us_email from users where us_id=" + id;
break;
case StringType.ProjectDefaultUserId:
sql = "select pj_default_user from projects where pj_id=" + id;
break;
case StringType.BugUserId:
sql = "select bg_reported_user from bugs where bg_id=" + id;
break;
}
var ds = new DataSet();
var da = new SqlDataAdapter(sql, conn);
var c = da.Fill(ds, "table");
var dr = ds.Tables[].Select();
conn.Close();
return c != ? dr[][].ToString() : "";
}
} public static DataRow[] GetBugDataRows(int bugId)
{
using (SqlConnection conn = get_sqlconnection())
{
var sql = "select * from bugs where bg_id=" + bugId;
var ds = new DataSet();
var da = new SqlDataAdapter(sql, conn);
da.Fill(ds, "table");
var drs=ds.Tables[].Select();
conn.Close();
return drs;
}
}
最后效果：
二、自动登录
自动登录也要改改，每次都要点一次。刚开始以为在login打头的文件中，试了几次登录函数是在default.aspx 页面中。
1、在Page_Load中的 if (username_cookie != null) 中加入最后三句，就是判断下cookie。asp中的控件赋值比较神器.... input元素直接可以点出value。
if (username_cookie != null)
{
// Set the user name from the last logon.
user.Value = username_cookie["name"];
var pcookie = Request.Cookies["pwd"];
if (pcookie != null && pcookie.Value!="")
{
pw.Value = pcookie.Value;
on_logon();
}
}
2、再在下面的on_logon() 中的 if (authenticated) 中加入下面的代码。 初始的时候加上cookie
var httpCookie = Response.Cookies["pwd"];
if (httpCookie == null)
{
var currentCookie = new HttpCookie("pwd") {Value = pw.Value, Expires = DateTime.Now.AddDays()};
Response.Cookies.Add(currentCookie);
}
else
{
httpCookie.Value = pw.Value;
}
3、处理退出，不然的话人家登录了很难切换用户。
用户点击右上角的logoff的时候，其实是先跳转到了logoff.aspx页面。在页面跳转到defau.aspx之前，清空cookie的值。
var httpCookie = Response.Cookies["pwd"];
if (httpCookie != null)
{
httpCookie.Value = null;
} Response.Redirect("default.aspx?msg=logged+off");
感觉下次就会用上。