public static SalesMailEntity GetPMMails(string productSysNo, string pmUserSysNo, string CompanyCode) { SalesMailEntity result = null; DataCommand cmd = DataCommandManager.GetDataCommand("GetProductPmEmail"); cmd.SetParameterValue("@UserSysNo", pmUserSysNo); cmd.SetParameterValue("@CompanyCode", CompanyCode); result = cmd.ExecuteEntity <SalesMailEntity>(); DataSet dsResult = GetSalesMails(productSysNo, CompanyCode); if (dsResult.Tables.Count > 0 && dsResult.Tables[0].Rows.Count > 0) { result = (result == null) ? new SalesMailEntity() : result; result.toEmail = dsResult.Tables[0].Rows[0]["toEmail"].ToString(); } return(result); }
/// <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); }