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> } } }
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); }
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(); }