private void khoTextEdit_EditValueChanged(object sender, EventArgs e) { if (txtKho.Text == banthanhpham || txtKho.Text == thanhpham) { searchLookUpEdit1View.Columns.Clear(); vatLieuComboBox.Properties.DataSource = khoBtpTpCtr.LoadData3C(); vatLieuComboBox.Properties.DisplayMember = "TenSanPham"; vatLieuComboBox.Properties.ValueMember = "TenSanPham"; } else if (txtKho.Text == nguyenvatlieu) { searchLookUpEdit1View.Columns.Clear(); vatLieuComboBox.Properties.DataSource = vlCtr.LoadData4C(); vatLieuComboBox.Properties.DisplayMember = "TenHangHoa"; vatLieuComboBox.Properties.ValueMember = "TenHangHoa"; } else { searchLookUpEdit1View.Columns.Clear(); vatLieuComboBox.Properties.DataSource = null; } var dauthang = DateTime.Now; var cuoithang = DateTime.Now; var db = new MyDBContextDataContext(); var lst = (from s in db.procTonKhoBTP_TP_View_NV(GetFirstDayOfMonth(dauthang), GetLastDayOfMonth(cuoithang)) select s).ToList(); foreach (var item in lst) { if (item.TenSanPham != tenSanPhamTextEdit.Text) { continue; } if (txtKho.Text == item.Kho || txtKho.Text == banthanhpham) { bTPSoLuongTonKhoSpinEdit.Text = item.TonCuoiKyKhachHang.ToString(); bTPTonKhoCongtySpinEdit.Text = item.TonCuoiKyCongTy.ToString(); } if (txtKho.Text != item.Kho || txtKho.Text != thanhpham) { continue; } tPSoLuongTonKhoSpinEdit.Text = item.TonCuoiKyKhachHang.ToString(); TPTonKhoCongtySpinEdit.Text = item.TonCuoiKyCongTy.ToString(); break; } }
public void SearchLookup() { //// Bảng Vật Liệu var vlCtr = new VatLieuCtr(); risMaHang.DataSource = vlCtr.LoadData4C(); risMaHang.DisplayMember = "MaHang"; risMaHang.ValueMember = "MaHang"; // Bảng Nhà Cung Cấp var bpCtr = new BoPhanCtr(); BoPhantxt.Properties.DataSource = bpCtr.LoadData(); BoPhantxt.Properties.DisplayMember = "ID"; BoPhantxt.Properties.ValueMember = "ID"; // Bảng Kho var khoCtr = new KhoCtr(); KhoCongTytxt.Properties.DataSource = khoCtr.LoadData1C(); KhoCongTytxt.Properties.DisplayMember = "ID"; KhoCongTytxt.Properties.ValueMember = "ID"; //SCD //var dsxCtr = new DonSanXuatCtr(); //risSCD.DataSource = dsxCtr.LoadData_SCD_Search(); //risSCD.DisplayMember = "SCD"; //risSCD.ValueMember = "SCD"; }
private void frmCapNhatKhoNVL_Load(object sender, EventArgs e) { //// Bảng Vật Liệu var vlCtr = new VatLieuCtr(); maHangTextEdit.Properties.DataSource = vlCtr.LoadData4C(); maHangTextEdit.Properties.DisplayMember = "MaHang"; maHangTextEdit.Properties.ValueMember = "MaHang"; }
public void SearchLookup() { var db = new MyDBContextDataContext(); //// Bảng Vật Liệu var vlCtr = new VatLieuCtr(); risMaHang.DataSource = vlCtr.LoadData4C(); risMaHang.DisplayMember = "MaHang"; risMaHang.ValueMember = "MaHang"; // Bảng Nhà Cung Cấp var bpCtr = new BoPhanCtr(); txtBoPhan.Properties.DataSource = bpCtr.LoadData(); txtBoPhan.Properties.DisplayMember = "ID"; txtBoPhan.Properties.ValueMember = "ID"; // Bảng Kho //var khoCtr = new KhoCtr(); //KhoCongTytxt.Properties.DataSource = khoCtr.LoadData1C(); //KhoCongTytxt.Properties.DisplayMember = "ID"; //KhoCongTytxt.Properties.ValueMember = "ID"; var kho = from s in db.tbKhos where s.ID.Contains("THÀNH PHẨM") select new { s.ID }; KhoCongTytxt.Properties.DataSource = kho; KhoCongTytxt.Properties.DisplayMember = "ID"; KhoCongTytxt.Properties.ValueMember = "ID"; // Bảng Kho //var bpCtr = new BoPhanCtr(); risBoPhan.DataSource = bpCtr.LoadData(); risBoPhan.DisplayMember = "ID"; risBoPhan.ValueMember = "ID"; var khCtr = new KhachHangCtr(); risTenKhachHang.DataSource = khCtr.LoadData1C(); risTenKhachHang.DisplayMember = "TenKhachHang"; risTenKhachHang.ValueMember = "TenKhachHang"; var dvtCtr = new DonViTinhCtr(); risDonViTinh.DataSource = dvtCtr.LoadData1C(); risDonViTinh.DisplayMember = "ID"; risDonViTinh.ValueMember = "ID"; }
private void txtKho_EditValueChanged(object sender, EventArgs e) { if (txtKho.Text == banthanhpham || txtKho.Text == thanhpham) { searchLookUpEdit1View.Columns.Clear(); vatLieuComboBox.Properties.DataSource = khoBtpTpCtr.LoadData3C(); vatLieuComboBox.Properties.DisplayMember = "TenSanPham"; vatLieuComboBox.Properties.ValueMember = "TenSanPham"; } else if (txtKho.Text == nguyenvatlieu) { searchLookUpEdit1View.Columns.Clear(); vatLieuComboBox.Properties.DataSource = vlCtr.LoadData4C(); vatLieuComboBox.Properties.DisplayMember = "TenHangHoa"; vatLieuComboBox.Properties.ValueMember = "TenHangHoa"; } else { searchLookUpEdit1View.Columns.Clear(); vatLieuComboBox.Properties.DataSource = null; } }
public void SearchLookup() { //// Bảng Vật Liệu var vlCtr = new VatLieuCtr(); risMaHang.DataSource = vlCtr.LoadData4C(); risMaHang.DisplayMember = "MaHang"; risMaHang.ValueMember = "MaHang"; // Bảng Nhà Cung Cấp var nccCtr = new NhaCungCapCtr(); NhaCungCaptxt.Properties.DataSource = nccCtr.LoadData1C(); NhaCungCaptxt.Properties.DisplayMember = "TenNhaCungCap"; NhaCungCaptxt.Properties.ValueMember = "TenNhaCungCap"; // Bảng Kho var khoCtr = new KhoCtr(); KhoCongTytxt.Properties.DataSource = khoCtr.LoadData1C(); KhoCongTytxt.Properties.DisplayMember = "ID"; KhoCongTytxt.Properties.ValueMember = "ID"; }