/// <summary>
/// 删除指定数据
/// </summary>
/// <param name="ID">要删除的对象 （通过主键）</param>
/// <returns></returns>
public int Delete(BU_AcIO _bU_AcIO)
{
return(db.ExecuteNonQuery(deleteByKeyText, CommandType.Text,
new SqlParameter[] {
new SqlParameter("@ID", SqlDbType.BigInt, 19)
{
Value = _bU_AcIO.ID
}
}));
}
/// <summary>
/// 将数据行转换为对象
/// </summary>
/// <param name="dt">要转换的数据行</param>
/// <returns></returns>
public BU_AcIO DataRowToModel(DataRow dr)
{
BU_AcIO _bu_acio = null;
object _temp = null;
DataColumnCollection dcs = dr.Table.Columns;
_bu_acio = new BU_AcIO();
if (dcs.Contains("id"))
{
_bu_acio.ID = Convert.ToInt64(dr["ID"]);
}
if (dcs.Contains("userid"))
{
_bu_acio.UserID = Convert.ToInt64(dr["UserID"]);
}
if (dcs.Contains("acbookid"))
{
_bu_acio.AcBookID = Convert.ToInt64(dr["AcBookID"]);
}
if (dcs.Contains("acbookname"))
{
_bu_acio.AcBookName = dr["AcBookName"].ToString();
}
if (dcs.Contains("opway"))
{
_bu_acio.OpWay = Convert.ToInt32(dr["OpWay"]);
}
if (dcs.Contains("paytype"))
{
_bu_acio.PayType = Convert.ToInt32(dr["PayType"]);
}
if (dcs.Contains("paytype2"))
{
_bu_acio.PayType2 = dr["PayType2"].ToString();
}
if (dcs.Contains("paytype3"))
{
_bu_acio.PayType3 = dr["PayType3"].ToString();
}
if (dcs.Contains("mediid"))
{
_bu_acio.MediID = Convert.ToInt64(dr["MediID"]);
}
if (dcs.Contains("mediname"))
{
_bu_acio.MediName = dr["MediName"].ToString();
}
if (dcs.Contains("paywayid"))
{
_bu_acio.PayWayID = Convert.ToInt64(dr["PayWayID"]);
}
if (dcs.Contains("paywayname"))
{
_bu_acio.PayWayName = dr["PayWayName"].ToString();
}
if (dcs.Contains("youdebtid"))
{
_bu_acio.YouDebtID = Convert.ToInt64(dr["YouDebtID"]);
}
if (dcs.Contains("youcomname"))
{
_bu_acio.YouComName = dr["YouComName"].ToString();
}
if (dcs.Contains("youname"))
{
_bu_acio.YouName = dr["YouName"].ToString();
}
if (dcs.Contains("youwayid"))
{
_bu_acio.YouWayID = Convert.ToInt64(dr["YouWayID"]);
}
if (dcs.Contains("youwayname"))
{
_bu_acio.YouWayName = dr["YouWayName"].ToString();
}
if (dcs.Contains("youwayidnumber"))
{
_bu_acio.YouWayIDNumber = dr["YouWayIDNumber"].ToString();
}
if (dcs.Contains("paydate"))
{
_bu_acio.PayDate = Convert.ToDateTime(dr["PayDate"]);
}
if (dcs.Contains("paydatestr"))
{
_bu_acio.PayDateStr = dr["PayDateStr"].ToString();
}
if (dcs.Contains("money_old"))
{
_bu_acio.Money_Old = Convert.ToDecimal(dr["Money_Old"]);
}
if (dcs.Contains("money_added"))
{
_bu_acio.Money_Added = Convert.ToDecimal(dr["Money_Added"]);
}
if (dcs.Contains("money_percent"))
{
_bu_acio.Money_Percent = Convert.ToInt32(dr["Money_Percent"]);
}
if (dcs.Contains("setmoney"))
{
_bu_acio.SetMoney = Convert.ToDecimal(dr["SetMoney"]);
}
if (dcs.Contains("paymoney"))
{
_bu_acio.PayMoney = Convert.ToDecimal(dr["PayMoney"]);
}
if (dcs.Contains("money_result"))
{
_bu_acio.Money_Result = Convert.ToDecimal(dr["Money_Result"]);
}
if (dcs.Contains("remark"))
{
_bu_acio.Remark = dr["Remark"].ToString();
}
if (dcs.Contains("yumoney"))
{
_bu_acio.YuMoney = Convert.ToDecimal(dr["YuMoney"]);
}
if (dcs.Contains("isbreaktolinkuser"))
{
_bu_acio.IsBreakToLinkUser = Convert.ToInt32(dr["IsBreakToLinkUser"]);
}
if (dcs.Contains("isbreaktopayway"))
{
_bu_acio.IsBreakToPayWay = Convert.ToInt32(dr["IsBreakToPayWay"]);
}
if (dcs.Contains("isbaoxiao"))
{
_bu_acio.IsBaoXiao = Convert.ToInt32(dr["IsBaoXiao"]);
}
if (dcs.Contains("linkuserid"))
{
_bu_acio.LinkUserID = Convert.ToInt64(dr["LinkUserID"]);
}
if (dcs.Contains("linkusername"))
{
_bu_acio.LinkUserName = dr["LinkUserName"].ToString();
}
if (dcs.Contains("linktableid"))
{
_bu_acio.LinkTableID = Convert.ToInt64(dr["LinkTableID"]);
}
if (dcs.Contains("applytablename"))
{
_bu_acio.ApplyTableName = dr["ApplyTableName"].ToString();
}
if (dcs.Contains("applytableid"))
{
_bu_acio.ApplyTableID = Convert.ToInt64(dr["ApplyTableID"]);
}
if (dcs.Contains("adddate"))
{
_bu_acio.AddDate = Convert.ToDateTime(dr["AddDate"]);
}
return(_bu_acio);
}
/// <summary>
/// 更新数据库的一条记录
/// </summary>
/// <param name="_bU_AcIO">需要更新的对象</param>
/// <returns></returns>
public int Update(BU_AcIO _bU_AcIO)
{
return(db.ExecuteNonQuery(updateByKeyText, CommandType.Text,
new SqlParameter[] {
new SqlParameter("@UserID", SqlDbType.BigInt, 19)
{
Value = _bU_AcIO.UserID
}
, new SqlParameter("@AcBookID", SqlDbType.BigInt, 19)
{
Value = _bU_AcIO.AcBookID
}
, new SqlParameter("@AcBookName", SqlDbType.NVarChar, 50)
{
Value = _bU_AcIO.AcBookName
}
, new SqlParameter("@OpWay", SqlDbType.Int, 10)
{
Value = _bU_AcIO.OpWay
}
, new SqlParameter("@PayType", SqlDbType.Int, 10)
{
Value = _bU_AcIO.PayType
}
, new SqlParameter("@PayType2", SqlDbType.NVarChar, 50)
{
Value = _bU_AcIO.PayType2
}
, new SqlParameter("@PayType3", SqlDbType.NVarChar, 50)
{
Value = _bU_AcIO.PayType3
}
, new SqlParameter("@MediID", SqlDbType.BigInt, 19)
{
Value = _bU_AcIO.MediID
}
, new SqlParameter("@MediName", SqlDbType.NVarChar, 50)
{
Value = _bU_AcIO.MediName
}
, new SqlParameter("@PayWayID", SqlDbType.BigInt, 19)
{
Value = _bU_AcIO.PayWayID
}
, new SqlParameter("@PayWayName", SqlDbType.NVarChar, 50)
{
Value = _bU_AcIO.PayWayName
}
, new SqlParameter("@YouDebtID", SqlDbType.BigInt, 19)
{
Value = _bU_AcIO.YouDebtID
}
, new SqlParameter("@YouComName", SqlDbType.NVarChar, 50)
{
Value = _bU_AcIO.YouComName
}
, new SqlParameter("@YouName", SqlDbType.NVarChar, 50)
{
Value = _bU_AcIO.YouName
}
, new SqlParameter("@YouWayID", SqlDbType.BigInt, 19)
{
Value = _bU_AcIO.YouWayID
}
, new SqlParameter("@YouWayName", SqlDbType.NVarChar, 50)
{
Value = _bU_AcIO.YouWayName
}
, new SqlParameter("@YouWayIDNumber", SqlDbType.NVarChar, 50)
{
Value = _bU_AcIO.YouWayIDNumber
}
, new SqlParameter("@PayDate", SqlDbType.DateTime, 23)
{
Value = _bU_AcIO.PayDate
}
, new SqlParameter("@PayDateStr", SqlDbType.NVarChar, 50)
{
Value = _bU_AcIO.PayDateStr
}
, new SqlParameter("@Money_Old", SqlDbType.Decimal, 10)
{
Value = _bU_AcIO.Money_Old
}
, new SqlParameter("@Money_Added", SqlDbType.Decimal, 10)
{
Value = _bU_AcIO.Money_Added
}
, new SqlParameter("@Money_Percent", SqlDbType.Int, 10)
{
Value = _bU_AcIO.Money_Percent
}
, new SqlParameter("@SetMoney", SqlDbType.Decimal, 10)
{
Value = _bU_AcIO.SetMoney
}
, new SqlParameter("@PayMoney", SqlDbType.Decimal, 10)
{
Value = _bU_AcIO.PayMoney
}
, new SqlParameter("@Money_Result", SqlDbType.Decimal, 10)
{
Value = _bU_AcIO.Money_Result
}
, new SqlParameter("@Remark", SqlDbType.NVarChar, 500)
{
Value = _bU_AcIO.Remark
}
, new SqlParameter("@YuMoney", SqlDbType.Decimal, 10)
{
Value = _bU_AcIO.YuMoney
}
, new SqlParameter("@IsBreakToLinkUser", SqlDbType.Int, 10)
{
Value = _bU_AcIO.IsBreakToLinkUser
}
, new SqlParameter("@IsBreakToPayWay", SqlDbType.Int, 10)
{
Value = _bU_AcIO.IsBreakToPayWay
}
, new SqlParameter("@IsBaoXiao", SqlDbType.Int, 10)
{
Value = _bU_AcIO.IsBaoXiao
}
, new SqlParameter("@LinkUserID", SqlDbType.BigInt, 19)
{
Value = _bU_AcIO.LinkUserID
}
, new SqlParameter("@LinkUserName", SqlDbType.NVarChar, 50)
{
Value = _bU_AcIO.LinkUserName
}
, new SqlParameter("@LinkTableID", SqlDbType.BigInt, 19)
{
Value = _bU_AcIO.LinkTableID
}
, new SqlParameter("@ApplyTableName", SqlDbType.NVarChar, 50)
{
Value = _bU_AcIO.ApplyTableName
}
, new SqlParameter("@ApplyTableID", SqlDbType.BigInt, 19)
{
Value = _bU_AcIO.ApplyTableID
}
, new SqlParameter("@AddDate", SqlDbType.DateTime, 23)
{
Value = _bU_AcIO.AddDate
}
, new SqlParameter("@ID1", SqlDbType.BigInt, 19)
{
Value = _bU_AcIO.ID
}
}));
}
/// <summary>
/// 向数据库插入一条新数据 返回插入的自增长值
/// </summary>
/// <param name="_bU_AcIO">需要插入的对象</param>
/// <returns></returns>
public long Add(BU_AcIO _bU_AcIO)
{
object obj = db.ExecuteScalar(insertText, CommandType.Text,
new SqlParameter[] {
new SqlParameter("@UserID", SqlDbType.BigInt, 19)
{
Value = _bU_AcIO.UserID
}
, new SqlParameter("@AcBookID", SqlDbType.BigInt, 19)
{
Value = _bU_AcIO.AcBookID
}
, new SqlParameter("@AcBookName", SqlDbType.NVarChar, 50)
{
Value = _bU_AcIO.AcBookName
}
, new SqlParameter("@OpWay", SqlDbType.Int, 10)
{
Value = _bU_AcIO.OpWay
}
, new SqlParameter("@PayType", SqlDbType.Int, 10)
{
Value = _bU_AcIO.PayType
}
, new SqlParameter("@PayType2", SqlDbType.NVarChar, 50)
{
Value = _bU_AcIO.PayType2
}
, new SqlParameter("@PayType3", SqlDbType.NVarChar, 50)
{
Value = _bU_AcIO.PayType3
}
, new SqlParameter("@MediID", SqlDbType.BigInt, 19)
{
Value = _bU_AcIO.MediID
}
, new SqlParameter("@MediName", SqlDbType.NVarChar, 50)
{
Value = _bU_AcIO.MediName
}
, new SqlParameter("@PayWayID", SqlDbType.BigInt, 19)
{
Value = _bU_AcIO.PayWayID
}
, new SqlParameter("@PayWayName", SqlDbType.NVarChar, 50)
{
Value = _bU_AcIO.PayWayName
}
, new SqlParameter("@YouDebtID", SqlDbType.BigInt, 19)
{
Value = _bU_AcIO.YouDebtID
}
, new SqlParameter("@YouComName", SqlDbType.NVarChar, 50)
{
Value = _bU_AcIO.YouComName
}
, new SqlParameter("@YouName", SqlDbType.NVarChar, 50)
{
Value = _bU_AcIO.YouName
}
, new SqlParameter("@YouWayID", SqlDbType.BigInt, 19)
{
Value = _bU_AcIO.YouWayID
}
, new SqlParameter("@YouWayName", SqlDbType.NVarChar, 50)
{
Value = _bU_AcIO.YouWayName
}
, new SqlParameter("@YouWayIDNumber", SqlDbType.NVarChar, 50)
{
Value = _bU_AcIO.YouWayIDNumber
}
, new SqlParameter("@PayDate", SqlDbType.DateTime, 23)
{
Value = _bU_AcIO.PayDate
}
, new SqlParameter("@PayDateStr", SqlDbType.NVarChar, 50)
{
Value = _bU_AcIO.PayDateStr
}
, new SqlParameter("@Money_Old", SqlDbType.Decimal, 10)
{
Value = _bU_AcIO.Money_Old
}
, new SqlParameter("@Money_Added", SqlDbType.Decimal, 10)
{
Value = _bU_AcIO.Money_Added
}
, new SqlParameter("@Money_Percent", SqlDbType.Int, 10)
{
Value = _bU_AcIO.Money_Percent
}
, new SqlParameter("@SetMoney", SqlDbType.Decimal, 10)
{
Value = _bU_AcIO.SetMoney
}
, new SqlParameter("@PayMoney", SqlDbType.Decimal, 10)
{
Value = _bU_AcIO.PayMoney
}
, new SqlParameter("@Money_Result", SqlDbType.Decimal, 10)
{
Value = _bU_AcIO.Money_Result
}
, new SqlParameter("@Remark", SqlDbType.NVarChar, 500)
{
Value = _bU_AcIO.Remark
}
, new SqlParameter("@YuMoney", SqlDbType.Decimal, 10)
{
Value = _bU_AcIO.YuMoney
}
, new SqlParameter("@IsBreakToLinkUser", SqlDbType.Int, 10)
{
Value = _bU_AcIO.IsBreakToLinkUser
}
, new SqlParameter("@IsBreakToPayWay", SqlDbType.Int, 10)
{
Value = _bU_AcIO.IsBreakToPayWay
}
, new SqlParameter("@IsBaoXiao", SqlDbType.Int, 10)
{
Value = _bU_AcIO.IsBaoXiao
}
, new SqlParameter("@LinkUserID", SqlDbType.BigInt, 19)
{
Value = _bU_AcIO.LinkUserID
}
, new SqlParameter("@LinkUserName", SqlDbType.NVarChar, 50)
{
Value = _bU_AcIO.LinkUserName
}
, new SqlParameter("@LinkTableID", SqlDbType.BigInt, 19)
{
Value = _bU_AcIO.LinkTableID
}
, new SqlParameter("@ApplyTableName", SqlDbType.NVarChar, 50)
{
Value = _bU_AcIO.ApplyTableName
}
, new SqlParameter("@ApplyTableID", SqlDbType.BigInt, 19)
{
Value = _bU_AcIO.ApplyTableID
}
, new SqlParameter("@AddDate", SqlDbType.DateTime, 23)
{
Value = _bU_AcIO.AddDate
}
});
return(obj is DBNull ? 0 : Convert.ToInt64(obj));
}
/// <summary>
/// 删除指定数据
/// </summary>
/// <param name="ID">要删除的对象 （通过主键）</param>
/// <returns></returns>
public int Delete(BU_AcIO _bU_AcIO)
{
return(_dal.Delete(_bU_AcIO));
}
/// <summary>
/// 更新数据库的一条记录
/// </summary>
/// <param name="_bU_AcIO">需要更新的对象</param>
/// <returns></returns>
public int Update(BU_AcIO _bU_AcIO)
{
return(_dal.Update(_bU_AcIO));
}
/// <summary>
/// 向数据库插入一条新数据 返回插入的自增长值
/// </summary>
/// <param name="_bU_AcIO">需要插入的对象</param>
/// <returns></returns>
public long Add(BU_AcIO _bU_AcIO)
{
return(_dal.Add(_bU_AcIO));
}
