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