/// <summary> /// 带事务的Update /// </summary> /// <param name="entity"></param> /// <param name="trans">The trans.</param> /// <returns></returns> /// <remarks>2016/5/19 14:22:36</remarks> public bool Update(AllCsdkEntity entity, DbTransaction trans) { var database = new SqlDatabase(this.ConnectionString); DbCommand commandWrapper = database.GetStoredProcCommand("dbo.P_AllCsdk_Update"); database.AddInParameter(commandWrapper, "@Idx", DbType.Int32, entity.Idx); database.AddInParameter(commandWrapper, "@_sign", DbType.AnsiString, entity._sign); database.AddInParameter(commandWrapper, "@orderId", DbType.Int32, entity.orderId); database.AddInParameter(commandWrapper, "@gameOrderId", DbType.AnsiString, entity.gameOrderId); database.AddInParameter(commandWrapper, "@price", DbType.Int32, entity.price); database.AddInParameter(commandWrapper, "@channelAlias", DbType.AnsiString, entity.channelAlias); database.AddInParameter(commandWrapper, "@playerId", DbType.AnsiString, entity.playerId); database.AddInParameter(commandWrapper, "@serverId", DbType.AnsiString, entity.serverId); database.AddInParameter(commandWrapper, "@goodsId", DbType.Int32, entity.goodsId); database.AddInParameter(commandWrapper, "@payResult", DbType.Int32, entity.payResult); database.AddInParameter(commandWrapper, "@_state", DbType.AnsiString, entity._state); database.AddInParameter(commandWrapper, "@payTime", DbType.Date, entity.payTime); int results = 0; if (trans != null) { results = database.ExecuteNonQuery(commandWrapper, trans); } else { results = database.ExecuteNonQuery(commandWrapper); } entity.Idx = (System.Int32)database.GetParameterValue(commandWrapper, "@Idx"); return(Convert.ToBoolean(results)); }
/// <summary> /// 将IDataReader的当前记录读取到AllCsdkEntity 对象 /// </summary> /// <param name="reader"></param> /// <returns></returns> public AllCsdkEntity LoadSingleRow(IDataReader reader) { var obj = new AllCsdkEntity(); obj.Idx = (System.Int32)reader["Idx"]; obj._sign = (System.String)reader["_sign"]; obj.orderId = (System.Int32)reader["orderId"]; obj.gameOrderId = (System.String)reader["gameOrderId"]; obj.price = (System.Int32)reader["price"]; obj.channelAlias = (System.String)reader["channelAlias"]; obj.playerId = (System.String)reader["playerId"]; obj.serverId = (System.String)reader["serverId"]; obj.goodsId = (System.Int32)reader["goodsId"]; obj.payResult = (System.Int32)reader["payResult"]; obj._state = (System.String)reader["_state"]; obj.payTime = (System.DateTime)reader["payTime"]; return(obj); }
/// <summary> /// GetById /// </summary> /// <param name="idx">idx</param> /// <returns>AllCsdkEntity</returns> /// <remarks>2016/5/19 14:22:36</remarks> public AllCsdkEntity GetById(System.Int32 idx) { var database = new SqlDatabase(this.ConnectionString); DbCommand commandWrapper = database.GetStoredProcCommand("P_AllCsdk_GetById"); database.AddInParameter(commandWrapper, "@Idx", DbType.Int32, idx); AllCsdkEntity obj = null; using (IDataReader reader = database.ExecuteReader(commandWrapper)) { if (reader.Read()) { obj = LoadSingleRow(reader); } } return(obj); }
/// <summary> /// Update /// </summary> /// <param name="entity"></param> /// <returns></returns> /// <remarks>2016/5/19 14:22:36</remarks> public bool Update(AllCsdkEntity entity) { return(Update(entity, null)); }
/// <summary> /// Insert /// </summary> /// <param name="entity"></param> /// <param name="trans">The trans.</param> /// <returns></returns> /// <remarks>2016/5/19 14:22:36</remarks> public bool Insert(AllCsdkEntity entity) { return(Insert(entity, null)); }
public static bool Update(AllCsdkEntity allCsdkEntity, DbTransaction trans = null, string zoneId = "") { var provider = new AllCsdkProvider(zoneId); return(provider.Update(allCsdkEntity, trans)); }