public List<DeliverChangeLogQuery> GetDeliverChangeLogList(DeliverChangeLogQuery Query, out int totalCount)
{
try
{
return _IDeliverChangeLogDao.GetDeliverChangeLogList(Query, out totalCount);
}
catch (Exception ex)
{
throw new Exception("DeliverChangeLogMgr-->GetDeliverChangeLogList-->" + ex.Message, ex);
}
}
/// <summary>
/// 期望到货日调整记录
/// </summary>
/// <returns></returns>
// by zhaozhi0623j add at 20151112
public HttpResponseBase GetDeliveryChangeLogList()
{
string json = string.Empty;
DeliverChangeLogQuery dclQuery = new DeliverChangeLogQuery();
_DeliverChangeLogMgr = new DeliverChangeLogMgr(mySqlConnectionString);
List<DeliverChangeLogQuery> dclList = new List<DeliverChangeLogQuery>();
try
{
dclQuery.Start = Convert.ToInt32(Request.Params["start"] ?? "0");//用於分頁的變量
dclQuery.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25");//用於分頁的變量
#region 查詢條件
if (!string.IsNullOrEmpty(Request.Params["deliver_id"]))//出貨單單號
{
dclQuery.deliver_id = Convert.ToInt32(Request.Params["deliver_id"]);
}
if (Request.Params["dcl_create_type"] != "-1")//創建類型1:前台創建 2:後台創建
{
dclQuery.dcl_create_type = Convert.ToInt32(Request.Params["dcl_create_type"]);
}
if (!string.IsNullOrEmpty(Request.Params["userName_ro_email"]))//出貨單記錄調整人員
{
if (Request.Params["query_type"] == "1")
{
dclQuery.dcl_user_name = Request.Params["userName_ro_email"];
}
if (Request.Params["query_type"] == "2")
{
dclQuery.dcl_user_email = Request.Params["userName_ro_email"];
}
}
if (!string.IsNullOrEmpty(Request.Params["time_start"]))//dcl_create_datetime
{
dclQuery.time_start = Convert.ToDateTime(Convert.ToDateTime(Request.Params["time_start"]).ToString("yyyy-MM-dd HH:mm:ss"));
}
if (!string.IsNullOrEmpty(Request.Params["time_end"]))
{
dclQuery.time_end = Convert.ToDateTime(Convert.ToDateTime(Request.Params["time_end"]).ToString("yyyy-MM-dd HH:mm:ss"));
}
#endregion
int totalCount = 0;
dclList = _DeliverChangeLogMgr.GetDeliverChangeLogList(dclQuery, out totalCount);
//foreach (var item in dclList)
//{
//
//}
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter();
//这里使用自定义日期格式，如果不使用的话，默认是ISO8601格式
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
json = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(dclList, Formatting.Indented, timeConverter) + "}";
}
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}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
public List<DeliverChangeLogQuery> GetDeliverChangeLogList(DeliverChangeLogQuery Query, out int totalCount)
{
StringBuilder sbSql = new StringBuilder();
StringBuilder conndSql = new StringBuilder();
Query.Replace4MySQL();
try
{
sbSql.AppendFormat(@"select deliver_id,dcl_create_datetime,dcl_create_type,dcl_note,dcl_ipfrom, expect_arrive_date,expect_arrive_period,
u.user_name as dcl_create_username,mu.user_username as dcl_create_musername
from delivery_change_log dcl LEFT JOIN users u on u.user_id=dcl.dcl_create_user
LEFT JOIN manage_user mu on mu.user_id=dcl.dcl_create_muser where 1=1 ");
if (Query.deliver_id != 0)
{
conndSql.AppendFormat(" and deliver_id='{0}' ", Query.deliver_id);
}
if (Query.dcl_create_type != 0)
{
conndSql.AppendFormat(" and dcl_create_type='{0}' ", Query.dcl_create_type);
}
if (Query.dcl_user_name != string.Empty)
{
if (Query.dcl_create_type == 0)
{
conndSql.AppendFormat(" and (u.user_name like '%{0}%' or mu.user_username like '%{0}%') ", Query.dcl_user_name);
}
if (Query.dcl_create_type == 1)
{
conndSql.AppendFormat(" and u.user_name like '%{0}%' ", Query.dcl_user_name);
}
if (Query.dcl_create_type == 2)
{
conndSql.AppendFormat(" and mu.user_username like '%{0}%' ", Query.dcl_user_name);
}
}
if (Query.dcl_user_email != string.Empty)
{
if (Query.dcl_create_type == 0)
{
conndSql.AppendFormat(" and (u.user_email like '%{0}%' or mu.user_email like '%{0}%') ", Query.dcl_user_email);
}
if (Query.dcl_create_type == 1)
{
conndSql.AppendFormat(" and u.user_email like '%{0}%' ", Query.dcl_user_email);
}
if (Query.dcl_create_type == 2)
{
conndSql.AppendFormat(" and mu.user_email like '%{0}%' ", Query.dcl_user_email);
}
}
if (Query.time_start != DateTime.MinValue && Query.time_end != DateTime.MinValue)
{
conndSql.AppendFormat(" and dcl_create_datetime BETWEEN '{0}' and '{1}'", Query.time_start.ToString("yyyy-MM-dd HH:mm:ss"), Query.time_end.ToString("yyyy-MM-dd HH:mm:ss"));
}
conndSql.AppendFormat(" order by dcl_create_datetime desc ");
sbSql.AppendFormat(conndSql.ToString());
totalCount = 0;
if (Query.IsPage)
{
DataTable _dt = new DataTable();
_dt = _access.getDataTable(@"select count(deliver_id) as totalCount from delivery_change_log dcl LEFT JOIN users u on u.user_id=dcl.dcl_create_user
LEFT JOIN manage_user mu on mu.user_id=dcl.dcl_create_muser where 1=1 " + conndSql.ToString());
if (_dt.Rows.Count > 0)
{
totalCount = Convert.ToInt32(_dt.Rows[0]["totalCount"]);
}
sbSql.AppendFormat(" limit {0},{1}",Query.Start,Query.Limit);
}
return _access.getDataTableForObj<DeliverChangeLogQuery>(sbSql.ToString());
}
catch (Exception ex)
{
throw new Exception("DeliverChangeLogDao-->GetDeliverChangeLogList-->" + ex.Message + sbSql.ToString(), ex);
}
}
public DataTable GetExpectArriveDateByCreatetime(DeliverChangeLogQuery Query)
{
StringBuilder sbSql = new StringBuilder();
Query.Replace4MySQL();
try
{
sbSql.Append(@"select expect_arrive_date from delivery_change_log where 1=1");
sbSql.AppendFormat(" and deliver_id = '{0}'", Query.deliver_id);
sbSql.AppendFormat(" and dcl_create_datetime <= '{0}' ",Query.time_end.ToString("yyyy-MM-dd HH:mm:ss"));
sbSql.Append(" order by dcl_create_datetime desc");
System.Data.DataTable dt = _access.getDataTable(sbSql.ToString());
return dt;
}
catch (Exception ex)
{
throw new Exception("DeliverChangeLog-->GetExpectArriveDateByCreatetime-->" + ex.Message + sbSql.ToString(), ex);
}
}
public DataTable GetDataTable(DeliverChangeLogQuery Query)
{
StringBuilder sbSql = new StringBuilder();
Query.Replace4MySQL();
try
{
sbSql.AppendFormat(@"select m.deliver_id,m.order_id,m.vendor_id,m.vendor_name_full,m.vendor_email,m.dcl_note,
m.deliver_org_days,m.expect_arrive_date_dm,m.expect_arrive_period_dm ,m.dcl_create_datetime ,m.type,m.order_date_pay
from(
select dcl.deliver_id, dm.order_id,dm.type,v.vendor_id,v.vendor_name_full,v.vendor_email,dcl.dcl_note,om.order_date_pay,
dm.deliver_org_days,dm.expect_arrive_date as expect_arrive_date_dm,dm.expect_arrive_period as expect_arrive_period_dm ,dcl.dcl_create_datetime from delivery_change_log dcl
LEFT JOIN deliver_master dm on dm.deliver_id=dcl.deliver_id LEFT JOIN order_master om on om.order_id=dm.order_id
inner JOIN vendor v on v.vendor_id=dm.export_id
where 1=1 and dm.type=2 ");
sbSql.AppendFormat(" and dcl.dcl_create_datetime between '{0}' and '{1}'", Query.time_start.ToString("yyyy-MM-dd HH:mm:ss"), Query.time_end.ToString("yyyy-MM-dd HH:mm:ss"));
sbSql.Append(" order by deliver_id,dcl_create_datetime desc )m GROUP BY m.deliver_id");
System.Data.DataTable dt = _access.getDataTable(sbSql.ToString());
return dt;
}
catch (Exception ex)
{
throw new Exception("DeliverChangeLog-->GetDataTable-->" + ex.Message + sbSql.ToString(), ex);
}
}
public DataTable GetDeliverChangeLogDataTable(DeliverChangeLogQuery Query)
{
StringBuilder sbSql = new StringBuilder();
Query.Replace4MySQL();
try
{
//sbSql.AppendFormat("select dm.order_id,dcl.deliver_id,dcl_create_type, u.user_name as dcl_create_username,mu.user_username as dcl_create_musername ,
// dcl.dcl_create_datetime,'' as ori_expect_arrive_date,dcl.expect_arrive_date,dcl.expect_arrive_period,dcl.dcl_note,dcl.dcl_ipfrom
sbSql.Append(@"select dm.order_id,dcl.deliver_id,v.vendor_id,v.vendor_name_full,v.vendor_email,dm.type,dcl_create_type, u.user_name as dcl_create_username,mu.user_username as dcl_create_musername ,");
sbSql.Append("dcl.dcl_create_datetime,dm.expect_arrive_date as expect_arrive_date_dcl,dm.expect_arrive_period as expect_arrive_period_dcl,dcl.dcl_note,dcl.dcl_ipfrom,");
sbSql.Append("dm.deliver_org_days,dm.expect_arrive_date as expect_arrive_date_dm,dm.expect_arrive_period as expect_arrive_period_dm,'' as delivery_date ");
sbSql.Append(" from delivery_change_log dcl ");
sbSql.AppendFormat(" inner join(select MAX(dcl_id) as dcl_id from delivery_change_log ");//where dcl_create_datetime between '{0}' and '{1}', Query.time_start.ToString("yyyy-MM-dd HH:mm:ss"), Query.time_end.ToString("yyyy-MM-dd HH:mm:ss")
sbSql.Append(" group by deliver_id order by deliver_id,dcl_create_datetime desc ) dc on dc.dcl_id=dcl.dcl_id ");
sbSql.Append(" inner JOIN deliver_master dm on dm.deliver_id=dcl.deliver_id ");
sbSql.Append("inner JOIN vendor v on v.vendor_id=dm.export_id ");
sbSql.Append(" LEFT JOIN users u on u.user_id=dcl.dcl_create_user ");
sbSql.Append(" LEFT JOIN manage_user mu on mu.user_id=dcl.dcl_create_muser where 1=1 and dm.delivery_date is null order by dcl.dcl_create_datetime desc ");
//sbSql.AppendFormat(" and dcl.dcl_create_datetime between '{0}' and '{1}'", Query.time_start.ToString("yyyy-MM-dd HH:mm:ss"), Query.time_end.ToString("yyyy-MM-dd HH:mm:ss"));
//sbSql.Append(" order by deliver_id,dcl_create_datetime desc");
System.Data.DataTable dt=_access.getDataTable(sbSql.ToString());
return dt;
}
catch(Exception ex)
{
throw new Exception("DeliverChangeLog-->GetDeliverChangeLogDataTable-->" + ex.Message + sbSql.ToString(), ex);
}
}
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);
}
}
