Ejemplo n.º 1
0
        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"));
        }
Ejemplo n.º 2
0
        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());
        }