private void BindBorrowListDataGrid(List<QueryElement> list) { BorrowORLoanCollection coll = BorrowedMethods.GetBorrowList(list); this.BorrowListDataGrid.DataSource = coll; this.BorrowListDataGrid.DataBind(); for (int i = 0; i < coll.Count; i++) { CardInfo cardInfo = CardMethods.GetCardById(coll[i].BorrowORLoanAccountId); string bank = StaticRescourse.DisplayBank(cardInfo.BankId); this.BorrowListDataGrid.Items[i].Cells[4].Text = coll[i].BorrowedAccount + " " + bank; this.BorrowListDataGrid.Items[i].Cells[8].Text = coll[i].HappenedDate.ToString("yyyy-MM-dd"); this.BorrowListDataGrid.Items[i].Cells[2].Text = StaticRescourse.DisplayBorrowORLoanType(coll[i].BorrowORLoanType); bool dateFlag = HelperCommon.CompareAccordToRequired(coll[i].ReturnDate); if (dateFlag) { this.BorrowListDataGrid.Items[i].Cells[9].Text = coll[i].ReturnDate.ToString("yyyy-MM-dd"); } else { this.BorrowListDataGrid.Items[i].Cells[9].Text = string.Empty; } if (coll[i].Status == 2) { this.BorrowListDataGrid.Items[i].Cells[10].Text = "已还"; } else { this.BorrowListDataGrid.Items[i].Cells[10].Text = "未还"; } } }
private void BindDataGrid(List <QueryElement> list) { cardColl = CardMethods.GetCard(list); this.CardListDataGrid.DataSource = cardColl; this.CardListDataGrid.DataBind(); for (int i = 0; i < cardColl.Count; i++) { this.CardListDataGrid.Items[i].Cells[2].Text = StaticRescourse.DisplayAccountType(cardColl[i].AccountType); this.CardListDataGrid.Items[i].Cells[3].Text = StaticRescourse.DisplayBank(cardColl[i].BankId); } }
/// <summary> /// 初始化卡号(新增) /// </summary> private void InitializeDropExpensesDropControl() { List <CardHelper> cardNumberList = new List <CardHelper>(); List <CardHelper> cxList = new List <CardHelper>(); CardCollection cardcoll = new CardCollection(); //返回的卡的collection cardcoll = CardMethods.GetCard(new List <QueryElement>()); List <DropItem> card = new List <DropItem>(); card.Add(new DropItem { ValueField = "", DisplayField = " " }); for (int i = 0; i < cardcoll.Count; i++) { CardInfo info = cardcoll[i]; cardNumberList.Add(new CardHelper { CardId = info.Id, BankId = info.BankId, CardNumber = info.CardNumber }); } cxList.AddRange(cardNumberList.OrderBy(x => x.CardNumber)); cardNumberList.Clear(); for (int i = 0; i < cxList.Count; i++) { if (i == 0 || cxList[i].CardNumber != cxList[i - 1].CardNumber) { cardNumberList.Add(new CardHelper { CardId = cxList[i].CardId, BankId = cxList[i].BankId, CardNumber = cxList[i].CardNumber }); } } for (int i = 0; i < cardNumberList.Count; i++) { var cardInfo = cardNumberList[i]; string bank = StaticRescourse.DisplayBank(cardInfo.BankId); card.Add(new DropItem { ValueField = cardInfo.CardId.ToString(), DisplayField = cardInfo.CardNumber + " " + bank }); // +" "+bank } this.dropExpensesAddCardNumber.DataSource = card; Helper.SetDropDownList(this.dropExpensesAddCardNumber); this.dropExpensesAddSpendMode.DataSource = StaticRescourse.GetSpendMode(); Helper.SetDropDownList(this.dropExpensesAddSpendMode); this.dropExpensesAddSpendType.DataSource = StaticRescourse.GetSpendType(); Helper.SetDropDownList(this.dropExpensesAddSpendType); }
private void BindExpensesListDataGrid(List <QueryElement> list) { ExpensesCollection coll = ExpensesMethods.GetExpensesList(list); this.ExpensesListDataGrid.DataSource = coll; this.ExpensesListDataGrid.DataBind(); for (int i = 0; i < coll.Count; i++) { ExpensesInfo expenses = coll[i]; CardInfo cardInfo = CardMethods.GetCardByCardNumber(expenses.CardNumber, expenses.OwnerId); string bank = StaticRescourse.DisplayBank(cardInfo.BankId); this.ExpensesListDataGrid.Items[i].Cells[4].Text = StaticRescourse.DisplaySpendType(expenses.SpendType); this.ExpensesListDataGrid.Items[i].Cells[6].Text = expenses.SpendDate.ToString("yyyy-MM-dd"); this.ExpensesListDataGrid.Items[i].Cells[7].Text = StaticRescourse.DisplaySpendMode(expenses.SpendMode); } }
private void BindIncomeListDataGrid(List <QueryElement> list) { CashIncomeCollection coll = CashIncomeMethods.GetCashIncome(list); this.IncomeListDataGrid.DataSource = coll; this.IncomeListDataGrid.DataBind(); for (int i = 0; i < coll.Count; i++) { CashIncomeInfo cashInfo = coll[i]; CardInfo cardInfo = CardMethods.GetCardByCardNumber(cashInfo.CardNumber, cashInfo.OwnerId); string bank = StaticRescourse.DisplayBank(cardInfo.BankId); this.IncomeListDataGrid.Items[i].Cells[1].Text = StaticRescourse.DisplayIncomeStatus(cashInfo.Status); this.IncomeListDataGrid.Items[i].Cells[4].Text = StaticRescourse.DisplayIncomeType(cashInfo.IncomeType); this.IncomeListDataGrid.Items[i].Cells[6].Text = StaticRescourse.DisplayMode(cashInfo.Mode); this.IncomeListDataGrid.Items[i].Cells[7].Text = StaticRescourse.DisplayRate(cashInfo.Rate); this.IncomeListDataGrid.Items[i].Cells[8].Text = cashInfo.DepositDate.ToString("yyyy-MM-dd"); if (cashInfo.AutoSave == 1) { this.IncomeListDataGrid.Items[i].Cells[12].Text = "是"; } else { this.IncomeListDataGrid.Items[i].Cells[12].Text = "否"; } if (HelperCommon.CompareAccordToRequired(cashInfo.BDate)) { this.IncomeListDataGrid.Items[i].Cells[9].Text = cashInfo.BDate.ToString("yyyy-MM-dd"); } else { this.IncomeListDataGrid.Items[i].Cells[9].Text = string.Empty; } if (HelperCommon.CompareAccordToRequired(cashInfo.EDate)) { this.IncomeListDataGrid.Items[i].Cells[10].Text = cashInfo.EDate.ToString("yyyy-MM-dd"); } else { this.IncomeListDataGrid.Items[i].Cells[10].Text = string.Empty; } this.IncomeListDataGrid.Items[i].Cells[13].Text = StaticRescourse.DisplayIncomeDepositMode(cashInfo.DepositMode); } }
public static List <DropItem> getLoanAccountByPerson(string loanName) { UserInfo userInfo = UserMethods.GetUserByName(loanName); if (userInfo.Id > 0) { CardCollection coll = CardMethods.GetCardByUserId(userInfo.Id); List <DropItem> list = new List <DropItem>(); //list.Add(new DropItem { ValueField = "", DisplayField = " " }); for (int i = 0; i < coll.Count; i++) { string bank = StaticRescourse.DisplayBank(coll[i].BankId); list.Add(new DropItem { ValueField = coll[i].Id.ToString(), DisplayField = coll[i].CardNumber + " " + bank }); } return(list); } return(new List <DropItem>()); }
/// <summary> /// 初始化卡号(新增) /// </summary> private void InitializeDropIncomeCardNumber() { CardCollection cardcoll = new CardCollection(); List <QueryElement> list = new List <QueryElement>(); cardcoll = CardMethods.GetCard(list); List <DropItem> card = new List <DropItem>(); card.Add(new DropItem { ValueField = "", DisplayField = " " }); for (int i = 0; i < cardcoll.Count; i++) { CardInfo cardInfo = cardcoll[i]; string bank = StaticRescourse.DisplayBank(cardInfo.BankId); card.Add(new DropItem { ValueField = cardInfo.Id.ToString(), DisplayField = cardInfo.CardNumber + " " + bank }); // +" "+bank } this.dropIncomeAddCardNumber.DataSource = card; Helper.SetDropDownList(this.dropIncomeAddCardNumber); this.dropIncomeAddCardNumber.SelectedValue = string.Empty; }
protected void btnIncomeEditSave_Click(object sender, EventArgs e) { CashIncomeInfo info = new CashIncomeInfo(); #region 验证 if (Session["editFlag"].Equals("true")) { this.ClientScript.RegisterStartupScript(this.GetType(), "", "DisplayEditIncomediv();", true); info.Id = Convert.ToInt32(Request.QueryString["IncomeId"]); } else { this.ClientScript.RegisterStartupScript(this.GetType(), "", "DisplayAddIncomediv();", true); } if (string.IsNullOrEmpty(this.dropIncomeAddCardNumber.SelectedValue)) { Alert.Show(this, "请选择卡号!"); this.dropIncomeAddCardNumber.Focus(); return; } if (string.IsNullOrEmpty(this.dropIncomeAddInComeType.SelectedValue)) { Alert.Show(this, "请输入收入类型!"); this.dropIncomeAddInComeType.Focus(); return; } if (string.IsNullOrEmpty(this.dropIncomeAddMode.SelectedValue)) { Alert.Show(this, "请输入存款状态!"); this.dropIncomeAddMode.Focus(); return; } if (string.IsNullOrEmpty(this.txtIncomeAddAmount.Text.Trim())) { Alert.Show(this, "请输入收入金额!"); this.txtIncomeAddAmount.Focus(); return; } if (string.IsNullOrEmpty(this.dropIncomeAddRate.SelectedValue)) { Alert.Show(this, "请输入利率!"); this.dropIncomeAddRate.Focus(); return; } if (string.IsNullOrEmpty(this.txtIncomeAddDepositDate.Text.Trim())) { Alert.Show(this, "请输入存款日期!"); this.txtIncomeAddDepositDate.Focus(); return; } if (string.IsNullOrEmpty(this.txtIncomeAddDepositorName.Text.Trim())) { Alert.Show(this, "请输入存款人!"); this.txtIncomeAddDepositDate.Focus(); return; } if (!string.IsNullOrEmpty(this.txtIncomeAddBDate.Text.Trim()) || !string.IsNullOrEmpty(this.txtIncomeAddEDate.Text.Trim())) { if (!string.IsNullOrEmpty(this.txtIncomeAddBDate.Text.Trim()) && string.IsNullOrEmpty(this.txtIncomeAddEDate.Text.Trim())) { Alert.Show(this, "请输入到期日期!"); this.txtIncomeAddEDate.Focus(); return; } else if (string.IsNullOrEmpty(this.txtIncomeAddBDate.Text.Trim()) && !string.IsNullOrEmpty(this.txtIncomeAddEDate.Text.Trim())) { Alert.Show(this, "请输入定存开始日期!"); this.txtIncomeAddBDate.Focus(); return; } else { bool comparflag = true; comparflag = HelperCommon.ValidDateTime(string.Format("{0:d}", this.txtIncomeAddBDate.Text.Trim()), string.Format("{0:d}", this.txtIncomeAddEDate.Text.Trim())); if (!comparflag) { Alert.Show(this, "到期日期不能小于开始日期"); this.txtIncomeAddEDate.Focus(); return; } comparflag = HelperCommon.ComparDay(string.Format("{0:d}", this.txtIncomeAddBDate.Text.Trim()), string.Format("{0:d}", this.txtIncomeAddEDate.Text.Trim())); if (!comparflag) { Alert.Show(this, "定存日期必须大于等于三个月!"); this.txtIncomeAddEDate.Focus(); return; } } } if (string.IsNullOrEmpty(this.dropIncomeAddStatus.SelectedValue)) { Alert.Show(this, "请选择收入状态!"); this.dropIncomeAddStatus.Focus(); return; } if (string.IsNullOrEmpty(this.dropIncomeAddDepositMode.SelectedValue)) { Alert.Show(this, "请选存款方式!"); this.dropIncomeAddDepositMode.Focus(); return; } if (string.IsNullOrEmpty(this.txtIncomeAddOwner.Text.Trim())) { Alert.Show(this, "请输入资产所有者!"); this.txtIncomeAddOwner.Focus(); return; } #endregion #region 赋值 UserInfo userInfo = UserMethods.GetUserByName(this.txtIncomeAddOwner.Text.Trim()); info.OwnerName = this.txtIncomeAddOwner.Text.Trim(); userInfo = UserMethods.GetUserByName(this.txtIncomeAddOwner.Text.Trim()); if (userInfo.Id > 0) { info.OwnerId = userInfo.Id; } else { info.OwnerId = 0; } CardInfo cardInfo = CardMethods.GetCardById(Convert.ToInt32(this.dropIncomeAddCardNumber.SelectedValue)); info.CardNumber = cardInfo.CardNumber; info.BankCardNumber = cardInfo.CardNumber + " " + StaticRescourse.DisplayBank(cardInfo.BankId); info.CardId = Convert.ToInt32(this.dropIncomeAddCardNumber.SelectedItem.Value); info.IncomeAmount = Convert.ToSingle(this.txtIncomeAddAmount.Text.Trim()); info.PreMode = Convert.ToInt32(this.dropIncomeAddPreMode.SelectedValue); info.Mode = Convert.ToInt32(this.dropIncomeAddMode.SelectedValue); info.PreRate = Convert.ToInt32(this.dropIncomeAddPreRate.SelectedValue); info.Rate = Convert.ToInt32(this.dropIncomeAddRate.SelectedValue); info.DepositDate = HelperCommon.ConverToDateTime(string.Format("{0:d}", this.txtIncomeAddDepositDate.Text.Trim())); if (!string.IsNullOrEmpty(this.txtIncomeAddBDate.Text.Trim())) { info.BDate = HelperCommon.ConverToDateTime(string.Format("{0:d}", this.txtIncomeAddBDate.Text.Trim())); } if (!string.IsNullOrEmpty(this.txtIncomeAddEDate.Text.Trim())) { info.EDate = HelperCommon.ConverToDateTime(string.Format("{0:d}", this.txtIncomeAddEDate.Text.Trim())); } if (this.checkIncomeAddAutoSave.Checked) { info.AutoSave = 1; } else { info.AutoSave = 0; } userInfo = UserMethods.GetUserByName(this.txtIncomeAddDepositorName.Text.Trim()); if (userInfo.Id > 0) { info.DepositorId = userInfo.Id; } else { info.DepositorId = 0; } info.DepositorName = this.txtIncomeAddDepositorName.Text.Trim(); info.DepositMode = Convert.ToInt32(this.dropIncomeAddDepositMode.SelectedValue); info.Status = Convert.ToInt32(this.dropIncomeAddStatus.SelectedValue); info.IncomeType = Convert.ToInt32(this.dropIncomeAddInComeType.SelectedValue); info.TAmount = info.IncomeAmount; info.Content = !string.IsNullOrEmpty(this.txtIncomeAddContent.Text.Trim()) ? this.txtIncomeAddContent.Text.Trim() : string.Empty; #endregion int iSuccess = CashIncomeMethods.InsertOrUpdatetocashincome(info); this.ClientScript.RegisterStartupScript(this.GetType(), "", "DisplayAddIncomediv();", true); if (iSuccess > 0) { Alert.Show(this, "新增一条收入成功!"); } else if (iSuccess == -1) { Alert.Show(this, "修改成功!"); } else { Alert.Show(this, "操作失败!"); } InitializeIncomeAdd(new CashIncomeInfo()); queryList = new List <QueryElement>(); BindIncomeListDataGrid(queryList); }