private void RptBind(string _order) { var bll = new BLL.CCOM.Reply_student(); //计算数量 int totalCount = bll.GetRecordCount(" Group_id=" + apply_id); //绑定当页 this.rptList.DataSource = bll.GetList(" Group_id=" + apply_id); this.rptList.DataBind(); string pageUrl = Utils.CombUrlTxt("StudentList.aspx", "fun_id={0}&groupid={1}", MyRequest.GetQueryString("fun_id"), MyRequest.GetQueryString("groupid")); }
protected string CombSqlTxt() { int flag = 0; int i = 0; var model = GetAdminInfo_CCOM(); StringBuilder strTemp = new StringBuilder(); BLL.CCOM.Reply_student rs_bll = new BLL.CCOM.Reply_student(); BLL.CCOM.Reply_commission rc_bll = new BLL.CCOM.Reply_commission(); BLL.CCOM.Reply_group rg_bll = new BLL.CCOM.Reply_group(); strTemp.Append("("); //学生 DataSet ds = rs_bll.GetList("User_id=" + model.User_id); if (ds.Tables[0].Rows.Count > 0) { flag = 1; strTemp.Append(ds.Tables[0].Rows[0]["Group_id"]); for (i = 1; i < ds.Tables[0].Rows.Count; i++) { strTemp.Append("," + ds.Tables[0].Rows[i]["Group_id"]); } } //组长 ds = rg_bll.GetList("User_id=" + model.User_id); if (ds.Tables[0].Rows.Count > 0) { if (flag == 0) { flag = 1; strTemp.Append(ds.Tables[0].Rows[0]["Group_id"]); i = 1; } else { i = 0; } for (; i < ds.Tables[0].Rows.Count; i++) { strTemp.Append("," + ds.Tables[0].Rows[i]["Group_id"]); } } //组员 ds = rc_bll.GetList("User_id=" + model.User_id); if (ds.Tables[0].Rows.Count > 0) { if (flag == 0) { flag = 1; strTemp.Append(ds.Tables[0].Rows[0]["Group_id"]); i = 1; } else { i = 0; } for (; i < ds.Tables[0].Rows.Count; i++) { strTemp.Append("," + ds.Tables[0].Rows[i]["Group_id"]); } } if (flag == 0) { strTemp.Append("-1"); } strTemp.Append(")"); return(strTemp.ToString()); }