public void Start() { // 配置文件统一 string CompanyCode = "8601"; // CompanyCode if (!String.IsNullOrEmpty(ConfigurationManager.AppSettings["CompanyCode"].ToString())) { CompanyCode = ConfigurationManager.AppSettings["CompanyCode"].ToString(); } DataSet dsResult = AutoPricingDisableDA.GetProductItemNoList(CompanyCode); if (dsResult.Tables != null && dsResult.Tables[0].Rows.Count == 0) { return; } int iCount = dsResult.Tables[0].Rows.Count; for (int i = 0; i < iCount; i++) { try { AutoPricingDisableDA.UpdateAutoPricingDisableData(dsResult.Tables[0].Rows[i]["SysNo"].ToString(), CompanyCode); SendAutoPricingDisableNotify(dsResult.Tables[0].Rows[i], CompanyCode); Console.WriteLine("当前执行位置:" + (i + 1) + "/" + iCount);; }catch (Exception ex) { Console.WriteLine(ex.Message); } } }
/// <summary> /// 邮件PM /// </summary> /// <param name="entity"></param> private void SendAutoPricingDisableNotify(DataRow drData, string CompanyCode) { string SendEmailFlag = ConfigurationManager.AppSettings["SendEmailFlag"]; if (String.IsNullOrEmpty(SendEmailFlag) || SendEmailFlag.Equals("0")) { return; } SalesMailEntity salesMailEntity = AutoPricingDisableDA.GetPMMails(drData["SysNo"].ToString(), drData["PMUserSysNo"].ToString(), CompanyCode); string toMailAddress = (salesMailEntity != null) ? salesMailEntity.toEmail : ""; string ccMailAddress = (salesMailEntity != null) ? salesMailEntity.ccEmail : ""; toMailAddress = String.IsNullOrEmpty(toMailAddress) ? ConfigurationManager.AppSettings["SLGroupEmail"] : toMailAddress; ccMailAddress = String.IsNullOrEmpty(ccMailAddress) ? ConfigurationManager.AppSettings["PMGroupEmail"] : ccMailAddress; if (String.IsNullOrEmpty(toMailAddress) && String.IsNullOrEmpty(ccMailAddress)) { return; } if (String.IsNullOrEmpty(toMailAddress) && !String.IsNullOrEmpty(ccMailAddress)) { toMailAddress = ccMailAddress; ccMailAddress = ""; } ccMailAddress = (!String.IsNullOrEmpty(ccMailAddress)) ? ccMailAddress + ";" + ConfigurationManager.AppSettings["EmailOceo"].ToString() : ConfigurationManager.AppSettings["EmailOceo"].ToString(); MailEntity mail = BuildEmail(drData); mail.From = ConfigurationManager.AppSettings["EmailFrom"]; mail.To = toMailAddress; mail.CC = ccMailAddress; mail.Subject = "禁止自动调价到期失效通知"; mail.CompanyCode = CompanyCode; EmailComparisonCNServiceFacade.SendProductEmail(mail); }