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");
* }*/
}
}
