public string GetBigOrderNumbersMailBody(OrderMasterQuery query,out bool isShow)
{
isShow = false;
StringBuilder strbody = new StringBuilder();
strbody.AppendLine("一小時之內數量過多訂單檢查:");
DataTable _newErrorDt = new DataTable();
_newErrorDt.Columns.Add("訂購人", typeof(String));
_newErrorDt.Columns.Add("郵箱", typeof(String));
_newErrorDt.Columns.Add("IP地址", typeof(String));
_newErrorDt.Columns.Add("訂單編號", typeof(String));
_newErrorDt.Columns.Add("付款時間", typeof(String));
_orderMaster = new OrderMasterMgr(mySqlConnectionString);
DataTable _dtResult = _orderMaster.GetBigOrderNumbers(query);
if (_dtResult.Rows.Count > 0)
{
for (int j = 0; j < _dtResult.Rows.Count; j++)
{
DataRow drtwo = _newErrorDt.NewRow();
drtwo[0] = _dtResult.Rows[j][0];
drtwo[1] = _dtResult.Rows[j][1];
drtwo[2] = _dtResult.Rows[j][2];
drtwo[3] = _dtResult.Rows[j][3];
drtwo[4] = DateTime.Parse(_dtResult.Rows[j][4].ToString()).ToString("yyyy/MM/dd HH:mm:ss");
_newErrorDt.Rows.Add(drtwo);
}
isShow = true;
}
strbody.AppendFormat(GetHtmlByDataTable(_newErrorDt));
return strbody.ToString();
}
