Пример #1
0
    protected void Page_Load(object sender, EventArgs e)
    {
        string Model = Request.QueryString["Model"];
        int    Id    = StringDeal.ToInt(Request.QueryString["Id"]);
        int    Sort  = StringDeal.ToInt(Request.QueryString["Sort"]);

        HXD.ModelField.BLL.Model mm = new HXD.ModelField.BLL.Model();
        mm.ModelSort(Id, Model, Sort);
    }
Пример #2
0
    protected void Page_Load(object sender, EventArgs e)
    {
        LoginCheck.AdManage();
        getztOperation();
        if (!IsPostBack)
        {
            string MenuId    = Session["userid"].ToString();
            string sql_mid   = "select Classid from tb_User where id=" + MenuId;
            int    scholl_id = int.Parse(HXD.DBUtility.SQLHelper.ExecuteScalar(sql_mid).ToString());

            //string sql = "SELECT * from tb_User where Classid='" + scholl_id + "' and GroupId=1 order by id";

            //Repeater1.DataSource = HXD.DBUtility.SQLHelper.ExecuteDataset(sql);
            //Repeater1.DataBind();
            //cid 1=测评  2=预约  3=辅导 4=消息
            HXD.ModelField.BLL.Model   bll = new HXD.ModelField.BLL.Model();
            HXD.ModelField.Model.Model mod = new HXD.ModelField.Model.Model();
            mod.Condition = " Classid=" + scholl_id + " and cid=4 and zxs_id=" + MenuId + "";
            mod.FieldList = "Content,ClassId,PostTime,IsStatus";
            mod.TableName = "tb_U_Message";
            mod.Sort      = "Sort desc";
            mod.PageSize  = 20;
            mod.PageIndex = HXD.Common.StringDeal.ToInt(Request.QueryString["page"]);
            DataSet ds1 = bll.ModelList(mod);
            DataSet ds  = HXD.DBUtility.SQLHelper.ExecuteDataset("select top 20 Content,ClassId,PostTime,IsStatus from tb_U_Message where Classid=" + scholl_id + "  order by Sort desc,id desc;");
            this.Repeater1.DataSource = ds1;
            this.Repeater1.DataBind();

            HXD.Common.SgqPage pg = new HXD.Common.SgqPage();
            pg.PageSize        = mod.PageSize;
            pg.PageIndex       = mod.PageIndex;
            pg.RecordCount     = (int)ds1.Tables[1].Rows[0][0];
            this.Literal1.Text = pg.PageView2();
            if (pg.RecordCount == 0)
            {
                this.Literal1.Text = "暂无数据!";
            }
            ds.Clear();
            ds.Dispose();
            ds1.Clear();
            ds1.Dispose();

            //审核
            int    icd    = StringDeal.ToInt(Request.QueryString["Id"]);
            string Action = Request.QueryString["Action"];
            if (Action == "lock")
            {
                string sql2 = "SELECT IsStatus from tb_U_Message where id='" + icd + "'";
                bool   stra = bool.Parse(HXD.DBUtility.SQLHelper.ExecuteScalar(sql2).ToString());

                string sql = "UPDATE tb_U_Message set IsStatus=1 where id='" + icd + "'";
                HXD.DBUtility.SQLHelper.ExecuteScalar(sql);
            }
        }
    }
