예제 #1
0
        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);
        }
예제 #2
0
        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);
        }