public string GetBigAmountMailBody(OrderMasterQuery query,out bool isShow)
{
isShow = false;
StringBuilder strbody = new StringBuilder();
strbody.AppendLine("大金額訂單檢查");
_orderMaster = new OrderMasterMgr(mySqlConnectionString);
DataTable _dt = _orderMaster.GetBigAmount(query);
if (_dt.Rows.Count > 0)
{
DataTable _newDt = new DataTable();
_newDt.Columns.Add("訂單編號", typeof(String));
_newDt.Columns.Add("付款時間", typeof(String));
_newDt.Columns.Add("付款總金額", typeof(String));
for (int i = 0; i < _dt.Rows.Count; i++)
{
DataRow dr = _newDt.NewRow();
dr[0] = _dt.Rows[i][0];
dr[1] = CommonFunction.GetNetTime(Convert.ToInt64(_dt.Rows[i][1])).ToString("yyyy/MM/dd HH:mm:ss");
dr[2] = GetString(_dt.Rows[i][2].ToString());
_newDt.Rows.Add(dr);
}
strbody.AppendFormat(GetHtmlByDataTable(_newDt));
isShow = true;
}
return strbody.ToString();
}
