/// <summary> /// 加载邮件列表 /// </summary> private void LoadEmailHistory() { EmailHistory cEmailHistory = new EmailHistory(); if (EmailType != "") { cEmailHistory.EmailType = EmailType; } if (MasterCode != "") { cEmailHistory.MasterCode = MasterCode; } string Receiver = ""; DataTable dt = new DataTable(); switch (EmailType) { case "BiddingEmitTo": dt = SupplierRule.GetSupplierByCode(Request["SupplierCode"]).CurrentTable; if (dt.Rows.Count > 0) { Receiver = dt.Rows[0]["Email"].ToString(); } dt.Dispose(); break; default: Receiver = ""; break; } if (Receiver != "") { cEmailHistory.Receiver = Receiver; } dt = cEmailHistory.GetEmailHistorys(); dt.Columns.Add(new DataColumn("EmailTypeCN", Type.GetType("System.String"))); for (int i = 0; i < dt.Rows.Count; i++) { dt.Rows[i]["EmailTypeCN"] = GetEmailTypeCNByEmailType(dt.Rows[i]["EmailType"].ToString()); } this.gvEmailHistoryList.DataSource = dt; this.gvEmailHistoryList.AutoGenerateColumns = false; this.gvEmailHistoryList.Columns[6].Visible = false; this.gvEmailHistoryList.DataBind(); }
/// <summary> /// 网上招投标发送Email通知供应商用户名密码,单个供应商 /// </summary> /// <param name="SupplierCode">供应商编号</param> /// <param name="EmitToCode">投标编号</param> /// <param name="pwd">密码</param> /// <param name="gid">用户名</param> /// <param name="EmailTemplateFileName">邮件模板XML文件名</param> private static void SendEmail(string SupplierCode, string EmitToCode, string pwd, string gid, string EmailTemplateFileName) { try { string Title = ""; string MailBody = ""; string UserMail = ""; string UserName = ""; string BiddingTitle = ""; string MailUser = ConfigurationManager.AppSettings["MailUser"].ToString(); string MailPwd = ConfigurationManager.AppSettings["MailPwd"].ToString(); EntityData entity = new EntityData(); entity = SupplierRule.GetSupplierByCode(SupplierCode); if (entity.HasRecord()) { UserName = entity.CurrentTable.Rows[0]["SupplierName"].ToString(); UserMail = entity.CurrentTable.Rows[0]["EMail"].ToString(); entity.Dispose(); if (UserMail != "") { Bidding cBidding = new Bidding(); BiddingEmit cBiddingEmit = new BiddingEmit(); StandardEntityDAO dao = new StandardEntityDAO("BiddingEmitTo"); string BiddingCode = cBiddingEmit.GetBiddingEmitByEmitToCode(dao, EmitToCode).CurrentRow["BiddingCode"].ToString(); BiddingTitle = cBidding.GetBiddingName(BiddingCode); XMLTreeViewManager vm = new XMLTreeViewManager(EmailTemplateFileName); XmlDocument doc = new XmlDocument(); doc.Load(vm.m_XMLFileName); XmlNode EmailTypeNode = doc.DocumentElement.SelectSingleNode("BiddingEmitTo"); if (EmailTypeNode != null) { Title = EmailTypeNode.SelectSingleNode("Title").InnerText; MailBody = EmailTypeNode.SelectSingleNode("MailBody").InnerText; } Title = Title.Replace("#BiddingTitle#", BiddingTitle); Title = Title.Replace("#Password#", pwd); Title = Title.Replace("#GID#", gid); MailBody = MailBody.Replace("#BiddingTitle#", BiddingTitle); MailBody = MailBody.Replace("#Password#", pwd); MailBody = MailBody.Replace("#GID#", gid); BLL.MailRule mail = new BLL.MailRule(); mail.Title = Title; mail.Body = MailBody; mail.ToMail = UserMail; mail.sendMail(); EmailHistoryInsert("BiddingEmitTo", EmitToCode, Title, UserMail, MailUser, MailBody, DateTime.Now); } } } catch (Exception ex) { ApplicationLog.WriteLog("BiddingBFL", ex, ex.Message); } }
private void LoadData() { string SupplierCode = Request.QueryString["SupplierCode"] + ""; try { EntityData entity = ProjectDAO.GetStandard_SupplierByCode(SupplierCode); if (entity.HasRecord()) { this.txtArtificialPerson.Text = entity.GetString("ArtificialPerson"); this.txtAbbreviation.Text = entity.GetString("Abbreviation"); this.txtCheckOpinion.Text = entity.GetString("CheckOpinion"); this.txtContractPerson.Text = entity.GetString("ContractPerson"); this.txtEmail.Text = entity.GetString("Email"); this.txtIndustrySort.Text = entity.GetString("IndustrySort"); this.txtIndustryType.Text = entity.GetString("IndustryType"); this.txtLicenseID.Text = entity.GetString("LicenseID"); this.txtOfficePhone.Text = entity.GetString("OfficePhone"); this.txtPostCode.Text = entity.GetString("PostCode"); this.txtProduct.Text = entity.GetString("Product"); this.txtQuality.Text = entity.GetString("Quality"); this.txtRegisteredAddress.Text = entity.GetString("RegisteredAddress"); this.txtRegisteredCapital.Text = entity.GetString("RegisteredCapital"); this.txtSJHG.Text = entity.GetString("SJHG"); string typeCode = entity.GetString("SupplierTypeCode"); this.inputSystemGroup.Value = typeCode; this.txtSupplierName.Text = entity.GetString("SupplierName"); this.txtTaxID.Text = entity.GetString("TaxID"); this.txtTaxNo.Text = entity.GetString("TaxNo"); // this.txtU8Code.Text = entity.GetString("U8Code"); this.txtWebAddress.Text = entity.GetString("WebAddress"); this.txtWorkAddress.Text = entity.GetString("WorkAddress"); this.txtWorkTimeLimit.Text = entity.GetString("WorkTimeLimit"); this.txtAreaCode.Text = entity.GetString("AreaCode"); this.txtMobile.Text = entity.GetString("Mobile"); this.txtFax.Text = entity.GetString("Fax"); this.txtAchievement.Text = entity.GetString("Achievement"); this.txtCreditLevel.Text = entity.GetString("CreditLevel"); this.txtWorkScope.Text = entity.GetString("WorkScope"); this.txtStructure.Text = entity.GetString("Structure"); this.txtRemark.Text = entity.GetString("Remark"); SupplierRule.LoadDictionarySelect(this.selSaleType, "销售形式", entity.GetString("saleType")); SupplierRule.LoadDictionarySelect(this.selCharacterType, "品质类别", entity.GetString("characterType")); this.selCCC.Value = entity.GetString("IsCCC"); this.selISO.Value = entity.GetString("IsISO"); // Added by yiwl at 2007-03-08 this.tbxOpenBank.Text = entity.GetString("OpenBank"); this.tbxAccount.Text = entity.GetString("Account"); this.tbxReciver.Text = entity.GetString("Reciver"); switch (this.up_sPMName.ToLower()) { case "tangchenpm": this.selQualityGrade.Visible = false; this.tdQualityGrade.InnerHtml = entity.GetString("QualityGrade") + " "; break; default: SupplierRule.LoadDictionarySelect(this.selQualityGrade, "资质等级", entity.GetString("QualityGrade")); break; } } else { SupplierRule.LoadDictionarySelect(this.selSaleType, "销售形式", ""); SupplierRule.LoadDictionarySelect(this.selCharacterType, "品质类别", ""); } entity.Dispose(); } catch (Exception ex) { ApplicationLog.WriteLog(this.ToString(), ex, "载入页面出错"); Response.Write(Rms.Web.JavaScript.Alert(true, "载入页面出错:" + ex.Message)); } }