Пример #3
0
    protected void Page_Load(object sender, EventArgs e)
    {
        LoginCheck.AdManage();
        getztOperation();
        if (!IsPostBack)
        {
            // string sqlc = "select id,FstudentNo,Fscore,posttime from t_exam_results where [Fresultid] in(select distinct Fresultid  from t_exam_subitems_score where Fsubitemid='" + Fsubitemid + "' and [Fscore] >='" + Fscore + "' and [wid] ='" + wid + "')";

            string Fsubitemid = Request.QueryString["Fsubitemid"].ToString().Trim();
            string Fscore     = Request.QueryString["Fscore"].ToString().Trim();
            string wid        = Request.QueryString["wid"].ToString().Trim();

            //string MenuId = Session["userid"].ToString();
            //string sql_mid = "select Classid from tb_User where id=" + MenuId;
            int scholl_id = int.Parse(LoginCheck.getadminid());

            //string sql = "SELECT * from tb_User where Classid='" + scholl_id + "' and GroupId=1 order by id";

            //Repeater1.DataSource = HXD.DBUtility.SQLHelper.ExecuteDataset(sql);
            //Repeater1.DataBind();


            HXD.ModelField.BLL.Model   bll = new HXD.ModelField.BLL.Model();
            HXD.ModelField.Model.Model mod = new HXD.ModelField.Model.Model();
            //select * from t_exam_results where Fpaperid=1 and Fscore>160 and wid=
            mod.Condition = " Fpaperid='" + Fsubitemid + "' and Fscore >='" + Fscore + "' and wid ='" + wid + "'";
            mod.FieldList = "FstudentNo,Fscore,posttime";
            mod.TableName = "t_exam_results";
            mod.Sort      = "Sort desc";
            mod.PageSize  = 20;
            mod.PageIndex = HXD.Common.StringDeal.ToInt(Request.QueryString["page"]);
            DataSet ds1 = bll.ModelList(mod);
            DataSet ds  = HXD.DBUtility.SQLHelper.ExecuteDataset("select id,FstudentNo,Fscore,posttime from t_exam_results where  Fpaperid='" + Fsubitemid + "' and Fscore >='" + Fscore + "' and wid ='" + wid + "' order by Sort desc;");
            this.Repeater1.DataSource = ds1;
            this.Repeater1.DataBind();

            HXD.Common.SgqPage pg = new HXD.Common.SgqPage();
            pg.PageSize        = mod.PageSize;
            pg.PageIndex       = mod.PageIndex;
            pg.RecordCount     = (int)ds1.Tables[1].Rows[0][0];
            this.Literal1.Text = pg.PageView2();
            if (pg.RecordCount == 0)
            {
                this.Literal1.Text = "暂无数据!";
            }
            ds.Clear();
            ds.Dispose();
            ds1.Clear();
            ds1.Dispose();
        }
    }
Пример #4
0
    protected void Page_Load(object sender, EventArgs e)
    {
        LoginCheck.AdManage();
        getztOperation();
        if (!IsPostBack)
        {
            string MenuId    = Session["userid"].ToString();
            string sql_mid   = "select Classid from tb_User where id=" + MenuId;
            int    scholl_id = int.Parse(HXD.DBUtility.SQLHelper.ExecuteScalar(sql_mid).ToString());

            //string sql = "SELECT * from tb_User where Classid='" + scholl_id + "' and GroupId=1 order by id";

            //Repeater1.DataSource = HXD.DBUtility.SQLHelper.ExecuteDataset(sql);
            //Repeater1.DataBind();


            HXD.ModelField.BLL.Model   bll = new HXD.ModelField.BLL.Model();
            HXD.ModelField.Model.Model mod = new HXD.ModelField.Model.Model();
            mod.Condition = " Classid=" + scholl_id + " and GroupId=1  ";
            mod.FieldList = "UserName,RegTime,islock";
            mod.TableName = "tb_User";
            mod.Sort      = "Sort desc";
            mod.PageSize  = 20;
            mod.PageIndex = HXD.Common.StringDeal.ToInt(Request.QueryString["page"]);
            DataSet ds1 = bll.ModelList(mod);
            DataSet ds  = HXD.DBUtility.SQLHelper.ExecuteDataset("select top 20 UserName,RegTime,islock from tb_User where Classid=" + scholl_id + "  and GroupId=1 order by Sort desc,id desc;");
            this.Repeater1.DataSource = ds1;
            this.Repeater1.DataBind();

            HXD.Common.SgqPage pg = new HXD.Common.SgqPage();
            pg.PageSize        = mod.PageSize;
            pg.PageIndex       = mod.PageIndex;
            pg.RecordCount     = (int)ds1.Tables[1].Rows[0][0];
            this.Literal1.Text = pg.PageView2();
            if (pg.RecordCount == 0)
            {
                this.Literal1.Text = "暂无数据!";
            }
            ds.Clear();
            ds.Dispose();
            ds1.Clear();
            ds1.Dispose();
        }
    }
