public List <CTHDLePhuc> LoadCTHDLePhucListByMalp(int malp)
{
List <CTHDLePhuc> list = new List <CTHDLePhuc>();
var query = string.Format("select CTHD_LEPHUC.* from CTHD_LEPHUC,LEPHUC where CTHD_LEPHUC.MaLePhuc= LEPHUC.MaLePhuc and CTHD_LEPHUC.MaLePhuc={0}", malp);
DataTable table = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow row in table.Rows)
{
CTHDLePhuc ct = new CTHDLePhuc(row);
list.Add(ct);
}
return(list);
}
public List <CTHDLePhuc> GetCTHD_LephucList(int mahd)
{
List <CTHDLePhuc> list = new List <CTHDLePhuc>();
var query = string.Format("select CTHD_LEPHUC.* from CTHD_LEPHUC, HOADON where CTHD_LEPHUC.MaHD= HOADON.MaHD and CTHD_LEPHUC.MaHD={0}", mahd);
DataTable table = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow row in table.Rows)
{
CTHDLePhuc ct = new CTHDLePhuc(row);
list.Add(ct);
}
return(list);
}
public bool check(int mahoadon)
{
List <CTHDLePhuc> list = new List <CTHDLePhuc>();
var query = string.Format("select * from CTHD_LEPHUC where MaHD={0}", mahoadon);
DataTable table = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow row in table.Rows)
{
CTHDLePhuc ct = new CTHDLePhuc(row);
list.Add(ct);
}
int count = list.Count;
int check = (int)DataProvider.Instance.ExecuteScalar("select SoLePhucToiDa from QUYDINH");
return(count >= check);
}
