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);
}
