public void AddStatusReportTest() { var accountId = "account"; SMS sms = new SMS() { Account = "account", Audit = AuditType.Auto, AuditTime = DateTime.Now.ToString(), AuditUser = "******", Channel = "default", Content = "ceshi neirong", Level = LevelType.Level0, IsSplit = true, SendTime = DateTime.Now, SerialNumber = System.Guid.NewGuid(), Signature = "【1111】", LinkID = System.Guid.NewGuid().ToString(), SPNumber = "1234", StatusReport = StatusReportType.Enabled, Extend = null, FailureCase = "", Filter = FilterType.Failure, Number = new List <string> { "123", "1235", "234" }, NumberCount = 3, WapURL = "wapurl" }; StatusReport report = new StatusReport(); report.StatusCode = 3100; report.Describe = "发送成功"; report.Gateway = "CMPP"; report.Message = sms; report.Serial = sms.SerialNumber.ToString(); report.SplitNumber = 1; report.SplitTotal = 1; report.Succeed = true; var b = StatusReportDB.AddStatusReport(accountId, report); Assert.IsTrue(b); report.Succeed = false; b = StatusReportDB.Update(report); Assert.IsTrue(b); b = StatusReportDB.CloneTable("statusReport_" + UnitTestDBAccess.Util.GenRandStr(5)); Assert.IsTrue(b); var tables = StatusReportDB.GetTables(); Assert.IsTrue(tables.Count > 0); var sr = StatusReportDB.GetStatusReport(sms.SerialNumber, DateTime.Now); Assert.IsTrue(sr.Count > 0); }
/// <summary> /// 短信状态报告明细(数据库获取) /// </summary> /// <param name="serialNumber"></param> /// <param name="sendTime"></param> /// <returns></returns> public RPCResult <QueryResult <StatusReport> > GetStatusReportBySMSID(QueryParams qp) { try { var list = StatusReportDB.GetStatusReport(qp); if (list.Total == 0) { return(new RPCResult <QueryResult <StatusReport> >(false, list, "没有短信状态报告")); } return(new RPCResult <QueryResult <StatusReport> >(true, list, "")); } catch (Exception ex) { LogHelper.LogError("StatusReport", "StatusReportService.GetSMSStatusReport", ex.ToString()); return(new RPCResult <QueryResult <StatusReport> >(false, null, "获取短信报告出现异常")); } }
/// <summary> /// 短信状态报告明细(数据库获取) /// </summary> /// <param name="serialNumber"></param> /// <param name="sendTime"></param> /// <returns></returns> public RPCResult <List <StatusReport> > GetSMSStatusReport(string smsid, DateTime sendTime) { try { if (sendTime.ToString("yyyyMMdd") == "00010101") { return(new RPCResult <List <StatusReport> >(true, null, "")); } var list = StatusReportDB.GetStatusReport(smsid, sendTime); if (list.Count == 0) { return(new RPCResult <List <StatusReport> >(false, list, "没有短信状态报告")); } return(new RPCResult <List <StatusReport> >(true, list, "")); } catch (Exception ex) { LogHelper.LogError("StatusReport", "StatusReportService.GetSMSStatusReport", ex.ToString()); return(new RPCResult <List <StatusReport> >(false, null, "获取短信报告出现异常")); } }