/// <summary>
/// 写入HWERP 回写日志信息
/// </summary>
/// <param name="log"></param>
/// <param name="transaction"></param>
/// <returns></returns>
public int InertHwUpdateLog(Hw_Log log, SqlTransaction transaction)
{
/*@Number nvarchar(50),
@Content ntext,
@State tinyint,
@CreateTime datetime,
@ExtField nvarchar(50),
*/
var paras = new List<SqlParameter>
{
this.sqlServer.CreateSqlParameter(
"Number",
SqlDbType.VarChar,
log.Number,
ParameterDirection.Input),
this.sqlServer.CreateSqlParameter(
"Content",
SqlDbType.NVarChar,
log.Content,
ParameterDirection.Input),
this.sqlServer.CreateSqlParameter(
"State",
SqlDbType.Int,
log.State,
ParameterDirection.Input),
this.sqlServer.CreateSqlParameter(
"ExtField",
SqlDbType.NVarChar,
log.ExtField,
ParameterDirection.Input),
this.sqlServer.CreateSqlParameter(
"CreateTime",
SqlDbType.DateTime,
DateTime.Now.ToLocalTime(),
ParameterDirection.Input),
this.sqlServer.CreateSqlParameter(
"ReferenceID",
SqlDbType.Int,
null,
ParameterDirection.Output)
};
this.sqlServer.ExecuteNonQuery(CommandType.StoredProcedure, "sp_hw_Log_Insert", paras, transaction);
return (int)paras.Find(p => p.ParameterName == "ReferenceID").Value;
}
public int AddHwLog(Hw_Log log, SqlTransaction transaction)
{
return this.erpLogDa.InertHwUpdateLog(log, transaction);
}
