private void RptBind(string _strWhere, string _order) { int pageSize = GetPageSize(15); //每页数量 int page = MyRequest.GetQueryInt("page", 1); string keywords = MyRequest.GetQueryString("keywords"); int start_index = pageSize * (page - 1) + 1; this.st_index = pageSize * (page - 1) + 1; int end_index = pageSize * page; this.txtKeywords.Value = keywords; BLL.CCOM.Topic bll = new BLL.CCOM.Topic(); //计算数量 int totalCount = bll.GetRecordCount(_strWhere); //绑定当页 this.rptList.DataSource = bll.GetListByPage(_strWhere, _order, start_index, end_index); this.rptList.DataBind(); //绑定页码 txtPageNum.Text = pageSize.ToString(); string pageUrl = Utils.CombUrlTxt("StudentChoose.aspx", "fun_id={0}&keywords={1}&sort={2}&page={3}", this.fun_id, this.keywords, MyRequest.GetString("sort"), "__id__"); this.PageContent.InnerHtml = Utils.OutPageList(pageSize, page, totalCount, pageUrl, 8, true); //绑定我的选题 BLL.CCOM.View_Selete_Topic selete_bll = new BLL.CCOM.View_Selete_Topic(); this.rptList2.DataSource = selete_bll.GetList(" Student_id =" + GetAdminInfo_CCOM().User_id); //this.rptList2.DataSource = selete_bll.GetListByPage(_strWhere + "and Student_id ="+GetAdminInfo_CCOM().User_id, _order, start_index, end_index); this.rptList2.DataBind(); }
private void RptBind(string _order) { string _strWhere = ""; string str = GetStudentID(); if (str != "") { _strWhere += "Student_id in (" + str + ")"; } else { _strWhere += "Student_id=-1"; } int pageSize = GetPageSize(15); //每页数量 int page = MyRequest.GetQueryInt("page", 1); string keywords = MyRequest.GetQueryString("keywords"); int start_index = pageSize * (page - 1) + 1; this.st_index = pageSize * (page - 1) + 1; int end_index = pageSize * page; BLL.CCOM.View_Selete_Topic bll = new BLL.CCOM.View_Selete_Topic(); //计算数量 // int totalCount = bll.GetRecordCount(_strWhere); //绑定我的选题 this.rptList.DataSource = bll.GetListByPage(_strWhere, _order, start_index, end_index); this.rptList.DataBind(); }
protected void bindTitleInfo() { //Model.CCOM.Examination_arrangement exam_model = new BLL.CCOM.Examination_arrangement().GetModel(Group_id); //Model.CCOM.Examination_room room_model = new BLL.CCOM.Examination_room().GetModel(exam_model.Ea_room); //Model.CCOM.Examination_subject subject_model = new BLL.CCOM.Examination_subject().GetModel(" Ea_id='" + exam_model.Ea_id + "'"); //string year = ""; //if (subject_model != null) //{ // Model.CCOM.Subject s_model = new BLL.CCOM.Subject().GetModel(subject_model.Esn_id); // year = new BLL.CCOM.Period().GetModel(s_model.Period_id).Period_year; //} //if (year == "") year = Utils.ObjectToStr(DateTime.Now.Year); //this.lbltime.Text = Convert.ToDateTime(exam_model.Ea_starttime).ToString("MM月dd日 HH:mm"); //this.lblplace.Text = room_model.Er_building + room_model.Er_floor + "层" + room_model.Er_room; Model.CCOM.Reply_group rg_model = new BLL.CCOM.Reply_group().GetModel(Group_id); this.lbltime.Text = rg_model.Reply_time.ToString("yyyy年MM月dd日 HH:mm"); this.lblplace.Text = rg_model.Reply_room; this.lbltitle.Text = rg_model.Group_name; if (rg_model.Group_type == 0) { page_title = "2017软件学院毕业设计答辩安排"; this.lbltype.Text = "口头答辩"; } else if (rg_model.Group_type == 1) { page_title = "2017软件学院毕业设计软件验收安排"; this.lbltype.Text = "软件验收"; } else if (rg_model.Group_type == 2) { page_title = "2017软件学院开题评审答辩安排"; this.lbltype.Text = "开题评审"; } //绑定答辩委员会 var group_model = new BLL.CCOM.Reply_group().GetModel(" Group_id=" + Group_id); var leader_model = new BLL.CCOM.View_User().GetModel(" User_id=" + group_model.User_id); reviewTr1 = "<tr><td style=\"text-align:center\">" + leader_model.User_realname + "</td><td style=\"text-align:center\">" + leader_model.Role_name + "</td><td style=\"text-align:center\">主席</td></tr>"; var rcs = new BLL.CCOM.Reply_commission().GetModelList(" Group_id=" + Group_id); foreach (var rc in rcs) { var u_model = new BLL.CCOM.View_User().GetModel(" User_id=" + rc.User_id); reviewTr1 += "<tr><td style=\"text-align:center\">" + u_model.User_realname + "</td><td style=\"text-align:center\">" + u_model.Role_name + "</td><td style=\"text-align:center\">成员</td></tr>"; } //绑定学生 var rss = new BLL.CCOM.Reply_student().GetModelList("Group_id=" + Group_id + " order by User_id"); BLL.CCOM.View_Selete_Topic user_bll = new BLL.CCOM.View_Selete_Topic(); foreach (var rs in rss) { var s_model = new BLL.CCOM.View_Selete_Topic().GetModel(" Student_id=" + rs.User_id); reviewTr2 += "<tr><td style=\"text-align:center\">" + s_model.Student_name + "</td><td style=\"text-align:center\">" + s_model.User_number + "</td><td style=\"text-align:center\">" + s_model.Teacher_name + "</td><td style=\"text-align:center\">" + s_model.Topic_name + "</td></tr>"; } }
private void RptBind(string _order) { string _strWhere = ""; _strWhere += "Accept_state = 1 and Teacher_id =" + GetAdminInfo_CCOM().User_id; int pageSize = GetPageSize(15); //每页数量 int page = MyRequest.GetQueryInt("page", 1); string keywords = MyRequest.GetQueryString("keywords"); int start_index = pageSize * (page - 1) + 1; this.st_index = pageSize * (page - 1) + 1; int end_index = pageSize * page; BLL.CCOM.View_Selete_Topic bll = new BLL.CCOM.View_Selete_Topic(); //计算数量 // int totalCount = bll.GetRecordCount(_strWhere); //绑定我的选题 this.rptList.DataSource = bll.GetListByPage(_strWhere, _order, start_index, end_index); this.rptList.DataBind(); }