private void KhoiTao(string LyDo) { grdvDSThuChi.Columns.Clear(); if (grdvDSThuChi.Rows.Count > 0) { grdvDSThuChi.Rows.Clear(); } DataTable Bang; if (LyDo == "Tất cả") { Bang = CongTyBus.LayBangChiTietThuChi(dtpTuNgay.Value, dtpDenNgay.Value, "TatCa", txtDoiTuong.Text.Trim()); } else { Bang = CongTyBus.LayBangChiTietThuChi(dtpTuNgay.Value, dtpDenNgay.Value, LyDo, txtDoiTuong.Text.Trim()); } Double TienTonDauKy = CongTyBus.LayTienTonDauKy(); Double TienTonCuoiKy = TienTonDauKy; for (int i = 0; i < Bang.Rows.Count; i++) { Double TienThu = double.Parse(Bang.Rows[i]["Thu"].ToString()); Double TienChi = double.Parse(Bang.Rows[i]["Chi"].ToString()); TienTonCuoiKy = TienTonCuoiKy + TienThu - TienChi; Bang.Rows[i]["Ton"] = TienTonCuoiKy; } txtTonDauDy.Text = clsSupport.CurrencyNumber(TienTonDauKy.ToString()); txtTonCuoiKy.Text = clsSupport.CurrencyNumber(TienTonCuoiKy.ToString()); grdvDSThuChi.DataSource = Bang; AnCotTrenLuoi(); DinhDangCot(); btnInRa.Enabled = true; }
private void frmTienQuyDauKy_Load(object sender, EventArgs e) { try { Double TienTonDauKy = CongTyBus.LayTienTonDauKy(); txtTienQuyDauKy.Text = clsSupport.CurrencyNumber(TienTonDauKy.ToString()); } catch (Exception ex) { MessageBox.Show("Lỗi kết nối cơ sở dữ liệu.", "Thông báo lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } }