//UNREPEATABLE SOLVED
public static ArrayList unrepeatableSolvedTimKiemNhaCungCapTheoTenVaTheoTinhTrangGiaoDichCoHoacNgung(string ten, int tinhTrangGiaoDich, int maNhaHang)
{
DbCommand command = DataAccessCode.CreateCommand();
//command.CommandText = "dbo.timKiemNhaCungCapTheoTenVaTheoTinhTrangGiaoDichCoHoacNgung";
//phantom read
//command.CommandText = "dbo.timKiemNhaCungCapTheoTenVaTheoTinhTrangGiaoDichCoHoacNgung";
//dirty
//command.CommandText = "dbo.DirtyReadSolvedT1TimKiemNhaCungCapTheoTenVaTheoTinhTrangGiaoDichNgungGiaoDich";
//unrepeat
command.CommandText = "dbo.UnrepeatableReadSolvedT1TimKiemNhaCungCapTheoTenVaTheoTinhTrangGiaoDichCoGiaoDich";
DbParameter param = command.CreateParameter();
param.ParameterName = "@ten";
param.Value = ten;
param.DbType = DbType.String;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@tinhTrangGiaoDich";
param.Value = tinhTrangGiaoDich;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@maNhaHang";
param.Value = maNhaHang;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
DataTable dt = DataAccessCode.ExecuteSecondSelectCommand(command);
ArrayList list = new ArrayList();
if (dt != null)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
NhaCungCapDTO dto = new NhaCungCapDTO();
dto.MaNhaCungCap = Convert.ToInt32(dt.Rows[i]["MaNhaCungCap"]);
dto.TenNhaCungCap = dt.Rows[i]["TenNhaCungCap"].ToString();
dto.DienThoai = dt.Rows[i]["DienThoai"].ToString();
dto.SoTaiKhoan = dt.Rows[i]["SoTaiKhoan"].ToString();
if (dt.Rows[i]["TongNo"].ToString() != "")
{
dto.TongNo = Convert.ToDecimal(dt.Rows[i]["TongNo"]);
}
list.Add(dto);
}
}
return(list);
}
public static List <ChiTietThucDonDTO> LayDanhSachMonAnTrongHoaDon(Guid maHoaDon, bool isPhantom, bool isDirtyRead, bool isUnrepeatableRead, bool isLostUpdate)
{
DbCommand command = DataAccessCode.CreateCommand();
bool isSecond = false;
if (GlobalVariables.bMacDinh || isLostUpdate)
{
command.CommandText = "dbo.LayDanhSachMonAnTrongHoaDon";
}
else
{
if (isPhantom)
{
isSecond = true;
if (GlobalVariables.bBongMa)
{
command.CommandText = "dbo.LayDanhSachMonAnTrongHoaDonPhantom";
}
else
{
command.CommandText = "dbo.LayDanhSachMonAnTrongHoaDonSolvePhantom";
}
}
else if (isDirtyRead)
{
if (GlobalVariables.bDuLieuRac)
{
command.CommandText = "dbo.LayDanhSachMonAnTrongHoaDonDirtyRead";
}
else
{
command.CommandText = "dbo.LayDanhSachMonAnTrongHoaDonSolveDirtyRead";
}
}
else if (isUnrepeatableRead)
{
isSecond = true;
if (GlobalVariables.bKhongTheDocLai)
{
command.CommandText = "dbo.LayDanhSachMonAnTrongHoaDonUnRepeatableRead";
}
else
{
command.CommandText = "dbo.LayDanhSachMonAnTrongHoaDonSolveUnRepeatableRead";
}
}
}
DbParameter param = command.CreateParameter();
param.ParameterName = "@MaHoaDon";
param.Value = maHoaDon.ToString();
param.DbType = DbType.String;
command.Parameters.Add(param);
DataTable dt;
if (isSecond)
{
dt = DataAccessCode.ExecuteSecondSelectCommand(command);
}
else
{
dt = DataAccessCode.ExecuteSelectCommand(command);
}
List <ChiTietThucDonDTO> list = new List <ChiTietThucDonDTO>();
if (dt != null)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
ChiTietThucDonDTO chiTietThucDon = new ChiTietThucDonDTO();
chiTietThucDon.MaChiTietThucDon = Int32.Parse(dt.Rows[i]["MaChiTietThucDon"].ToString());
chiTietThucDon.MaMonAn = Int32.Parse(dt.Rows[i]["MaMonAn"].ToString());
chiTietThucDon.TenMonAn = dt.Rows[i]["TenMonAn"].ToString();
chiTietThucDon.DonGia = Decimal.Parse(dt.Rows[i]["DonGia"].ToString());
chiTietThucDon.SoLuong = Int32.Parse(dt.Rows[i]["SoLuong"].ToString());
chiTietThucDon.MaChiTietHoaDon = Int32.Parse(dt.Rows[i]["MaChiTietHoaDon"].ToString());
chiTietThucDon.ThanhTien = chiTietThucDon.SoLuong * chiTietThucDon.DonGia;
list.Add(chiTietThucDon);
}
}
return(list);
}
public static List <ThongTinBanDTO> TimBanTrongSolvedPhanTom(int maNhaHang, int maKhuVuc, DateTime ngayDatBan, int buoi, int soLuong)
{
DbCommand command = DataAccessCode.CreateCommand();
command.CommandText = "dbo.CnTimBanTrongSolvedPhanTom";
// create a new parameter
DbParameter param = command.CreateParameter();
param.ParameterName = "@MaNhaHang";
if (maNhaHang == 0)
{
param.Value = DBNull.Value;
}
else
{
param.Value = maNhaHang;
}
param.DbType = DbType.Int32;
command.Parameters.Add(param);
// create a new parameter
param = command.CreateParameter();
param.ParameterName = "@MaKhuVuc";
if (maKhuVuc == 0)
{
param.Value = DBNull.Value;
}
else
{
param.Value = maKhuVuc;
}
param.DbType = DbType.Int32;
command.Parameters.Add(param);
// create a new parameter
param = command.CreateParameter();
param.ParameterName = "@NgayDatBan";
param.DbType = DbType.DateTime;
if (ngayDatBan == new DateTime())
{
param.Value = DBNull.Value;
}
else
{
param.Value = ngayDatBan;
}
command.Parameters.Add(param);
// create a new parameter
param = command.CreateParameter();
param.ParameterName = "@Buoi";
if (buoi == 0)
{
param.Value = DBNull.Value;
}
else
{
param.Value = buoi;
}
param.DbType = DbType.Int32;
command.Parameters.Add(param);
// create a new parameter
param = command.CreateParameter();
param.ParameterName = "@SoLuong";
if (soLuong == 0)
{
param.Value = DBNull.Value;
}
else
{
param.Value = soLuong;
}
param.DbType = DbType.Int32;
command.Parameters.Add(param);
DataTable dt = DataAccessCode.ExecuteSecondSelectCommand(command);
List <ThongTinBanDTO> list = new List <ThongTinBanDTO>();
if (dt != null)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
ThongTinBanDTO thongTinBan = new ThongTinBanDTO();
thongTinBan.MaBan = Int32.Parse(dt.Rows[i]["MaBan"].ToString());
thongTinBan.SucChua = Int32.Parse(dt.Rows[i]["SucChua"].ToString());
thongTinBan.MaNhaHang = Int32.Parse(dt.Rows[i]["MaNhaHang"].ToString());
thongTinBan.GiaBan = Decimal.Parse(dt.Rows[i]["GiaBan"].ToString());
thongTinBan.MaKhuVuc = Int32.Parse(dt.Rows[i]["MaKhuVuc"].ToString());
list.Add(thongTinBan);
}
}
return(list);
}
