Exemple #1
0
        public static void BindGridView(ref GridView myGridView, string listPage, string method, string userID, string schoolYear, string schoolCode)
        {
            try
            {
                if (listPage == "SchoolHistory")
                {
                    string      sp        = "dbo.tcdsb_PLF_SchoolHistoryNew @Operate,@UserID,@UserRole,@SchoolYear,@SchoolCode";
                    ParameterSP parameter = new ParameterSP {
                        Operate = method, UserID = userID, SchoolYear = schoolYear, SchoolCode = schoolCode
                    };

                    List <School> schools = GeneralDataAccess.GetSchoolList(sp, parameter);
                    //schools = PublishListDA.GetSchoolHistroy("Get", "", userID, schoolyear, schoolcode);
                    myGridView.DataSource = schools;
                    myGridView.DataBind();
                }
            }
            catch (System.Exception ex)
            {
                string em = ex.Message;
            }
        }
Exemple #2
0
        public static void BindGridView(ref GridView myGridView, string listPage, string method, string userID, string schoolYear, string schoolCode, string schoolArea)
        {
            try
            {
                if (listPage == "SchoolListbyArea")
                {
                    string       sp        = "dbo.tcdsb_PLF_AreaSchoolList @Operate,@UserID,@UserRole,@SchoolYear,@SchoolCode,@SchoolArea";
                    ParameterSP2 parameter = new ParameterSP2 {
                        Operate = "", UserID = userID, SchoolYear = schoolYear, SchoolCode = schoolCode, SchoolArea = schoolArea
                    };

                    List <School> schools = GeneralDataAccess.GetSchoolList(sp, parameter);

                    // List<School> schools = PublishList.GetAreaSchools("Get", "Role", userID, schoolyear, schoolcode, schoolArea); ;
                    myGridView.DataSource = schools;
                    myGridView.DataBind();
                }
            }
            catch (System.Exception ex)
            {
                string em = ex.Message;
            }
        }