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