public bool SendEMail() { string json = string.Empty; try { #region string schedule_code = "send mail";//Request.Params["schedule_code"].ToString(); MailModel mailModel = new MailModel(); mailModel.MysqlConnectionString = mySqlConnectionString; string GroupCode = string.Empty; string MailTitle = string.Empty; string MailBody = string.Empty; bool IsSeparate = false; bool IsDisplyName = true; ScheduleServiceMgr _secheduleServiceMgr; List<MailRequest> MR = new List<MailRequest>(); MailRequest model = new MailRequest(); List<ScheduleConfigQuery> store_config = new List<ScheduleConfigQuery>(); ScheduleConfigQuery query_config = new ScheduleConfigQuery(); query_config.schedule_code = schedule_code; _secheduleServiceMgr = new ScheduleServiceMgr(mySqlConnectionString); store_config = _secheduleServiceMgr.GetScheduleConfig(query_config); foreach (ScheduleConfigQuery item in store_config) { if (item.parameterCode.Equals("MailFromAddress")) { mailModel.MailFromAddress = item.value; } else if (item.parameterCode.Equals("MailHost")) { mailModel.MailHost = item.value; } else if (item.parameterCode.Equals("MailPort")) { mailModel.MailPort = item.value; } else if (item.parameterCode.Equals("MailFromUser")) { mailModel.MailFromUser = item.value; } else if (item.parameterCode.Equals("EmailPassWord")) { mailModel.MailFormPwd = item.value; } else if (item.parameterCode.Equals("GroupCode")) { GroupCode = item.value; } else if (item.parameterCode.Equals("MailTitle")) { MailTitle = item.value; } else if (item.parameterCode.Equals("MailTitle")) { MailTitle = item.value; } else if (item.parameterCode.Equals("MailBody")) { MailBody = item.value; } else if (item.parameterCode.Equals("IsSeparate")) { if (item.value.ToString().Trim().ToLower() == "false") { IsSeparate = false; } else if (item.value.ToString().Trim().ToLower() == "true") { IsSeparate = true; } } else if (item.parameterCode.Equals("IsDisplyName")) { if (item.value.ToString().Trim().ToLower() == "false") { IsDisplyName = false; } else if (item.value.ToString().Trim().ToLower() == "true") { IsDisplyName = true; } } else if (!string.IsNullOrEmpty(Request.Params["IsDisplyName"])) { if (Request.Params["IsDisplyName"].ToString().Trim().ToLower() == "false") { IsSeparate = false; } else if (Request.Params["IsDisplyName"].ToString().Trim().ToLower() == "true") { IsSeparate = true; } } } MailHelper mail = new MailHelper(mailModel); _edmcontentMgr = new EdmContentNewMgr(mySqlConnectionString); _edmcontentMgr.SendEMail(mail); #endregion } catch (Exception ex) { Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); json = "{success:false}"; } return true; }
public bool Start(string schedule_code) { BLL.gigade.Common.MailModel mailModel = new Common.MailModel (); mailModel.MysqlConnectionString = mySqlConnectionString; string GroupCode = string.Empty; string MailTitle = string.Empty; string MailBody = string.Empty; string hourNum = string.Empty; //bool IsSeparate = false; //bool IsDisplyName = true; string isSendMailToGroup = string.Empty; try { //獲取該排程參數 List<ScheduleConfigQuery> store_config = new List<ScheduleConfigQuery>(); ScheduleConfigQuery query_config = new ScheduleConfigQuery(); query_config.schedule_code = schedule_code; ScheduleServiceMgr _secheduleServiceMgr = new ScheduleServiceMgr(mySqlConnectionString); store_config = _secheduleServiceMgr.GetScheduleConfig(query_config); #region mailhelp賦值 foreach (ScheduleConfigQuery item in store_config) { if (item.parameterCode.Equals("MailFromAddress")) { mailModel.MailFromAddress = item.value; } else if (item.parameterCode.Equals("MailHost")) { mailModel.MailHost = item.value; } else if (item.parameterCode.Equals("MailPort")) { mailModel.MailPort = item.value; } else if (item.parameterCode.Equals("MailFromUser")) { mailModel.MailFromUser = item.value; } else if (item.parameterCode.Equals("EmailPassWord")) { mailModel.MailFormPwd = item.value; } else if (item.parameterCode.Equals("GroupCode")) { GroupCode = item.value; } else if (item.parameterCode.Equals("MailTitle")) { MailTitle = item.value; } else if (item.parameterCode.Equals("HourNum")) { if (item.value.Trim() == "0") { hourNum = "1"; } else { hourNum = item.value; } } else if (item.parameterCode.Equals("isSendMailToGroup")) { isSendMailToGroup = item.value; } } if (hourNum.Trim() == string.Empty) { hourNum = "1"; } #endregion //獲取期望到貨日調整記錄(邮件内容) #region 獲取期望到貨日調整記錄表格 DeliverChangeLogQuery aclQuery = new DeliverChangeLogQuery(); aclQuery.time_start = DateTime.Now.AddHours(-Convert.ToDouble(hourNum)); aclQuery.time_end = DateTime.Now; System.Data.DataTable dclTable = _IDeliverChangeLogDao.GetDeliverChangeLogDataTable(aclQuery); System.Data.DataTable dmTable = _IDeliverChangeLogDao.GetDataTable(aclQuery); DataTable _dt = new DataTable(); DataRow dr; _dt.Columns.Add("訂單編號", typeof(string)); _dt.Columns.Add("出貨單號", typeof(string)); _dt.Columns.Add("供應商名稱", typeof(string)); _dt.Columns.Add("出貨方式", typeof(string)); _dt.Columns.Add("異動人", typeof(string)); _dt.Columns.Add("異動類型", typeof(string));// _dt.Columns.Add("異動時間", typeof(string)); //_dt.Columns.Add("原期望到貨日", typeof(string)); _dt.Columns.Add("期望到貨日", typeof(string)); _dt.Columns.Add("期望到貨時段", typeof(string)); _dt.Columns.Add("備註", typeof(string)); _dt.Columns.Add("來源IP", typeof(string)); _dt.Columns.Add("異動時段", typeof(string)); _dt.Columns.Add("時間", typeof(string));//difftime //自行出貨的供應商 DataTable deliverDt = new DataTable(); DataRow deliverDr; deliverDt.Columns.Add("訂單編號", typeof(string)); deliverDt.Columns.Add("出貨單號", typeof(string)); deliverDt.Columns.Add("付款完成時間", typeof(string)); deliverDt.Columns.Add("供應商編號", typeof(string)); deliverDt.Columns.Add("供應商郵箱", typeof(string)); deliverDt.Columns.Add("供應商名稱", typeof(string)); deliverDt.Columns.Add("期望到貨日", typeof(string)); deliverDt.Columns.Add("期望到貨時段", typeof(string)); deliverDt.Columns.Add("預計到貨日", typeof(string)); deliverDt.Columns.Add("備註", typeof(string)); if (dclTable.Rows.Count > 0) { #region 循環賦值 for (int i = 0; i < dmTable.Rows.Count; i++) { #region 自行出貨的供應商的table賦值 deliverDr = deliverDt.NewRow(); deliverDr["訂單編號"] = dmTable.Rows[i]["order_id"].ToString(); deliverDr["出貨單號"] = dmTable.Rows[i]["deliver_id"].ToString(); if (Convert.ToInt32(dmTable.Rows[i]["order_date_pay"]) == 0) { deliverDr["付款完成時間"] = ""; } else { deliverDr["付款完成時間"] = CommonFunction.GetNetTime(Convert.ToInt32(dmTable.Rows[i]["order_date_pay"])).ToString("yyyy-MM-dd HH:mm:ss"); } deliverDr["供應商編號"] = dmTable.Rows[i]["vendor_id"].ToString(); deliverDr["供應商郵箱"] = dmTable.Rows[i]["vendor_email"].ToString(); deliverDr["供應商名稱"] = dmTable.Rows[i]["vendor_name_full"].ToString(); if (Convert.ToDateTime(dmTable.Rows[i]["expect_arrive_date_dm"]).ToString("yyyy-MM-dd") == "0001-01-01") { deliverDr["期望到貨日"] = ""; } else { deliverDr["期望到貨日"] = Convert.ToDateTime(dmTable.Rows[i]["expect_arrive_date_dm"]).ToString("yyyy-MM-dd"); } //期望到貨時段 StringBuilder expectArrivePeriodSb = new StringBuilder(); if (dmTable.Rows[i]["expect_arrive_period_dm"].ToString() == "1") { expectArrivePeriodSb.Append("12:00以前"); } if (dmTable.Rows[i]["expect_arrive_period_dm"].ToString() == "2") { expectArrivePeriodSb.Append("12:00-17:00"); } if (dmTable.Rows[i]["expect_arrive_period_dm"].ToString() == "3") { expectArrivePeriodSb.Append("17:00-20:00"); } if (dmTable.Rows[i]["expect_arrive_period_dm"].ToString() == "0") { expectArrivePeriodSb.Append("不限制"); } deliverDr["期望到貨時段"] = expectArrivePeriodSb.ToString(); if (Convert.ToInt32(dmTable.Rows[i]["deliver_org_days"]) == 0) { deliverDr["預計到貨日"] = ""; } else { deliverDr["預計到貨日"] = Convert.ToDateTime(CommonFunction.GetNetTime(Convert.ToInt32(dmTable.Rows[i]["deliver_org_days"]))).ToString("yyyy-MM-dd"); } deliverDr["備註"] = dmTable.Rows[i]["dcl_note"].ToString(); deliverDt.Rows.Add(deliverDr); #endregion } #region MyRegion for (int i = 0; i < dclTable.Rows.Count; i++) { dr = _dt.NewRow(); StringBuilder sb = new StringBuilder(); dr["訂單編號"] = dclTable.Rows[i]["order_id"].ToString(); dr["出貨單號"] = dclTable.Rows[i]["deliver_id"].ToString(); dr["供應商名稱"] = dclTable.Rows[i]["vendor_name_full"].ToString(); if (dclTable.Rows[i]["type"].ToString() == "1") { dr["出貨方式"] = "統倉出貨"; } else if (dclTable.Rows[i]["type"].ToString() == "2") { dr["出貨方式"] = "供應商自行出貨"; } else //if (dclTable.Rows[i]["type"].ToString() == "101") { dr["出貨方式"] = "其他"; } if (dclTable.Rows[i]["dcl_create_type"].ToString() == "1") { dr["異動人"] = dclTable.Rows[i]["dcl_create_username"].ToString(); dr["異動類型"] = "前台"; } else if (dclTable.Rows[i]["dcl_create_type"].ToString() == "2") { dr["異動人"] = dclTable.Rows[i]["dcl_create_musername"].ToString(); dr["異動類型"] = "後台"; } dr["異動時間"] = Convert.ToDateTime(dclTable.Rows[i]["dcl_create_datetime"]).ToString("yyyy-MM-dd HH:mm:ss"); #region 獲取該出貨單的上一個小時之前的期望到貨日 ////aclQuery.time_start = dcl_create_datetime_start.AddHours(-1); //aclQuery.time_end = dcl_create_datetime_end.AddHours(-1); //aclQuery.deliver_id = Convert.ToInt32(dclTable.Rows[i]["deliver_id"]); //System.Data.DataTable Table = _IDeliverChangeLogDao.GetExpectArriveDateByCreatetime(aclQuery); //if (Table.Rows.Count > 0) //{ // if (Convert.ToDateTime(Table.Rows[0]["expect_arrive_date"]).ToString("yyyy-MM-dd") == "0001-01-01") // { // dr["原期望到貨日"] = ""; // } // else // { // dr["原期望到貨日"] = Convert.ToDateTime(Table.Rows[0]["expect_arrive_date"]).ToString("yyyy-MM-dd"); // } //} //else //{ // dr["原期望到貨日"] = ""; //} #endregion if (Convert.ToDateTime(dclTable.Rows[i]["expect_arrive_date_dcl"]).ToString("yyyy-MM-dd") == "0001-01-01") { dr["期望到貨日"] = ""; } else { dr["期望到貨日"] = Convert.ToDateTime(dclTable.Rows[i]["expect_arrive_date_dcl"]).ToString("yyyy-MM-dd"); } if (dclTable.Rows[i]["expect_arrive_period_dcl"].ToString() == "1") { sb.Append("12:00以前"); } if (dclTable.Rows[i]["expect_arrive_period_dcl"].ToString() == "2") { sb.Append("12:00-17:00"); } if (dclTable.Rows[i]["expect_arrive_period_dcl"].ToString() == "3") { sb.Append("17:00-20:00"); } if (dclTable.Rows[i]["expect_arrive_period_dcl"].ToString() == "0") { sb.Append("不限制"); } dr["期望到貨時段"] = sb.ToString(); dr["備註"] = dclTable.Rows[i]["dcl_note"].ToString(); dr["來源IP"] = dclTable.Rows[i]["dcl_ipfrom"].ToString(); TimeSpan ti = aclQuery.time_end-Convert.ToDateTime(dclTable.Rows[i]["dcl_create_datetime"]); dr["異動時段"] = hourNum + "小時以外"; dr["時間"] = "0"; if (ti.TotalHours < int.Parse(hourNum)) { dr["異動時段"] = Convert.ToInt32(ti.TotalHours) + "小時"; dr["時間"] = "1"; } _dt.Rows.Add(dr); sb.Clear(); } #endregion #endregion #region 出貨方式為“供應商自行出貨”的出貨單整理后,發郵件給對應的供應商 Dictionary<string, string> vendorDictionary = new Dictionary<string, string>(); for (int i = 0; i < deliverDt.Rows.Count; i++) { if (!vendorDictionary.ContainsKey(deliverDt.Rows[i]["出貨單號"].ToString())) { vendorDictionary.Add(deliverDt.Rows[i]["出貨單號"].ToString(), deliverDt.Rows[i]["供應商編號"].ToString()); } } List<string> SendEmailVendorIdList = new List<string>(); foreach (KeyValuePair<string, string> kvp in vendorDictionary) { DataTable deliverDt_1 = deliverDt.Clone(); string MailToAddress_1 = string.Empty; string vendor_name_full = string.Empty; if (!SendEmailVendorIdList.Contains(kvp.Value)) { for (int i = 0; i < deliverDt.Rows.Count; i++) { DataRow deliverDr_1 = deliverDt_1.NewRow(); if (kvp.Value == deliverDt.Rows[i]["供應商編號"].ToString()) { MailToAddress_1 = deliverDt.Rows[i]["供應商郵箱"].ToString(); vendor_name_full = deliverDt.Rows[i]["供應商名稱"].ToString(); deliverDr_1["訂單編號"] = deliverDt.Rows[i]["訂單編號"].ToString(); deliverDr_1["出貨單號"] = deliverDt.Rows[i]["出貨單號"].ToString(); deliverDr_1["付款完成時間"] = deliverDt.Rows[i]["付款完成時間"].ToString(); //deliverDr_1["供應商編號"] = deliverDt.Rows[i]["供應商編號"].ToString(); //deliverDr_1["供應商郵箱"] = deliverDt.Rows[i]["供應商郵箱"].ToString(); //deliverDr_1["供應商名稱"] = deliverDt.Rows[i]["供應商名稱"].ToString(); deliverDr_1["期望到貨日"] = deliverDt.Rows[i]["期望到貨日"].ToString(); deliverDr_1["期望到貨時段"] = deliverDt.Rows[i]["期望到貨時段"].ToString(); deliverDr_1["預計到貨日"] = deliverDt.Rows[i]["預計到貨日"].ToString(); deliverDr_1["備註"] = deliverDt.Rows[i]["備註"].ToString(); deliverDt_1.Rows.Add(deliverDr_1); } } SendEmailVendorIdList.Add(kvp.Value); BLL.gigade.Common.MailModel mailModel_1 = new Common.MailModel(); mailModel_1.MysqlConnectionString = mySqlConnectionString; mailModel_1.MailFromAddress = mailModel.MailFromAddress; mailModel_1.MailHost = mailModel.MailHost; mailModel_1.MailPort = mailModel.MailPort; mailModel_1.MailFromUser = mailModel.MailFromUser; mailModel_1.MailFormPwd = mailModel.MailFormPwd; //string MailBody_1 = "<br/><font size=\"4\">" + "<font color=\"#00BB00\" >" + vendor_name_full + "</font>" + " 您好,在前 " + "<font color=\"#FF0000\" >" + Convert.ToDouble(hourNum) // + "</font>" + " 個小時之內,貴公司自行出貨的商品出貨單期望到貨日調整記錄如下:</font><br/><p/>" + GetHtmlByDataTable(deliverDt_1); deliverDt_1.Columns.Remove("供應商編號"); deliverDt_1.Columns.Remove("供應商郵箱"); deliverDt_1.Columns.Remove("供應商名稱"); string MailBody_1 = "<p>吉甲地市集【期望到貨日改變】通知信</p><p><font color=\"#00BB00\" >" + vendor_name_full + "</font> 您好:</p>" + "<p>以下訂單已改變出貨單期望到貨日,訂單資訊如下。</p>" + //"<p>============================================================</p>"+ GetHtmlByDataTable(deliverDt_1) + //"<p>============================================================</p>"+ "<p>訂單的相關資訊,請至<a href='http://vendor.gigade100.com' style='color:#3399ff;text-decoration: none;'>【後台管理】</a>中查詢。</p>"+ "<p>※本信由系統寄出,請勿直接回覆!</p>"+ "有任何問題與建議,歡迎聯絡我們<a href='http://www.gigade100.com/contact_service.php' target='_blank'> <img src='http://www.gigade100.com/images/send_mail.jpg'></a>" + "<p>吉甲地市集<a href='http://www.gigade100.com/'>http://www.gigade100.com/</a></p>"; string MailTitle_1 = MailTitle; //MailToAddress_1 = "*****@*****.**"; BLL.gigade.Common.MailHelper mailHelper = new MailHelper(mailModel_1); //public Boolean SendMailAction(string MailToAddress, string MailTitle, string MailBody) try { mailHelper.SendMailAction(MailToAddress_1, MailTitle_1, MailBody_1 + " ");//給單個供應商發送郵件 } catch (Exception) { continue; } } } #endregion } #endregion if (_dt.Rows.Count == 0) { //MailBody = "<br/><p><font size=\"4\"> 出貨單期望日在前 <font color=\"#FF0000\" >" + Convert.ToDouble(hourNum) + "</font> 個小時之內沒有調整記錄!</font><p/>"; } else { if (isSendMailToGroup.Trim() == "true") { MailBody = "<br/><font size=\"4\">出貨單期望到貨日在前 " + "<font color=\"#FF0000\" >" + Convert.ToDouble(hourNum) + "</font>" + " 個小時之內的調整記錄如下:</font><br/><p/>" + GetHtmlByDataTable(_dt, "時間","0"); BLL.gigade.Common.MailHelper mail = new Common.MailHelper(mailModel); mail.SendToGroup(GroupCode, MailTitle, MailBody + " ", false, true); } } return true; } catch (Exception ex) { throw new Exception("DeliverChangeLogMgr-->Start-->" + ex.Message, ex); } }