void SelectTonKho()
{
dataTon.ItemsSource = null;
KK.Clear();
var select = from s in db.SANPHAMs
from t in db.LOAISANPHAMs
where s.KichHoat == true && s.MaLoaiSP == t.MaLoaiSP
select new { s.MaSP, s.TenSP, s.GiaMuaVao, s.SoLuong, t.TenLoaiSP, t.MaLoaiSP };
foreach (var data in select)
{
var kkk = new KiemKeKho()
{
MaLSP = data.MaLoaiSP,
TenLoaiSP = data.TenLoaiSP,
MaSP = data.MaSP,
TenSP = data.TenSP,
GiaMuaVao = data.GiaMuaVao == null ? "" : ((int)data.GiaMuaVao).ToString(),
SoLuong = (int)data.SoLuong,
};
KK.Add(kkk);
}
dataTon.ItemsSource = KK.ToList();
}
public List <KiemKeKho> LoadKiemKeList(string ngaykk)
{
string a = ngaykk.Substring(0, ngaykk.IndexOf(" "));
List <KiemKeKho> kiemkekhoList = new List <KiemKeKho>();
DataTable data = DataProvider.Instance.ExecuteQuery("USP_GetKiemKeList @ngaykk", new object[] { a });
foreach (DataRow item in data.Rows)
{
KiemKeKho kkk = new KiemKeKho(item);
kiemkekhoList.Add(kkk);
}
return(kiemkekhoList);
}