Пример #5
0
    protected void Page_Load(object sender, EventArgs e)
    {
        LoginCheck.AdManage(5);


        if (!IsPostBack)
        {
            getztOperation();

            string userid = Session["userid"].ToString();
            //string sql = "select * from tb_U_Message where zxs_id=" + userid;

            //Repeater1.DataSource = HXD.DBUtility.SQLHelper.ExecuteDataset(sql);
            //Repeater1.DataBind();
            //cid 1=消息 2=预约  3=辅导
            HXD.ModelField.BLL.Model   bll = new HXD.ModelField.BLL.Model();
            HXD.ModelField.Model.Model mod = new HXD.ModelField.Model.Model();
            mod.Condition = "cid in(2,3) and zxs_id=" + userid;
            mod.FieldList = "uid,state,yy_time";
            mod.TableName = "tb_U_Message";
            mod.Sort      = "Sort desc";
            mod.PageSize  = 20;
            mod.PageIndex = HXD.Common.StringDeal.ToInt(Request.QueryString["page"]);
            DataSet ds1 = bll.ModelList(mod);
            DataSet ds  = HXD.DBUtility.SQLHelper.ExecuteDataset("select top 20 uid,state,yy_time from tb_U_Message where cid in(2,3) and zxs_id=" + userid + " order by Sort desc,id desc;");
            this.Repeater1.DataSource = ds1;
            this.Repeater1.DataBind();

            HXD.Common.SgqPage pg = new HXD.Common.SgqPage();
            pg.PageSize        = mod.PageSize;
            pg.PageIndex       = mod.PageIndex;
            pg.RecordCount     = (int)ds1.Tables[1].Rows[0][0];
            this.Literal1.Text = pg.PageView2();
            if (pg.RecordCount == 0)
            {
                this.Literal1.Text = "暂无数据!";
            }
            ds.Clear();
            ds.Dispose();
            ds1.Clear();
            ds1.Dispose();
        }
    }
Пример #6
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Request.QueryString["c"] != "" || Request.QueryString["c"] != null)
        {
            int id = int.Parse(Request.QueryString["c"].ToString());
            //string sql = "select id,Title,PostTime from tb_U_info where ClassId="+id;

            string sql2 = "select title from tb_U_schoolfl where Id=" + id;
            list_title = HXD.DBUtility.SQLHelper.ExecuteScalar(sql2).ToString();

            //Repeater1.DataSource = HXD.DBUtility.SQLHelper.ExecuteDataset(sql);
            //Repeater1.DataBind();



            HXD.ModelField.BLL.Model   bll = new HXD.ModelField.BLL.Model();
            HXD.ModelField.Model.Model mod = new HXD.ModelField.Model.Model();
            mod.Condition = " Classid=" + id + " ";
            mod.FieldList = "Title,PostTime";
            mod.TableName = "tb_U_Info";
            mod.Sort      = "Sort desc";
            mod.PageSize  = 20;
            mod.PageIndex = HXD.Common.StringDeal.ToInt(Request.QueryString["page"]);
            DataSet ds1 = bll.ModelList(mod);
            DataSet ds  = HXD.DBUtility.SQLHelper.ExecuteDataset("select top 20 id,Title from tb_U_Info where Classid=" + id + "   order by Sort desc,id desc;");
            this.Repeater1.DataSource = ds1;
            this.Repeater1.DataBind();

            HXD.Common.SgqPage pg = new HXD.Common.SgqPage();
            pg.PageSize        = mod.PageSize;
            pg.PageIndex       = mod.PageIndex;
            pg.RecordCount     = (int)ds1.Tables[1].Rows[0][0];
            this.Literal1.Text = pg.PageView1();
            if (pg.RecordCount == 0)
            {
                this.Literal1.Text = "暂无数据!";
            }
            ds.Clear();
            ds.Dispose();
            ds1.Clear();
            ds1.Dispose();
        }
    }
