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