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