/// <summary> /// 获取公司银行列表 /// </summary> /// <param name="companyID"></param> /// <returns></returns> private string GetCompanyBankList(int companyID) { DataTable dtBankList = ComBankManager.getList(companyID); StringBuilder htmlBuilder = new StringBuilder(); EtNet_Models.Company company = CompanyManager.getCompanyById(companyID); if (company != null) { htmlBuilder.AppendFormat("<option value=\"{0}\">", company.CardId + "$" + company.CardName + "$" + company.Remark); //htmlBuilder.Append("<option value=\"0\">"); htmlBuilder.Append(company.Bank); htmlBuilder.Append("</option>"); } if (dtBankList.Rows.Count > 0) { int rowCount = dtBankList.Rows.Count; for (int i = 0; i < rowCount; i++) { DataRow currentRow = dtBankList.Rows[i]; htmlBuilder.AppendFormat("<option value=\"{0}\">", currentRow["id"]); htmlBuilder.Append(currentRow["bank"]); htmlBuilder.Append("</option>"); } } return(htmlBuilder.ToString()); }
//读取其他银行信息 private void loadOtherLink() { string id = Request.QueryString["id"].ToString(); DataTable dt = ComBankManager.getList(Convert.ToInt32(id)); if (dt.Rows.Count > 0) { HtmlTableRow row = null; HtmlTableCell cell = null; for (int i = 0; i < dt.Rows.Count; i++) { row = new HtmlTableRow(); cell = new HtmlTableCell(); cell.InnerHtml = dt.Rows[i]["bank"].ToString(); row.Controls.Add(cell); cell = new HtmlTableCell(); cell.InnerHtml = dt.Rows[i]["cardId"].ToString(); row.Controls.Add(cell); cell = new HtmlTableCell(); cell.InnerHtml = dt.Rows[i]["cardName"].ToString(); row.Controls.Add(cell); cell = new HtmlTableCell(); cell.InnerHtml = dt.Rows[i]["remark"].ToString(); row.Controls.Add(cell); this.tablebank.Controls.Add(row); } } }
private void loadbank() { string id = Request.QueryString["id"].ToString(); DataTable tbl = ComBankManager.getList(Convert.ToInt32(id)); if (tbl.Rows.Count >= 1) { HtmlTableRow row = null; HtmlTableCell cell = null; for (int i = 0; i < tbl.Rows.Count; i++) { if (i == 0) { row = this.tablebank.Controls[1] as HtmlTableRow; cell = row.Controls[0] as HtmlTableCell; cell.InnerHtml = "<input type='text' value='" + tbl.Rows[i]["bank"] + "' class='clsblurtxt clsedit' />"; cell = row.Controls[1] as HtmlTableCell; cell.InnerHtml = "<input type='text' value='" + tbl.Rows[i]["cardId"] + "' class='clsblurtxt clsedit' />"; cell = row.Controls[2] as HtmlTableCell; cell.InnerHtml = "<input type='text' value='" + tbl.Rows[i]["cardName"] + "' class='clsblurtxt clsedit' />"; cell = row.Controls[3] as HtmlTableCell; cell.InnerHtml = "<input type='text' value='" + tbl.Rows[i]["remark"] + "' class='clsblurtxt clsedit' />"; } else { row = new HtmlTableRow(); cell = new HtmlTableCell(); cell.InnerHtml = "<input type='text' value='" + tbl.Rows[i]["bank"] + "' class='clsblurtxt clsedit' />"; row.Controls.Add(cell); cell = new HtmlTableCell(); cell.InnerHtml = "<input type='text' value='" + tbl.Rows[i]["cardId"] + "' class='clsblurtxt clsedit' />"; row.Controls.Add(cell); cell = new HtmlTableCell(); cell.InnerHtml = "<input type='text' value='" + tbl.Rows[i]["cardName"] + "' class='clsblurtxt clsedit' />"; row.Controls.Add(cell); cell = new HtmlTableCell(); cell.InnerHtml = "<input type='text' value='" + tbl.Rows[i]["remark"] + "' class='clsblurtxt clsedit' />"; row.Controls.Add(cell); cell = new HtmlTableCell(); cell.InnerHtml = "<div title='删除' class='clsimgdel'> </div>"; row.Controls.Add(cell); this.tablebank.Controls.Add(row); } } } }
/// <summary> /// 绑定公司银行列表 /// </summary> private void FillCompanyBank(DataTable dtBankList, int companyID) { EtNet_Models.Company company = CompanyManager.getCompanyById(companyID); if (company != null && company.Bank.Trim() != string.Empty) { DataRow newRow = dtBankList.NewRow(); newRow["bankId"] = 0; newRow["bankName"] = company.Bank;// string.Format("{0}(主银行)", company.Bank); newRow["bankAccount"] = company.CardId; newRow["bankUser"] = company.CardName; newRow["bankMark"] = company.Remark; dtBankList.Rows.Add(newRow); } DataTable dtCompanyBankList = ComBankManager.getList(companyID); if (dtCompanyBankList.Rows.Count > 0) { int rowCount = dtCompanyBankList.Rows.Count; for (int i = 0; i < rowCount; i++) { DataRow currentRow = dtCompanyBankList.Rows[i]; DataRow newRow = dtBankList.NewRow(); newRow["bankId"] = currentRow["id"]; newRow["bankName"] = currentRow["bank"]; newRow["bankAccount"] = currentRow["cardId"]; newRow["bankUser"] = currentRow["cardName"]; newRow["bankMark"] = currentRow["remark"]; dtBankList.Rows.Add(newRow); } } }