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