| | |
| | | this.Response.Write("<script type='text/javascript'>alert('导出数据不能大于100万条!');location.href='GwSm.aspx';</script>"); |
| | | this.Response.End(); |
| | | } |
| | | DataTable dataTable = gwSmDao.LoadSpDataTable(apMid, opName, clientId, spid, mobile, sDate, beginTime, endTime, content, @int, opstat); |
| | | |
| | | DataTable dataTable = new DataTable(); |
| | | if (this.AppContext.GetString("SendType") == "ReSend") |
| | | { |
| | | dataTable= gwSmDao.LoadSpDataTable(apMid, opName, clientId, spid, mobile, sDate, beginTime, endTime, content, @int, opstat, this.AppContext.GetString("SendType")); |
| | | } |
| | | else |
| | | { |
| | | dataTable = gwSmDao.LoadSpDataTable(apMid, opName, clientId, spid, mobile, sDate, beginTime, endTime, content, @int, opstat); |
| | | } |
| | | |
| | | //if(dataTable.Rows.Count>1000000) |
| | | //{ |
| | | // this.Response.Write("<script type='text/javascript'>alert('导出数据不能大于100万条!');location.href='GwSm.aspx';</script>"); |
| | | // this.Response.End(); |
| | | //} |
| | | |
| | | WebTool webTool = new WebTool(); |
| | | Dictionary<string, string> dictionary = new Dictionary<string, string>(); |
| | | dictionary["AP消息ID"] = "AP_MID"; |
| | | dictionary["CLTID"] = "CLIENT_ID"; |
| | | dictionary["代理商"] = "CLIENT_ID"; |
| | | dictionary["账号"] = "SP_ID"; |
| | | dictionary["APID"] = "AP_ID"; |
| | | dictionary["OPID"] = "OP_ID"; |
| | | dictionary["接入点ID"] = "AP_ID"; |
| | | dictionary["通道名"] = "OP_NAME"; |
| | | dictionary["码号"] = "ACCESS_CODE"; |
| | | dictionary["接收号码"] = "MOBILE"; |
| | | dictionary["PKN "] = "PK_NUMBER"; |
| | |
| | | dictionary["状态报告回执时间"] = "OP_DELIVER_TIME"; |
| | | dictionary["内容"] = "MSG_CONTENT"; |
| | | dictionary["状态"] = "STAT"; |
| | | dictionary["短信类型"] = "ResendStatus";//0==正常 1==补发 |
| | | dictionary["补发状态"] = "ResendFlag"; |
| | | dictionary["耗时"] = "OUT_TIME"; |
| | | webTool.Export(dataTable, dictionary, "日志_" + sDate, this.Context.Response); |
| | | } |
| | | } |