public NHATKINHAPSACH editNhatKiNhapSach(NHATKINHAPSACH nkns, int oldMaNhatKiNhapSach) { NHATKINHAPSACH nhatkinhapsach_re = (from c in entity.NHATKINHAPSACHes where c.STT == oldMaNhatKiNhapSach select c).FirstOrDefault(); int change; if (nhatkinhapsach_re.SOLUONG > nkns.SOLUONG) { change = (int)(nhatkinhapsach_re.SOLUONG - nkns.SOLUONG); KHO kho = (from c in entity.KHOes where c.MASACH == nhatkinhapsach_re.MASACH select c).FirstOrDefault(); kho.TONGSOLUONG = kho.TONGSOLUONG - change; } else { change = (int)(nkns.SOLUONG - nhatkinhapsach_re.SOLUONG); KHO kho = (from c in entity.KHOes where c.MASACH == nhatkinhapsach_re.MASACH select c).FirstOrDefault(); kho.TONGSOLUONG = kho.TONGSOLUONG + change; } nhatkinhapsach_re.MASACH = nkns.MASACH; //saveNhatKiNhapSach(nkns); //deleteNhatKiNhapSach(nhatkinhapsach_re.STT); nhatkinhapsach_re.NGAYNHAP = nkns.NGAYNHAP; nhatkinhapsach_re.SOLUONG = nkns.SOLUONG; entity.SaveChanges(); return(nhatkinhapsach_re); //nhatkinhapsach cu }
private void tx_TextChanged(object sender, EventArgs e) { try { long value = long.Parse(txt.Text); var ob = cb.SelectedItem; if (ob.GetType().Name == "KHO") { KHO _e = DataInstance.Instance().DBContext().KHOes.Where(u => u.ID == value).First(); cb.SelectedItem = _e; } if (ob.GetType().Name == "NHA_CUNG_CAP") { NHA_CUNG_CAP _e = DataInstance.Instance().DBContext().NHA_CUNG_CAP.Where(u => u.ID == value).First(); cb.SelectedItem = _e; } if (ob.GetType().Name == "KHACH_HANG") { KHACH_HANG _e = DataInstance.Instance().DBContext().KHACH_HANG.Where(u => u.ID == value).First(); cb.SelectedItem = _e; } if (ob.GetType().Name == "HANG_HOA") { HANG_HOA _e = DataInstance.Instance().DBContext().HANG_HOA.Where(u => u.ID == value).First(); cb.SelectedItem = _e; } } catch (Exception ex) { } }
public ActionResult Delete(int id) { if (id <= 0) { ViewBag.Message = "Không tìm thấy khu vực tương ứng."; return(View("../Home/Error"));; } var ctx = new SmsContext(); KHO khuVuc = ctx.KHOes.Find(id); if (khuVuc.ACTIVE.Equals("A")) { khuVuc.ACTIVE = "I"; khuVuc.UPDATE_AT = DateTime.Now; khuVuc.UPDATE_BY = (int)Session["UserId"]; ctx.SaveChanges(); ctx.Dispose(); return(RedirectToAction("Index").Success("Xóa thành công.")); } else { ctx.Dispose(); ViewBag.Message = "Không tìm thấy khu vực tương ứng."; return(View("../Home/Error"));; } }
private void cb_SelectedValueChanged(object sender, EventArgs e) { try { var ob = cb.SelectedItem; if (ob.GetType().Name == "KHO") { KHO _e = (KHO)cb.SelectedItem; txt.Text = _e.ID.ToString(); } if (ob.GetType().Name == "NHA_CUNG_CAP") { NHA_CUNG_CAP _e = (NHA_CUNG_CAP)cb.SelectedItem; txt.Text = _e.ID.ToString(); } if (ob.GetType().Name == "KHACH_HANG") { KHACH_HANG _e = (KHACH_HANG)cb.SelectedItem; txt.Text = _e.ID.ToString(); } if (ob.GetType().Name == "HANG_HOA") { HANG_HOA _e = (HANG_HOA)cb.SelectedItem; txt.Text = _e.ID.ToString(); } txt.Select(); txt.SelectAll(); } catch (Exception ex) { } }
public bool suakho(string makho, string tenkho, string ghichu) { if (kTraKhoaChinh(makho) == 1) { List <KHO> list = loadKho(); KHO a = new KHO(); a = qlkho.KHOs.Where(bp => bp.MAKHO == makho.Trim()).FirstOrDefault(); a.TENKHO = tenkho; a.GHICHU = ghichu; foreach (KHO b in list) { if (b.MAKHO == makho) { qlkho.KHOs.DeleteOnSubmit(b); qlkho.SubmitChanges(); } } qlkho.SubmitChanges(); return(true); } else { return(false); } }
private void btnThemKho_Click(object sender, EventArgs e) { if (txtSP.Text == "" || txtDMSP.Text == "" || txtLoaiGiay.Text == "" || txtSOLUONG.Text == "" || txtTrangThai.Text == "") { MessageBox.Show("Không được để trống"); return; } KHO k = new KHO(); var kt = from s in db.KHOs where s.MASP == txtMaSP.Text && s.MADMSP == txtDMSP.Text && s.MALOAI == txtLoaiGiay.Text select s; if (kt.Count() > 0) { MessageBox.Show("Trùng khóa chính"); return; } k.MASP = txtSP.Text; k.MADMSP = txtDMSP.Text; k.MALOAI = txtLoaiGiay.Text; k.SOLUONG = Convert.ToInt16(txtSOLUONG.Text); k.TRANGTHAI = txtTrangThai.Text; db.KHOs.InsertOnSubmit(k); db.SubmitChanges(); frm_kho_Load(sender, e); MessageBox.Show("Thành công"); }
public ActionResult Edit(int id) { if (id <= 0) { ViewBag.Message = "Không tìm thấy khu vực tương ứng."; return(View("../Home/Error"));; } var ctx = new SmsContext(); KHO khuVuc = ctx.KHOes.Find(id); var nguoiDungList = (from s in ctx.NGUOI_DUNG where s.ACTIVE == "A" select s).ToList <NGUOI_DUNG>(); ViewBag.nguoiDungList = nguoiDungList; if (khuVuc.ACTIVE.Equals("A")) { ctx.Dispose(); return(View(khuVuc)); } else { ctx.Dispose(); ViewBag.Message = "Không tìm thấy khu vực tương ứng."; return(View("../Home/Error"));; } }
public ActionResult DeleteConfirmed(string id) { KHO kHO = db.KHOes.Find(id); db.KHOes.Remove(kHO); db.SaveChanges(); return(RedirectToAction("Index")); }
public void XoaKho(string Madv) { KHO d = new KHO(); d = qltg.KHOs.Where(t => t.MaKho == Madv).FirstOrDefault(); qltg.KHOs.DeleteOnSubmit(d); qltg.SubmitChanges(); }
public void SuaKho(String MAKHO, string tenkho) { KHO d = new KHO(); d = qltg.KHOs.Where(t => t.MaKho == MAKHO).FirstOrDefault(); d.TenKho = tenkho; qltg.SubmitChanges(); }
public KHO deleteKho(string MaKho) { KHO kho = (from c in entity.KHOes where c.MASACH == MaKho select c).FirstOrDefault(); entity.KHOes.Remove(kho); entity.SaveChanges(); return(kho); }
private void btnThem_Click(object sender, EventArgs e) { if (btnThem.Text == "Thêm") { btnThem.Text = "Lưu"; btnSua.Enabled = false; btnXoa.Text = "Hủy"; groupThongTin.Enabled = true; dgvSACH.Enabled = false; btnTimKiem.Enabled = false; txtTimKiem.Enabled = false; ClearControl(); return; } if (btnThem.Text == "Lưu") { if (Check()) { btnThem.Text = "Thêm"; btnSua.Enabled = true; btnXoa.Text = "Xóa"; groupThongTin.Enabled = false; dgvSACH.Enabled = true; btnTimKiem.Enabled = true; txtTimKiem.Enabled = true; try { SACH tg = getSACHByForm(); db.SACHes.Add(tg); db.SaveChanges(); KHO kho = new KHO(); kho.SACHID = tg.ID; kho.SOLUONG = 0; db.KHOes.Add(kho); db.SaveChanges(); MessageBox.Show("Thêm thông tin sách thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { MessageBox.Show("Thêm thông tin sách thất bại\n" + ex.Message, "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } LoadDgvNhanVien(); } return; } }
public void showSelected() { if (view.selectedKho != "") { KHO kho = repository.getKho(view.selectedKho); ModelToView(kho); //view.Kho = kho; } }
public void ThemKho(String MAKHO, string tenkho) { KHO dv = new KHO(); dv.MaKho = MAKHO; dv.TenKho = tenkho; qltg.KHOs.InsertOnSubmit(dv); qltg.SubmitChanges(); }
private void btnThemChiTietNhap_Click(object sender, EventArgs e) { if (btnThemChiTietNhap.Text == "Thêm") { btnThemChiTietNhap.Text = "Lưu"; btnSuaChiTietNhap.Enabled = false; btnXoaChiTietNhap.Text = "Hủy"; groupThongTinChiTietNhap.Enabled = true; dgvChiTietNhap.Enabled = false; panelPhieuNhap.Enabled = false; ClearControlChiTietNhap(); return; } if (btnThemChiTietNhap.Text == "Lưu") { if (CheckChiTietNhap()) { btnThemChiTietNhap.Text = "Thêm"; btnSuaChiTietNhap.Enabled = true; btnXoaChiTietNhap.Text = "Xóa"; groupThongTinChiTietNhap.Enabled = false; dgvChiTietNhap.Enabled = true; panelPhieuNhap.Enabled = true; try { CHITIETNHAP tg = getChiTietNhapByForm(); db.CHITIETNHAPs.Add(tg); db.SaveChanges(); KHO kho = db.KHOes.Where(p => p.SACHID == tg.SACHID).FirstOrDefault(); kho.SOLUONG += tg.SOLUONG; db.SaveChanges(); MessageBox.Show("Thêm thông tin Chi tiết nhập thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { MessageBox.Show("Thêm thông tin Chi tiết nhập thất bại\n" + ex.Message, "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } LoadDgvChiTietNhap(); UpdateDetailPhieuNhap(); } return; } }
private KHO ViewToModel() { KHO kho = new KHO(); kho.MASACH = view.MASACH; kho.SOLUONGCON = view.SOLUONGCON; kho.TONGSOLUONG = view.TONGSOLUONG; return(kho); }
private void btnThem_Click(object sender, EventArgs e) { SANPHAM sanp = new SANPHAM(); SIZEGIAY size = new SIZEGIAY(); KHO k = new KHO(); int b = 0; for (int i = 1; i <= dgv_sp.RowCount; i++) { b = i; } sanp.MASP = "SP" + (b + 1).ToString(); k.MASP = sanp.MASP; k.SOLUONG = 0; k.TRANGTHAI = cb_trangthaisp.Text.ToString(); size.MASP = sanp.MASP; size.SIZE = 0; size.SOLUONGSIZE = 0; sanp.TENSP = cb_tensp.Text.ToString(); sanp.MAU = txt_mau.Text.ToString(); sanp.CHATLIEU = txt_chatlieu.Text.ToString(); sanp.TINHTRANGSP = cb_trangthai.Text.ToString(); sanp.MALOAI = cb_loaigiay.SelectedValue.ToString(); sanp.MANCC = cb_ncc.SelectedValue.ToString(); if (sp.ktkc_sp(sanp) == true) { if (sp.themsp(sanp) == true) { MessageBox.Show("thêm thành công"); usercontrol_sanpham_Load(sender, e); if (sg.ktkc_sizegiay1(size) == true) { if (sg.themsizegiay(size) == true) { MessageBox.Show("thêm size giày thành công"); } } if (kh.ktkc_kho(k) == true) { if (kh.themkho(k) == true) { MessageBox.Show("thêm kho giày thành công"); } } usercontrol_sanpham_Load(sender, e); } else { MessageBox.Show("thất bại"); } } else { MessageBox.Show("sản phẩm này đã tồn tại"); } }
private void btn_them_Click(object sender, EventArgs e) { MAIN mainForm = new MAIN(); maNhanVien = mainForm.getMaNhanVien(); List <NhaCungCap> listNhaCungCap = new List <NhaCungCap>(); List <NguyenLieu> listNguyenLieu = new List <NguyenLieu>(); listNhaCungCap = bus_nhaCungCap.LayNhaCungCap(); listNguyenLieu = bus_nguyenLieu.layNguyenLieu(); //TAO PHIEU NHAP if (count == 0) { String maPhieuNhap = bus_phieuNhap.taoMa(); DateTime ngayLap = DateTime.Now.Date; float tongTien = 0; PhieuNhap phieunhap = new PhieuNhap(maPhieuNhap, ngayLap, tongTien, maNhanVien); bus_phieuNhap.Them(phieunhap); MessageBox.Show(ngayLap.ToString()); count++; maPhieuNhapct = maPhieuNhap; String maChiTietPhieuNhap = bus_chiTietPhieuNhap.taoMa(); String maNguyenLieu = listNguyenLieu[box_nguyenLieu.SelectedIndex].MaNguyenLieu; int soLuong = Int32.Parse(txt_soLuong.Text.ToString()); String loaiDonVi = box_loaiDonVi.SelectedItem.ToString(); String id = bus_kho.taoMa(); KHO kho = new KHO(id, maNguyenLieu, soLuong, loaiDonVi); listNhapKho.Add(kho); String maNhaCungCap = listNhaCungCap[box_nhaCungCap.SelectedIndex].MaNhaCungCap; ChiTietPhieuNhap chiTiet = new ChiTietPhieuNhap(maChiTietPhieuNhap, maNguyenLieu, soLuong, maNhaCungCap, maPhieuNhapct); bus_chiTietPhieuNhap.Them(chiTiet); } else { String id = bus_kho.taoMa(); String maChiTietPhieuNhap = bus_chiTietPhieuNhap.taoMa(); String maNguyenLieu = listNguyenLieu[box_nguyenLieu.SelectedIndex].MaNguyenLieu; int soLuong = Int32.Parse(txt_soLuong.Text.ToString()); String maNhaCungCap = listNhaCungCap[box_nhaCungCap.SelectedIndex].MaNhaCungCap; String loaiDonVi = box_loaiDonVi.SelectedItem.ToString(); KHO kho = new KHO(id, maNguyenLieu, soLuong, loaiDonVi); listNhapKho.Add(kho); ChiTietPhieuNhap chiTiet = new ChiTietPhieuNhap(maChiTietPhieuNhap, maNguyenLieu, soLuong, maNhaCungCap, maPhieuNhapct); bus_chiTietPhieuNhap.Them(chiTiet); } gridChiTietPhieuNhap.DataSource = bus_chiTietPhieuNhap.LayChiTietPhieuNhap(); }
public static bool del_HoaDon(HoaDon_View hd, DataUpdate <CT_HOADON> list_Change) { using (var transaction = Context.getInstance().db.Database.BeginTransaction()) { try { hd.TrangThai = 0; Context.getInstance().db.Entry(hd.toHoaDon()).State = System.Data.Entity.EntityState.Modified; //list_Change.Inserts.ForEach(x => //{ //}); //list_Change.Updates.ForEach(x => //{ // x.TinhTrang = 1; // Context.getInstance().db.Entry(getCTHD(x)).State = System.Data.Entity.EntityState.Modified; //}); list_Change.Deletes.ForEach(x => { //set trang thai = 0 o day x.TinhTrang = 0; Context.getInstance().db.Entry(getCTHD(x)).State = System.Data.Entity.EntityState.Modified; //them trong kho KHO kho = Context.getInstance().db.KHOes.Where(key => key.MaLinhKien == x.MaLinhKien).Where(k => k.Seri == x.Seri).FirstOrDefault(); kho.TrangThai = 1; Context.getInstance().db.Entry(kho).State = System.Data.Entity.EntityState.Modified; }); //update so tien mua hang cua khach hang KHACHHANG kh = Context.getInstance().db.KHACHHANGs.Where(key => key.MaKhachHang == hd.MaKhachHang).FirstOrDefault(); kh.Tong -= hd.TongTien; Context.getInstance().db.Entry(kh).State = System.Data.Entity.EntityState.Modified; //update so luong ban hang cua nhan vien NHANVIEN mNV = Context.getInstance().db.NHANVIENs.Where(key => key.MaNhanVien == hd.MaNhanVien).FirstOrDefault(); mNV.TongTien -= hd.TongTien; Context.getInstance().db.Entry(mNV).State = System.Data.Entity.EntityState.Modified; Context.getInstance().db.SaveChanges(); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); Context.Refresh(); Console.WriteLine("ERROR--------------------------------------" + ex.Message); return(false); } } return(true); }
private void btnThem_Click(object sender, EventArgs e) { try { KHO kho = null; XUAT xuat = db.XUATs.ToList()[index]; CHITIETXUAT ctx = new CHITIETXUAT(); ctx.XUATID = xuat.XUATID; ctx.MATHANGID = (int)cbxMatHang.SelectedValue; ctx.SOLUONG = (int)txtSoLuong.Value; ctx.GIABAN = (int)txtDonGia.Value; try { kho = db.KHOes.Where(p => p.MATHANGID == ctx.MATHANGID).First(); } catch { } if (kho == null || kho.SOLUONG < ctx.SOLUONG) { MessageBox.Show("Số lượng hàng trong kho của mặt hàng " + cbxMatHang.Text + " không đủ", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } kho.SOLUONG -= ctx.SOLUONG; List<CHITIETXUAT> ct = db.CHITIETXUATs.Where(p => p.XUATID == xuat.XUATID).ToList(); int i = 1; foreach (var r in ct) { if (r.MATHANGID == (int)cbxMatHang.SelectedValue) { r.SOLUONG += (int)txtSoLuong.Value; db.SaveChanges(); i = 0; break; } } if(i==1) db.CHITIETXUATs.Add(ctx); db.SaveChanges(); MessageBox.Show("Thêm chi tiết xuất thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); LoadDgvChiTietXuat(); } catch { } }
// Xóa một kho khỏi database public static void XoaKho(Kho kho) { using (MyDatabaseDataContext db = new MyDatabaseDataContext()) { KHO khoDB = (from n in db.KHOs where n.MAKHO == kho.MaKho select n).FirstOrDefault(); db.KHOs.DeleteOnSubmit(khoDB); db.SubmitChanges(); } }
public ActionResult Edit([Bind(Include = "MaLoHang,MaNSX,TenLoHang,SoLuong,NgayNhap")] KHO kHO) { if (ModelState.IsValid) { db.Entry(kHO).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.MaNSX = new SelectList(db.NSXes, "MaNSX", "TenNSX", kHO.MaNSX); return(View(kHO)); }
public static IQueryable <BOTonKho> GetTonKhoByKho(KaraokeEntities kara, KHO kho) { return(from a in kara.TONKHOes join b in kara.MENUMONs on a.MonID equals b.MonID where a.KhoID == kho.KhoID && a.SoLuongTon > 0 select new BOTonKho { TonKho = a, TenMon = b.TenDai }); }
private void btnThem_Click(object sender, EventArgs e) { if (btnThem.Text == "Thêm") { btnSua.Enabled = false; btnThem.Text = "Lưu"; btnXoa.Text = "Hủy"; ClearControl(); UnlockControl(); return; } if (btnThem.Text == "Lưu") { if (Check()) { btnThem.Text = "Thêm"; btnXoa.Text = "Xóa"; LockControl(); MATHANG moi = getMATHANGByForm(); db.MATHANGs.Add(moi); try { db.SaveChanges(); KHO kho = new KHO(); kho.MATHANGID = moi.ID; kho.SOLUONG = 0; db.KHOes.Add(kho); db.SaveChanges(); MessageBox.Show("Thêm thông tin mặt hàng thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { MessageBox.Show("Thêm thông tin mặt hàng thất bại\n" + ex.Message, "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } LoadDgvMatHang(); } return; } }
public List <KHO> loadSTOCKlist() { List <KHO> stocklist = new List <KHO>(); DataTable data = DataProvider.Instance.ExecuteQuery("SELECT * FROM DBO.STOCK"); foreach (DataRow item in data.Rows) { KHO kho = new KHO(item); stocklist.Add(kho); } return(stocklist); }
public ActionResult AddNew() { KHO model = new KHO(); var ctx = new SmsContext(); var nguoiDungList = (from s in ctx.NGUOI_DUNG where s.ACTIVE == "A" select s).ToList <NGUOI_DUNG>(); ViewBag.nguoiDungList = nguoiDungList; ctx.Dispose(); return(View()); }
public ActionResult Create([Bind(Include = "MaLoHang,MaNSX,TenLoHang,SoLuong,NgayNhap")] KHO kHO) { if (ModelState.IsValid) { db.KHOes.Add(kHO); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.MaNSX = new SelectList(db.NSXes, "MaNSX", "TenNSX", kHO.MaNSX); return(View(kHO)); }
// Thêm kho public static void ThemKho(Kho kho) { KHO KhoDB = new KHO(); KhoDB.MAKHO = kho.MaKho; KhoDB.TENKHO = kho.TenKho; using (MyDatabaseDataContext db = new MyDatabaseDataContext()) { db.KHOs.InsertOnSubmit(KhoDB); db.SubmitChanges(); } }
public static bool add_HoaDonNhap(HoaDonNhap_View hd, List <CT_HoaDonNhap_View> ct_hds) { using (var transaction = Context.getInstance().db.Database.BeginTransaction()) { try { decimal phanTramLoiNhuanBanLe = decimal.Parse(HeThong_DAL.getHeThongByMa("HT002").GiaTri); decimal phanTramLoiNhuanBanBuon = decimal.Parse(HeThong_DAL.getHeThongByMa("HT003").GiaTri); Context.getInstance().db.Entry(hd.toHoaDonNhap()).State = System.Data.Entity.EntityState.Added; Context.getInstance().db.SaveChanges(); LINHKIEN lk; ct_hds.ForEach(x => { foreach (var seri in x.SoSeri) { Context.getInstance().db.Entry(x.toCT_HoaDonNhap(seri)).State = System.Data.Entity.EntityState.Added; //nhap kho KHO myK = new KHO(); myK.MaLinhKien = x.MaLinhKien; myK.Seri = seri; myK.NgayNhap = hd.NgayLap; myK.TrangThai = 1; Context.getInstance().db.Entry(myK).State = System.Data.Entity.EntityState.Added; } lk = Context.getInstance().db.LINHKIENs.Where(key => key.MaLinhKien == x.MaLinhKien).FirstOrDefault(); if (lk.GiaNhap != x.GiaNhap) { lk.GiaNhap = x.GiaNhap; lk.GiaBanLe = x.GiaNhap + (x.GiaNhap * phanTramLoiNhuanBanLe / 100); lk.GiaBanSi = x.GiaNhap + (x.GiaNhap * phanTramLoiNhuanBanBuon / 100); Context.getInstance().db.Entry(lk).State = System.Data.Entity.EntityState.Modified; } }); //update so tien nhap hang cua nha cc NHACUNGCAP ncc = Context.getInstance().db.NHACUNGCAPs.Where(key => key.MaNhaCungCap == hd.MaNhaCungCap).FirstOrDefault(); ncc.Tong += hd.TongTien; Context.getInstance().db.Entry(ncc).State = System.Data.Entity.EntityState.Modified; Context.getInstance().db.SaveChanges(); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); Context.Refresh(); Console.WriteLine("ERROR--------------------------------------" + ex.Message); return(false); } } return(true); }
// Sửa thông tin kho public static void CapNhatKho(Kho kho) { using (MyDatabaseDataContext db = new MyDatabaseDataContext()) { KHO khoDB = (from n in db.KHOs where n.MAKHO == kho.MaKho select n).FirstOrDefault(); khoDB.MAKHO = kho.MaKho; khoDB.TENKHO = kho.TenKho; db.SubmitChanges(); } }