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