public List <SelectedCbxModel> GetPhieuXuat(bool isSearch)
{
db = new DBQLVT();
List <SelectedCbxModel> result = new List <SelectedCbxModel>();
result = db.PhieuXuats.Where(m => m.TrangThai == CommonConstant.STATUS_DADUYET).Select(m => new SelectedCbxModel()
{
DisPlayMember = m.MaPX, ValueMember = m.MaPX
}).ToList();
if (isSearch)
{
SelectedCbxModel sel = new SelectedCbxModel();
sel.ValueMember = "";
sel.DisPlayMember = "---Chọn---";
result.Insert(0, sel);
}
return(result);
}
public List <SelectedCbxModel> GetCbxKhoVT(bool isSearch)
{
db = new DBQLVT();
List <SelectedCbxModel> result = new List <SelectedCbxModel>();
result = db.KhoVatTus.Select(m => new SelectedCbxModel()
{
DisPlayMember = m.TenKhoVT, ValueMember = m.MaKhoVT
}).ToList();
if (isSearch)
{
SelectedCbxModel sel = new SelectedCbxModel();
sel.ValueMember = "";
sel.DisPlayMember = "---Chọn---";
result.Insert(0, sel);
}
return(result);
}
public List <SelectedCbxModel> CreateTreeDV(bool isAdd)
{
db = new DBQLVT();
mlstReturn = new List <SelectedCbxModel>();
List <PXTD> model = (from m in db.PXTDs select m).ToList();
//List<KhoVatTu> vlstTest = model.ToList() as List<KhoVatTu>;
var root = model.GenerateTree(c => c.MaPXTD, c => c.ParentID);
GetTreeList(root);
if (isAdd)//Them moi
{
SelectedCbxModel sel = new SelectedCbxModel()
{
DisPlayMember = "---Chọn---", ValueMember = ""
};
mlstReturn.Insert(0, sel);
}
return(mlstReturn);
}
public List <SelectedCbxModel> GetCbxVatTuInKho(bool isAdd, string maPX)
{
db = new DBQLVT();
List <SelectedCbxModel> result = new List <SelectedCbxModel>();
var s = db.PhieuXuats.Find(maPX).MaKhoXuat;
var model = db.ChiTietKhoVatTus.Where(m => m.MaKhoVT == s)
.GroupBy(a => a.MaVT).Select(p => new { MaVT = p.Key, SoLuongTK = p.Sum(q => q.SoLuong) });
var mos = model.ToList();
var results = from m in db.VatTus
join n in mos on m.MaVT equals n.MaVT
select new SelectedCbxModel()
{
DisPlayMember = m.MaVT + " - " + m.TenVT, ValueMember = n.MaVT, SL = n.SoLuongTK
};
if (isAdd)
{
SelectedCbxModel sel = new SelectedCbxModel();
sel.ValueMember = "";
sel.DisPlayMember = "---Chọn---";
results.ToList().Insert(0, sel);
}
return(results.ToList());
}