private void btnThemPDH_Click(object sender, EventArgs e) { try { TongTien = 0; PhieuDatHangDTO pdh = new PhieuDatHangDTO(); pdh.year = dtpNgayLap_PDH.Value.Year; pdh.month = dtpNgayLap_PDH.Value.Month; pdh.day = dtpNgayLap_PDH.Value.Day; pdh.ma_pdh = txtMa_PDH.Text; string ma = txtMaKhachHang_PDH.Text; KhachHangDTO kHang = new KhachHangDTO(); kHang = KhachHangBUS.Search_KH(ma); pdh.ma_kh = kHang.ma_kh; pdh.ma_nv = cbxNhanvien.SelectedValue.ToString(); PhieuDatHangBUS.Insert_PDH(pdh); load_data(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public static void Delete_KH(KhachHangDTO kh) { try { HoaDonDTO hd = new HoaDonDTO(); PhieuDatHangDTO pdh = new PhieuDatHangDTO(); List <string> ds = new List <string>(); string delete_kh = string.Format("DELETE FROM db_khach_hang WHERE ma_kh='{0}'", kh.ma_kh); string delete_hd_in_kh = string.Format("SELECT ma_hd FROM db_hoa_don WHERE ma_kh = '{0}'", kh.ma_kh); string delete_pdh_in_kh = string.Format("SELECT ma_pdh FROM db_phieu_dat_hang WHERE ma_kh = '{0}'", kh.ma_kh); ds = Xoa_thong_tin(delete_hd_in_kh); for (int i = 0; i < ds.Count; i++) { hd.ma_hd = ds[0]; ChiTietHoaDonDAO.delete_SPHD(hd); HoaDonDAO.Delete_HD(hd); } ds = Xoa_thong_tin(delete_pdh_in_kh); for (int i = 0; i < ds.Count; i++) { pdh.ma_pdh = ds[0]; ChiTietPhieuDatHangDAO.delete_SPPDH(pdh); PhieuDatHangDAO.Delete_PDH(pdh); } cnn = DataProvider.ConnectData(); DataProvider.Execute(cnn, delete_kh); cnn.Close(); } catch (Exception ex) { throw ex; } }
public static double SumPDH_TheoMa(PhieuDatHangDTO pdh) { try { string select = string.Format("SELECT SUM(thanhtien) FROM chi_tiet_pdh WHERE ma_pdh ='{0}';", pdh.ma_pdh); return(Sum(select)); } catch (Exception ex) { throw ex; } }
public static void update_Gia(PhieuDatHangDTO pdh) { try { cnn = DataProvider.ConnectData(); string update_gia = string.Format("UPDATE db_phieu_dat_hang SET tonggiatri='{0}' WHERE ma_pdh='{1}'", pdh.tonggiatri, pdh.ma_pdh); DataProvider.Execute(cnn, update_gia); cnn.Close(); } catch (Exception ex) { throw ex; } }
/// <summary> /// xóa 1 phiếu đặt hàng /// </summary> /// <param name="pdh"></param> public static void Delete_PDH(PhieuDatHangDTO pdh) { try { cnn = DataProvider.ConnectData(); string delete = string.Format("DELETE FROM chi_tiet_pdh WHERE ma_pdh = '{0}';DELETE FROM db_phieu_dat_hang WHERE ma_pdh = '{0}';", pdh.ma_pdh); DataProvider.Execute(cnn, delete); cnn.Close(); } catch (Exception ex) { throw ex; } }
public static void Insert_PDH(PhieuDatHangDTO pdh) { try { cnn = DataProvider.ConnectData(); string insert = string.Format("insert into db_phieu_dat_hang(ma_pdh,ma_nv,ma_kh,ngay_lap) values ('{0}','{1}','{2}','{3}/{4}/{5}');", pdh.ma_pdh, pdh.ma_nv, pdh.ma_kh, pdh.year, pdh.month, pdh.day); DataProvider.Execute(cnn, insert); cnn.Close(); } catch (Exception ex) { throw ex; } }
/// <summary> /// Tìm theo mã phiếu /// </summary> /// <returns></returns> public static DataTable Search_Ma(PhieuDatHangDTO pdh) { try { DataTable dt = new DataTable(); cnn = DataProvider.ConnectData(); string select = string.Format("SELECT ma_pdh,db_nhanvien.ten_nv,db_khach_hang.ten_kh,ngay_lap,tonggiatri FROM db_phieu_dat_hang inner join db_nhanvien on db_phieu_dat_hang.ma_nv = db_nhanvien.ma_nv inner join db_khach_hang on db_phieu_dat_hang.ma_kh = db_khach_hang.ma_kh WHERE ma_pdh = '{0}'", pdh.ma_pdh); dt = DataProvider.Load_database(select, cnn); cnn.Close(); return(dt); } catch (Exception ex) { throw ex; } }
public static void delete_SPPDH(PhieuDatHangDTO pdh) { try { cnn = DataProvider.ConnectData(); string id = string.Format("Delete FROM chi_tiet_pdh WHERE ma_pdh='{0}';", pdh.ma_pdh); DataTable dt = new DataTable(); MySqlDataAdapter da = new MySqlDataAdapter(id, cnn); DataProvider.Execute(cnn, id); cnn.Close(); } catch (Exception ex) { throw ex; } }
/// <summary> /// load theo mã phiếu đặt hàng /// </summary> /// <returns></returns> public static DataTable Load_DSTheoMaPDH(PhieuDatHangDTO pdh) { try { DataTable dt = new DataTable(); cnn = DataProvider.ConnectData(); string select = string.Format("SELECT ma_pdh,chi_tiet_pdh.ma_sp,db_sanpham.ten_sp,chi_tiet_pdh.soluong,db_sanpham.gia_sp,thanhtien FROM chi_tiet_pdh inner join db_sanpham on chi_tiet_pdh.ma_sp = db_sanpham.ma_sp WHERE ma_pdh='{0}'", pdh.ma_pdh); dt = DataProvider.Load_database(select, cnn); cnn.Close(); return(dt); } catch (Exception ex) { throw ex; } }
private void btnxoaspn_Click(object sender, EventArgs e) { try { SanPhamDTO sp = new SanPhamDTO(); txtMaSanPham.Text = dgvCTPDH.CurrentRow.Cells[1].Value.ToString(); sp.ma_sp = txtMaSanPham.Text; PhieuDatHangDTO pdhn = new PhieuDatHangDTO(); pdhn.ma_pdh = txtMa_PDH.Text; PhieuDatHangBUS.delete_sppdh(sp, pdhn); load_data(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public static double SumPDH_theoma(PhieuDatHangDTO pdh) { return(ThongKeDAO.SumPDH_TheoMa(pdh)); }
public static void Update_gia(PhieuDatHangDTO pdh) { PhieuDatHangDAO.update_Gia(pdh); }
public static void delete_sppdh(SanPhamDTO sp, PhieuDatHangDTO pdh) { ChiTietPhieuDatHangDAO.delete_SPPDH(sp, pdh); }
public static void Insert_PDH(PhieuDatHangDTO pdh) { PhieuDatHangDAO.Insert_PDH(pdh); }
public static void delete_sppdh(PhieuDatHangDTO pdh) { ChiTietPhieuDatHangDAO.delete_SPPDH(pdh); }
public static DataTable Search_NgayLPDH(PhieuDatHangDTO pdh) { return(PhieuDatHangDAO.Search_NgayLPDH(pdh)); }
public static DataTable Search_Ma(PhieuDatHangDTO pdh) { return(PhieuDatHangDAO.Search_Ma(pdh)); }
public static DataTable Load_DSTheoMaPDH(PhieuDatHangDTO pdh) { return(ChiTietPhieuDatHangDAO.Load_DSTheoMaPDH(pdh)); }
public static void Delete_PDH(PhieuDatHangDTO pdh) { PhieuDatHangDAO.Delete_PDH(pdh); }