protected void Page_Load(object sender, EventArgs e) { LoginCheck.AdManage(); if (!IsPostBack) { string sname = Session["AdminManage"].ToString(); string MenuId = Session["userid"].ToString(); userid = int.Parse(MenuId); string sql_mid = "select Classid from tb_User where id=" + userid; int scholl_id = int.Parse(HXD.DBUtility.SQLHelper.ExecuteScalar(sql_mid).ToString()); string sql_school = "select s_name from tb_U_school where ID=" + scholl_id; sc_name = HXD.DBUtility.SQLHelper.ExecuteScalar(sql_school).ToString(); string user_name = "select Name from tb_U_User where ID=" + MenuId; u_name = HXD.DBUtility.SQLHelper.ExecuteScalar(user_name).ToString(); //string sql = "select * from tb_User where ID=" + MenuId; //DataSet ds = HXD.DBUtility.SQLHelper.ExecuteDataset(sql); //icd = ds.Tables[0].Rows[0]["id"].ToString(); string cscun = "select COUNT(id) from t_exam_results where FstudentNo='" + sname + "'"; cs_cun = HXD.DBUtility.SQLHelper.ExecuteScalar(cscun).ToString(); //cid 1=测评 2=预约 3=辅导 4=消息 string yycun = "select COUNT(id) from tb_U_Message where uid='" + MenuId + "' and cid=2"; yy_cun = HXD.DBUtility.SQLHelper.ExecuteScalar(yycun).ToString(); string tzcun = "select COUNT(id) from tb_U_Message where uid='" + MenuId + "' and cid=4"; tz_cun = HXD.DBUtility.SQLHelper.ExecuteScalar(tzcun).ToString(); } }
protected void Page_Load(object sender, EventArgs e) { LoginCheck.AdManage(); getztOperation(); if (!IsPostBack) { string MenuId = Session["userid"].ToString(); string sql_group = "select GroupId from tb_User where id=" + MenuId; int groupid = int.Parse(HXD.DBUtility.SQLHelper.ExecuteScalar(sql_group).ToString()); if (groupid == 7) { //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_U_school order by id"; Repeater1.DataSource = HXD.DBUtility.SQLHelper.ExecuteDataset(sql); Repeater1.DataBind(); } else { StringDeal.Alter("您没有这个权限!"); } } }
protected void Page_Load(object sender, EventArgs e) { LoginCheck.AdManage(5); if (!IsPostBack) { this.Panel1.Visible = true; string cid = Request.QueryString["cid"].ToString(); string sql = "select uid,content,Replay,yy_time,state from tb_U_Message where id=" + cid; DataSet ds = HXD.DBUtility.SQLHelper.ExecuteDataset(sql); string str = ds.Tables[0].Rows[0]["content"].ToString(); string strid = ds.Tables[0].Rows[0]["uid"].ToString(); string sql1 = "select name from tb_U_user where id=" + strid; string str_name = HXD.DBUtility.SQLHelper.ExecuteScalar(sql1).ToString(); this.Label1.Text = str_name; this.Label2.Text = str; this.Label3.Text = ds.Tables[0].Rows[0]["yy_time"].ToString(); this.container.Value = ds.Tables[0].Rows[0]["Replay"].ToString(); int icd = int.Parse(ds.Tables[0].Rows[0]["state"].ToString()); if (icd == 2) { this.Panel1.Visible = false; } } }
protected void Page_Load(object sender, EventArgs e) { LoginCheck.AdManage(6); if (!IsPostBack) { this.Panel1.Visible = true; this.Select1.Items.Add(new ListItem("顶级栏目", "0")); menid = LoginCheck.getadminid(); bd(menid); if (Request.QueryString["id"] != null) { this.Panel1.Visible = false; this.Panel2.Visible = true; string id = Request.QueryString["id"].ToString(); string sql = "select id,ClassId,title,depth from tb_U_schoolfl where id='" + id + "'"; DataSet ds = HXD.DBUtility.SQLHelper.ExecuteDataset(sql); if (ds.Tables[0].Rows.Count > 0) { TextBox1.Text = ds.Tables[0].Rows[0]["title"].ToString(); Select1.Value = ds.Tables[0].Rows[0]["ClassId"].ToString(); } } } }
protected void Page_Load(object sender, EventArgs e) { LoginCheck.AdManage(6); this.Select1.Items.Add(new ListItem("顶级栏目", "0")); string sql = "select classid from tb_user where ID=" + Session["userid"].ToString(); menid = HXD.DBUtility.SQLHelper.ExecuteScalar(sql).ToString(); bd(menid); if (!IsPostBack) { if (Request.QueryString["id"] != null) { this.Panel2.Visible = true; string id = Request.QueryString["id"].ToString(); string sqlmb = "select title,ClassId,Sid,Depth,mb_id from tb_U_schoolfl where id=" + id; DataSet ds = HXD.DBUtility.SQLHelper.ExecuteDataset(sqlmb); if (ds.Tables[0].Rows.Count > 0) { this.TextBox1.Text = ds.Tables[0].Rows[0]["title"].ToString(); this.Select1.Value = ds.Tables[0].Rows[0]["ClassId"].ToString(); this.Select2.Value = ds.Tables[0].Rows[0]["mb_id"].ToString(); } } else { this.Panel1.Visible = true; } } }
protected void Page_Load(object sender, EventArgs e) { LoginCheck.AdManage(); if (!IsPostBack) { if (Request.QueryString["id"] != null) { string id = Request.QueryString["id"].ToString(); string sql = "select Id,uid,Name,Content,yy_time,zxs_id,replay,PostTime from tb_U_Message where Id='" + id + "'"; //string sql = "select id,ClassId,Title,content,PostTime from tb_U_info where Id=" + id; DataSet ds = HXD.DBUtility.SQLHelper.ExecuteDataset(sql); if (ds.Tables[0].Rows.Count > 0) { xs_name = getname(ds.Tables[0].Rows[0]["uid"].ToString()); xs_note = ds.Tables[0].Rows[0]["Content"].ToString(); xs_time = ds.Tables[0].Rows[0]["yy_time"].ToString(); ls_name = getname(ds.Tables[0].Rows[0]["zxs_id"].ToString()); ls_note = ds.Tables[0].Rows[0]["replay"].ToString(); ls_time = ds.Tables[0].Rows[0]["PostTime"].ToString(); if (ls_note == null || ls_note == "") { ls_note = "暂无回复!请稍后。"; ls_time = ""; } } } } }
protected void Page_Load(object sender, EventArgs e) { LoginCheck.AdManage(6); if (!IsPostBack) { string sqlc = "select Classid from tb_User where Id=" + Session["userid"].ToString(); string scid = HXD.DBUtility.SQLHelper.ExecuteScalar(sqlc).ToString(); if (Request.QueryString["wzid"] != null) { string wzid = Request.QueryString["wzid"].ToString(); string sql = "select * from tb_U_info where id=" + wzid; DataSet ds = HXD.DBUtility.SQLHelper.ExecuteDataset(sql); if (ds.Tables[0].Rows.Count > 0) { this.TextBox1.Text = ds.Tables[0].Rows[0]["title"].ToString(); this.TextBox2.Text = ds.Tables[0].Rows[0]["note"].ToString(); this.container.Value = ds.Tables[0].Rows[0]["Content"].ToString(); } this.Panel1.Visible = false; this.Panel2.Visible = true; } else { this.Panel1.Visible = true; this.Panel2.Visible = false; } } }
protected void Page_Load(object sender, EventArgs e) { LoginCheck.AdManage(); if (!IsPostBack) { stre(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { LoginCheck.AdManage(5); string classid = LoginCheck.getadminid(); bd(classid); } }
protected void Page_Load(object sender, EventArgs e) { LoginCheck.AdManage(7); if (!IsPostBack) { this.Select1.Items.Add(new ListItem("顶级栏目", "0")); menid = Session["userid"].ToString(); bd(menid); } }
protected void Page_Load(object sender, EventArgs e) { LoginCheck.AdManage(6); this.Select1.Items.Add(new ListItem("顶级栏目", "0")); string sql = "select classid from tb_user where ID=" + Session["userid"].ToString(); menid = HXD.DBUtility.SQLHelper.ExecuteScalar(sql).ToString(); bd(menid); }
protected void Page_Load(object sender, EventArgs e) { LoginCheck.AdManage(5); if (!IsPostBack) { string userid = Session["userid"].ToString(); this.TextBox1.Text = Session["AdminManage"].ToString(); } }
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); } } }
protected void Page_Load(object sender, EventArgs e) { LoginCheck.AdManage(); if (Request.QueryString["para"] != null)//Request.QueryString["MenuId"] { string str = Request.QueryString["para"].ToString(); string iid = Request.QueryString["iid"].ToString(); Response.Write(stra(str, iid)); } }
protected void Page_Load(object sender, EventArgs e) { LoginCheck.AdManage(6); if (!IsPostBack) { string userid = Session["userid"].ToString(); this.TextBox1.Text = Session["AdminManage"].ToString(); string sql = "select name from tb_u_user where id='" + userid + "'"; this.cname.Text = HXD.DBUtility.SQLHelper.ExecuteScalar(sql).ToString(); } }
protected void Page_Load(object sender, EventArgs e) { LoginCheck.AdManage(1); if (!IsPostBack) { //string sql = "select classid from tb_user where ID=" + Session["userid"].ToString(); //string xz_id = HXD.DBUtility.SQLHelper.ExecuteScalar(sql).ToString(); //bdinfo(); } }
protected void Page_Load(object sender, EventArgs e) { LoginCheck.AdManage(); if (!IsPostBack) { string MenuId = Session["userid"].ToString(); int userid = int.Parse(MenuId); string sql = "select id,uid,zxs_id,Content,PostTime,state from tb_U_Message where cid=1 and uid=" + userid + " order by id desc"; Repeater1.DataSource = HXD.DBUtility.SQLHelper.ExecuteDataset(sql); Repeater1.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { LoginCheck.AdManage(7); if (!IsPostBack) { string menid = Session["userid"].ToString(); //string sql = "select * from tb_U_schoolfl where sid=" + menid; //Repeater1.DataSource = HXD.DBUtility.SQLHelper.ExecuteDataset(sql); //Repeater1.DataBind(); bdlist(menid); } }
protected void Page_Load(object sender, EventArgs e) { LoginCheck.AdManage(6); if (!IsPostBack) { /* string sql = "select classid from tb_user where id=" + Session["userid"].ToString(); * string classid = HXD.DBUtility.SQLHelper.ExecuteScalar(sql).ToString();*/ bd(); /* lb(Session["userid"].ToString());*/ /* getztOperation();*/ } }
protected void Page_Load(object sender, EventArgs e) { LoginCheck.AdManage(); string cp_title = "select * from t_exam_paper where Fpaperid=1"; //测评标题 string cp_questions = "select * from t_exam_questions where Fexampaperid=1"; //测评问题 string cp_questions_score = "select * from t_exam_score_ref where Fexampaperid=1 order by Fquestionid"; //测评答案分数 string cp_questions_options = "select * from t_exam_options where Foptionid=9"; //测评答案选项 cp_questioncun = HXD.DBUtility.SQLHelper.ExecuteScalar("select COUNT(Fexampaperid) from t_exam_questions where Fexampaperid=1").ToString(); DataSet cp = HXD.DBUtility.SQLHelper.ExecuteDataset(cp_title); if (cp.Tables[0].Rows.Count > 0) { cp_name = cp.Tables[0].Rows[0]["Fpapername"].ToString(); //测评题目 cp_note = cp.Tables[0].Rows[0]["Fdescription"].ToString(); //测评简介 cp_id = cp.Tables[0].Rows[0]["Fpaperid"].ToString(); //测评简介 } DataSet ques = HXD.DBUtility.SQLHelper.ExecuteDataset(cp_questions); for (int i = 0; i < ques.Tables[0].Rows.Count; i++) { int b = i + 1; string ques_title = ques.Tables[0].Rows[i]["Fquestion"].ToString(); string sql22 = "select Fscoreref from t_exam_score_ref where Fexampaperid=1 and Fquestionid=" + b; string core = HXD.DBUtility.SQLHelper.ExecuteScalar(sql22).ToString(); string[] sArray = core.Split('|'); string option1 = sArray[0]; string option2 = sArray[1]; string option3 = sArray[2]; string option4 = sArray[3]; string option5 = sArray[4]; questions += "<div id=\"panel2\" class=\"panel-body js_answer\" style=\"display: none;\">"; questions += "<form action=\"#\" method=\"POST\"><a name=\"result\" href=\"javascript:void(0)\"></a>"; questions += "<div class=\"form-group avatar text-center\"><label for=\"\" class=\"sr-only\">前言</label>"; questions += "<a href=\"javascript:void(0)\" class=\"img-circle\" name=\"1\"><span style=\"float: left;text-align: center; width: 100%; padding-top: 18px;\"><img src=\"ks.jpg\"></span> </a></div>"; questions += "<dl><dd>" + b + "." + ques_title + "</dd></dl>"; questions += "<ul class=\"list-group js_group\">"; DataSet option = HXD.DBUtility.SQLHelper.ExecuteDataset(cp_questions_options); for (int ii = 0; ii < option.Tables[0].Rows.Count; ii++) { string options = option.Tables[0].Rows[ii]["Foptionitemvalue"].ToString(); questions += "<li class=\"list-group-item\" onclick=\"return toggle(this);\">"; questions += "<input name=\"g\" type=\"radio\" class=\"\" value=\"" + sArray[ii] + "\" />" + options + "</li>"; } questions += "</ul></form></div>"; } }
protected void Page_Load(object sender, EventArgs e) { LoginCheck.AdManage(7); getztOperation(); if (!IsPostBack) { string sql = "SELECT * from tb_User where GroupId=6 order by id"; Repeater1.DataSource = HXD.DBUtility.SQLHelper.ExecuteDataset(sql); Repeater1.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { LoginCheck.AdManage(5); if (!IsPostBack) { string sql = "select classid from tb_user where id=" + Session["userid"].ToString(); string classid = HXD.DBUtility.SQLHelper.ExecuteScalar(sql).ToString(); bd(classid); bd(); lb(Session["userid"].ToString()); } }
protected void Page_Load(object sender, EventArgs e) { LoginCheck.AdManage(6); if (!IsPostBack) { string userid = Session["userid"].ToString(); string sqlcl = "select name,tel from tb_u_user where id=" + userid; DataSet ds = HXD.DBUtility.SQLHelper.ExecuteDataset(sqlcl); this.TextBox1.Text = ds.Tables[0].Rows[0]["name"].ToString(); this.TextBox2.Text = ds.Tables[0].Rows[0]["tel"].ToString(); } }
protected void Page_Load(object sender, EventArgs e) { LoginCheck.AdManage(5); if (!IsPostBack) { //string sql = "select * from t_exam_paper where Fpapertype=1"; //Repeater1.DataSource = HXD.DBUtility.SQLHelper.ExecuteDataset(sql); //Repeater1.DataBind(); lb(Session["userid"].ToString()); } }
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(); } }
protected void Page_Load(object sender, EventArgs e) { LoginCheck.AdManage(7); getztOperation(); if (!IsPostBack) { string userid = Session["userid"].ToString(); string sql = "select * from tb_U_info where userid=" + userid; Repeater1.DataSource = HXD.DBUtility.SQLHelper.ExecuteDataset(sql); Repeater1.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { LoginCheck.AdManage(); if (Request.QueryString["answers"] != null) //Request.QueryString["MenuId"] { string sc_id = LoginCheck.getadminid(); //学校ID string answers = Request.QueryString["answers"].ToString(); //答案 string wid = Request.QueryString["wid"].ToString(); //答案 answers = answers.Remove(0, 2); int paperID2 = int.Parse(Request.QueryString["paperid"].ToString()); //量表名称 string UserName = Session["AdminManage"].ToString(); //"maidi007";用户名 string Userid = Session["userid"].ToString(); //string answers = "0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|2|2|2|2|2|2|2|2|2|2|2|2|2|2|2";//scl-90 //string answers = "0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|1|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0"; //int paperID2 = 2; Scorer scorer = Scorer.CreateScorer(paperID2); string resultText; float totalScore; int[] scoreArray; scorer.Score(paperID2, answers, out resultText, out totalScore, out scoreArray); int[] subitemIds = null; float[] subitemScoreArray = null; bool seniorScoreResult = scorer.SeniorScore(paperID2, answers, scoreArray, UserName, ref resultText, out subitemIds, out subitemScoreArray); scorer.Diagnose(paperID2, answers, UserName, scoreArray, totalScore, subitemScoreArray, ref resultText); int resultid = int.Parse(Session["userid"].ToString()); //string wid = DateTime.Now.ToString("yyyyMMddHHmmssfff"); SaveResult(resultid, UserName, paperID2, answers, scoreArray, totalScore, resultText, GetTestNum(paperID2), wid, sc_id); if (seniorScoreResult) { SaveSubItemResult(UserName, resultid, subitemIds, subitemScoreArray, wid, sc_id); } if (IsPCPaper(paperID2)) { string sql = "update tb_U_Message set state=2 where rid='" + wid + "' and uid='" + Userid + "'"; HXD.DBUtility.SQLHelper.ExecuteNonQuery(sql); Response.Write("结果已提交到服务器,谢谢你完成此调查所有问题。"); //base.get_Response().Write("结果已提交到服务器,谢谢你完成此调查所有问题。"); } else { string sql = "update tb_U_Message set state=2 where rid='" + wid + "' and uid='" + Userid + "'"; HXD.DBUtility.SQLHelper.ExecuteNonQuery(sql); //Response.Write(resultText); } } }
protected void Page_Load(object sender, EventArgs e) { LoginCheck.AdManage(6); if (!IsPostBack) { string userid = Session["userid"].ToString(); string sqlcl = "select Classid from tb_user where id=" + userid; string id = HXD.DBUtility.SQLHelper.ExecuteScalar(sqlcl).ToString(); // LoginCheck.Sendmsg(id, "【教育局】" + s_name2 + "查看了学校的量表统计!"); string sql = "select * from tb_U_school where id=" + id; DataSet ds = HXD.DBUtility.SQLHelper.ExecuteDataset(sql); this.TextBox1.Text = ds.Tables[0].Rows[0]["s_name"].ToString(); this.TextBox2.Text = ds.Tables[0].Rows[0]["note"].ToString(); } }
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(); }
protected void Page_Load(object sender, EventArgs e) { LoginCheck.AdManage(1); if (!IsPostBack) { bd(); //string MenuId = Session["userid"].ToString(); //userid = int.Parse(MenuId); //string sql = "select * from tb_U_User where id=" + userid; //DataSet ds = HXD.DBUtility.SQLHelper.ExecuteDataset(sql); //this.username.Text = ds.Tables[0].Rows[0]["name"].ToString(); //this.userphone.Text = ds.Tables[0].Rows[0]["tel"].ToString(); } }