public void AddSMSHistoryTest()
{
SMS sms = GetSMS();
var b = ReportStatisticsDB.AddSMSHistory(sms);
Assert.IsTrue(b);
}
/// <summary>
/// 获取全部账号统计报告ISMP 使用
/// </summary>
/// <param name="account"></param>
/// <param name="beginTime"></param>
/// <param name="endTime"></param>
/// <returns></returns>
public RPCResult <List <ReportStatistics> > GetStatisticsReportAll(DateTime beginTime, DateTime endTime)
{
DateTime cacheBeginTime = DateTime.MaxValue;
if (DateTime.Compare(beginTime, endTime) > 0)
{
DateTime dt = beginTime;
beginTime = endTime;
endTime = dt;
}
if (DateTime.Compare(endTime, DateTime.Now) > 0)
{
endTime = DateTime.Now;
}
List <string> list = ReportStatisticsDB.GetTables();
var maxdate = list.Max(s => DateTime.Parse(s.Remove(0, 17).Insert(4, "-").Insert(7, "-")));
if (DateTime.Compare(endTime, maxdate) > 0)
{
endTime = maxdate;
}
var mindate = list.Min(s => DateTime.Parse(s.Remove(0, 17).Insert(4, "-").Insert(7, "-")));
if (DateTime.Compare(beginTime, mindate) < 0)
{
beginTime = mindate;
}
List <ReportStatistics> dbRS = ReportStatisticsDB.GetStatisticsByDate(beginTime, endTime);
return(new RPCResult <List <ReportStatistics> >(true, dbRS, ""));
}
void CreateTable()
{
try
{
if (operatorFlag)
{
string tableName = "SMSStatusReport_" + DateTime.Now.AddDays(1).ToString("yyyyMMdd");
if (!statusReportTables.Contains(tableName.ToLower()))
{
StatusReportDB.CloneTable(tableName);
statusReportTables.Add(tableName.ToLower());
}
tableName = "ReportStatistics_" + DateTime.Now.AddDays(1).ToString("yyyyMMdd");
if (!statisticsReportTables.Contains(tableName.ToLower()))
{
ReportStatisticsDB.CloneTable(tableName);
statisticsReportTables.Add(tableName.ToLower());
}
}
}
catch
{
operatorFlag = true;
}
}
public void GetReportStatisticsTest()
{
SMS sms = GetSMS();
var b = ReportStatisticsDB.AddSMSHistory(sms);
Assert.IsTrue(b);
var r = ReportStatisticsDB.GetReportStatistics(sms.SerialNumber, sms.SendTime);
Assert.IsNotNull(r);
}
/// <summary>
/// 查看短信统计报告
/// </summary>
/// <param name="serialNumber"></param>
/// <returns></returns>
public RPCResult <ReportStatistics> GetReportStatistics(string smsid, DateTime sendTime)
{
try
{
var rs = ReportStatisticsDB.GetReportStatistics(smsid, sendTime);
return(new RPCResult <ReportStatistics>(true, rs, ""));
}
catch (Exception ex)
{
LogHelper.LogError("StatusReport", "StatusReportService.GetReportStatistics", ex.ToString());
return(new RPCResult <ReportStatistics>(false, null, "获取统计报告失败"));
}
}
private static bool frSMSOriginal_ReceiveMessage(RabbitMQHelper mq, string message)
{
try
{
var rs = JsonSerialize.Instance.Deserialize <ReportStatistics>(message);
ReportStatisticsDB.AddSMSHistory(rs);
}
catch (Exception ex)
{
LogClient.LogHelper.LogError("StatusReport", "StatusReportHost.frSMSOriginal_ReceiveMessage", ex.ToString());
}
return(true);
}
public void UpdateTest()
{
SMS sms = GetSMS();
var b = ReportStatisticsDB.AddSMSHistory(sms);
Assert.IsTrue(b);
var r = ReportStatisticsDB.GetReportStatistics(sms.SerialNumber, sms.SendTime);
Assert.IsNotNull(r);
ReportStatistics rs = new ReportStatistics()
{
SerialNumber = sms.SerialNumber,
SendCount = 100,
SendTime = sms.SendTime
};
b = ReportStatisticsDB.Update("account", rs);
Assert.IsTrue(b);
}
/// <summary>
/// 统计报告表
/// </summary>
void LoadStatisticsReportTables()
{
List <string> tables = ReportStatisticsDB.GetTables();
if (tables.Count == 0)
{
string name = "ReportStatistics_" + DateTime.Now.ToString("yyyyMMdd");
ReportStatisticsDB.CloneTable(name);
statisticsReportTables.Add(name.ToLower());
return;
}
int min = 99991231;
foreach (var table in tables)
{
statisticsReportTables.Add(table.ToLower());
if (min > int.Parse(table.Remove(0, 17)))
{
min = int.Parse(table.Remove(0, 17));
}
}
string date = min.ToString();
date = date.Insert(4, "-");
date = date.Insert(7, "-");
DateTime beginTime = DateTime.Parse(date).AddDays(1);
while (DateTime.Compare(DateTime.Now, beginTime) > 0)
{
string name = "ReportStatistics_" + beginTime.ToString("yyyyMMdd");
if (!statisticsReportTables.Contains(name.ToLower()))
{
ReportStatisticsDB.CloneTable(name);
statisticsReportTables.Add(name.ToLower());
}
beginTime = beginTime.AddDays(1);
}
}
internal void Send(SMSDTO sms)
{
ReportStatisticsDB.AddSMSHistory(new ReportStatistics(sms.Message));
fqSMS.PublishMessage(JsonConvert.SerializeObject(sms), sms.Message.SMSLevel);
}
/// <summary>
/// 获取状态报告
/// </summary>
/// <param name="account"></param>
/// <param name="beginTime"></param>
/// <param name="endTime"></param>
/// <returns></returns>
public RPCResult <List <ReportStatistics> > GetStatisticsReportByAccount(string accountID, DateTime beginTime, DateTime endTime)
{
var r = ReportStatisticsDB.GetStatisticsByAccount(accountID, beginTime, endTime);
return(new RPCResult <List <ReportStatistics> >(true, r, ""));
}
public void GetSMSStatisticsByAccountTest()
{
var r = ReportStatisticsDB.GetSMSStatisticsByAccount("account", new DateTime(2016, 4, 28), DateTime.Now);
Assert.IsTrue(r.Length > 0);
}
public void GetStatisticsByDateTest()
{
var r = ReportStatisticsDB.GetStatisticsByDate(new DateTime(2016, 4, 28), DateTime.Now);
Assert.IsTrue(r.Count > 0);
}
public void GetTablesTest()
{
var l = ReportStatisticsDB.GetTables();
Assert.IsTrue(l.Count > 0);
}
public static void Send(SMSDTO sms)
{
ReportStatisticsDB.AddSMSHistory(new ReportStatistics(sms.Message));
}
