public override void LoadDataForm() { _iEntry = _iEntry ?? new eNhaCungCap(); _aEntry = clsFunction.GetItem <eNhaCungCap>("NhaCungCap/GetByID", _iEntry.KeyID); SetControlValue(); }
public void InsertNhaCC(eNhaCungCap a) { NhaCungCap e = new NhaCungCap(); e.MaNhaCungCap = TaoMaNhaCC(); e.TenNhaCungCap = a.TenNCC; e.Phone = a.Phone; e.DiaChi = a.DiaChi; e.NgayThanhLap = null; db.NhaCungCaps.InsertOnSubmit(e); db.SubmitChanges(); }
public override bool SaveData() { lstEdited.ToList().ForEach(x => { eNhaCungCap NhaCungCap = (eNhaCungCap)rlokNhaCungCap.GetDataSourceRowByKeyValue(x.IDNhaCungCap) ?? new eNhaCungCap(); x.MaNhaCungCap = NhaCungCap.Ma; x.TenNhaCungCap = NhaCungCap.Ten; }); Tuple <bool, List <eSoDuDauKyNhaCungCap> > Res = clsFunction.Post("sodudaukynhacungcap", lstEdited.ToList()); return(Res.Item1); }
public async override Task <bool> SaveData() { lstEdited.ToList().ForEach(x => { eNhaCungCap NhaCungCap = (eNhaCungCap)rlokNhaCungCap.GetDataSourceRowByKeyValue(x.IDNhaCungCap) ?? new eNhaCungCap(); x.MaNhaCungCap = NhaCungCap.Ma; x.TenNhaCungCap = NhaCungCap.Ten; }); bool chk = false; chk = await clsFunction <eSoDuDauKyNhaCungCap> .Instance.AddOrUpdate(lstEdited.ToList()); return(chk); }
/// <summary> /// Lấy danh sách nhà cung cấp có công nợ /// </summary> /// <returns>danh sách nhà cung cấp</returns> public List <eNhaCungCap> GetListNhaCungCapNo() { List <eNhaCungCap> l = new List <eNhaCungCap>(); foreach (var cn in db.CongNoNCCs) { NhaCungCap ncc = cn.HoaDonNhaCungCap.NhaCungCap; eNhaCungCap encc = new eNhaCungCap(); encc.MaNCC = ncc.MaNhaCungCap; encc.TenNCC = ncc.TenNhaCungCap; encc.DiaChi = ncc.DiaChi; encc.Phone = ncc.Phone; // entity thiếu field NgayThanhLap so với data base; -- cập nhập ngày 15/11/2016 l.Add(encc); } return(l); }
public bool Update(eNhaCungCap ncc) { try { Tbl_NhaCungCap update = db.Tbl_NhaCungCaps.Single(tmp => tmp.maNCC == ncc.maNCC); update.maNCC = ncc.maNCC; update.tenNCC = ncc.tenNCC; update.diaChi = ncc.diaChi; update.sDT = ncc.sDT; update.email = ncc.email; db.SubmitChanges(); return(true); } catch { return(false); } }
public int xoa1nhacungcap(eNhaCungCap ncc) { Tbl_NhaCungCap p = new Tbl_NhaCungCap(); p = db.Tbl_NhaCungCaps.Where(x => x.maNCC == ncc.maNCC).FirstOrDefault(); if (p != null) { return(0); } p.maNCC = ncc.maNCC; p.tenNCC = ncc.tenNCC; p.diaChi = ncc.diaChi; p.sDT = ncc.sDT; p.email = ncc.email; db.Tbl_NhaCungCaps.DeleteOnSubmit(p); db.SubmitChanges(); return(1); }
public int themNCC(eNhaCungCap ncc) { var nccap = db.Tbl_NhaCungCaps.Where(x => x.maNCC == ncc.maNCC).FirstOrDefault(); if (nccap != null) { return(0); } Tbl_NhaCungCap p = new Tbl_NhaCungCap(); p.maNCC = ncc.maNCC; p.tenNCC = ncc.tenNCC; p.diaChi = ncc.diaChi; p.sDT = ncc.sDT; p.email = ncc.email; db.Tbl_NhaCungCaps.InsertOnSubmit(p); db.SubmitChanges(); return(1); }
private void btnluuncc_Click(object sender, EventArgs e) { eNhaCungCap a = new eNhaCungCap(); a.maNCC = txtMaNCC.Text; a.tenNCC = txtTenNCC.Text; a.diaChi = txtAddress.Text; a.sDT = txtphone.Text; a.email = txtMail.Text; int m = nccbll.themNCC(a); if (m == 0) { MessageBox.Show("Trùng mã !", "Thông báo!", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1); } else if (m == 1) { MessageBox.Show("Thêm thành công !", "Thông báo!", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1); } }
private void btThemNhaCC_Click(object sender, EventArgs e) { loaddvg(); try { if (txtTenncc.Text == null || txtphone.Text == null || txtdiachi.Text == null) { MessageBox.Show("Các Thông Tin Băt Buộc Phải Nhập"); } else { eNhaCungCap newncc = new eNhaCungCap(); newncc.TenNCC = txtTenncc.Text; newncc.DiaChi = txtdiachi.Text; newncc.Phone = Convert.ToInt32(txtphone.Text); Sp.ThemNcc(newncc); LoadCBNCC(); } } catch (Exception ex) { MessageBox.Show("Error: " + ex.Message.ToString()); } }
public override bool SaveData() { DateTime time = DateTime.Now.ServerNow(); if (_aEntry.KeyID > 0) { _aEntry.NguoiCapNhat = clsGeneral.curPersonnel.KeyID; _aEntry.MaNguoiCapNhat = clsGeneral.curPersonnel.Ma; _aEntry.TenNguoiCapNhat = clsGeneral.curPersonnel.Ten; _aEntry.NgayCapNhat = time; _aEntry.TrangThai = 2; } else { _aEntry.NguoiTao = clsGeneral.curPersonnel.KeyID; _aEntry.MaNguoiTao = clsGeneral.curPersonnel.Ma; _aEntry.TenNguoiTao = clsGeneral.curPersonnel.Ten; _aEntry.NgayTao = time; _aEntry.TrangThai = 1; eNhaCungCap nhaCungCap = (eNhaCungCap)slokNhaCungCap.Properties.GetRowByKeyValue(slokNhaCungCap.EditValue) ?? new eNhaCungCap(); _aEntry.IDNhaCungCap = nhaCungCap.KeyID; _aEntry.MaNhaCungCap = nhaCungCap.Ma; _aEntry.TenNhaCungCap = nhaCungCap.Ten; } _aEntry.Ma = txtMaPhieu.Text.Trim(); _aEntry.MaLoHang = txtSoLoHang.Text.Trim(); _aEntry.NgayNhap = dteNgayNhap.DateTime; _aEntry.GhiChu = mmeGhiChu.Text.Trim(); _aEntry.SoLuong = spnSoLuong.Value; _aEntry.ThanhTien = spnSoTien.Value; _aEntry.TongTien = spnTongNo.Value; _aEntry.NoCu = spnNoCu.Value; _aEntry.ThanhToan = spnThanhToan.Value; _aEntry.ConLai = spnConLai.Value; _aEntry.eNhapHangNhaCungCapChiTiet.Clear(); foreach (eNhapHangNhaCungCapChiTiet item in lstDetail) { if (item.KeyID > 0) { item.NguoiCapNhat = clsGeneral.curPersonnel.KeyID; item.MaNguoiCapNhat = clsGeneral.curPersonnel.Ma; item.TenNguoiCapNhat = clsGeneral.curPersonnel.Ten; item.NgayCapNhat = time; item.TrangThai = 2; } else { item.NguoiTao = clsGeneral.curPersonnel.KeyID; item.MaNguoiTao = clsGeneral.curPersonnel.Ma; item.TenNguoiTao = clsGeneral.curPersonnel.Ten; item.NgayTao = time; item.TrangThai = 1; } eKho kho = (eKho)rlokKho.GetDataSourceRowByKeyValue(item.IDKho) ?? new eKho(); item.MaKho = kho.Ma; item.TenKho = kho.Ten; _aEntry.eNhapHangNhaCungCapChiTiet.Add(item); } Tuple <bool, eNhapHangNhaCungCap> Res = _aEntry.KeyID > 0 ? clsFunction.Put("NhapHangNhaCungCap", _aEntry) : clsFunction.Post("NhapHangNhaCungCap", _aEntry); if (Res.Item1) { KeyID = Res.Item2.KeyID; } return(Res.Item1); }
public void ThemNcc(eNhaCungCap e) { z.InsertNhaCC(e); }