/// <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)); }