Пример #1
0
        private void LoadTC()
        {
            String maTC = cmbMaTiecCuoi.Text;

            DTO.DTO_TiecCuoi tc = BUS_DatTiecCuoi.getThongTinTiecCuoi(maTC);
            if (tc == null)
            {
                HienThiDsMonAn(maTC);
                HienThiDsDichVu(maTC);
                CapNhatBtt(maTC);
                KiemTraSanhTrong();
                return;
            }
            DTO.DTO_KhachHang kh = BUS_DatTiecCuoi.getThongTinKhachHang(tc.MA_KHACH_HANG);
            cmbSanh.Text     = tc.MA_SANH.Trim();
            cmbCa.Text       = tc.MA_CA.Trim();
            numSLBan.Value   = tc.SL_BAN;
            numSLDuTru.Value = tc.SL_BAN_DU_TRU;
            tbDatCoc.Text    = tc.TIEN_DAT_COC.ToString();
            HienThiThongTinKH(kh);
            HienThiThongTinTC(tc);
            HienThiDsMonAn(maTC);
            HienThiDsDichVu(maTC);
            KiemTraSanhTrong();
            CapNhatBtt(maTC);
        }
Пример #2
0
 private void HienThiThongTinTC(DTO.DTO_TiecCuoi tc)
 {
     DTO.DTO_Sanh s = BUS_DatTiecCuoi.getThongTinSanh(tc.MA_SANH);
     DTO.DTO_Ca   c = BUS_DatTiecCuoi.getThongTinCa(tc.MA_CA);
     dateTimePicker1.Text = tc.NGAY_TO_CHUC;
     cmbCa.Text           = c.MA_CA;
 }
Пример #3
0
        public static DTO.DTO_TiecCuoi getThongTinTiecCuoi(String maTC)
        {
            String sql = String.Format(@"SELECT * FROM TIEC_CUOI WHERE MA_TIEC_CUOI = '{0}'", maTC);

            Console.WriteLine(sql);
            DataTable da = DatabaseHelper.GetData(sql);

            DTO.DTO_TiecCuoi result = null;
            if (da.Rows.Count > 0)
            {
                Console.WriteLine("ok");
                result = new DTO.DTO_TiecCuoi();
                DataRow row = da.Rows[0];
                result.MA_TIEC_CUOI  = maTC;
                result.MA_KHACH_HANG = row["MA_KHACH_HANG"].ToString();
                result.MA_SANH       = row["MA_SANH"].ToString();
                result.NGAY_TO_CHUC  = row["NGAY_TO_CHUC"].ToString();
                result.MA_CA         = row["MA_CA"].ToString();
                result.TIEN_DAT_COC  = int.Parse(row["TIEN_DAT_COC"].ToString());
                result.SL_BAN        = int.Parse(row["SL_BAN"].ToString());
                result.SL_BAN_DU_TRU = int.Parse(row["SL_BAN_DU_TRU"].ToString());
            }
            Console.WriteLine("ok");
            return(result);
        }
Пример #4
0
        public static bool capNhatThongTinTiecCuoi(DTO.DTO_TiecCuoi tc)
        {
            String sql = String.Format(@"UPDATE TIEC_CUOI SET MA_KHACH_HANG = '{1}', MA_SANH = '{2}', NGAY_TO_CHUC = '{3}', MA_CA = '{4}', TIEN_DAT_COC = {5}, SL_BAN = {6}, SL_BAN_DU_TRU = {7} WHERE MA_TIEC_CUOI='{0}' ",
                                       tc.MA_TIEC_CUOI, tc.MA_KHACH_HANG, tc.MA_SANH, tc.NGAY_TO_CHUC, tc.MA_CA, tc.TIEN_DAT_COC, tc.SL_BAN, tc.SL_BAN_DU_TRU);

            if (DatabaseHelper.ExcuteSql(sql) > 0)
            {
                return(true);
            }
            return(false);
        }
Пример #5
0
        public static bool themTiecCuoi(DTO.DTO_TiecCuoi tc)
        {
            String sql = String.Format(@"INSERT INTO TIEC_CUOI (MA_TIEC_CUOI, MA_KHACH_HANG, MA_SANH, NGAY_TO_CHUC, MA_CA, TIEN_DAT_COC, SL_BAN, SL_BAN_DU_TRU) VALUES ('{0}','{1}','{2}','{3}','{4}',{5},{6},{7})",
                                       tc.MA_TIEC_CUOI, tc.MA_KHACH_HANG, tc.MA_SANH, tc.NGAY_TO_CHUC, tc.MA_CA, tc.TIEN_DAT_COC, tc.SL_BAN, tc.SL_BAN_DU_TRU);

            Console.WriteLine(sql);
            if (DatabaseHelper.ExcuteSql(sql) > 0)
            {
                return(true);
            }
            return(false);
        }
