/// <summary> /// 删除指定数据 /// </summary> /// <param name="ID">要删除的对象 (通过主键)</param> /// <returns></returns> public int Delete(BU_BankAccount _bU_BankAccount) { return(db.ExecuteNonQuery(deleteByKeyText, CommandType.Text, new SqlParameter[] { new SqlParameter("@ID", SqlDbType.BigInt, 19) { Value = _bU_BankAccount.ID } })); }
/// <summary> /// 将表转换为对象集合 /// </summary> /// <param name="dt">要转换的表</param> /// <returns></returns> public List <BU_BankAccount> DataTableToList(DataTable dt) { List <BU_BankAccount> bu_bankaccounts = new List <BU_BankAccount>(); BU_BankAccount _bu_bankaccount = null; object _temp = null; DataColumnCollection dcs = dt.Columns; foreach (DataRow item in dt.Rows) { _bu_bankaccount = new BU_BankAccount(); if (dcs.Contains("id")) { _bu_bankaccount.ID = Convert.ToInt64(item["ID"]); } if (dcs.Contains("userid")) { _bu_bankaccount.UserID = Convert.ToInt64(item["UserID"]); } if (dcs.Contains("banktype")) { _bu_bankaccount.BankType = Convert.ToInt32(item["BankType"]); } if (dcs.Contains("name")) { _bu_bankaccount.Name = item["Name"].ToString(); } if (dcs.Contains("idnumber")) { _bu_bankaccount.IDNumber = item["IDNumber"].ToString(); } if (dcs.Contains("moneytype")) { _bu_bankaccount.MoneyType = Convert.ToInt32(item["MoneyType"]); } if (dcs.Contains("yumoney")) { _bu_bankaccount.YuMoney = Convert.ToDecimal(item["YuMoney"]); } if (dcs.Contains("isbreak")) { _bu_bankaccount.IsBreak = Convert.ToInt32(item["IsBreak"]); } if (dcs.Contains("adddate")) { _bu_bankaccount.AddDate = Convert.ToDateTime(item["AddDate"]); } bu_bankaccounts.Add(_bu_bankaccount); } return(bu_bankaccounts); }
/// <summary> /// 将数据行转换为对象 /// </summary> /// <param name="dt">要转换的数据行</param> /// <returns></returns> public BU_BankAccount DataRowToModel(DataRow dr) { BU_BankAccount _bu_bankaccount = null; object _temp = null; DataColumnCollection dcs = dr.Table.Columns; _bu_bankaccount = new BU_BankAccount(); if (dcs.Contains("id")) { _bu_bankaccount.ID = Convert.ToInt64(dr["ID"]); } if (dcs.Contains("userid")) { _bu_bankaccount.UserID = Convert.ToInt64(dr["UserID"]); } if (dcs.Contains("banktype")) { _bu_bankaccount.BankType = Convert.ToInt32(dr["BankType"]); } if (dcs.Contains("name")) { _bu_bankaccount.Name = dr["Name"].ToString(); } if (dcs.Contains("idnumber")) { _bu_bankaccount.IDNumber = dr["IDNumber"].ToString(); } if (dcs.Contains("moneytype")) { _bu_bankaccount.MoneyType = Convert.ToInt32(dr["MoneyType"]); } if (dcs.Contains("yumoney")) { _bu_bankaccount.YuMoney = Convert.ToDecimal(dr["YuMoney"]); } if (dcs.Contains("isbreak")) { _bu_bankaccount.IsBreak = Convert.ToInt32(dr["IsBreak"]); } if (dcs.Contains("adddate")) { _bu_bankaccount.AddDate = Convert.ToDateTime(dr["AddDate"]); } return(_bu_bankaccount); }
/// <summary> /// 更新数据库的一条记录 /// </summary> /// <param name="_bU_BankAccount">需要更新的对象</param> /// <returns></returns> public int Update(BU_BankAccount _bU_BankAccount) { return(db.ExecuteNonQuery(updateByKeyText, CommandType.Text, new SqlParameter[] { new SqlParameter("@UserID", SqlDbType.BigInt, 19) { Value = _bU_BankAccount.UserID } , new SqlParameter("@BankType", SqlDbType.Int, 10) { Value = _bU_BankAccount.BankType } , new SqlParameter("@Name", SqlDbType.NVarChar, 50) { Value = _bU_BankAccount.Name } , new SqlParameter("@IDNumber", SqlDbType.NVarChar, 50) { Value = _bU_BankAccount.IDNumber } , new SqlParameter("@MoneyType", SqlDbType.Int, 10) { Value = _bU_BankAccount.MoneyType } , new SqlParameter("@YuMoney", SqlDbType.Decimal, 14) { Value = _bU_BankAccount.YuMoney } , new SqlParameter("@IsBreak", SqlDbType.Int, 10) { Value = _bU_BankAccount.IsBreak } , new SqlParameter("@AddDate", SqlDbType.DateTime, 23) { Value = _bU_BankAccount.AddDate } , new SqlParameter("@ID1", SqlDbType.BigInt, 19) { Value = _bU_BankAccount.ID } })); }
/// <summary> /// 向数据库插入一条新数据 返回插入的自增长值 /// </summary> /// <param name="_bU_BankAccount">需要插入的对象</param> /// <returns></returns> public long Add(BU_BankAccount _bU_BankAccount) { object obj = db.ExecuteScalar(insertText, CommandType.Text, new SqlParameter[] { new SqlParameter("@UserID", SqlDbType.BigInt, 19) { Value = _bU_BankAccount.UserID } , new SqlParameter("@BankType", SqlDbType.Int, 10) { Value = _bU_BankAccount.BankType } , new SqlParameter("@Name", SqlDbType.NVarChar, 50) { Value = _bU_BankAccount.Name } , new SqlParameter("@IDNumber", SqlDbType.NVarChar, 50) { Value = _bU_BankAccount.IDNumber } , new SqlParameter("@MoneyType", SqlDbType.Int, 10) { Value = _bU_BankAccount.MoneyType } , new SqlParameter("@YuMoney", SqlDbType.Decimal, 14) { Value = _bU_BankAccount.YuMoney } , new SqlParameter("@IsBreak", SqlDbType.Int, 10) { Value = _bU_BankAccount.IsBreak } , new SqlParameter("@AddDate", SqlDbType.DateTime, 23) { Value = _bU_BankAccount.AddDate } }); return(obj is DBNull ? 0 : Convert.ToInt64(obj)); }
/// <summary> /// 删除指定数据 /// </summary> /// <param name="ID">要删除的对象 (通过主键)</param> /// <returns></returns> public int Delete(BU_BankAccount _bU_BankAccount) { return(_dal.Delete(_bU_BankAccount)); }
/// <summary> /// 更新数据库的一条记录 /// </summary> /// <param name="_bU_BankAccount">需要更新的对象</param> /// <returns></returns> public int Update(BU_BankAccount _bU_BankAccount) { return(_dal.Update(_bU_BankAccount)); }
/// <summary> /// 向数据库插入一条新数据 返回插入的自增长值 /// </summary> /// <param name="_bU_BankAccount">需要插入的对象</param> /// <returns></returns> public long Add(BU_BankAccount _bU_BankAccount) { return(_dal.Add(_bU_BankAccount)); }