private async void UpdateTable()
{
btnSearchMonth.Enabled = false;
var d = new Dictionary <string, object>();
d["u-name"] = m_uname;
d["datepoint"] = dtpDate.Value;
var p = await CrmPerformance.GetCstmofMgrByMonth(d);
if (p.IsOk)
{
myGridViewBinding1.BindTo(p);
}
else
{
Commons.ShowResultErrorBox(this, p);
}
btnSearchMonth.Enabled = true;
}
private async void UpdateTable()
{
btnSearchDay.Enabled = false;
var checkedManagers = GetCheckedManagers();
if (checkedManagers.Count == 0)
{
Commons.ShowInfoBox(this, "至少选择一个客户经理");
btnSearchDay.Enabled = true;
return;
}
var p = new Dictionary <string, object>();
p["datepoint"] = searchDate.Value;
p["u-names"] = string.Join(",", checkedManagers).Replace("+", Properties.Settings.Default.LastUser);
var r = await CrmPerformance.GetPerformanceByDaily(p);
if (r.IsOk)
{
myGridViewBinding1.BindTo(r.AsDictList, Commons.BindFlag.Replace, "", () => {
var sumInvestAmt = 0M;
var sumTenderAmt = 0M;
var sumRepaidCapitalAmt = 0M;
var sumFirstInvestCount = 0M;
var sumInvesterCount = 0U;
var sumInvestCount = 0U;
var sumCreditAmt = 0U;
var sumBindCount = 0U;
var sumIncomeAmt = 0M;
for (var i = 0; i < myGridViewBinding1.DataTable.Count; ++i)
{
sumInvestAmt += Convert.ToDecimal(myGridViewBinding1.DataTable[i, "sumInvestAmt"]);
sumTenderAmt += Convert.ToDecimal(myGridViewBinding1.DataTable[i, "sumTenderAmt"]);
sumRepaidCapitalAmt += Convert.ToDecimal(myGridViewBinding1.DataTable[i, "sumRepaidCapitalAmt"]);
sumFirstInvestCount += Convert.ToDecimal(myGridViewBinding1.DataTable[i, "sumFirstInvestCount"]);
sumInvesterCount += Convert.ToUInt32(myGridViewBinding1.DataTable[i, "sumInvesterCount"]);
sumInvestCount += Convert.ToUInt32(myGridViewBinding1.DataTable[i, "sumInvestCount"]);
sumCreditAmt += Convert.ToUInt32(myGridViewBinding1.DataTable[i, "sumCreditAmt"]);
sumBindCount += Convert.ToUInt32(myGridViewBinding1.DataTable[i, "sumBindCount"]);
sumIncomeAmt += Convert.ToDecimal(myGridViewBinding1.DataTable[i, "sumIncomeAmt"]);
}
var sumRow = new List <object>();
//客户经理
sumRow.Add("<总计>");
//客户经理编码
sumRow.Add(null);
//客户经理上级
sumRow.Add(null);
//客户经理职务
sumRow.Add(null);
//投资余额
sumRow.Add(sumInvestAmt);
//投标总额
sumRow.Add(sumTenderAmt);
//已还本金总额
sumRow.Add(sumRepaidCapitalAmt);
//首次投标人数
sumRow.Add(sumFirstInvestCount);
//投标人数
sumRow.Add(sumInvesterCount);
//投标次数
sumRow.Add(sumInvestCount);
//买入债权本金总额
sumRow.Add(sumCreditAmt);
//绑卡人数
sumRow.Add(sumBindCount);
//平台收入
sumRow.Add(sumIncomeAmt);
myGridViewBinding1.DataTable.Add(sumRow);
myGridViewBinding1.InvalidateView();
});
}
else
{
Commons.ShowResultErrorBox(this, r);
}
btnSearchDay.Enabled = true;
}
