Ejemplo n.º 1
0
    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 Fpaperid in (" + setting + ")";
        DataSet ds  = HXD.DBUtility.SQLHelper.ExecuteDataset(sql);

        if (ds.Tables[0].Rows.Count > 0)
        {
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                string stritem   = ds.Tables[0].Rows[i]["Fpaperid"].ToString();
                string strvalues = ds.Tables[0].Rows[i]["Fpapername"].ToString();

                this.Select1.Items.Add(new ListItem(strvalues, stritem));

                //<option value="a">-The.CC</option>
            }
        }
    }
Ejemplo n.º 2
0
    protected string getzt(string str)
    {
        str = "," + str + ",";
        //string sql = "select usersetting from tb_user where id=" + Session["userid"].ToString();
        //string setting = HXD.DBUtility.SQLHelper.ExecuteScalar(sql).ToString();
        string setting = LoginCheck.LbManage(int.Parse(Session["userid"].ToString()));
        string name    = "";

        string zt_yes = "<img src=\"assets/img/yes.png\">";
        string zt_no  = "<img src=\"assets/img/no.png\">";

        if (setting.IndexOf(str) > -1)
        {  //包含指定的字符串,执行相应的代码
            name = zt_yes;
        }
        else
        {
            name = zt_no;
        }


        //bool sta = bool.Parse(str);
        //if (sta == true)
        //{
        //    name = zt_no;
        //}
        //else
        //{
        //   name = zt_yes;
        //}
        return(name);
    }
Ejemplo n.º 3
0
    protected void Page_Load(object sender, EventArgs e)
    {
        LoginCheck.AdManage(1);
        string uid     = Session["userid"].ToString();
        string setting = LoginCheck.LbManage(int.Parse(uid));

        wid     = Request.QueryString["wid"].ToString();
        setting = setting.Substring(1);
        setting = setting.Substring(0, setting.Length - 1);
        setting = setting.Replace("m", "0");
        string sql = "select * from t_exam_paper where Fpapertype=1 and Fpaperid in(" + setting + ")";

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