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(); }