public static List <List2Item> GetLists(string operate, string userID, string userRole, string schoolYear, string schoolCode) { using (IDbConnection connection = new SqlConnection(conSTR)) { string SP = "dbo.tcdsb_PLF_ListSchoolsNew @Operate,@UserID,@UserRole,@SchoolYear,@SchoolCode"; ParameterSP2 parameter = new ParameterSP2 { Operate = operate, UserID = userID, UserRole = userRole, SchoolYear = schoolYear, SchoolCode = schoolCode }; var mylist = connection.Query <List2Item>(SP, parameter).ToList(); return(mylist); } }
public static List <School> GetAreaSchools(string operate, string userID, string userRole, string schoolYear, string schoolCode, string schoolArea) { using (IDbConnection connection = new SqlConnection(conSTR)) { string SP = "dbo.tcdsb_PLF_AreaSchoolList @Operate,@UserID,@UserRole,@SchoolYear,@SchoolCode,@SchoolArea"; ParameterSP2 parameter = new ParameterSP2 { Operate = operate, UserID = userID, UserRole = userRole, SchoolYear = schoolYear, SchoolCode = schoolCode, SchoolArea = schoolArea }; var schoollist = connection.Query <School>(SP, parameter).ToList(); return(schoollist); } }
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; } }