private async void SaveData()
{
if (m_bpmpId == 0 || m_bpmpId == -1)
{
Commons.ShowInfoBox(this, "请选择一个借款人!");
btnSelBorPer.Focus();
return;
}
var p = new Dictionary <string, object>();
p["pid"] = m_pId;
p["bpmp-id"] = m_bpmpId;
p["loan-purposes"] = tbLoanPurpose.Text.Trim();
p["loan-bal"] = (int)nudLoanBal.Value;
p["other-loan-bal"] = (int)nudOtherLoanBal.Value;
p["overdue-num"] = tbOverDueNum.Text.Trim();
p["other-overdue-num"] = tbOtherOverDueNum.Text.Trim();
p["overdue-amt"] = nudOverDueAmt.Value;
p["other-overdue-amt"] = nudOtherOverDueAmt.Value;
p["visible"] = cbbVisible.GetSelectedValue();
p["order-no"] = (int)nudOrder.Value;
p["loan-intro"] = tbSituation.Text.LeftStr(2000);
var r = await Projects.BorrowPerPut(p);
if (r.IsOk)
{
DlgResult = r;
DialogResult = DialogResult.OK;
}
else
{
Commons.ShowResultErrorBox(this, r);
}
}
private async void UpdateData()
{
var r = await PrjOwners.GetOwner(m_boId);
if (r.IsOk)
{
var d = r.AsDictionary;
tbName.Text = d.GetOrDefault <string>("ownerName");
tbShowName.Text = d.GetOrDefault <string>("ownerShowName");
dtpRegisterDate.Value = Commons.FromTimestamp(d.GetOrDefault <long>("registeredDate"));
tbRegYear.Text = d.GetOrDefault <string>("regYears");
tbRegFunds.Text = d.GetOrDefault <string>("regFunds");
tbShowRegFunds.Text = d.GetOrDefault <string>("showRegFunds");
cbbEntIndustry.Text = d.GetOrDefault <string>("entIndustry");
cbbOwnerNature.Text = d.GetOrDefault <string>("ownerNature");
cbbOwnerStrength.Text = d.GetOrDefault <string>("ownerStrength");
cbbOwnerQuality.Text = d.GetOrDefault <string>("ownerQuality");
tbIntro.Text = d.GetOrDefault <string>("intro");
}
else
{
Commons.ShowResultErrorBox(this, r);
}
}
private async void UpdateData()
{
var r = await PrjGuaranteeOrgs.GetGuarantee(m_bgoId);
if (r.IsOk)
{
var d = r.AsDictionary;
tbName.Text = d.GetOrDefault <string>("name");
tbShowName.Text = d.GetOrDefault <string>("showName");
dtpRegisterDate.Value = Commons.FromTimestamp(d.GetOrDefault <long>("registeredDate"));
tbRegYear.Text = d.GetOrDefault <string>("regYears");
tbRegFunds.Text = d.GetOrDefault <string>("regFunds");
tbRegAddress.Text = d.GetOrDefault <string>("regAddress");
tbPostCode.Text = d.GetOrDefault <string>("postcode");
tbLinkMan.Text = d.GetOrDefault <string>("linkman");
tbMobile.Text = d.GetOrDefault <string>("mobile");
tbRanking.Text = d.GetOrDefault <string>("ranking");
tbGetPrize.Text = d.GetOrDefault <string>("getPrize");
tbOrgWebSite.Text = d.GetOrDefault <string>("orgWebSite");
tbQualification.Text = d.GetOrDefault <string>("qualification");
tbShowRegAddress.Text = d.GetOrDefault <string>("showRegAddress");
tbLegalIdCard.Text = d.GetOrDefault <string>("legalIdCard");
tbLegalPersonName.Text = d.GetOrDefault <string>("legalPersonName");
tbLegalPersonShowName.Text = d.GetOrDefault <string>("legalPersonShowName");
tbSocialCreditCode.Text = d.GetOrDefault <string>("socialCreditCode");
tbShowSocialCreditCode.Text = d.GetOrDefault <string>("showSocialCreditCode");
tbIntro.Text = d.GetOrDefault <string>("intro");
}
else
{
Commons.ShowResultErrorBox(this, r);
}
}
private async void UpdateTable1() {
btnSearch.Enabled = false;
var prjType = cbProjType.ComboBox.GetSelectedValue();
var p = new Dictionary<string, object>();
p["start-time"] = startDate.Value.TruncToStart();
p["end-time"] = endDate.Value.TruncToEnd();
p["date-type"] = cbDateType.ComboBox.GetSelectedValue();
p["status"] = cbTransType.ComboBox.GetSelectedValue();
if (prjType != Commons.AllValue) {
p["prj-type"] = prjType;
}
p["key-type"] = cbKeyValue.ComboBox.GetSelectedValue();
p["key"] = tbKey.Text.Trim();
var r = await CreditAssignProjs.GetAllPrjs(p);
if (r.IsOk) {
this.myGridViewBinding1.BindTo(r);
} else {
Commons.ShowResultErrorBox(this, r);
}
btnSearch.Enabled = true;
}
private async void SaveData()
{
btnOk.Enabled = false;
var r = new Dictionary <string, object>();
r["pid"] = m_pId;
r["login-name"] = tbLoginName.Text.Trim();
r["mobile"] = tbMobile.Text.Trim();
var p = await Projects.AddAllowInvest(r);
if (p.IsOk)
{
DlgResult = p;
DialogResult = DialogResult.OK;
}
else
{
Commons.ShowResultErrorBox(this, p);
}
btnOk.Enabled = true;
}
private async void Delete(IList <long> idArray)
{
btnDelete.Enabled = false;
var ss = idArray.JoinSome();
if (Commons.ShowConfirmBox(this, "删除以下借款机构：" + ss + " 此操作不可恢复！确认吗？"))
{
foreach (var id in idArray)
{
var p = await PrjBorOrgs.Delete(id);
if (p.IsOk)
{
myGridViewBinding1.BindTo(p, Commons.BindFlag.Delete, "bpmoId");
}
else
{
Commons.ShowResultErrorBox(this, p);
}
}
Commons.ShowInfoBox(this, "借款机构：" + ss + " 已被删除。");
}
btnDelete.Enabled = true;
}
private async void UpdateData()
{
btnSearch.Enabled = false;
listView1.Items.Clear();
var p = new Dictionary <string, object>();
p["key"] = tbKey.Text.Trim();
var r = await PrjGuaranteePers.GetGuarantees(p);
if (r.IsOk)
{
var dl = JArray.Parse(r.AsString).ToList();
foreach (var d in dl)
{
ListViewItem lvi = new ListViewItem();
lvi.Text = d["bgpId"].ToStdString();
if (SelGuaId.ToString() == lvi.Text)
{
lvi.Checked = true;
}
lvi.SubItems.Add(d["name"].ToStdString());
lvi.SubItems.Add(d["showName"].ToStdString());
listView1.Items.Add(lvi);
}
m_maxRow = listView1.Items.Count;
}
else
{
Commons.ShowResultErrorBox(this, r);
}
if (listView1.CheckedItems.Count == 0)
{
SelGuaId = -1;
}
btnSearch.Enabled = true;
}
private async void Delete(IList <string> userNames)
{
btnDelete.Enabled = false;
var ss = userNames.JoinSome();
if (Commons.ShowConfirmBox(this, "删除以下用户：" + ss + " 此操作不可恢复！确认吗？"))
{
foreach (var userName in userNames)
{
var p = await Security.Users.DeleteUser(userName);
if (p.IsOk)
{
myGridViewBinding1.BindTo(p, Commons.BindFlag.Delete, "userName");
}
else
{
Commons.ShowResultErrorBox(this, p);
}
}
Commons.ShowInfoBox(this, "用户：" + ss + " 已被删除。");
}
btnDelete.Enabled = true;
}
private async void UpdateTable()
{
btnOk.Enabled = false;
tabControl.Enabled = false;
var p = await Roles.Perms(m_roleName);
if (p.IsOk)
{
var dl = JArray.Parse(p.AsString).ToList();
foreach (var v in dl)
{
if (m_allCheckBoxs.Contains(v.ToStdString()))
{
((CheckBox)m_allCheckBoxs[v.ToStdString()]).Checked = true;
}
}
}
else
{
Commons.ShowResultErrorBox(this, p);
}
tabControl.Enabled = true;
btnOk.Enabled = true;
}
private async void SaveData()
{
var r = new Dictionary <string, object>();
r["ci-id"] = m_ciId;
r["real-name"] = tbRealName.Text.Trim();
r["mobile"] = tbMobile.Text.Trim();
r["company"] = tbCompany.Text.Trim();
r["position"] = tbPosition.Text.Trim();
r["city"] = tbCity.Text.Trim();
r["birth"] = (DateTime.Now.AddYears(-Convert.ToInt32(nudAge.Value))).TruncToStart();
r["gender"] = cbbGender.GetSelectedValue();
r["origin-type"] = tbSourceType.Text.Trim();
r["pr-level"] = cbbPrLevel.GetSelectedValue();
r["remark"] = tbRemark.Text.Trim().LeftStr(2000);
IResult p;
if (m_ciId == 0)
{
p = await CrmInvestor.Create(r);
}
else
{
p = await CrmInvestor.Update(r);
}
if (p.IsOk)
{
DlgResult = p;
DialogResult = DialogResult.OK;
}
else
{
Commons.ShowResultErrorBox(this, p);
}
}
private async void UpdateData3()
{
var r = await Projects.Financier(m_pId);
if (r.IsOk)
{
var dl = JArray.Parse(r.AsString).ToList();
foreach (var d in dl)
{
var roleType = d["roleType"].ToStdString();
string userType = d["userType"].ToStdString();
string name = userType == "1" ? d["realName"].ToStdString() : d["orgName"].ToStdString();
switch (roleType)
{
case "1":
m_borId = d["auId"].ToInt64();
tbBor.Text = mapBorName(userType, name);
break;
case "2":
m_nominalBorId = d["auId"].ToInt64();
tbNominalBor.Text = mapBorName(userType, name);
break;
case "3":
m_sponsorId = d["auId"].ToInt64();
tbSponsor.Text = mapBorName(userType, name);
break;
}
}
}
else
{
Commons.ShowResultErrorBox(this, r);
}
}
private async void Create()
{
if (tbRCode.Text.Trim() == "")
{
Commons.ShowInfoBox(this, "必须输入推广代号");
return;
}
btnCreate.Enabled = false;
var d = new Dictionary <string, object>();
d["ori-rcode"] = tbRCode.Text.Trim();
var p = await CrmInvestor.SpreadQRCode(d);
if (p.IsOk)
{
tbRAddress.Text = p.AsString.Trim('\"');
pictureBox1.Image = GetQRCodeBitmap(tbRAddress.Text);
}
else
{
Commons.ShowResultErrorBox(this, p);
}
btnCreate.Enabled = true;
}
private async void ToTop()
{
btnTop.Enabled = false;
var topTime = Convert.ToBoolean(myGridViewBinding1.GetSelectedValues <long>("topTime").FirstOrDefault());
Rpc.IResult p;
if (topTime)
{
p = await Projects.PrjRevokeTop(myGridViewBinding1.GetSelectedValues <long>("pId").FirstOrDefault());
}
else
{
p = await Projects.PrjToTop(myGridViewBinding1.GetSelectedValues <long>("pId").FirstOrDefault());
}
if (p.IsOk)
{
UpdateTable1();
}
else
{
Commons.ShowResultErrorBox(this, p);
}
btnTop.Enabled = true;
}
private async void DeleteGuaranteePers(IList <long> idArray)
{
btnGuaranteePerDel.Enabled = false;
var ss = idArray.JoinSome();
if (Commons.ShowConfirmBox(this, "删除以下担保人：" + ss + " 此操作不可恢复！确认吗？"))
{
foreach (var id in idArray)
{
var p = await Projects.GuaranteePerDel(m_pId, id);
if (p.IsOk)
{
myGridViewBinding1.BindTo(p, Commons.BindFlag.Delete, "pgpId");
}
else
{
Commons.ShowResultErrorBox(this, p);
}
}
Commons.ShowInfoBox(this, "担保人：" + ss + " 已被删除。");
}
btnGuaranteePerDel.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;
}
private void btnUpdateURL_Click(object sender, EventArgs e)
{
System.Diagnostics.Process.Start(Properties.Settings.Default.Update_BaseUrl + Commons.AddUrlTail(URLTYPES.UPDATE) + "/index.jsp");
}
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 async void SaveData()
{
var amt = nudAmt.Value;
var eAmt = Convert.ToDecimal(tbExpectedAmt.Text);
if (amt <= 0)
{
Commons.ShowInfoBox(this, "还款金额必须大于零");
nudAmt.Focus();
return;
}
var dAmt = eAmt - amt;
if (dAmt < 0)
{
Commons.ShowInfoBox(this, "差额不能小于零");
nudAmt.Focus();
return;
}
var tranNo = myGridViewBinding1.GetSelectedValues <int>("tranNo").FirstOrDefault();
var tranType = myGridViewBinding1.GetSelectedValues <string>("tranType").FirstOrDefault();
var payType = rbNormal.Checked ? 1 : rbNominal.Checked ? 3 : rbReverse.Checked ? 2 : 0;
var sPayType = payType == 1 ? "正常还款" : payType == 3 ? "名义借款人还款" : payType == 2 ? "保证金还款" : "";
if (Commons.ShowConfirmBox(this, string.Format(
"来源:{0:N}\r\n" +
"金额:{1:N}\r\n" +
"差额:{2:N}\r\n" +
"还款时间:{3:G}\r\n" +
"期数:{4}\r\n" +
"类型:{5}\r\n" +
"\n发起还款么?", sPayType, nudAmt.Value, tbDiffAmt.Text, dtpDatePoint.Value,
tranNo, TRAN_TYPES.FindByValue(tranType))))
{
string vf = "";
var r = new Dictionary <string, object>();
r.AddVF("pid", m_pId, ref vf)
.AddVF("tran-no", tranNo, ref vf)
.AddVF("tran-type", tranType, ref vf)
.AddVF("pay-type", payType, ref vf)
.AddVF("amt", amt, ref vf)
.AddVF("paid-time", dtpDatePoint.Value, ref vf)
.AddVF("remark", tbComments.Text.LeftStr(2000), ref vf);
r["signature"] = Verification.GetSha1(vf);
var p = await Projects.SaveBonusDetail(r);
if (p.IsOk)
{
panel1.Visible = false;
UpdateTable1();
UpdateTable2();
if (dAmt > 0 && tranType == "0")
{
Commons.ShowWarnBox(this, "刚才发起的还息不是足额还款。如果是提前还款，请执行还息后立刻足额还本");
}
var p2 = await Projects.RepayFileUploadTime();
if (!p2.IsOk)
{
Commons.ShowResultErrorBox(this, p2);
}
}
else
{
Commons.ShowResultErrorBox(this, p);
}
}
}
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;
}
private async void SaveData()
{
btnOk.Enabled = false;
try {
var r = new Dictionary <string, object>();
r["bbo-id"] = m_bboId;
//机构信息
r["org-name"] = tbName.Text.Trim();
r["show-org-name"] = tbShowName.Text.Trim();
r["registered-fund"] = tbRegFunds.Text.Trim();
r["registered-show-fund"] = tbShowRegFunds.Text.Trim();
r["registered-date"] = dtpRegisterDate.Value;
r["address"] = tbAddress.Text.Trim();
r["show-address"] = tbShowAddress.Text.Trim();
r["social-credit-code"] = tbSocialCreditCode.Text.Trim();
r["show-social-credit-code"] = tbShowSocialCreditCode.Text.Trim();
r["industry"] = cbbIndustry.Text.Trim();
r["work-address"] = tbWorkAddress.Text.Trim();
r["show-work-address"] = tbShowWorkAddress.Text.Trim();
r["shareholder-info"] = tbShareholderInfo.Text.Trim();
r["show-shareholder-info"] = tbShowShareholderInfo.Text.Trim();
r["operate-area"] = tbOperateArea.Text.Trim();
r["other-info"] = tbOtherInfo.Text.Trim();
//法人信息
r["legal-person-name"] = tbLawName.Text.Trim();
r["legal-person-show-name"] = tbShowLawName.Text.Trim();
r["legal-id-card"] = tbLawIdCard.Text.Trim();
r["mobile"] = tbLawMobile.Text.Trim();
r["email"] = tbLawEmail.Text.Trim();
r["fax"] = tbLawFax.Text.Trim();
r["wchat"] = tbLawWechat.Text.Trim();
//联系人信息
r["linkman-name"] = tbLinkManName.Text.Trim();
r["linkman-show-name"] = tbShowLinkManName.Text.Trim();
r["linkman-id-card"] = tbLinkManIdCard.Text.Trim();
r["linkman-mobile"] = tbLinkManMobile.Text.Trim();
r["linkman-email"] = tbLinkManEmail.Text.Trim();
r["linkman-wchat"] = tbLinkManWeChat.Text.Trim();
r["linkman-address"] = tbLinkManAddress.Text.Trim();
r["linkman-show-address"] = tbShowLinkManAddress.Text.Trim();
r["linkman-fax"] = tbLinkManFax.Text.Trim();
//介绍
r["intro"] = tbIntro.Text.Trim();
IResult p;
if (m_bboId == 0)
{
p = await PrjBorOrgs.Create(r);
}
else
{
p = await PrjBorOrgs.Update(r);
}
if (p.IsOk)
{
DlgResult = p;
DialogResult = DialogResult.OK;
}
else
{
Commons.ShowResultErrorBox(this, p);
}
} finally {
btnOk.Enabled = true;
}
}
private async void Updatetable1()
{
var r = new Dictionary <string, object>();
r["u-name"] = m_uName;
var p = await CrmInvestor.GetNumInStatus(r);
if (p.IsOk)
{
var dl = p.AsDictionary;
foreach (var btn in panel2.Controls)
{
if (btn is Button)
{
((Button)btn).Text = string.Format(Convert.ToString(((Button)btn).Tag), dl.GetOrDefault <string>(Commons.NormalNumberStr(((Button)btn).Name)));
}
}
}
else
{
Commons.ShowResultErrorBox(this, p);
}
}
private async void UploadFiles()
{
if (m_maxCount > 0)
{
if (listView1.Items.Count >= m_maxCount)
{
Commons.ShowInfoBox(this, string.Format("最多只能上传 {0} 个文件，请删除后再上传！", m_maxCount));
}
}
using (var oFile = new OpenFileDialog()) {
oFile.Filter = m_filter;
if (oFile.ShowDialog() == DialogResult.OK)
{
if (m_fileType == 37)
{
if (!oFile.FileName.StartsWith("intermediary_") && !oFile.FileName.StartsWith("loan_"))
{
Commons.ShowInfoBox(this, "上传文件应以“intermediary_”或“loan_”开头");
return;
}
}
FileStream fileStream;
try {
fileStream = new FileStream(oFile.FileName, FileMode.Open);
} catch (Exception e) {
Commons.ShowInfoBox(this, e.Message);
return;
}
if (fileStream.Length > m_maxSize * MB)
{
Commons.ShowInfoBox(this, string.Format("文件 {0} 太大，大小不能超过 {1} MB", oFile.FileName, m_maxSize));
return;
}
btnUpload.Enabled = false;
var d = new Dictionary <string, object>();
d["objectId"] = m_objectId;
d["fileType"] = m_fileType;
d["fileName"] = oFile.SafeFileName;
if (m_pname != "")
{
d["parentName"] = m_pname;
}
d["force"] = true;
var p = await Files.Create(d);
if (p.IsOk)
{
var fileId = p.AsLong;
if (fileId == 0)
{
Commons.ShowInfoBox(this, "创建新文件失败!");
btnUpload.Enabled = true;
return;
}
var data = new byte[fileStream.Length];
try {
fileStream.Read(data, 0, data.Length);
} catch (Exception e) {
Commons.ShowInfoBox(this, e.Message);
btnUpload.Enabled = true;
return;
}
var p2 = await Files.Upload(fileId, data);
if (p2.IsOk)
{
UpdateTable();
}
else
{
Commons.ShowResultErrorBox(this, p2);
}
}
fileStream.Close();
btnUpload.Enabled = true;
}
}
}
private async void UpdateData1()
{
var r = await Projects.Prj(m_pId);
if (r.IsOk)
{
var d = r.AsDictionary;
tbItemName.Text = d.GetOrDefault <string>("itemName");
tbItemShowName.Text = d.GetOrDefault <string>("itemShowName");
tbItemNo.Text = d.GetOrDefault <string>("itemNo");
tbDeputy.Text = d.GetOrDefault <string>("outProxy");
tbFinanceManager.Text = d.GetOrDefault <string>("inProxy");
tbFinancier.Text = d.GetOrDefault <string>("financier");
tbPrjSource.Text = d.GetOrDefault <string>("src");
tbLoanPurpose.Text = d.GetOrDefault <string>("loanPurposes");
nudAmt.SetValue(d.GetOrDefault <decimal>("amt"));
nudPerInvestMaxAmt.Maximum = nudAmt.Value;
nudRate.SetValue(d.GetOrDefault <decimal>("rate"));
nudExtensionRate.SetValue(d.GetOrDefault <decimal>("extensionRate"));
nudTimeoutRate.SetValue(d.GetOrDefault <decimal>("timeOutRate"));
nudDepositRatio.SetValue(d.GetOrDefault <decimal>("depositRatio"));
nudBorrowDays.SetValue(d.GetOrDefault <decimal>("borrowDays"));
nudExtensionDay.SetValue(d.GetOrDefault <decimal>("extensionDays"));
nudBuyRate.SetValue(d.GetOrDefault <decimal>("costFee"));
dtpInTime.Value = Commons.FromTimestamp(d.GetOrDefault <long>("inTime"));
dtpOutTime.Value = Commons.FromTimestamp(d.GetOrDefault <long>("outTime"));
ckbInEqualOut.Checked = dtpInTime.Value.Date == dtpOutTime.Value.Date;
nudFinanceDays.SetValue(d.GetOrDefault <decimal>("financingDays"));
dtpExpecteBorTime.Value = Commons.FromTimestamp(d.GetOrDefault <long>("expectedBorrowTime"));
nudPerInvestMinAmt.SetValue(d.GetOrDefault <decimal>("perInvestMinAmt"));
nudPerInvestAmt.SetValue(d.GetOrDefault <decimal>("perInvestAmt"));
nudFeeRate.SetValue(d.GetOrDefault <decimal>("feeRate"));
cbbPrjType.SetSelectedValue(d.GetOrDefault <string>("type"));
visible = d.GetOrDefault <bool>("visible");
tbPrjIntro.Text = d.GetOrDefault <string>("prjIntro");
var investMaxAmtRatio = d.GetOrDefault <decimal>("investMaxAmtRatio");
var investMaxAmt = d.GetOrDefault <decimal>("investMaxAmt");
var perMaxMoney = d.GetOrDefault <decimal>("perInvestMaxAmt");
if (investMaxAmtRatio > 0)
{
ckbLimitMoneyRate.Checked = true;
nudInvestMaxAmtRatio.SetValue(investMaxAmtRatio);
}
if (investMaxAmt > 0)
{
ckbLimitMoney.Checked = true;
nudInvestMaxAmt.SetValue(investMaxAmt);
}
if (perMaxMoney > 0)
{
ckbPerMaxMoney.Checked = true;
nudPerInvestMaxAmt.SetValue(perMaxMoney);
}
UpdateTotalInterest();
var contract = d.GetOrDefault <int>("contract");
ckbContract1.Checked = Convert.ToBoolean(contract & 1);
ckbContract2.Checked = Convert.ToBoolean(contract & 2);
ckbContract8.Checked = Convert.ToBoolean(contract & 8);
tbKeys.Text = d.GetOrDefault <string>("key");
var flags = d.GetOrDefault <int>("flags");
ckbFlagNewer.Checked = Convert.ToBoolean(flags & 0x0001);
ckbFlagJcb.Checked = Convert.ToBoolean(flags & 0x0010);
ckbFlagBx.Checked = Convert.ToBoolean(flags & 0x0040);
cbbWaterMark.Text = d.GetOrDefault <string>("waterMark");
btnDelayCollect.Enabled = d.GetOrDefault <int>("status") == 40;
tbRemark.Text = d.GetOrDefault <string>("remark");
if (m_pId == 0)
{
btnDelayCollect.Visible = false;
}
}
else
{
Commons.ShowResultErrorBox(this, r);
}
}
private async void SaveData()
{
if (PrjReadOnly)
{
return;
}
if (m_borId == 0 || m_borId == -1)
{
Commons.ShowInfoBox(this, "必须选择一个借款人帐户");
return;
}
btnOk.Enabled = false;
string vf = "";
var r = new Dictionary <string, object>();
r.AddVF("pid", m_pId, ref vf)
.AddVF("item-name", tbItemName.Text.Trim(), ref vf)
.AddVF("item-show-name", tbItemShowName.Text.Trim(), ref vf)
.AddVF("item-no", tbItemNo.Text.Trim(), ref vf)
.AddVF("out-proxy", tbDeputy.Text.Trim(), ref vf)
.AddVF("in-proxy", tbFinanceManager.Text.Trim(), ref vf)
.AddVF("financier", tbFinancier.Text.Trim(), ref vf)
.AddVF("src", tbPrjSource.Text.Trim(), ref vf)
.AddVF("amt", nudAmt.Value, ref vf)
.AddVF("rate", nudRate.Value, ref vf)
.AddVF("extension-rate", nudExtensionRate.Value, ref vf)
.AddVF("time-out-rate", nudTimeoutRate.Value, ref vf)
.AddVF("penalty-ratio", 0, ref vf)
.AddVF("deposit-ratio", nudDepositRatio.Value, ref vf)
.AddVF("borrow-days", (int)nudBorrowDays.Value, ref vf)
.AddVF("extension-days", (int)nudExtensionDay.Value, ref vf)
.AddVF("cost-fee", nudBuyRate.Value, ref vf)
.AddVF("sold-fee", nudRate.Value, ref vf)
.AddVF("in-time", dtpInTime.Value, ref vf)
.AddVF("out-time", dtpOutTime.Value, ref vf)
.AddVF("financing-days", (int)nudFinanceDays.Value, ref vf)
.AddVF("expected-borrow-time", dtpExpecteBorTime.Value, ref vf)
.AddVF("per-invest-min-amt", nudPerInvestMinAmt.Value, ref vf)
.AddVF("per-invest-amt", nudPerInvestAmt.Value, ref vf)
.AddVF("fee-rate", nudFeeRate.Value, ref vf)
.AddVF("visible", visible, ref vf);
if (ckbLimitMoneyRate.Checked)
{
r.AddVF("invest-max-amt-ratio", nudInvestMaxAmtRatio.Value, ref vf);
}
if (ckbLimitMoney.Checked)
{
r.AddVF("invest-max-amt", nudInvestMaxAmt.Value, ref vf);
}
if (ckbPerMaxMoney.Checked)
{
r.AddVF("per-invest-max-amt", nudPerInvestMaxAmt.Value, ref vf);
}
r.AddVF("contract", (ckbContract1.Checked ? 1 : 0) |
(ckbContract2.Checked ? 2 : 0) |
(ckbContract8.Checked ? 8 : 0), ref vf);
r.AddVF("key", tbKeys.Text.Trim(), ref vf)
.AddVF("water-mark", cbbWaterMark.Text.Trim(), ref vf)
.AddVF("type", cbbPrjType.GetSelectedValue(), ref vf);
long flags = 0;
if (ckbFlagNewer.Checked)
{
flags |= 0x0001;
}
if (ckbFlagJcb.Checked)
{
flags |= 0x0010;
}
if (ckbFlagBx.Checked)
{
flags |= 0x0040;
}
r.AddVF("flags", flags, ref vf)
.AddVF("remark", tbRemark.Text.Trim(), ref vf)
.AddVF("prj-intro", tbPrjIntro.Text.Trim(), ref vf)
.AddVF("loan-purposes", tbLoanPurpose.Text.Trim(), ref vf);
r["signature"] = Verification.GetSha1(vf);
var p1 = await Projects.Update(r);
if (!p1.IsOk)
{
Commons.ShowResultErrorBox(this, p1);
btnOk.Enabled = true;
return;
}
else
{
DlgResult = p1;
}
vf = "";
r.Clear();
r.AddVF("pid", m_pId, ref vf)
.AddVF("financier-cu-id", m_borId, ref vf);
r["signature"] = Verification.GetSha1(vf);
var p3 = await Projects.SaveFinancier(r);
if (!p3.IsOk)
{
Commons.ShowResultErrorBox(this, p3);
btnOk.Enabled = true;
return;
}
vf = "";
r.Clear();
r.AddVF("pid", m_pId, ref vf)
.AddVF("nominal-au-id", m_nominalBorId, ref vf)
.AddVF("bondsman-au-id", m_sponsorId, ref vf);
r["signature"] = Verification.GetSha1(vf);
var p4 = await Projects.SaveNorminalBor(r);
if (!p4.IsOk)
{
Commons.ShowResultErrorBox(this, p4);
btnOk.Enabled = true;
return;
}
vf = "";
r.Clear();
r.AddVF("pid", m_pId, ref vf)
.AddVF("prj-rating", cbbPrjRating.Text.Trim(), ref vf)
.AddVF("s-all", (int)nudSAll.Value, ref vf)
.AddVF("prj-risk-assess", tbRiskAssess.Text.Trim(), ref vf);
r["signature"] = Verification.GetSha1(vf);
var p5 = await Projects.SaveRating(r);
if (!p5.IsOk)
{
Commons.ShowResultErrorBox(this, p5);
btnOk.Enabled = true;
return;
}
vf = "";
r.Clear();
r.AddVF("pid", m_pId, ref vf)
.AddVF("bonus-period", cbbBonusPeriod.GetSelectedValue(), ref vf);
if (nudBonusDay.Enabled)
{
r.AddVF("bonus-day", (int)nudBonusDay.Value, ref vf);
}
r["signature"] = Verification.GetSha1(vf);
var p6 = await Projects.SaveBonusPeriod(r);
if (!p6.IsOk)
{
Commons.ShowResultErrorBox(this, p6);
btnOk.Enabled = true;
return;
}
btnOk.Enabled = true;
DialogResult = DialogResult.OK;
}
private async void UpdateTable2()
{
var text = tbComments.Text.LeftStr(500);
if (rbNo.Checked)
{
if (text.Trim() == "")
{
Commons.ShowInfoBox(this, "审批不通过时必须输入备注");
tbComments.Focus();
return;
}
if (m_status == 50 || m_status == 70)
{
if (!Commons.ShowConfirmBox(this, "此时审批不通过会导致\"流标\"!确认吗？"))
{
return;
}
}
}
if (rbYes.Checked && m_status == 50)
{
var p = await Projects.IsExistsUncheckedTender(m_pId);
if (p.IsOk)
{
if (p.AsInt > 0)
{
Commons.ShowWarnBox(this, string.Format("存在{0}个状态未知的投标，请检查投标", p.AsInt));
return;
}
}
else
{
Commons.ShowResultErrorBox(this, p);
}
}
if (m_status == 60)
{
var reservedAmt = Commons.ShowDecimalInputDialog(this, 0, "金额(&A)", "输入财务核收服务费", 200);
if (reservedAmt == -1)
{
return;
}
var p = new Dictionary <string, object>();
p["pid"] = m_pId;
p["amt"] = reservedAmt;
var r = await Projects.SaveReservedAmt(p);
if (!r.IsOk)
{
Commons.ShowResultErrorBox(this, r);
}
}
if (m_status == 70)
{
if (m_statusSign == 0)
{
if (!Commons.ShowConfirmBox(this, "签章未完成，确认放款嘛？", "确认"))
{
return;
}
}
var password = Commons.ShowInputDialog(this, "密码(&P)", "操作人员身份验证", 200, null, true).Trim();
if (password == "")
{
return;
}
else if (!(await SignIn.ValidateUser(password)))
{
Commons.ShowInfoBox(this, "密码错误，禁止操作!");
return;
}
}
var isOk = rbYes.Visible ? rbYes.Checked : true;
var p2 = new Dictionary <string, object>();
p2["pid"] = m_pId;
p2["flag"] = isOk;
p2["comments"] = text;
Rpc.IResult r2;
switch (m_status)
{
case 0:
r2 = await Projects.PrjSubmit(p2);
break;
case 1:
r2 = await Projects.PrjMgrAudit(p2);
break;
case 10:
r2 = await Projects.PrjRiskCtrlAudit(p2);
break;
case 20:
r2 = await Projects.PrjBusSecAudit(p2);
break;
case 30:
r2 = await Projects.PrjBusVpAprOnline(p2);
break;
case 50:
r2 = await Projects.PrjBusVpConfirmFull(p2);
break;
case 60:
r2 = await Projects.PrjCheckFee(p2);
break;
case 70:
r2 = await Projects.PrjBusVpConfirmLoan(p2);
break;
default:
return;
}
if (r2.IsOk)
{
if (!Convert.ToBoolean(r2.AsBoolean))
{
Commons.ShowInfoBox(this, "业务操作失败!");
}
}
else
{
Commons.ShowResultErrorBox(this, r2);
}
DialogResult = DialogResult.OK;
}
private async void UpdateTable()
{
if (CrmCommons.IsAll(m_selUName) && string.IsNullOrWhiteSpace(tbKeys.Text))
{
Commons.ShowInfoBox(this, "请输入关键字");
return;
}
btnSearch.Enabled = false;
var age = cbbAge.ComboBox.GetSelectedValue();
var gender = cbbGender.ComboBox.GetSelectedValue();
var userType = cbbAccType.ComboBox.GetSelectedValue();
var status = cbbAccStatus.ComboBox.GetSelectedValue();
var d = new Dictionary <string, object>();
d["u-name"] = m_selUName;
d["search-key"] = tbKeys.Text.Trim();
if (age != Commons.AllValue)
{
d["age"] = age;
}
if (gender != Commons.AllValue)
{
d["gender"] = gender;
}
if (userType != Commons.AllValue)
{
d["user-type"] = userType;
}
if (status != Commons.AllValue)
{
d["jx-status"] = status;
}
var p = await CrmInvestor.MyRegUsers(d);
if (p.IsOk)
{
myGridViewBinding1.DataTable.Clear();
var ids = p.AsList;
if (ids.Count == 0)
{
myGridViewBinding1.DataTable = null;
btnSearch.Enabled = true;
return;
}
var dlg = new BatchProcessDlg(ids.Select <object, long>(o => Convert.ToInt64(o)).ToList());
dlg.StartPosition = FormStartPosition.CenterParent;
var d2 = new Dictionary <string, object>();
d2["datepoint"] = dtpSearchDate.Value;
var todayInvestAmt = 0M;
var todayRepayCapitalAmt = 0M;
var todayRechargeAmt = 0M;
var todayWithdrawAmt = 0M;
var investRemainAmt = 0M;
var investCount = 0L;
var sumInvestAmt = 0M;
dlg.RunSingle += (id) => {
var m = CrmInvestor.MyRegUserDetail(id, d2).Result;
myGridViewBinding1.BindTo(m, Commons.BindFlag.Update, "auId");
var dic = m.AsDictionary;
todayInvestAmt += Convert.ToDecimal(dic["todayInvestAmt"]);
todayRepayCapitalAmt += Convert.ToDecimal(dic["todayRepayCapitalAmt"]);
todayRechargeAmt += Convert.ToDecimal(dic["todayRechargeAmt"]);
todayWithdrawAmt += Convert.ToDecimal(dic["todayWithdrawAmt"]);
investRemainAmt += Convert.ToDecimal(dic["investRemainAmt"]);
investCount += Convert.ToInt64(dic["investCount"]);
sumInvestAmt += Convert.ToDecimal(dic["sumInvestAmt"]);
return(m);
};
dlg.ShowDialog();
var sumRow = new List <object>();
//ID
sumRow.Add("");
//用户名
sumRow.Add("<总计>");
//姓名
sumRow.Add("");
//性别
sumRow.Add(0L);
//年龄
sumRow.Add(null);
//手机
sumRow.Add("");
//注册时间
sumRow.Add(null);
//类型
sumRow.Add(null);
//状态
sumRow.Add(null);
//分配时间
sumRow.Add(null);
//投资
sumRow.Add(todayInvestAmt);
//还本
sumRow.Add(todayRepayCapitalAmt);
//充值
sumRow.Add(todayRechargeAmt);
//提现
sumRow.Add(todayWithdrawAmt);
//投资余额
sumRow.Add(investRemainAmt);
//当月投资次数
sumRow.Add(investCount);
//累计投资额
sumRow.Add(sumInvestAmt);
//绑卡时间
sumRow.Add(null);
myGridViewBinding1.DataTable.Add(sumRow);
myGridViewBinding1.InvalidateView();
//var dl = new JArray();
//var temp = new List<string>();
//foreach (var result in dlg.AllResult) {
// dl.Add(JObject.Parse(result.AsString));
//}
//var sum = new JObject();
//sum["auId"] = "统计";
//sum["gender"] = 0;
//sum["todayInvestAmt"] = 0;
//sum["todayRepayCapitalAmt"] = 0;
//sum["todayRechargeAmt"] = 0;
//sum["todayWithdrawAmt"] = 0;
//sum["investCount"] = 0;
//sum["investRemainAmt"] = 0;
//sum["sumInvestAmt"] = 0;
//foreach (var l in dl) {
// foreach (var j in sum) {
// sum[j.Key] = j.Value.ToDecimal() + l[j.Key].ToDecimal();
// }
//}
// dl.Add(sum);
//myGridViewBinding1.BindTo(new JsonResult(dl.ToString()));
}
else
{
Commons.ShowResultErrorBox(this, p);
}
btnSearch.Enabled = true;
}
private async void SaveData()
{
btnOk.Enabled = false;
try {
var data = new Dictionary <string, object>();
data["bpm-id"] = m_bpmId;
//借款人信息
data["real-name"] = tbRealName.Text.Trim();
data["show-name"] = tbShowName.Text.Trim();
data["mobile"] = tbMobile.Text.Trim();
data["gender"] = cbbGenders.GetSelectedValue();
data["age"] = tbAge.Text.Trim();
data["show-age"] = tbShowAge.Text.Trim();
data["id-card"] = tbIdCard.Text.Trim();
data["id-card-address-prov"] = tbProvince.Text.Trim();
data["id-card-address-city"] = tbCity.Text.Trim();
data["email"] = tbEmail.Text.Trim();
data["address"] = tbAddress.Text.Trim();
data["show-address"] = tbShowAddress.Text.Trim();
data["company"] = tbCompany.Text.Trim();
data["position"] = tbPosition.Text.Trim();
data["work-years"] = tbWorkYear.Text.Trim();
data["fax"] = tbFax.Text.Trim();
data["wchat"] = tbWechat.Text.Trim();
data["industry"] = tbIndustry.Text.Trim();
data["work-nature"] = cbbWorkNature.Text;
data["other-info"] = tbOtherInfo.Text;
//联系人信息
data["linkman-name"] = tbLinkManName.Text.Trim();
data["linkman-show-name"] = tbShowLinkManName.Text.Trim();
data["linkman-mobile"] = tbLinkManMobile.Text.Trim();
data["linkman-email"] = tbLinkManEmail.Text.Trim();
data["linkman-wchat"] = tbLinkManWeChat.Text.Trim();
data["linkman-fax"] = tbLinkManFax.Text.Trim();
data["linkman-id-card"] = tbLinkManIdCard.Text.Trim();
data["linkman-address"] = tbLinkManAddress.Text.Trim();
data["linkman-show-address"] = tbShowLinkManAddress.Text.Trim();
data["intro"] = tbIntro.Text.Trim();
IResult r;
if (m_bpmId == 0)
{
r = await PrjBorPersons.Create(data);
}
else
{
r = await PrjBorPersons.Update(data);
}
if (r.IsOk)
{
DlgResult = r;
DialogResult = DialogResult.OK;
}
else
{
Commons.ShowResultErrorBox(this, r);
}
} finally {
btnOk.Enabled = true;
}
}
private async void UpdateTable1()
{
btnSearch.Enabled = false;
var timeType = cbbTimeTypes.ComboBox.GetSelectedValue();
var status = cbStatus.ComboBox.GetSelectedValue();
var type = cbTypes.ComboBox.GetSelectedValue();
var key = tbKey.Text.Trim();
var prjType = cbbPrjType.ComboBox.GetSelectedValue();
var p = new Dictionary <string, object>();
switch (timeType)
{
case "1":
p["start-time"] = startDate.Value.TruncToStart();
p["end-time"] = endDate.Value.TruncToEnd();
break;
case "2":
p["on-line-start-time"] = startDate.Value.TruncToStart();
p["on-line-end-time"] = endDate.Value.TruncToEnd();
break;
case "3":
p["loan-start-time"] = startDate.Value.TruncToStart();
p["loan-end-time"] = endDate.Value.TruncToEnd();
break;
}
if (prjType != Commons.AllValue)
{
p["type"] = prjType;
}
if (status != Commons.AllValue)
{
p["status"] = status;
}
switch (type)
{
case "1":
p["item-no-key"] = key;
break;
case "2":
p["item-name-key"] = key;
break;
case "3":
p["financier-key"] = key;
break;
case "4":
p["creator-key"] = key;
break;
}
var r = await Projects.GetAllPrjs(p);
if (r.IsOk)
{
this.myGridViewBinding1.BindTo(r);
}
else
{
Commons.ShowResultErrorBox(this, r);
}
btnSearch.Enabled = true;
}
private async void UpdateTable1()
{
btnUpdate.Enabled = false;
wbInfo.DocumentText = "";
var r = await Projects.Investors(m_pId);
if (r.IsOk)
{
var rows = JArray.Parse(r.AsString).ToList();
string info;
info = string.Format(@"<table border=1 cellspacing=0 align=center>
<tr><th width=80 {0}>序号</th>
<th width=100 {0}>姓名/名称</th>
<th width=250 {0}>身份证号/统一社会信用代码</th>
<th width=150 {0}>手机</th>
<th width=150 {0}>电子邮箱</th>
<th width=150 {0}>出借金额</th></tr>",
"bgcolor=#A9A9A9 ");
if (rows.Count == 0)
{
info += "</table>";
wbInfo.DocumentText = info;
btnUpdate.Enabled = true;
Commons.ShowInfoBox(this, "未查询到数据!");
return;
}
int index = 1;
foreach (var row in rows)
{
string name, code, mobile, email, temp;
decimal amt;
name = row["name"].ToStdString();
name = name[0].ToString().PadRight(name.Length, '*');
code = row["code"].ToStdString();
code = code.LeftStr(6).PadRight(code.Length - 4, '*') + code.RightStr(4);
mobile = row["mobile"].ToStdString();
mobile = mobile.LeftStr(3).PadRight(mobile.Length - 4, '*') + mobile.RightStr(4);
email = row["email"].ToStdString();
amt = row["amt"].ToDecimal();
temp = 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:N}</td></tr>",
"align=center valign=middle", index, name, code, mobile, email, amt);
++index;
info += temp;
}
info += "</table>";
wbInfo.DocumentText = info;
}
else
{
Commons.ShowResultErrorBox(this, r);
}
btnUpdate.Enabled = true;
}
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;
}
