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