/// <summary>
/// 带事务Insert
/// </summary>
/// <param name="entity"></param>
/// <param name="trans">The trans.</param>
/// <returns></returns>
/// <remarks>2014/1/2 17:29:22</remarks>
public bool SaveTransaction(ShadowTransactionEntity entity, DbTransaction trans)
{
var database = new SqlDatabase(this.ConnectionString);
DbCommand commandWrapper = database.GetStoredProcCommand("dbo.P_Transaction_Insert");
database.AddInParameter(commandWrapper, "@TransactionType", DbType.Int32, entity.TransactionType);
database.AddInParameter(commandWrapper, "@ManagerId", DbType.Guid, entity.ManagerId);
database.AddInParameter(commandWrapper, "@AppId", DbType.AnsiString, entity.AppId);
database.AddInParameter(commandWrapper, "@TerminalIP", DbType.AnsiString, entity.TerminalIP);
database.AddInParameter(commandWrapper, "@RowTime", DbType.DateTime, entity.RowTime);
database.AddParameter(commandWrapper, "@Idx", DbType.Guid, 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.Guid)database.GetParameterValue(commandWrapper, "@Idx");
return(Convert.ToBoolean(results));
}
public TransactionShadow(Guid managerId, EnumTransactionType transactionType, string zoneId = "")
{
Transaction = new ShadowTransactionEntity();
Transaction.Idx = ShareUtil.GenerateComb();
Transaction.TransactionType = (int)transactionType;
Transaction.ManagerId = managerId;
Transaction.RowTime = DateTime.Now;
Transaction.TerminalIP = ShareUtil.GetServerIp();
Transaction.AppId = ShareUtil.AppId;
Shadows = new List <IShadow>();
ItemShadows = new List <ItemShadow>();
_zoneId = zoneId;
}
/// <summary>
/// Insert
/// </summary>
/// <param name="entity"></param>
/// <param name="trans">The trans.</param>
/// <returns></returns>
/// <remarks>2014/1/2 17:29:22</remarks>
public bool SaveTransaction(ShadowTransactionEntity entity)
{
return(SaveTransaction(entity, null));
}
