protected void Page_Load(object sender, EventArgs e)
{
Session["RoleIDS"] = "";
Session["RoleName"] = "";
Session["RoleNames"] = "";
Session["cultureName"] = "zh-cn";
var manager = new BMaterialApproval().GetManager().Split(' ');
WebParas.Add("ManagerName", manager[0]);
WebParas.Add("ManagerCode", manager[1]);
var today = DateTime.Now.Day;
//获取时间窗口
var ds = new BMaterialApproval().GetEmailDay();
var dr1 = ds.Tables[0].Select("ConstantKey='接口人审核'")[0]["ConstantValue"].ToString().Split('-');
var dr2 = ds.Tables[0].Select("ConstantKey='项目经理审核'")[0]["ConstantValue"].ToString().Split('-');
var dr3 = ds.Tables[0].Select("ConstantKey='部门主管审核'")[0]["ConstantValue"].ToString().Split('-');
var dr4 = ds.Tables[0].Select("ConstantKey='计划员汇总'")[0]["ConstantValue"].ToString().Split('-');
var dr5 = ds.Tables[0].Select("ConstantKey='综合审批'")[0]["ConstantValue"].ToString().Split('-');
if (int.Parse(dr1[0]) <= today && today <= int.Parse(dr1[1]))//接口人审核邮催
{
//不规则邮催
var dt = new BMaterialApproval().GetReviewerCheckSendEmail();
SendEmailReviewerCheck(dt);
//未审核邮催
var dt2 = new BMaterialApproval().GetReviewerCheckSendEmailUnCheck();
SendEmailReviewerUnCheck(dt2);
}
if (int.Parse(dr2[0]) <= today && today <= int.Parse(dr2[1]))//项目经理审核邮催
{
var dt = new BMaterialApproval().GetProjectManagerUnCheck();
SendEmailProjectManagerUnCheck(dt);
}
if (int.Parse(dr3[0]) <= today && today <= int.Parse(dr3[1]))//部门主管审核邮催
{
var dt = new BMaterialApproval().GetDeptManagerUnCheck();
SendEmailDeptManagerUnCheck(dt);
}
if (int.Parse(dr4[0]) <= today && today <= int.Parse(dr4[1]))//计划员审核邮催
{
var dt = new BMaterialApproval().GetPlanManagerUnCheck();
SendEmailPlanManagerUnCheck(dt);
}
if (int.Parse(dr5[0]) <= today && today <= int.Parse(dr5[1]))//计划员审核邮催
{
var dt = new BMaterialApproval().GetFinalCheckUnCheck();
SendEmailFinalCheckUnCheck(dt);
}
Response.Write("发送邮件完成！");
}
public void DownLoadSearchMaterial()
{
string key = Request["key"];
InPara para = new InPara();
para.ApproveStatus = Request["ApproveStatus"];
para.PlanCode = Request["PlanCode"];
para.MaterialInfo = Request["MaterialInfo"];
para.ApplyUser = Request["ApplyUser"];
para.ApproveMonth = Request["ApproveMonth"];
para.MaterialName = Request["MaterialName"];
para.DeptCode = Request["DeptCode"];
para.Deptlevel = Request["Deptlevel"];
para.DeptCOACode = Request["DeptCOACode"];
para.ItemCode = Request["ItemCode"];
para.ReceiverPlace = Request["ReceiverPlace"];
para.ApproveRel = Request["ApproveRel"];
DataSet ds = new BMaterialApproval().DownLoadSearchMaterial(para, SiteSession.UserCode);
NPOIExcelHelper.DownLoad(ds.Tables[0]);
}
public void DownLoadDeptConfig()
{
DataSet ds = new BMaterialApproval().DownLoadDeptConfig();
NPOIExcelHelper.DownLoad(ds.Tables[0]);
}
