public static bool SentSuccessNews(int aid) { string sql = "INSERT INTO [news] ([Sid], [Ntitle], [Ncontent], [Ntime]) VALUES (@Sid, @Ntitle, @Ncontent, @Ntime)"; Apply apply = DNews.GetApply(aid); string title = apply.Cname + "-" + apply.Jname + "-提档通知"; string content = "亲爱的" + apply.Sname + "同学:\n\t您在" + apply.Adatetime + "的时候向" + apply.Cname + "公司" + apply.Jname + "职位投递的简历已被提档,请等待面试通知.\n\t祝您面试顺利!"; SqlParameter[] parm = new SqlParameter[] { new SqlParameter("@Sid", apply.Sid), new SqlParameter("@Ntitle", title), new SqlParameter("@Ncontent", content), new SqlParameter("@Ntime", DateTime.Now), }; int line = DBHelper.ExecuteNonQuery(sql, parm); DBHelper.SqlClose(); if (line > 0) { if (DEmploy.Employ(apply.Jid, apply.Sid)) { return(true); } } return(false); }
public static bool SentInterviewNews(int eid, string date) { string sql = "INSERT INTO [news] ([Sid], [Ntitle], [Ncontent], [Ntime]) VALUES (@Sid, @Ntitle, @Ncontent, @Ntime)"; Employ employ = DEmploy.getEmploy(eid); string title = employ.Jname + "-面试通知"; string content = "亲爱的" + employ.Sname + "同学:\n\t 请您在 " + date + " 的时候参加 " + employ.Jname + " 岗位的面试."; SqlParameter[] parm = new SqlParameter[] { new SqlParameter("@Sid", employ.Sid), new SqlParameter("@Ntitle", title), new SqlParameter("@Ncontent", content), new SqlParameter("@Ntime", DateTime.Now), }; int line = DBHelper.ExecuteNonQuery(sql, parm); DBHelper.SqlClose(); return(line > 0); }