public static List <ChiTietThucDonDTO> LayDanhSachMonAnTheoNhaHang(int maNhaHang, DateTime ngay) { DbCommand command = DataAccessCode.CreateCommand(); command.CommandText = "dbo.LayDanhSachMonAnTheoNhaHang"; DbParameter param = command.CreateParameter(); param.ParameterName = "@MaNhaHang"; param.Value = maNhaHang; param.DbType = DbType.Int32; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@Ngay"; param.Value = ngay; param.DbType = DbType.DateTime; command.Parameters.Add(param); DataTable 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()); list.Add(chiTietThucDon); } } 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); }