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; }