public string OtherTWPay(OrderMasterQuery query,out bool isShow) { isShow = false; StringBuilder strbody = new StringBuilder(); strbody.AppendLine("異地付款訂單檢查"); _orderMaster = new OrderMasterMgr(mySqlConnectionString); DataTable _dt = _orderMaster.GetOtherTWPay(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)); _newdt.Columns.Add("IP", typeof(String)); for (int i = 0; i < _dt.Rows.Count; i++) { DataRow dr = _newdt.NewRow(); dr[0] = _dt.Rows[i][0]; dr[1] = _dt.Rows[i][1].ToString(); dr[2] = CommonFunction.GetNetTime(Convert.ToInt64(_dt.Rows[i][2])).ToString("yyyy/MM/dd HH:mm:ss"); dr[3] = _dt.Rows[i][3].ToString(); _newdt.Rows.Add(dr); } strbody.AppendFormat(GetHtmlByDataTable(_newdt)); isShow = true; } return strbody.ToString(); }