/// <summary> /// 新增一条订单状态日志 /// </summary> /// <param name="orderStatusLog"> /// 订单状态日志 /// </param> /// <param name="transaction"> /// 数据库事务对象 /// </param> /// <returns> /// 新增的订单状态日子编码 /// </returns> public int Insert(Order_Status_Log orderStatusLog, SqlTransaction transaction) { /* Create Procedure sp_Order_Status_Log_Insert @OrderID int, @EmployeeID int, @Status int, @Remark nvarchar(512), @CreateTime datetime, @ReferenceID int output As */ var paras = new List<SqlParameter> { this.SqlServer.CreateSqlParameter( "OrderID", SqlDbType.Int, orderStatusLog.OrderID, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "EmployeeID", SqlDbType.Int, orderStatusLog.EmployeeID, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "Status", SqlDbType.Int, orderStatusLog.Status, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "Remark", SqlDbType.NVarChar, orderStatusLog.Remark, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "CreateTime", SqlDbType.DateTime, DateTime.Now, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "ReferenceID", SqlDbType.Int, null, ParameterDirection.Output) }; this.SqlServer.ExecuteNonQuery(CommandType.StoredProcedure, "sp_Order_Status_Log_Insert", paras, transaction); return (int)paras.Find(e => e.ParameterName == "ReferenceID").Value; }
/// <summary> /// 新增一条订单状态日志 /// </summary> /// <param name="orderStatusLog"> /// 订单状态日志 /// </param> /// <param name="transaction"> /// 数据库事务对象 /// </param> /// <returns> /// 新增的订单状态日子编码 /// </returns> public int Insert(Order_Status_Log orderStatusLog, SqlTransaction transaction) { return this.orderStatusLogDA.Insert(orderStatusLog, transaction); }