Пример #6
0
        private void TinhTienMonAn()
        {
            int sum = 0;

            DTO.DTO_TiecCuoi x = BUS_DatTiecCuoi.getThongTinTiecCuoi(cmbMaTiecCuoi.Text);
            if (x == null)
            {
                return;
            }
            int u = x.SL_BAN;

            for (int i = 0; i < dtMA.Rows.Count - 1; i++)
            {
                sum += int.Parse(dtMA.Rows[i].Cells[2].Value.ToString().Trim());
            }
            sum          *= u;
            lbTienAn.Text = sum.ToString();
        }
Пример #7
0
        private void Button9_Click(object sender, EventArgs e)
        {
            bool state = CheckThongTinTC();

            if (!state)
            {
                return;
            }
            String maTC       = cmbMaTiecCuoi.Text;
            String maKH       = cmbMaKH.Text;
            String maS        = cmbSanh.Text;
            String maCa       = cmbCa.Text;
            String ngayToChuc = dateTimePicker1.Value.ToString("yyyy-MM-dd");;
            int    tienDatCoc = int.Parse(tbDatCoc.Text);
            int    slBan      = int.Parse(numSLBan.Value.ToString());
            int    slDuTru    = int.Parse(numSLDuTru.Value.ToString());

            DTO.DTO_TiecCuoi tc = new DTO.DTO_TiecCuoi(maTC, maKH, maS, ngayToChuc, maCa, tienDatCoc, slBan, slDuTru);
            if (BUS_DatTiecCuoi.getDsMaTiecCuoi().Contains(maTC))
            {
                if (BUS_DatTiecCuoi.capNhatThongTinTiecCuoi(tc))
                {
                    MessageBox.Show("Cập nhật thành công.");
                }
                else
                {
                    MessageBox.Show("Cập nhật thất bại.");
                }
            }
            else
            {
                if (BUS_DatTiecCuoi.themTiecCuoi(tc))
                {
                    MessageBox.Show("Thêm thành công.");
                    cmbMaTiecCuoi.Items.Add(maTC);
                    CapNhatBtt(maTC);
                }
                else
                {
                    MessageBox.Show("Thêm thất bại.");
                }
            }
        }
Пример #8
0
        private void HienThiHoaDon(string ma)
        {
            DTO.DTO_TiecCuoi  tc   = BUS.BUS_LapHoaDon.getThongTinTiecCuoi(ma);
            DTO.DTO_KhachHang kh   = BUS.BUS_LapHoaDon.getThongTinKhachHang(tc.MA_KHACH_HANG);
            DTO.DTO_Sanh      sanh = BUS.BUS_LapHoaDon.getThongTinSanh(tc.MA_SANH);
            DTO.DTO_LoaiSanh  ls   = BUS.BUS_LapHoaDon.getThongTinLoaiSanh(sanh.MA_LOAI_SANH);

            lbTenChuRe.Text = kh.TEN_CHU_RE;
            lbTenCoDau.Text = kh.TEN_CO_DAU;
            lbSDT.Text      = kh.SDT;

            lbSanh.Text       = sanh.TEN_SANH;
            lbSLBan.Text      = (tc.SL_BAN + tc.SL_BAN_DU_TRU).ToString();
            lbDonGia.Text     = ls.DON_GIA_TOI_THIEU.ToString();
            lbNgayToChuc.Text = tc.NGAY_TO_CHUC.ToString().Split()[0];
            lbTienDatCoc.Text = tc.TIEN_DAT_COC.ToString();

            lbTongTienBan.Text = ((tc.SL_BAN + tc.SL_BAN_DU_TRU) * ls.DON_GIA_TOI_THIEU - tc.TIEN_DAT_COC).ToString();
            HienThiDsMonAn(tc.MA_TIEC_CUOI);
            HienThiDsDichVu(tc.MA_TIEC_CUOI);

            TinhTienPhat();
        }
Пример #9
0
 public static bool UpdateTiecCuoi(DTO.DTO_TiecCuoi tiecCuoiInfo)
 {
     return(DAO.DAO_LapHoaDonThanhToan.UpdateTiecCuoi(tiecCuoiInfo));
 }