/// <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);
}
}
}
/// <summary>
/// 添加其他银行
/// </summary>
private void addcombank()
{
string banklist = this.hidbank.Value; //得到其他银行信息
if (banklist != "")
{
string[] row = null;
string[] cell = null;
EtNet_Models.ComBank combank = null;
if (banklist.IndexOf(',') >= 0)
{
row = banklist.Split(',');
}
else
{
row = new string[1] {
banklist
};
}
for (int i = 0; i < row.Length; i++)
{
combank = new ComBank();
cell = row[i].Split('|');
combank.Bank = cell[0]; //开户银行
combank.CardId = cell[1]; //银行账号
combank.CardName = cell[2]; //户名
combank.Remark = cell[3]; //备注
combank.CompanyId = CompanyManager.getLastOneID().Id;
ComBankManager.addComBank(combank);
}
}
}
/// <summary>
/// 获取公司银行信息
/// </summary>
/// <param name="bankID"></param>
/// <returns></returns>
private string GetCompanyBankInfo(int bankID)
{
string result = string.Empty;
EtNet_Models.ComBank bankInfo = ComBankManager.getComBankById(bankID);
if (bankInfo != null)
{
result = string.Format("{0}\"account\":\"{1}\",\"accountname\":\"{2}\",\"mark\":\"{3}\"{4}"
, "{", bankInfo.CardId, bankInfo.CardName, bankInfo.Remark, "}");
}
return(result);
}
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);
}
}
}
private void addcombank()
{
string id = Request.QueryString["id"].ToString();
ComBankManager.deleteComBankByComId(Convert.ToInt32(id));
string banklist = this.hidbank.Value;
if (banklist != "")
{
string[] row = null;
string[] cell = null;
EtNet_Models.ComBank combank = null;
if (banklist.IndexOf(',') >= 0)
{
row = banklist.Split(',');
}
else
{
row = new string[1] {
banklist
};
}
for (int i = 0; i < row.Length; i++)
{
combank = new ComBank();
cell = row[i].Split('|');
combank.Bank = cell[0];
combank.CardId = cell[1];
combank.CardName = cell[2];
combank.Remark = cell[3];
combank.CompanyId = Convert.ToInt32(id);
ComBankManager.addComBank(combank);
}
}
}
