private async void UpdateTable1()
{
btnSearch.Enabled = false;
wbDataStatistic.DocumentText = "";
var r = new Dictionary <string, object>();
r["datepoint"] = dtpSearchDate.Value;
r["limit-amt"] = nudAmt.Value;
var p = await DataStatistic.VipStatistic(r);
if (p.IsOk)
{
var rows = JArray.Parse(p.AsString).ToList();
string info;
info = string.Format(@"<table border=1 cellspacing=0 align=center>
<tr><th width=80 {0}>ID</th>
<th width=100 {0}>帐户名</th>
<th width=100 {0}>真实姓名</th>
<th width=150 {0}>当前客户经理</th>
<th width=120 {0}>手机</th>
<th width=100 {0}>当月投资额</th>
<th width=100 {0}>投资余额</th>
<th width=150 {0}>当月买入债权额</th></tr>", "bgcolor=#A9A9A9");
if (rows.Count == 0)
{
info += "</table>";
wbDataStatistic.DocumentText = info;
btnSearch.Enabled = true;
Commons.ShowInfoBox(this, "未查询到数据!");
return;
}
foreach (var row in rows)
{
info += string.Format(@"<tr><td {0}> {1}</td>
<td {0}> {2}</td>
<td {0}> {3}</td>
<td {0}> {4}</td>
<td {0}> {5}</td>
<td align=right valign=middle> {6}</td>
<td align=right valign=middle> {7}</td>
<td align=right valign=middle> {8}</td></tr>"
, "align=center valign=middle", row["auId"].ToStdString(), row["loginName"].ToStdString()
, row["realName"].ToStdString(), row["uName"].ToStdString(), row["mobile"].ToStdString(), row["monthSumAmt"].ToMoney()
, row["blanceAmt"].ToMoney(), row["monthSumCredit"].ToMoney());
}
info += "</table>";
wbDataStatistic.DocumentText = info;
}
else
{
Commons.ShowResultErrorBox(this, p);
}
btnSearch.Enabled = true;
}
/// <summary>
/// 数据统计
/// </summary>
public static void Statistics(DataStatisticType type, object msg = null)
{
SetConsole(msg + "");
DataStatistic?.Send(new DataStatisticItem()
{
StatisticType = type, Data = msg
});
}
/// <summary>
/// 记录 崩溃
/// 崩溃数据会被上传
/// </summary>
public static void Crash(Exception ex)
{
SetConsole(ex.StackTrace);
DataStatistic?.Send(new DataStatisticItem()
{
StatisticType = DataStatisticType.Crash, Data = ex
});
LogSave?.Save(ex);
}
/// <summary> 释放托管数据 </summary>
protected virtual void ReleaseTrust()
{
if (LogSave != null)
{
LogSave.Stop();
LogSave = null;
}
if (DataStatistic != null)
{
DataStatistic.Stop();
DataStatistic = null;
}
}
private void ExportDate(int year)
{
var label = new List <string>();
var times = new List <DateTime>();
if (year == DateTime.Now.Year)
{
for (int i = 1; i <= DateTime.Now.Month; ++i)
{
label.Add(string.Format("{0}年{1}月", year, i));
times.Add(new DateTime(year, i, 1));
}
}
else
{
for (int i = 1; i <= 12; ++i)
{
label.Add(string.Format("{0}年{1}月", year, i));
times.Add(new DateTime(year, i, 1));
}
}
var dlg = new ExportExcel2Dlg(label, m_model);
dlg.StartPosition = FormStartPosition.CenterParent;
dlg.GetCellStr += GetCellStr;
for (int i = 0; i < times.Count; ++i)
{
var r = new Dictionary <string, object>();
r["datepoint"] = times[i];
dlg.ALL_SERVERS.Add((all) => {
var dic = new Dictionary <string, object>();
var d1 = DataStatistic.MonthStatistic1(r).Result;
var d2 = DataStatistic.MonthStatistic2(r).Result;
var d3 = DataStatistic.MonthStatistic3(r).Result;
var d4 = DataStatistic.MonthStatistic4(r).Result;
var d5 = DataStatistic.MonthStatistic5(r).Result;
Commons.DictionaryAddResult(dic, d1);
Commons.DictionaryAddResult(dic, d2);
Commons.DictionaryAddResult(dic, d3);
Commons.DictionaryAddResult(dic, d4);
Commons.DictionaryAddResult(dic, d5);
all.Add(dic);
});
}
dlg.ShowDialog();
}
static LogX()
{
LogSetting = Locator.GetInstance <ILogSetting>();
if (LogSetting != null)
{
LogSave = Locator.GetInstance <ILogSave>();
if (LogSave != null)
{
LogSave.Start(LogSetting);
}
}
LogReport = Locator.GetInstance <ILogReport>();
LogViewer = Locator.GetInstance <ILogViewer>();
DataStatistic = Locator.GetInstance <IDataStatistic>();
if (DataStatistic != null)
{
DataStatistic.Start();
}
}
private async void UpdateTable1()
{
btnSearch.Enabled = false;
wbInvestorsInfo.DocumentText = "";
var r = new Dictionary <string, object>();
r["datepoint"] = dtpSearchDate.Value.TruncToEnd();
var p = await DataStatistic.DailyStatistic(r);
if (p.IsOk)
{
var d = p.AsDictionary;
string info;
info = string.Format(@"<table border=1 cellspacing=0 align=center>
<tr>
<td {0} {1}><b>新增注册人数</b></td><td {0} {2}> {3}</td> <td {0} {1}><b>总注册人数</b></td><td {0} {2}> {4}</td>
</tr><tr>
<td {0} {1}><b>新增投资人数</b></td><td {0} {2}> {5}</td> <td {0} {1}><b>总投资人数</b></td><td {0} {2}> {6}</td>
</tr><tr>
<td {0} {1}><b>充值人数(仅投资人)</b></td><td {0} {2}> {7}</td> <td {0} {1}><b>总充值人数(仅投资人)</b></td><td {0} {2}> {8}</td>
</tr><tr>
<td {0} {1}><b>充值人数(其他)</b></td><td {0} {2}> {9}</td> <td {0} {1}><b>总充值人数(其他)</b></td><td {0} {2}> {10}</td>
</tr><tr>
<td {0} {1}><b>提现人数(仅投资人)</b></td><td {0} {2}> {11}</td> <td {0} {1}><b>总提现人数(仅投资人)</b></td><td {0} {2}> {12}</td>
</tr><tr>
<td {0} {1}><b>提现人数(其他)</b></td><td {0} {2}> {13}</td> <td {0} {1}><b>总提现人数(其他)</b></td><td {0} {2}> {14}</td>
</tr><tr>
<td {0} {1}><b>投资人数</b></td><td {0} {2}> {15}</td> <td {0} {1}><b> </b></td><td {0} {2}> </td>
</tr><tr>
<td {0} {1}><b>投资人充值金额(元)</b></td><td {0} {2}> {16}</td> <td {0} {1}><b>投资人总充值金额(元)</b></td><td {0} {2}> {17}</td>
</tr><tr>
<td {0} {1}><b>其他充值金额(元)</b></td><td {0} {2}> {18}</td> <td {0} {1}><b>其他总充值金额(元)</b></td><td {0} {2}> {19}</td>
</tr><tr>
<td {0} {1}><b>投资人提现金额(元)</b></td><td {0} {2}> {20}</td> <td {0} {1}><b>投资人总提现金额(元)</b></td><td {0} {2}> {21}</td>
</tr><tr>
<td {0} {1}><b>其他提现金额(元)</b></td><td {0} {2}> {22}</td> <td {0} {1}><b>其他总提现金额(元)</b></td><td {0} {2}> {23}</td>
</tr><tr>
<td {0} {1}><b>投资金额(元)</b></td><td {0} {2}> {24}</td> <td {0} {1}><b>总投资金额(元)</b></td><td {0} {2}> {25}</td>
</tr><tr>
<td {0} {1}><b>债权转让成交金额(元)</b></td><td {0} {2}> {26}</td> <td {0} {1}><b>总债权转让成交金额(元)</b></td><td {0} {2}> {27}</td>
</tr><tr>
<td {0} {1}><b>借款余额(元)</b></td><td {0} {2}> {28}</td> <td {0} {1}><b> </b></td><td {0} {2}> </td>
</tr><tr>
<td {0} {1}><b>还款服务费(元)</b></td><td {0} {2}> {29}</td> <td {0} {1}><b>债权转让服务费(元)</b></td><td {0} {2}> {30}</td>
</tr>
</table>", "align=center valign=middle", "width=200", "width=110"
, d.GetOrDefault <string>("newRegCount"), d.GetOrDefault <string>("totalRegCount")
, d.GetOrDefault <string>("newInvestCount"), d.GetOrDefault <string>("totalInvestCount")
, d.GetOrDefault <string>("rechargeCountInvestor"), d.GetOrDefault <string>("totalRechargeCountInvestor")
, d.GetOrDefault <string>("rechargeCountOther"), d.GetOrDefault <string>("totalRechargeCountOther")
, d.GetOrDefault <string>("withdrawCountInvestor"), d.GetOrDefault <string>("totalWithdrawCountInvestor")
, d.GetOrDefault <string>("withdrawCountOther"), d.GetOrDefault <string>("totalWithdrawCountOther")
, d.GetOrDefault <string>("investCount")
, d.GetOrDefault <string>("rechargeAmtInvestor"), d.GetOrDefault <string>("totalRechargeAmtInvestor")
, d.GetOrDefault <string>("rechargeAmtOther"), d.GetOrDefault <string>("totalRechargeAmtOther")
, d.GetOrDefault <string>("withdrawAmtInvestor"), d.GetOrDefault <string>("totalWithdrawAmtInvestor")
, d.GetOrDefault <string>("withdrawAmtOther"), d.GetOrDefault <string>("totalWithdrawAmtOther")
, d.GetOrDefault <string>("investAmt"), d.GetOrDefault <string>("totalInvestAmt")
, d.GetOrDefault <string>("creditAmt"), d.GetOrDefault <string>("totalCreditAmt")
, d.GetOrDefault <string>("loanBalanceAmt")
, d.GetOrDefault <string>("repayFeeAmt"), d.GetOrDefault <string>("creditFeeAmt"));
info += string.Format(@"<p> </p>
<dl><dt>投资注册人数:</dt>
<dd>第一次投资时间在{0}的人数</dd></dl>
<dl><dt>新增注册人数:</dt>
<dd>注册时间在{0}的人数</dd></dl>
<dl><dt>提现人数:</dt>
<dd>在{0}曾经成功提现的人数(分为投资人和其他两类)</dd></dl>
<dl><dt>充值人数:</dt>
<dd>在{0}曾经成功充值的人数(分为投资人和其他两类)</dd></dl>
<dl><dt>投资人数:</dt>
<dd>在{0}曾经成功投资的人数</dd></dl>
<dl><dt>提现金额:</dt>
<dd>在{0}曾经成功提现的总金额(分为投资人和其他两类)</dd></dl>
<dl><dt>充值金额:</dt>
<dd>在{0}曾经成功充值的总金额(分为投资人和其他两类)</dd></dl>
<dl><dt>投资金额:</dt>
<dd>在{0}曾经成功投资的总金额</dd></dl>
<dl><dt>债权转让成交金额:</dt>
<dd>在{0}曾经成功转让的标价总额</dd></dl>
<dl><dt>借款余额:</dt>
<dd>新系统截止到统计日期结束的总放款-总还本</dd></dl>"
, "指定日的00:00:00到指定日的23:59:59之间");
wbInvestorsInfo.DocumentText = info;
}
else
{
Commons.ShowResultErrorBox(this, p);
}
btnSearch.Enabled = true;
}
private void UpdateTable1(bool initial)
{
var allData = new Dictionary <string, object>();
if (!initial)
{
btnSearch.Enabled = false;
wbInvestorsInfo.DocumentText = "";
var r = new Dictionary <string, object>();
r["datepoint"] = dtpSearchDate.Value.AddDays(1).TruncToStart();
var dlg = new BatchProcessMultipleServers();
dlg.StartPosition = FormStartPosition.CenterParent;
dlg.ALL_SEVERS.Add(async() => { return(await DataStatistic.DailyStatistic1(r)); });
dlg.ALL_SEVERS.Add(async() => { return(await DataStatistic.DailyStatistic2(r)); });
dlg.ALL_SEVERS.Add(async() => { return(await DataStatistic.DailyStatistic3(r)); });
dlg.ALL_SEVERS.Add(async() => { return(await DataStatistic.DailyStatistic4(r)); });
dlg.ALL_SEVERS.Add(async() => { return(await DataStatistic.DailyStatistic5(r)); });
dlg.ShowDialog();
foreach (var d in dlg.AllResult)
{
if (d.IsOk)
{
Commons.DictionaryAddResult(allData, d);
}
}
}
string info = "<p>人数单位：个，金额单位：元</p>";
info += "<table border=1 cellspacing=0 align=center>";
for (int row = 0; row < m_allData.Count; ++row)
{
info += string.Format("<tr><td {0} {1}><b> {3}</b></td><td {0} {2}> {4}</td> <td {0} {1}><b> {5}</b></td><td {0} {2}> {6}</td></tr>",
"align=center valign=middle", "width=210", "width=110",
m_allData[row].Item1, allData.GetOrDefault <string>(m_allData[row].Item2),
m_allData[row].Item3, allData.GetOrDefault <string>(m_allData[row].Item4));
}
info += "</table>";
info += string.Format(@"<p> </p>
<dl><dt>投资注册人数:</dt>
<dd>第一次投资时间在{0}的人数</dd></dl>
<dl><dt>新增注册人数:</dt>
<dd>注册时间在{0}的人数</dd></dl>
<dl><dt>提现人数:</dt>
<dd>在{0}曾经成功提现的人数(分为投资人和其他两类)</dd></dl>
<dl><dt>充值人数:</dt>
<dd>在{0}曾经成功充值的人数(分为投资人和其他两类)</dd></dl>
<dl><dt>投资人数:</dt>
<dd>在{0}曾经成功投资的人数</dd></dl>
<dl><dt>提现金额:</dt>
<dd>在{0}曾经成功提现的总金额(分为投资人和其他两类)</dd></dl>
<dl><dt>充值金额:</dt>
<dd>在{0}曾经成功充值的总金额(分为投资人和其他两类)</dd></dl>
<dl><dt>投资金额:</dt>
<dd>在{0}曾经成功投资的总金额</dd></dl>
<dl><dt>债权转让成交金额:</dt>
<dd>在{0}曾经成功转让的标价总额</dd></dl>
<dl><dt>借款余额:</dt>
<dd>新系统截止到统计日期结束的总放款-总还本</dd></dl>"
, "指定日的00:00:00到指定日的23:59:59之间");
wbInvestorsInfo.DocumentText = info;
btnSearch.Enabled = true;
}
public void proveraRacunaDevijacijeFail(string s, int i, int j, int k)
{
DataStatistic data = new DataStatistic(s, i, j, k);
Assert.AreNotEqual(1, data.dev);
}
public static void Statistics(DataStatisticItem item)
{
SetConsole(item?.ToString() + "");
DataStatistic?.Send(item);
}
private void UpdateTable(bool initial)
{
var allData = new Dictionary <string, object>();
if (!initial)
{
btnSearch.Enabled = false;
wbDataStatistic.DocumentText = "";
var r = new Dictionary <string, object>();
var now = dtpSearchDate.Value;
r["datepoint1"] = new DateTime(now.Year, now.Month, 1).AddDays(-1).TruncToEnd();
r["datepoint2"] = new DateTime(now.Year, now.Month, 1).AddMonths(1).TruncToStart();
var dlg = new BatchProcessMultipleServers();
dlg.StartPosition = FormStartPosition.CenterParent;
dlg.ALL_SEVERS.Add(async() => { return(await DataStatistic.MonthStatistic1(r)); });
dlg.ALL_SEVERS.Add(async() => { return(await DataStatistic.MonthStatistic2(r)); });
dlg.ALL_SEVERS.Add(async() => { return(await DataStatistic.MonthStatistic3(r)); });
dlg.ALL_SEVERS.Add(async() => { return(await DataStatistic.MonthStatistic4(r)); });
dlg.ALL_SEVERS.Add(async() => { return(await DataStatistic.MonthStatistic5(r)); });
dlg.ShowDialog();
foreach (var d in dlg.AllResult)
{
if (d.IsOk)
{
Commons.DictionaryAddResult(allData, d);
}
}
}
string info = "<p>人数单位：个，金额单位：元</p>";
info += "<table border=1 cellspacing=0 align=center>";
for (int row = 0; row < m_model.Count; ++row)
{
info += string.Format("<tr><td {0} {1}><b> {3}</b></td><td {0} {2}> {4}</td> <td {0} {1}><b> {5}</b></td><td {0} {2}> {6}</td></tr>",
"align=center valign=middle", "width=220", "width=110",
GetCellStr(m_model[row][0], allData), GetCellStr(m_model[row][1], allData),
GetCellStr(m_model[row][2], allData), GetCellStr(m_model[row][3], allData));
}
info += "</table>";
info += string.Format(@"<p> </p>
<dl><dt>投资注册人数:</dt>
<dd>第一次投资时间在{0}的人数</dd></dl>
<dl><dt>新增注册人数:</dt>
<dd>注册时间在{0}的人数</dd></dl>
<dl><dt>提现人数:</dt>
<dd>在{0}曾经成功提现的人数(分为投资人和其他两类)</dd></dl>
<dl><dt>充值人数:</dt>
<dd>在{0}曾经成功充值的人数(分为投资人和其他两类)</dd></dl>
<dl><dt>投资人数:</dt>
<dd>在{0}曾经成功投资的人数</dd></dl>
<dl><dt>提现金额:</dt>
<dd>在{0}曾经成功提现的总金额(分为投资人和其他两类)</dd></dl>
<dl><dt>充值金额:</dt>
<dd>在{0}曾经成功充值的总金额(分为投资人和其他两类)</dd></dl>
<dl><dt>投资金额:</dt>
<dd>在{0}曾经成功投资的总金额</dd></dl>
<dl><dt>债权转让成交金额:</dt>
<dd>在{0}曾经成功转让的标价总额</dd></dl>
<dl><dt>借款余额:</dt>
<dd>新系统截止到统计月结束的总放款-总还本</dd></dl>", "指定月");
wbDataStatistic.DocumentText = info;
btnSearch.Enabled = true;
}