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