public List <MonAnmoi> LoadMonAnmoiListTheoCBB(string loaimonan) { List <MonAnmoi> MonAnmoiList = new List <MonAnmoi>(); DataTable dt = DataProvider.Instance.ExecuteQuery("select * from LOAIMON inner join MONAN on LOAIMON.MALOAI = MONAN.MALOAI where LOAIMON.TENLOAI = N'" + loaimonan + "' "); foreach (DataRow item in dt.Rows) { MonAnmoi monanmoi = new MonAnmoi(item); MonAnmoiList.Add(monanmoi); } return(MonAnmoiList); }
public List <MonAnmoi> LoadMonAnmoiList() { List <MonAnmoi> MonAnmoiList = new List <MonAnmoi>(); DataTable dt = DataProvider.Instance.ExecuteQuery("USP_GetMonAn"); foreach (DataRow item in dt.Rows) { MonAnmoi monanmoi = new MonAnmoi(item); MonAnmoiList.Add(monanmoi); } return(MonAnmoiList); }