//DIRTY READ SOLVED public static int dirtyReadSolvedSetNgungGiaoDich(int maNhaCungCap, int maNhaHang, int tinhTrang) { DbCommand command = DataAccessCode.CreateCommand(); //command.CommandText = "dbo.setNgungGiaoDich"; command.CommandText = "dbo.DirtyReadSolvedT2SetNgungGiaoDich"; //// create a new parameter DbParameter param = command.CreateParameter(); param.ParameterName = "@maNhaCungCap"; param.Value = maNhaCungCap; param.DbType = DbType.Int32; command.Parameters.Add(param); //// create a new parameter param = command.CreateParameter(); param.ParameterName = "@maNhaHang"; param.Value = maNhaHang; param.DbType = DbType.Int32; command.Parameters.Add(param); //// create a new parameter param = command.CreateParameter(); param.ParameterName = "@tinhTrang"; param.Value = tinhTrang; param.DbType = DbType.Int16; command.Parameters.Add(param); //create a new parameter param = command.CreateParameter(); param.ParameterName = "@isRollback"; param.Direction = ParameterDirection.Output; param.Value = 0; param.DbType = DbType.Int16; command.Parameters.Add(param); return(DataAccessCode.ExecuteNonQueryReturnIsRollBackOutputValue(command)); }