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