/// <summary> ///[CusBank]表查询实体的方法 /// </summary> public static CusBank getCusBankById(int id) { CusBank cusbank = null; string sql = "select * from CusBank where id=@id"; SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@id", id) }; DataTable dt = DBHelper.GetDataSet(sql, sp); if (dt.Rows.Count > 0) { cusbank = new CusBank(); foreach (DataRow dr in dt.Rows) { cusbank.Id = Convert.ToInt32(dr["id"]); cusbank.CustomerId = Convert.ToInt32(dr["customerId"]); cusbank.Bank = Convert.ToString(dr["bank"]); cusbank.CardId = Convert.ToString(dr["cardId"]); cusbank.CardName = Convert.ToString(dr["cardName"]); cusbank.Remark = Convert.ToString(dr["remark"]); } } return(cusbank); }
/// <summary> ///[CusBank]表添加的方法 /// </summary> public static int addCusBank(CusBank cusbank) { string sql = "insert into CusBank([customerId],[bank],[cardId],[cardName],[remark]) values (@customerId,@bank,@cardId,@cardName,@remark)"; SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@customerId", cusbank.CustomerId), new SqlParameter("@bank", cusbank.Bank), new SqlParameter("@cardId", cusbank.CardId), new SqlParameter("@cardName", cusbank.CardName), new SqlParameter("@remark", cusbank.Remark) }; return(DBHelper.ExecuteCommand(sql, sp)); }
/// <summary> ///[CusBank]表修改的方法 /// </summary> public static int updateCusBankById(CusBank cusbank) { string sql = "update CusBank set customerId=@customerId,bank=@bank,cardId=@cardId,cardName=@cardName,remark=@remark where id=@id"; SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@id", cusbank.Id), new SqlParameter("@customerId", cusbank.CustomerId), new SqlParameter("@bank", cusbank.Bank), new SqlParameter("@cardId", cusbank.CardId), new SqlParameter("@cardName", cusbank.CardName), new SqlParameter("@remark", cusbank.Remark) }; return(DBHelper.ExecuteCommand(sql, sp)); }
/// <summary> ///根据SQL语句获取实体 /// </summary> public static CusBank getCusBankBySql(string sql) { CusBank cusbank = null; DataTable dt = DBHelper.GetDataSet(sql); if (dt.Rows.Count > 0) { cusbank = new CusBank(); foreach (DataRow dr in dt.Rows) { cusbank.Id = Convert.ToInt32(dr["id"]); cusbank.CustomerId = Convert.ToInt32(dr["customerId"]); cusbank.Bank = Convert.ToString(dr["bank"]); cusbank.CardId = Convert.ToString(dr["cardId"]); cusbank.CardName = Convert.ToString(dr["cardName"]); cusbank.Remark = Convert.ToString(dr["remark"]); } } return(cusbank); }
/// <summary> ///根据SQL语句获取集合 /// </summary> public static IList <CusBank> getCusBanksBySql(string sql) { IList <CusBank> list = new List <CusBank>(); DataTable dt = DBHelper.GetDataSet(sql); if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { CusBank cusbank = new CusBank(); cusbank.Id = Convert.ToInt32(dr["id"]); cusbank.CustomerId = Convert.ToInt32(dr["customerId"]); cusbank.Bank = Convert.ToString(dr["bank"]); cusbank.CardId = Convert.ToString(dr["cardId"]); cusbank.CardName = Convert.ToString(dr["cardName"]); cusbank.Remark = Convert.ToString(dr["remark"]); list.Add(cusbank); } } return(list); }
public static int addCusBank(CusBank cusbank) { return(CusBankService.addCusBank(cusbank)); }
public static int updateCusBank(CusBank cusbank) { return(CusBankService.updateCusBankById(cusbank)); }