protected void Button1_Click(object sender, EventArgs e) { string classid = LoginCheck.getadminid(); string icd = Session["userid"].ToString(); string title = this.TextBox1.Text; string mb_id = this.Select2.Value; string str_se = this.Select1.Value; //判断有没有上级 //string sqll = "select mb_id from tb_U_schoolfl where Id='" + mb_id + "'"; //int scid = int.Parse(HXD.DBUtility.SQLHelper.ExecuteScalar(sqll).ToString()); string sql2 = "select COUNT(id) from tb_U_schoolfl where sid='" + classid + "' and mb_id='" + mb_id + "'"; int cunid = int.Parse(HXD.DBUtility.SQLHelper.ExecuteScalar(sql2).ToString()); if (cunid == 0) { int sid = pdsj(str_se); string sql = "insert into tb_U_schoolfl (title,ClassId,Sid,Depth,menuid)values('" + title + "','" + str_se + "','" + menid + "','" + sid + "','1')"; HXD.DBUtility.SQLHelper.ExecuteScalar(sql); Response.Redirect("new_fl.aspx"); } else { HXD.Common.StringDeal.Alter("该类目下只能有一个分类!"); } }
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(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.AdminManage(); if (Request.QueryString["id"] != null) { this.TextBox1.Text = "<script type=\"text/javascript\" src=\"" + Web.Model.PublicModel.XADJsFile + Request.QueryString["id"].ToString() + ".js\"></script>"; } }
protected void Page_Load(object sender, EventArgs e) { LoginCheck.AdminManage(); if (Request.QueryString["id"] != null) { id = Convert.ToInt32(Request.QueryString["id"]); } }
protected void Page_Load(object sender, EventArgs e) { LoginCheck.AdminManage(null); UserName = Session["AdminManage"].ToString(); Caches.RemoveCache("Admin_" + UserName); Session.Remove("AdminManage"); Response.Write("<script>window.parent.location='Logine.aspx'</script>"); }
protected void Page_Load(object sender, EventArgs e) { LoginCheck.AdminManage(); Pages = HXD.Common.StringDeal.ToInt(Request.QueryString["Page"]); this.DropDownList1.Attributes.Add("onchange", "selectvalue(this);"); this.Button1.Attributes.Add("onmouseover", "this.className='button1'"); this.Button1.Attributes.Add("onmouseout", "this.className='button'"); }
protected void Page_Load(object sender, EventArgs e) { LoginCheck.AdManage(); if (!IsPostBack) { stre(); } }
protected void Page_Load(object sender, EventArgs e) { LoginCheck.AdminManage(); InputName = Request.QueryString["InputName"]; if (!IsPostBack) { GetConfigInfo(); } }
protected void Page_Load(object sender, EventArgs e) { LoginCheck.AdminManage(); if (!IsPostBack) { this.DBList.DataSource = GetBackUpList().DefaultView; this.DBList.DataBind(); } }
static void Main(string[] args) { CsvCreation calling = new CsvCreation(); calling.Creation(); LoginCheck check = new LoginCheck(); check.checkIn(); }
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) { string classid = LoginCheck.getadminid(); bdlhead(classid); //if (RoomID == 1) //{ // h_str = " active"; //} }
protected void Page_Load(object sender, EventArgs e) { LoginCheck.AdminManage(); id = HXD.Common.StringDeal.ToInt(Request.QueryString["fid"]); Pages = HXD.Common.StringDeal.ToInt(Request.QueryString["Page"]); if (!IsPostBack) { databiner(id); } }
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 Button3_Click(object sender, EventArgs e) { int scholl_id = int.Parse(LoginCheck.getadminid()); string name = this.Text1.Value; string sql = "select a.id,UserName,RegTime,islock from tb_User as a,tb_U_User as b where a.id=b.id and a.Classid=" + scholl_id + " and a.GroupId=1 and (a.UserName like '%" + name + "%' or b.Name like '%" + name + "%') order by Sort desc,a.id desc;"; DataSet ds = HXD.DBUtility.SQLHelper.ExecuteDataset(sql); this.Repeater1.DataSource = ds; this.Repeater1.DataBind(); }
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 Button3_Click(object sender, EventArgs e) { string name = this.uname.Value.Trim(); string scholl_id = LoginCheck.getadminid(); //string sql = "SELECT * from tb_User where Classid='" + scholl_id + "' and GroupId=5 and username like '%" + name + "%'or order by id"; string sql = "SELECT a.id,UserName,islock,RegTime from tb_User as a,tb_U_user as b where a.Classid='" + scholl_id + "' and a.Id=b.Id and a.GroupId=5 and (a.UserName like '%" + name + "%' or b.Name like '%" + name + "%') order by a.id"; Repeater1.DataSource = HXD.DBUtility.SQLHelper.ExecuteDataset(sql); Repeater1.DataBind(); }
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(); 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); } } }
private void btnSend_Click(object sender, EventArgs e) { rtxtResponse.Text = ""; string url = "https://sir.sonora.gob.mx/api/access"; LoginCheck oLogin = GetRequestObject(); LoginCheckResponse response = Send(url, oLogin, "POST"); ShowResponse(response); }
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(); 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.AdminManage(); if (Request.QueryString["_path"] != null) { _path = Request.QueryString["_path"]; } if (!IsPostBack) { binder(); } }
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(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(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) { if (!IsPostBack) { LoginCheck.AdminSq(); /* Process kbpr = System.Diagnostics.Process.Start("osk.exe"); // 打开系统键盘 * if (kbpr.HasExited) * { * kbpr = System.Diagnostics.Process.Start("osk.exe"); * }*/ } }