//读取其他银行信息
private void loadOtherLink()
{
string id = Request.QueryString["id"].ToString();
DataTable dt = CusBankManager.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>
/// <param name="customerID"></param>
/// <returns></returns>
private string GetCustomerBankList(int customerID)
{
DataTable dtBankList = CusBankManager.getList(customerID);
StringBuilder htmlBuilder = new StringBuilder();
EtNet_Models.Customer customer = CustomerManager.getCustomerById(customerID);
if (customer != null && customer.Bank.Trim() != string.Empty)
{
htmlBuilder.AppendFormat("<option value=\"{0}\">", customer.CardId + "$" + customer.CardName + "$" + customer.Remark);
//htmlBuilder.Append("<option value=\"0\">");
htmlBuilder.Append(customer.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());
}
protected void ibtnDeleteAll_Click(object sender, ImageClickEventArgs e)
{
string delId = "";
//先遍历取得选中项
for (int i = 0; i < this.rpCustomer.Items.Count; i++)
{
CheckBox cbx = (CheckBox)(rpCustomer.Items[i].FindControl("cbx"));
Label lbl = (Label)rpCustomer.Items[i].FindControl("lbl");
if (cbx != null || cbx.Text != "")
{
if (cbx.Checked)
{
delId += lbl.Text + ",";
}
}
}
//去掉最后一个,
delId = (delId + ")").Replace(",)", "");
IList check = delId.Split(',');
for (int i = 0; i < check.Count; i++)
{
Customer customer = CustomerManager.getCustomerById(Convert.ToInt32(check[i]));
if (customer != null)
{
CusBankManager.deleteCusBankByCusId(customer.Id);
CusLinkmanManager.deleteCusLinkmanByCusId(customer.Id);
CustomerManager.deleteCustomer(customer.Id);
}
}
dataBind();
}
//其他银行
private void addbank(int cusid)
{
string banklist = this.hidbank.Value;
if (banklist != "")
{
string[] row = null;
string[] cell = null;
EtNet_Models.CusBank cusbank = null;
if (banklist.IndexOf(',') >= 0)
{
row = banklist.Split(',');
}
else
{
row = new string[1] {
banklist
};
}
for (int i = 0; i < row.Length; i++)
{
cusbank = new EtNet_Models.CusBank();
cell = row[i].Split('|');
cusbank.Bank = cell[0];
cusbank.CardId = cell[1];
cusbank.CardName = cell[2];
cusbank.Remark = cell[3];
cusbank.CustomerId = cusid;
CusBankManager.addCusBank(cusbank);
}
}
}
/// <summary>
/// 获取客户银行信息
/// </summary>
/// <param name="bankID"></param>
/// <returns></returns>
private string GetCustomerBankInfo(int bankID)
{
string result = string.Empty;
EtNet_Models.CusBank bankInfo = CusBankManager.getCusBankById(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 = CusBankManager.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);
}
}
}
}
private void bank()
{
string id = Request.QueryString["id"].ToString();
IList <CusBank> cusbank = CusBankManager.getCusBankByCusId(Convert.ToInt32(id));
if (cusbank.Count == 0)
{
tip.InnerHtml = "<div style='line-height:60px;height:60px;width:100%;text-align:center;'><p style='color:gray;width:200px;margin:0 auto;background:#FFFFFF;border:solid 0px #ccc; text-algin:center'><p></div>";
}
else
{
banklist.DataSource = cusbank;
}
banklist.DataBind();
}
protected void rpCustomer_ItemCommand(object source, RepeaterCommandEventArgs e)
{
if (e.CommandName == "Delete")
{
int id = Convert.ToInt32(e.CommandArgument);
EtNet_Models.Customer model = EtNet_BLL.CustomerManager.getCustomerById(id);
if (model != null)
{
CusBankManager.deleteCusBankByCusId(model.Id);
CusLinkmanManager.deleteCusLinkmanByCusId(model.Id);
int count = CustomerManager.deleteCustomer(model.Id);
if (count <= 0)
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "page", "alert('删除失败')", true);
return;
}
}
}
dataBind();
}
/// <summary>
/// 绑定客户银行列表
/// </summary>
private void FillCustomerBank(DataTable dtBankList, int customerID)
{
EtNet_Models.Customer customer = CustomerManager.getCustomerById(customerID);
if (customer != null && customer.Bank.Trim() != string.Empty)
{
DataRow newRow = dtBankList.NewRow();
newRow["bankId"] = 0;
newRow["bankName"] = customer.Bank;// string.Format("{0}（主银行）", customer.Bank);
newRow["bankAccount"] = customer.CardId;
newRow["bankUser"] = customer.CardName;
newRow["bankMark"] = customer.Remark;
dtBankList.Rows.Add(newRow);
}
DataTable dtCustomerBankList = CusBankManager.getList(customerID);
if (dtCustomerBankList.Rows.Count > 0)
{
int rowCount = dtCustomerBankList.Rows.Count;
for (int i = 0; i < rowCount; i++)
{
DataRow currentRow = dtCustomerBankList.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 addbank()
{
string id = Request.QueryString["id"].ToString();
CusBankManager.deleteCusBankByCusId(Convert.ToInt32(id));
string banklist = this.hidbank.Value;
if (banklist != "")
{
string[] row = null;
string[] cell = null;
EtNet_Models.CusBank cusbank = null;
if (banklist.IndexOf(',') >= 0)
{
row = banklist.Split(',');
}
else
{
row = new string[1] {
banklist
};
}
for (int i = 0; i < row.Length; i++)
{
cusbank = new EtNet_Models.CusBank();
cell = row[i].Split('|');
cusbank.Bank = cell[0];
cusbank.CardId = cell[1];
cusbank.CardName = cell[2];
cusbank.Remark = cell[3];
cusbank.CustomerId = Convert.ToInt32(id);
CusBankManager.addCusBank(cusbank);
}
}
}
