/// <summary> /// 带事务Insert /// </summary> /// <param name="entity"></param> /// <param name="trans">The trans.</param> /// <returns></returns> /// <remarks>2014/1/2 17:25:02</remarks> public bool SaveItem(ShadowItemEntity entity, DbTransaction trans = null) { var database = new SqlDatabase(this.ConnectionString); DbCommand commandWrapper = database.GetStoredProcCommand("dbo.P_Item_Insert"); database.AddInParameter(commandWrapper, "@TransactionId", DbType.Guid, entity.TransactionId); database.AddInParameter(commandWrapper, "@OperationType", DbType.Int32, entity.OperationType); database.AddInParameter(commandWrapper, "@ItemId", DbType.Guid, entity.ItemId); database.AddInParameter(commandWrapper, "@ItemCode", DbType.Int32, entity.ItemCode); database.AddInParameter(commandWrapper, "@ItemCount", DbType.Int32, entity.ItemCount); database.AddInParameter(commandWrapper, "@ItemType", DbType.Int32, entity.ItemType); database.AddInParameter(commandWrapper, "@IsBinding", DbType.Boolean, entity.IsBinding); database.AddInParameter(commandWrapper, "@ItemProperty", DbType.Binary, entity.ItemProperty); database.AddInParameter(commandWrapper, "@GridIndex", DbType.Int32, entity.GridIndex); database.AddInParameter(commandWrapper, "@Status", DbType.Int32, entity.Status); database.AddInParameter(commandWrapper, "@OperationCount", DbType.Int32, entity.OperationCount); database.AddParameter(commandWrapper, "@Idx", DbType.Int64, ParameterDirection.InputOutput, "", DataRowVersion.Current, entity.Idx); int results = 0; if (trans != null) { results = database.ExecuteNonQuery(commandWrapper, trans); } else { results = database.ExecuteNonQuery(commandWrapper); } entity.Idx = (System.Int64)database.GetParameterValue(commandWrapper, "@Idx"); return(Convert.ToBoolean(results)); }
public ItemShadow(ItemInfoEntity entity, EnumOperationType operationType, Guid transactionId, int operationCount) { Shadow = new ShadowItemEntity(); Shadow.TransactionId = transactionId; Shadow.OperationType = (int)operationType; Shadow.ItemId = entity.ItemId; Shadow.ItemCode = entity.ItemCode; Shadow.ItemType = entity.ItemType; Shadow.ItemCount = entity.ItemCount; Shadow.IsBinding = entity.IsBinding; Shadow.ItemProperty = SerializationHelper.ToByte(entity.ItemProperty); Shadow.GridIndex = entity.GridIndex; Shadow.Status = entity.Status; Shadow.OperationCount = operationCount; }