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