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