Пример #7
0
    protected void bd()
    {
        string classid = LoginCheck.getadminid();
        string sqld    = "select id from tb_User where Classid=" + classid + " and GroupId=1";

        string sql = "select id from tb_U_user  where id in(" + sqld + ") ";

        //string sql2 = "select id,Fresultid,FstudentNo,Fpaperid,Fscore,Fresult,postTime from t_exam_results where Fresultid in(" + sql + ")";
        //Repeater1.DataSource = HXD.DBUtility.SQLHelper.ExecuteDataset(sql2);
        //Repeater1.DataBind();


        HXD.ModelField.BLL.Model   bll = new HXD.ModelField.BLL.Model();
        HXD.ModelField.Model.Model mod = new HXD.ModelField.Model.Model();
        mod.Condition = "";
        mod.FieldList = "[User_id],Creation_time";
        mod.TableName = "tb_VortexDecompression";
        mod.Sort      = "Creation_time desc";
        mod.PageSize  = 20;
        mod.PageIndex = HXD.Common.StringDeal.ToInt(Request.QueryString["page"]);
        DataSet ds1 = bll.ModelList(mod);
        DataSet ds  = HXD.DBUtility.SQLHelper.ExecuteDataset("select top 20 id,Creation_time from tb_VortexDecompression order by Creation_time desc,id desc;");

        this.Repeater1.DataSource = ds1;
        this.Repeater1.DataBind();

        HXD.Common.SgqPage pg = new HXD.Common.SgqPage();
        pg.PageSize        = mod.PageSize;
        pg.PageIndex       = mod.PageIndex;
        pg.RecordCount     = (int)ds1.Tables[1].Rows[0][0];
        this.Literal1.Text = pg.PageView2();
        if (pg.RecordCount == 0)
        {
            this.Literal1.Text = "暂无数据!";
        }
        ds.Clear();
        ds.Dispose();
        ds1.Clear();
        ds1.Dispose();
    }
Пример #8
0
    protected void Page_Load(object sender, EventArgs e)
    {
        LoginCheck.AdManage(5);


        if (!IsPostBack)
        {
            //string sql = "select * from tb_U_Cplist where post_uid=" + Session["userid"] + " order by id desc";
            //Repeater1.DataSource = HXD.DBUtility.SQLHelper.ExecuteDataset(sql);
            //Repeater1.DataBind();
            getztOperation();
            HXD.ModelField.BLL.Model   bll = new HXD.ModelField.BLL.Model();
            HXD.ModelField.Model.Model mod = new HXD.ModelField.Model.Model();
            mod.Condition = "post_uid=" + Session["userid"];
            mod.FieldList = "title,cp_set,PostTime,cp_id,CreateUsers";
            mod.TableName = "tb_U_Cplist";
            mod.Sort      = "Sort desc";
            mod.PageSize  = 20;
            mod.PageIndex = HXD.Common.StringDeal.ToInt(Request.QueryString["page"]);
            DataSet ds1 = bll.ModelList(mod);
            DataSet ds  = HXD.DBUtility.SQLHelper.ExecuteDataset("select top 20 title,cp_set,PostTime,cp_id,CreateUsers from tb_U_Cplist where  post_uid='" + Session["userid"].ToString() + "' order by id desc;");
            this.Repeater1.DataSource = ds1;
            this.Repeater1.DataBind();

            HXD.Common.SgqPage pg = new HXD.Common.SgqPage();
            pg.PageSize        = mod.PageSize;
            pg.PageIndex       = mod.PageIndex;
            pg.RecordCount     = (int)ds1.Tables[1].Rows[0][0];
            this.Literal1.Text = pg.PageView2();
            if (pg.RecordCount == 0)
            {
                this.Literal1.Text = "暂无数据!";
            }
            ds.Clear();
            ds.Dispose();
            ds1.Clear();
            ds1.Dispose();
        }
    }
