public bool them(CHITIETHOADONBAN pmh) { try { data.CHITIETHOADONBANs.InsertOnSubmit(pmh); data.SubmitChanges(); return(true); } catch (Exception e) { return(false); } }
public bool xoa(CHITIETHOADONBAN pmh) { try { CHITIETHOADONBAN mh = data.CHITIETHOADONBANs.Where(t => t.MACTHDB == pmh.MACTHDB.ToString()).FirstOrDefault(); data.CHITIETHOADONBANs.DeleteOnSubmit(mh); data.SubmitChanges(); return(true); } catch { return(false); } }
public bool ktkc(CHITIETHOADONBAN ma) { int r = data.CHITIETHOADONBANs.Count(t => t.MACTHDB == ma.MACTHDB.ToString()); try { if (r == 0) { return(true); } return(false); } catch { return(false); } }
private void buttonX3_Click(object sender, EventArgs e) { try { CHITIETHOADONBAN bb = new CHITIETHOADONBAN(); if (txtmacthdb.Text == "" || txtmahd.Text == "" || txtmasp.Text == "" || cbososize.Text == "" || txtmabh.Text == "" || kHUYENMAIComboBox.Text == "" || txtsl.Text == "" || txtdongia.Text == "") { MessageBox.Show("không được để trống"); return; } var ktpbh = ( from ct in db.PHIEUBAOHANHs where ct.MABH == txtmabh.Text.ToString() select bb).Count(); if (ktpbh == 0) { frm_BaoHanh bh = new frm_BaoHanh(); bh.ShowDialog(); } var kt = from s in db.CHITIETHOADONBANs where s.MACTHDB == txtmacthdb.Text select s; if (kt.Count() > 0) { MessageBox.Show("Trùng khóa chính"); return; } bb.MACTHDB = txtmacthdb.Text; bb.MAHD = txtmahd.Text; bb.MASP = txtmasp.Text; bb.SOSIZE = Convert.ToInt16(cbososize.Text); bb.MABH = txtmabh.Text; bb.MAKM = kHUYENMAIComboBox.SelectedValue.ToString(); bb.SOLUONGBAN = Convert.ToInt32(txtsl.Text); bb.DONGIABAN = Convert.ToDouble(txtdongia.Text); db.CHITIETHOADONBANs.InsertOnSubmit(bb); db.SubmitChanges(); insert(); MessageBox.Show("Thành công"); } catch { return; } }
public bool xoacthdb(CHITIETHOADONBAN n) { return(hd.xoa(n)); }
public bool themcthd(CHITIETHOADONBAN n) { return(hd.them(n)); }
public bool Xoa_CTHDB(CHITIETHOADONBAN cthdb) { return(dal_BanHang.xoa_CTHDB(cthdb)); }
public bool KTKC_cthdb(CHITIETHOADONBAN cthdb) { return(dal_BanHang.ktkc_cthdb(cthdb)); }
public bool them_CTHDB(CHITIETHOADONBAN cthdb) { return(dal_BanHang.them_CTHoaDonBan(cthdb)); }
private void buttonX2_Click(object sender, EventArgs e) { try { Double t = 0; CHITIETHOADONBAN hdb = new CHITIETHOADONBAN(); hdb.MACTHDB = dgv_cthdb.CurrentRow.Cells[0].Value.ToString(); hdb.MAHD = dgv_cthdb.CurrentRow.Cells[1].Value.ToString(); hdb.MASP = dgv_cthdb.CurrentRow.Cells[2].Value.ToString(); PHIEUBAOHANH pbh = new PHIEUBAOHANH(); pbh.MABH = dgv_cthdb.CurrentRow.Cells[4].Value.ToString(); Double money = Convert.ToDouble(dgv_cthdb.CurrentRow.Cells[6].Value.ToString()) * Convert.ToDouble(dgv_cthdb.CurrentRow.Cells[7].Value.ToString()); KHO kh = new KHO(); kh.MASP = dgv_cthdb.CurrentRow.Cells[2].Value.ToString(); int ktkho = bll_hdb.capnhatkho1(dgv_cthdb.CurrentRow.Cells[2].Value.ToString(), Convert.ToInt32(dgv_cthdb.CurrentRow.Cells[6].Value.ToString())); kh.SOLUONG = ktkho; if (bll_cthd.xoacthdb(hdb) == true) { MessageBox.Show("xóa thành công"); dgv_cthdb.DataSource = bll_cthd.loadbangghep_cthd(); if (bh_bll.xoapbh(pbh) == true) { MessageBox.Show("xóa phiếu bảo hành thành công"); } else { MessageBox.Show("xóa phiếu bảo hành thất bại"); } if (kho_bll.ktkc_kho(kh) == false) { if (kho_bll.suakho(kh) == true) { MessageBox.Show("cập nhật kho thành công"); } } Double tt = 0; HOADONBAN hdb1 = new HOADONBAN(); hdb1.MAHD = txt_mahd.Text.ToString(); hdb1.NGAYLAP = Convert.ToDateTime(dateEdit_NgayLap.Text.ToString()); hdb1.MANV = txt_nvlap.Text.ToString(); if (radioButton1.Checked == true) { hdb1.MAKHTT = txt_khtt.Text.ToString(); tt = Convert.ToDouble(txt_chietkhau.Text.ToString()); Double gtbd = (1 - Convert.ToDouble(txt_mucgiam.Text.ToString())) / Convert.ToDouble(txt_tinhtranghang.Text.ToString()); hdb1.TONGTIEN = (gtbd - (money - (money * Convert.ToDouble(txt_mucgiam.Text.ToString())))) - (gtbd + (money - (money * Convert.ToDouble(txt_mucgiam.Text.ToString())))) * tt; } else { tt = 0; hdb1.TONGTIEN = Convert.ToDouble(txt_tinhtranghang.Text.ToString()) - (money - (money * Convert.ToDouble(txt_mucgiam.Text.ToString()))); hdb1.KHVANGLAI = txt_kvl.Text.ToString(); } hdb1.CHIECKHAU = tt; if (bll_hdb.ktkc_hdb(hdb1) == false) { if (bll_hdb.suahdb(hdb1) == true) { MessageBox.Show("sửa thành công"); dgv_hdb.DataSource = bll_hdb.loadbang_hdb(); } else { MessageBox.Show("thất bại"); } } else { MessageBox.Show("hóa đơn này chưa tồn tại"); } } else { MessageBox.Show("thất bại"); } } catch { return; } }
private void buttonX1_Click(object sender, EventArgs e) { try { Double t = 0; CHITIETHOADONBAN hdb = new CHITIETHOADONBAN(); int b = 0; for (int i = 1; i <= dgv_cthdb.RowCount; i++) { b = i; } hdb.MACTHDB = "CTHD" + (b + 1).ToString() + DateTime.Now.Second.ToString(); hdb.MAHD = dgv_hdb.CurrentRow.Cells[0].Value.ToString(); hdb.MASP = txt_msp.Text.ToString(); PHIEUBAOHANH pbh = new PHIEUBAOHANH(); String tem = DateTime.Now.ToString(); pbh.MABH = tem; pbh.MASP = txt_msp.Text.ToString(); pbh.NGAYHETHANDOITRA = DateTime.Now.AddDays(7); hdb.MAKM = null; hdb.SOLUONGBAN = Convert.ToInt32(txt_sldat.Text.ToString()); hdb.DONGIABAN = bll_hdb.laygiasp(txt_msp.Text.ToString()); Double money = Convert.ToDouble(txt_sldat.Text.ToString()) * Convert.ToDouble(txt_gia.Text.ToString()); hdb.SIZEGIAY = Convert.ToInt32(cb_sizegiay.Text.ToString()); KHO kh = new KHO(); kh.MASP = txt_msp.Text.ToString(); int ktkho = bll_hdb.capnhatkho(txt_msp.Text.ToString(), Convert.ToInt32(txt_sldat.Text.ToString())); if (ktkho >= 0) { kh.SOLUONG = ktkho; } else { MessageBox.Show("số lượng không đủ"); return; } if (bh_bll.thempbh(pbh) == true) { MessageBox.Show("thêm phiếu bảo hành thành công"); hdb.MABH = tem; } else { hdb.MABH = null; } if (bll_cthd.themcthd(hdb) == true) { MessageBox.Show("thêm thành công"); dgv_cthdb.DataSource = bll_cthd.loadbangghep_cthd(); if (kho_bll.ktkc_kho(kh) == false) { if (kho_bll.suakho(kh) == true) { MessageBox.Show("cập nhật kho thành công"); } } Double tt = 0; HOADONBAN hdb1 = new HOADONBAN(); hdb1.MAHD = txt_mahd.Text.ToString(); hdb1.NGAYLAP = Convert.ToDateTime(dateEdit_NgayLap.Text.ToString()); hdb1.MANV = txt_nvlap.Text.ToString(); if (radioButton1.Checked == true) { hdb1.MAKHTT = txt_khtt.Text.ToString(); tt = Convert.ToDouble(txt_chietkhau.Text.ToString()); hdb1.TONGTIEN = (Convert.ToDouble(txt_tinhtranghang.Text.ToString()) + (money - (money * Convert.ToDouble(txt_mucgiam.Text.ToString())))) - (Convert.ToDouble(txt_tinhtranghang.Text.ToString()) + (money - (money * Convert.ToDouble(txt_mucgiam.Text.ToString())))) * tt; } else { tt = 0; hdb1.TONGTIEN = Convert.ToDouble(txt_tinhtranghang.Text.ToString()) + (money - (money * Convert.ToDouble(txt_mucgiam.Text.ToString()))); hdb1.KHVANGLAI = txt_kvl.Text.ToString(); } hdb1.CHIECKHAU = tt; if (bll_hdb.ktkc_hdb(hdb1) == false) { if (bll_hdb.suahdb(hdb1) == true) { MessageBox.Show("sửa thành công"); dgv_hdb.DataSource = bll_hdb.loadbang_hdb(); } else { MessageBox.Show("thất bại"); } } else { MessageBox.Show("hóa đơn này chưa tồn tại"); } } else { MessageBox.Show("thất bại"); } } catch { return; } }