/// <summary> /// 根据选择银行加载银行账号 /// </summary> private void LoadBankAccount() { if (DdlBank.SelectedIndex < 0) { return; } FirmAccountInfo bankInfo = FirmAccountInfoManager.GetModel(int.Parse(DdlBank.SelectedValue)); txtBankAccount.Text = bankInfo.account.Trim(); }
public string getamount(object id) { int firmid = 0; int.TryParse(id.ToString(), out firmid); FirmAccountInfo model = FirmAccountInfoManager.GetModel(firmid); decimal collect = FirmAccountInfoManager.GetMoneySum(id.ToString(), "1", model.ystime.ToString("yyyy-MM-dd")); decimal pay = FirmAccountInfoManager.GetMoneySum(id.ToString(), "0", model.ystime.ToString("yyyy-MM-dd")); return((model.amount + collect - pay).ToString()); }
/// <summary> /// 选择银行之后显示帐号信息 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void ddlBank_SelectedIndexChanged(object sender, EventArgs e) { if (ddlBank.SelectedIndex > 0) { FirmAccountInfo bankInfo = FirmAccountInfoManager.GetModel(int.Parse(ddlBank.SelectedValue)); this.lblBankAccount.Text = bankInfo.account.Trim(); } else { this.lblBankAccount.Text = ""; } }
/// <summary> /// 初始化数据table /// </summary> /// <returns></returns> private DataTable initializeDataTable() { if (dtExpense != null && dtExpense.Rows.Count > 0) { return(dtExpense); } else { string bankId = Request.QueryString["bankid"]; if (!string.IsNullOrEmpty(bankId)) { FirmAccountInfo accountinfo = FirmAccountInfoManager.GetModel(int.Parse(bankId)); string sqlstr = " and comebankid = " + bankId; sqlstr += accountinfo.ystime.ToString() != "" ? " and comedate >='" + accountinfo.ystime.ToString("yyyy-MM-dd") + "' " : ""; decimal preinstallMoney = accountinfo.amount; //得到账户预设余额 DataTable dt = FirmAccountInfoManager.GetExpense(sqlstr, "comedate asc"); dt.Columns.Add("balance"); //增加余额一列 for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["InMoney"].ToString() == "-") // 表示是一条付款记录 { decimal d = 0; decimal.TryParse(dt.Rows[i]["OutMoney"].ToString(), out d); preinstallMoney -= d; dt.Rows[i]["balance"] = preinstallMoney.ToString("0.00"); } else //一条收款记录 { decimal d = 0; decimal.TryParse(dt.Rows[i]["InMoney"].ToString(), out d); preinstallMoney += d; dt.Rows[i]["balance"] = preinstallMoney.ToString("0.00"); } } dtExpense = dt.Copy(); dtExpense.Columns["comedate"].DataType = typeof(DateTime); return(dtExpense); } else { return(null); } } }