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]); }