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