/// <summary>
///[ComBank]表查询实体的方法
/// </summary>
public static ComBank getComBankById(int id)
{
ComBank combank = null;
string sql = "select * from ComBank where id=@id";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@id", id)
};
DataTable dt = DBHelper.GetDataSet(sql, sp);
if (dt.Rows.Count > 0)
{
combank = new ComBank();
foreach (DataRow dr in dt.Rows)
{
combank.Id = Convert.ToInt32(dr["id"]);
combank.CompanyId = Convert.ToInt32(dr["companyId"]);
combank.Bank = Convert.ToString(dr["bank"]);
combank.CardId = Convert.ToString(dr["cardId"]);
combank.CardName = Convert.ToString(dr["cardName"]);
combank.Remark = Convert.ToString(dr["remark"]);
}
}
return(combank);
}
/// <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>
///[ComBank]表添加的方法
/// </summary>
public static int addComBank(ComBank combank)
{
string sql = "insert into ComBank([companyId],[bank],[cardId],[cardName],[remark]) values (@companyId,@bank,@cardId,@cardName,@remark)";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@companyId", combank.CompanyId),
new SqlParameter("@bank", combank.Bank),
new SqlParameter("@cardId", combank.CardId),
new SqlParameter("@cardName", combank.CardName),
new SqlParameter("@remark", combank.Remark)
};
return(DBHelper.ExecuteCommand(sql, sp));
}
/// <summary>
///[ComBank]表修改的方法
/// </summary>
public static int updateComBankById(ComBank combank)
{
string sql = "update ComBank set companyId=@companyId,bank=@bank,cardId=@cardId,cardName=@cardName,remark=@remark where id=@id";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@id", combank.Id),
new SqlParameter("@companyId", combank.CompanyId),
new SqlParameter("@bank", combank.Bank),
new SqlParameter("@cardId", combank.CardId),
new SqlParameter("@cardName", combank.CardName),
new SqlParameter("@remark", combank.Remark)
};
return(DBHelper.ExecuteCommand(sql, sp));
}
/// <summary>
///根据SQL语句获取实体
/// </summary>
public static ComBank getComBankBySql(string sql)
{
ComBank combank = null;
DataTable dt = DBHelper.GetDataSet(sql);
if (dt.Rows.Count > 0)
{
combank = new ComBank();
foreach (DataRow dr in dt.Rows)
{
combank.Id = Convert.ToInt32(dr["id"]);
combank.CompanyId = Convert.ToInt32(dr["companyId"]);
combank.Bank = Convert.ToString(dr["bank"]);
combank.CardId = Convert.ToString(dr["cardId"]);
combank.CardName = Convert.ToString(dr["cardName"]);
combank.Remark = Convert.ToString(dr["remark"]);
}
}
return(combank);
}
/// <summary>
///根据SQL语句获取集合
/// </summary>
public static IList <ComBank> getComBanksBySql(string sql)
{
IList <ComBank> list = new List <ComBank>();
DataTable dt = DBHelper.GetDataSet(sql);
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
ComBank combank = new ComBank();
combank.Id = Convert.ToInt32(dr["id"]);
combank.CompanyId = Convert.ToInt32(dr["companyId"]);
combank.Bank = Convert.ToString(dr["bank"]);
combank.CardId = Convert.ToString(dr["cardId"]);
combank.CardName = Convert.ToString(dr["cardName"]);
combank.Remark = Convert.ToString(dr["remark"]);
list.Add(combank);
}
}
return(list);
}
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);
}
}
}
public static int addComBank(ComBank combank)
{
return(ComBankService.addComBank(combank));
}
public static int updateComBank(ComBank combank)
{
return(ComBankService.updateComBankById(combank));
}
