Ejemplo n.º 1
0
        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);
        }
Ejemplo n.º 2
0
        public static bool SentFailNews(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 + "职位投递的简历已被退回.";

            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();

            return(line > 0);
        }