Пример #1
0
        public async Task <ValueDTO <HocPhi> > GetData(int Thang, int IDLoaiHocSinh, int IDKhoi, int NgayNghi)
        {
            ValueDTO <HocPhi> val   = new ValueDTO <HocPhi>();
            DataTableSQL      dtSql = await ExecuteQuery("SelectChiTietTienHoc",
                                                         new SqlParameter("@Thang", SqlDbType.Int) { Value = Thang },
                                                         new SqlParameter("@IDLoaiHocSinh", SqlDbType.Int) { Value = IDLoaiHocSinh },
                                                         new SqlParameter("@IDKhoi", SqlDbType.Int) { Value = IDKhoi });

            if (dtSql.Error == 0)
            {
                foreach (DataRow dr in dtSql.Data.Rows)
                {
                    val.ListT.Add(new HocPhi(dr, NgayNghi));
                }
            }

            return(val);
        }
Пример #2
0
        public async Task <ValueDTO <BangDiem> > GetData(int IDHocSinh)
        {
            ValueDTO <BangDiem> val   = new ValueDTO <BangDiem>();
            DataTableSQL        dtSql = await ExecuteQuery("SelectBangDiemv2",
                                                           new SqlParameter("@IDHocSinh", SqlDbType.Int) { Value = IDHocSinh });

            if (dtSql.Error == 0)
            {
                foreach (DataRow dr in dtSql.Data.Rows)
                {
                    val.ListT.Add(new BangDiem(dr));
                }
            }
            else
            {
                val.Error = dtSql.Error;
            }

            return(val);
        }
Пример #3
0
        public async Task <ValueDTO <XinPhep> > GetData(int IDStudent)
        {
            ValueDTO <XinPhep> val   = new ValueDTO <XinPhep>();
            DataTableSQL       dtSql = await ExecuteQuery("SelectXinPhepTheoIDHS",
                                                          new SqlParameter("@IDHocSinh", SqlDbType.Int) { Value = IDStudent });

            if (dtSql.Error == 0)
            {
                foreach (DataRow dr in dtSql.Data.Rows)
                {
                    val.ListT.Add(new XinPhep(dr));
                }
            }
            else
            {
                val.Error = dtSql.Error;
            }

            return(val);
        }
Пример #4
0
        public async Task <ValueDTO <ThongBaoTruong> > GetContent(int ID)
        {
            ValueDTO <ThongBaoTruong> val = new ValueDTO <ThongBaoTruong>();
            DataTableSQL dtSql            = await ExecuteQuery("SelectNoiDungThongBaoTruong",
                                                               new SqlParameter("@ID", SqlDbType.Int) { Value = ID });

            if (dtSql.Error == 0)
            {
                foreach (DataRow dr in dtSql.Data.Rows)
                {
                    val.ListT.Add(new ThongBaoTruong(dr));
                }
            }
            else
            {
                val.Error = dtSql.Error;
            }

            return(val);
        }
Пример #5
0
        public async Task <ValueDTO <ThongBaoLop> > GetData()
        {
            ValueDTO <ThongBaoLop> val   = new ValueDTO <ThongBaoLop>();
            DataTableSQL           dtSql = await ExecuteQuery("SelectThongBaoLop",
                                                              new SqlParameter("@ID", SqlDbType.Int) { Value = -1 });

            if (dtSql.Error != 0)
            {
                foreach (DataRow dr in dtSql.Data.Rows)
                {
                    val.ListT.Add(new ThongBaoLop(dr));
                }
            }
            else
            {
                val.Error = dtSql.Error;
            }

            return(val);
        }
Пример #6
0
        public async Task <ValueDTO <LienKetPHvsHS> > GetData(int IDTaiKhoan)
        {
            ValueDTO <LienKetPHvsHS> val   = new ValueDTO <LienKetPHvsHS>();
            DataTableSQL             dtSql = await ExecuteQuery("SelectLayHSQuanLy",
                                                                new SqlParameter("@IDTaiKhoan", SqlDbType.Int) { Value = IDTaiKhoan });

            if (dtSql.Error == 0)
            {
                foreach (DataRow dr in dtSql.Data.Rows)
                {
                    val.ListT.Add(new LienKetPHvsHS(dr));
                }
            }
            else
            {
                val.Error = dtSql.Error;
            }

            return(val);
        }
Пример #7
0
        public async Task <ValueDTO <FunctionOrder> > GetData()
        {
            DataTableSQL dtSql = await ExecuteQuery("SelectFunctionOrder");

            ValueDTO <FunctionOrder> val = new ValueDTO <FunctionOrder>();

            if (dtSql.Error == 0)
            {
                foreach (DataRow dr in dtSql.Data.Rows)
                {
                    val.ListT.Add(new FunctionOrder(dr));
                }
            }
            else
            {
                val.Error = dtSql.Error;
            }

            return(val);
        }
Пример #8
0
        public async Task <ValueDTO <MonHoc> > GetData()
        {
            DataTableSQL dtSql = await ExecuteQuery("SelectMonhocv2");

            ValueDTO <MonHoc> val = new ValueDTO <MonHoc>();

            if (dtSql.Error == 0)
            {
                foreach (DataRow dr in dtSql.Data.Rows)
                {
                    val.ListT.Add(new MonHoc(dr));
                }
            }
            else
            {
                val.Error = dtSql.Error;
            }

            return(val);
        }
Пример #9
0
        public async Task <ValueDTO <ThoiKhoaBieu> > GetData(int IDLop)
        {
            DataTableSQL dtSql = await ExecuteQuery("m_SelectThoiKhoaBieu",
                                                    new SqlParameter("@IDLop", SqlDbType.Int) { Value = IDLop });

            ValueDTO <ThoiKhoaBieu> val = new ValueDTO <ThoiKhoaBieu>();

            if (dtSql.Error == 0)
            {
                foreach (DataRow dr in dtSql.Data.Rows)
                {
                    val.ListT.Add(new ThoiKhoaBieu(dr));
                }
            }
            else
            {
                val.Error = dtSql.Error;
            }

            return(val);
        }
Пример #10
0
        public async Task <ValueDTO <DTBTong> > GetData(int IDStudent, int IDClass)
        {
            ValueDTO <DTBTong> val   = new ValueDTO <DTBTong>();
            DataTableSQL       dtSql = await ExecuteQuery("M_LayDTB",
                                                          new SqlParameter("@IDHocSinh", SqlDbType.Int) { Value = IDStudent },
                                                          new SqlParameter("@IDLop", SqlDbType.Int) { Value = IDClass });

            if (dtSql.Error == 0)
            {
                foreach (DataRow dr in dtSql.Data.Rows)
                {
                    val.ListT.Add(new DTBTong(dr));
                }
            }
            else
            {
                val.Error = dtSql.Error;
            }


            return(val);
        }