private void loadHoaDon() { try { double giaPhong = 100000; dtHoaDon = DTBill.getAllWhere("HOADON", "PHONG = " + txtSoPhong.Tag.ToString() + " AND (TinhTrang = 0 OR TinhTrang = 1)"); string maHD = dtHoaDon.Rows[0]["MaHoaDon"].ToString(); txtSoBill.Text = dtHoaDon.Rows[0]["MaHoaDon"].ToString(); txtPhiDichVu.Text = dtHoaDon.Rows[0]["TongGia"].ToString(); DataTable dtRent = DTRent.getAllWhere("PHIEUTHUE", "MaPhieuThue = " + txtMaPhieuThue.Text); DateTime dateNgayThue = DateTime.ParseExact(dtRent.Rows[0]["NgayBatDau"].ToString(), "dd/MM/yyyy HH:mm:ss", CultureInfo.InvariantCulture); DateTime dateNgayTra = DateTime.ParseExact(dtRent.Rows[0]["NgayKetThuc"].ToString(), "dd/MM/yyyy HH:mm:ss", CultureInfo.InvariantCulture); double tienThuePhong = Math.Floor((dateNgayTra - dateNgayThue).TotalHours / 24 * giaPhong); txtTienThuePhong.Text = tienThuePhong.ToString(); double phuThu = dtKH.Rows[0]["LoaiKHID"].ToString() == "1" ? 0 : (tienThuePhong * 0.1); txtPhuThu.Text = phuThu.ToString(); txtVAT.Text = ((Double.Parse(dtHoaDon.Rows[0]["TongGia"].ToString()) + tienThuePhong) * 0.1).ToString(); txtTongTien.Text = (Double.Parse(dtHoaDon.Rows[0]["TongGia"].ToString()) + tienThuePhong + ((Double.Parse(dtHoaDon.Rows[0]["TongGia"].ToString()) + tienThuePhong) * 0.1) + phuThu).ToString(); } catch (Exception) { MessageBox.Show("Vui lòng chọn mũi giờ Việt Nam!"); throw; } }
private void btnThemDV_Click(object sender, EventArgs e) { string maDV = txtDichVuSelect.Text; if (String.IsNullOrEmpty(maDV)) { MessageBox.Show("Bạn phải chọn 1 dịch vụ khi thêm!"); } else { string[] values = { txtSoBill.Text, maDV, DateTime.Now.ToString("yyyy-MM-dd"), txtSoPhong.Tag.ToString() }; if (DTBillDetail.create(values)) { // //DataRow dr = new DataRow(txtSoBill.Text, maDV, DateTime.Now.ToString("yyyy-MM-dd"), txtSoPhong.Tag.ToString()); DataTable dtCTHD = DTBillDetail.getAllWhere("CHITIETHOADON", "MAHD = " + txtSoBill.Text + " AND Phong = " + txtSoPhong.Tag.ToString()); if (dtCTHD.Rows.Count != 0) { string[] arrayDV = new string[dtCTHD.Rows.Count]; for (int i = 0; i < dtCTHD.Rows.Count; i++) { arrayDV[i] = dtCTHD.Rows[i]["MaDichVu"].ToString(); } dtDVSD = DTService.getAllWhere("DICHVU", "MaDichVu in (" + String.Join(",", arrayDV) + ")"); DataColumn[] keysDVSD = new DataColumn[1]; keysDVSD[0] = dtDVSD.Columns[0]; dtDVSD.PrimaryKey = keysDVSD; gridControlDVSuDung.DataSource = dtDVSD; decimal giaDVselected = 0; foreach (DataRow item in dtDVSD.Rows) { if (item["MaDichVu"].ToString() == maDV) { giaDVselected = Decimal.Parse(item["Gia"].ToString()); } } DataTable dtHD = DTBill.getAllWhere("HOADON", "MaHoaDon = " + dtCTHD.Rows[0]["MaHD"].ToString()); if (DTBill.update("TongGia = " + (Decimal.Parse(dtHD.Rows[0]["TongGia"].ToString()) + giaDVselected), "MaHoaDon = " + dtCTHD.Rows[0]["MaHD"].ToString())) { //HD loadHoaDon(); } else { MessageBox.Show("Lỗi Khi cập nhật hóa đơn!"); } } else { dtDVSD = new DataTable(); gridControlDVSuDung.DataSource = dtDVSD; } } else { MessageBox.Show("Lỗi không thêm được dịch vụ!"); } } }