Пример #9
0
    /// <summary>
    /// 绑定量表
    /// </summary>
    /// <param name="id"></param>

/*    protected void lb(string userid)
 *  {
 *      string setting = LoginCheck.LbManage(int.Parse(Session["userid"].ToString()));
 *      //string sql1 = "select UserSetting from tb_User where id=" + userid;
 *      //string UserSetting = HXD.DBUtility.SQLHelper.ExecuteScalar(sql1).ToString();
 *      setting = setting.Substring(1);
 *      setting = setting.Substring(0, setting.Length - 1);
 *      setting = setting.Replace("m", "0");
 *      string sql = "select Fpaperid,Fpapername from t_exam_paper where [User_id] in (" + setting + ")";
 *      DataSet ds = HXD.DBUtility.SQLHelper.ExecuteDataset(sql);
 *
 *  }*/
    protected void Button1_Click(object sender, EventArgs e)
    {
        string sex = "", tj = "", stj = "", str_lb = "";

        if (this.option1.Checked == true)
        {
            tj += "and sex='男'";
        }
        if (this.option2.Checked == true)
        {
            tj += "and sex='女'";
        }
        string str_mz = this.se_mz.Value;//民族

        if (str_mz != "0")
        {
            tj += "and nationality='" + str_mz + "'";
        }
        string name = this.TextBox1.Text;//名字

        if (name != "")
        {
            tj += "and Name like '%" + name + "%'";
        }
        string a_time = ks_time.Value;//开始时间

        if (a_time != "")
        {
            str_lb += "and postTime>='" + a_time + "'";
        }
        string b_time = js_time.Value;//结束时间

        if (b_time != "")
        {
            str_lb += "and postTime<='" + b_time + "'";
        }

        string classid = LoginCheck.getadminid();
        string sqld    = "select id from tb_User where Classid=" + classid + " and GroupId=1";

        string sql = "select id from tb_U_user  where id in(" + sqld + ")  " + tj + "";

        //string sql2 = "select id,Fresultid,FstudentNo,Fpaperid,Fscore,Fresult,postTime from t_exam_results where Fresultid in(" + sql + ")";
        //Repeater1.DataSource = HXD.DBUtility.SQLHelper.ExecuteDataset(sql2);
        //Repeater1.DataBind();


        HXD.ModelField.BLL.Model   bll = new HXD.ModelField.BLL.Model();
        HXD.ModelField.Model.Model mod = new HXD.ModelField.Model.Model();
        mod.Condition = "  Fresultid in(" + sql + ")  " + str_lb + "";
        mod.FieldList = "Fresultid,FstudentNo,Fpaperid,Fscore,Fresult,postTime";
        mod.TableName = "t_exam_results";
        mod.Sort      = "postTime desc";
        mod.PageSize  = 20;
        mod.PageIndex = HXD.Common.StringDeal.ToInt(Request.QueryString["page"]);
        DataSet ds1 = bll.ModelList(mod);
        DataSet ds  = HXD.DBUtility.SQLHelper.ExecuteDataset("select top 20 id,Fresultid,FstudentNo,Fpaperid,Fscore,Fresult,postTime from t_exam_results where Fresultid in(" + sql + ") " + str_lb + " order by postTime desc,id desc;");

        this.Repeater1.DataSource = ds1;
        this.Repeater1.DataBind();

        HXD.Common.SgqPage pg = new HXD.Common.SgqPage();
        pg.PageSize        = mod.PageSize;
        pg.PageIndex       = mod.PageIndex;
        pg.RecordCount     = (int)ds1.Tables[1].Rows[0][0];
        this.Literal1.Text = pg.PageView2();
        if (pg.RecordCount == 0)
        {
            this.Literal1.Text = "暂无数据!";
        }
        ds.Clear();
        ds.Dispose();
        ds1.Clear();
        ds1.Dispose();
    }