public ActionResult MessageHistoryQuery(MessageHistoryQueryModel model, int?PageIndex) { if (model.IsExprot) { return(this.GetMessageHistoryInfoReport(model)); } else { GetMessageHistoryQueryRequest request = new GetMessageHistoryQueryRequest() { SqlWhere = GetSqlWhere(model), PageSize = UtilConstants.PAGESIZE, PageIndex = PageIndex ?? 0 }; Response <GetMessageHistoryQueryRequest> Response = new TotalService().GetMessageHistoryInfo(request); model.MessageHistoryTable = Response.Result.MessageHistoryTable; model.PageIndex = Response.Result.PageIndex; model.PageSize = Response.Result.PageSize; model.PageCount = Response.Result.PageCount; } return(View(model)); }
public ActionResult GetMessageHistoryInfoReport(MessageHistoryQueryModel view) { string SQL = this.GetSqlWhere(view); string ReportName = "Total短信信息" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xlsx"; GetMessageHistoryQueryRequest request = new GetMessageHistoryQueryRequest() { SqlWhere = GetSqlWhere(view) }; Response <GetMessageHistoryQueryRequest> Response = new TotalService().GetMessageHistoryInfoReport(request); DataTable Exprottable = Response.Result.MessageHistoryTable; ExcelHelper excelHelper = new ExcelHelper(); string targetPath = Path.Combine(Runbow.TWS.Common.Constants.UPLOAD_FOLDER_PATH, base.UserInfo.ProjectID.ToString(), "Temp"); string fileFullPath = Path.Combine(targetPath, ReportName); excelHelper.CreateExcelByDataTable(fileFullPath, Exprottable); excelHelper.Dispose(); string mimeType = "application/msexcel"; FileStream fs = MyFile.Open(fileFullPath, FileMode.Open); return(File(fs, mimeType, Url.Encode(ReportName))); }
public string GetSqlWhere(MessageHistoryQueryModel model) { string sql = ""; if (!string.IsNullOrEmpty(model.CustomerOrderNumber)) { string[] NumberList = model.CustomerOrderNumber.Replace("\r\n", ",").Split(','); string CustomerOrderNumber = ""; for (int i = 0; i < NumberList.Length; i++) { CustomerOrderNumber += "'" + NumberList[i].ToString() + "',"; } sql += " And SendHistory.Str1 in(" + CustomerOrderNumber.Substring(0, CustomerOrderNumber.Length - 1) + ")"; } if (!string.IsNullOrEmpty(model.Phone)) { string[] PhoneList = model.Phone.Replace("\r\n", ",").Split(','); string Phone = ""; for (int i = 0; i < PhoneList.Length; i++) { Phone += "'" + PhoneList[i].ToString() + "',"; } sql += " And SendHistory.PhoneNumber in(" + Phone.Substring(0, Phone.Length - 1) + ")"; } if (!string.IsNullOrEmpty(model.BeginSendTime.ToString())) { sql += " AND SendHistory.SendTime>='" + Convert.ToDateTime(model.BeginSendTime).ToString("yyyy-MM-dd") + " 00:00:00'"; } if (!string.IsNullOrEmpty(model.EndSendTime.ToString())) { sql += " AND SendHistory.SendTime<='" + Convert.ToDateTime(model.EndSendTime).ToString("yyyy-MM-dd") + " 23:59:59'"; } return(sql); }
// // GET: /POD/Total/ public ActionResult MessageHistoryQuery() { MessageHistoryQueryModel model = new MessageHistoryQueryModel(); return(View(model)); }