protected void btnDelAll_Click(object sender, EventArgs e)
{
string ggid = "";
int nums = 0;
foreach (GridViewRow Gvr in infoList.Rows)
{
CheckBox cb = (CheckBox)Gvr.Cells[0].Controls[1];
if (cb.Checked)
{
int k = Gvr.RowIndex;
ggid += "," + infoList.DataKeys[k].Value.ToString();
nums += 1;
}
}
if (ggid == "")
{
WebJS.Alert("请选择要删除的信息！");
}
else
{
ggid = ggid.Substring(1);
Class.DelInfo("delete from teacherinfo where teacher_id in (" + ggid + " )");
WebJS.Alert("删除完成");
dataBind();
}
}
private void geckoWebBrowser1_DocumentCompleted(object sender, Gecko.Events.GeckoDocumentCompletedEventArgs e)
{
String cUrl = geckoWebBrowser1.Url.AbsoluteUri;
if (!LOAD_LAST_FLAG)
{
if (cUrl.IndexOf("login") > 0)
{
WebJS js = new WebJS(geckoWebBrowser1.Document);
js.setFieldValue("user_id", INIConfig.ReadString("System", "UserID"));
js.setFieldValue("user_pass", INIConfig.ReadString("System", "UserPass"));
LOAD_LAST_FLAG = true;
}
}
if ((LOAD_LAST_FLAG) && (!LOAD_TOKEN_FLAG))
{
if (cUrl.IndexOf("index") > 0)
{
WebJS js = new WebJS(geckoWebBrowser1.Document);
string cUserCode = js.getFieldValue("usercode");
ApplicationEvent.setUserCode(cUserCode);
// ApplicationEvent.UserInfo.USER_CODE = cUserCode;
string cOrgID = js.getFieldValue("orgid");
//ApplicationEvent.UserInfo.ORG_ID = cOrgID;
string cToken = js.getFieldValue("token");
ApplicationEvent.Token = cToken;
LOAD_TOKEN_FLAG = true;
}
}
}
//protected void BindTree()
//{
// TreeNode node = new TreeNode(); //这里是创建一个根节点,就是dome中看到的Root
// node.Text = "新闻菜单权限";
// CreateChildTree(node, 0);
// TreeView1.Nodes.Add(node);
//}
//protected void CreateChildTree(TreeNode _parentNode, int _parentID)
//{
// string sql = "select CategoryID,CategoryName from Web_category where CategoryParent=" + _parentID + " order by CategoryRoot";
// DataBase data = new DataBase();
// using (SqlDataReader r = data.ExeSqlFillDr(sql))
// {
// while (r.Read())
// {
// TreeNode _node = new TreeNode(r["CategoryName"].ToString(), r["CategoryID"].ToString());
// string[] urights = ViewState["pvalue"].ToString().Split('|');
// foreach (string srig in urights)
// {
// if (srig.Trim() == _node.Value)
// _node.Checked = true;
// }
// CreateChildTree(_node, (int)r["CategoryID"]); //递归出子节点
// _parentNode.ChildNodes.Add(_node);
// }
// }
//}
//protected void chkNodes()
//{//先调用这个方法 把treeView1改成你的名字就可以了
// foreach (TreeNode tn in this.TreeView1.Nodes)
// {
// fff(tn);
// }
//}
//protected void fff(TreeNode tnp)
//{
// if (tnp.Checked)
// {
// //这里就是选中的节点tn
// rightstr_ls += tnp.Value + "|";
// }
// foreach (TreeNode tn in tnp.ChildNodes)
// {
// fff(tn);
// }
//}
protected void Button1_Click(object sender, EventArgs e)
{
//chkNodes();
//string rightstr = rightstr_ls;//"-1|";
//foreach (ListItem item in userRight.Items)
//{
// if (item.Selected == true)
// {
// rightstr += item.Value + "|"; //权限值
// }
//}
Class cls = new Class();
DataBase data = new DataBase();
SqlDataReader dr = null;
if (password.Text.Trim() != "")
{
dr = data.ExeSqlFillDr("select * from userinfo where user_password='******' and user_id=" + ViewState["id"].ToString());
if (dr.Read())
{
if (password1.Text.Trim() == "" && password2.Text.Trim() == "")
{
Class.DelInfo("update userinfo set Username='******',refresh_time='" + DateTime.Now.ToString() + "' where user_id=" + ViewState["id"].ToString());
}
else if (password1.Text.Trim() == password2.Text.Trim())
{
Class.DelInfo("update userinfo set Username='******', refresh_time='" + DateTime.Now.ToString() + "',user_password='******' where user_id=" + ViewState["id"].ToString());
}
else
{
WebJS.Alert("两次输入的密码不一样！");
return;
}
}
else
{
WebJS.Alert("旧密码不正确！");
return;
}
}
else
{
dr = data.ExeSqlFillDr("select * from userinfo where user_id=" + ViewState["id"].ToString());
if (dr.Read())
{
Class.DelInfo("update userinfo set Username='******',refresh_time='" + DateTime.Now.ToString() + "' where user_id=" + ViewState["id"].ToString());
}
}
WebJS.AlertAndRedirect("修改完成！", "admin.aspx");
}
public void InitBrowser()
{
CefSharpSettings.LegacyJavascriptBindingEnabled = true;
CefSettings cfg = new CefSettings();
Cef.Initialize(cfg);
browser = new ChromiumWebBrowser();
js = new WebJS(browser);
//交互数据
browser.RegisterJsObject("WinForm", js, new CefSharp.BindingOptions()
{
CamelCaseJavascriptNames = false
});
this.Controls.Add(browser);
browser.Dock = DockStyle.Fill;
iskin.SkinFile = "skins/PageColor2.ssk";
}
protected void Page_Load(object sender, EventArgs e)
{
Chkadmin.checkadmin("login.aspx");
action = Request.QueryString["action"].ToString();
id = Request.QueryString["id"].ToString();
ViewState["id"] = id;
if (!IsPostBack)
{
//ddltype.Attributes.Add("onchange", "selectChange(this,'" + this.ddltype.ClientID + "')");
Class cls = new Class();
DataBase data = new DataBase();
SqlDataReader dr = null;
dr = data.ExeSqlFillDr("select * from userinfo where user_id=" + id);
if (dr.Read())
{
username.Text = dr["Username"].ToString();
//realName.Text = dr["realName"].ToString();
//ddltype.SelectedIndex = ddltype.Items.IndexOf(ddltype.Items.FindByValue(dr["RightGroup"].ToString()));
//string[] urights = dr["PermissionValue"].ToString().Split('|');
//if (dr["RightGroup"].ToString() == "2")
//{
// trguanli.Visible = true;
// foreach (ListItem item in userRight.Items)
// {
// //if (dr["userRight"].ToString().Contains(item.Value))
// foreach (string srig in urights)
// {
// if (srig.Trim() == item.Value)
// item.Selected = true;
// }
// }
//}
//ViewState["pvalue"] = dr["PermissionValue"].ToString();
}
dr.Close();
dr.Dispose();
//BindTree();
switch (action)
{
case "dele":
Class.DelInfo("delete from userinfo where user_id=" + id);
WebJS.AlertAndRedirect("删除完成", "admin.aspx");
break;
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string sql = "update patentinfo set time='" + TextTime.Text + "',teacher_number='" + DdlTeacher_Number.SelectedValue + "',patent_name='" + TextPatent_Name.Text + "',patent_number='" + TextPatent_Number.Text + "',refresh_time='" + DateTime.Now.ToString() + "' where id=" + ViewState["id"].ToString();
DataBase data = new DataBase();
try
{
data.Exesql(sql);
WebJS.AlertAndRefresh("编辑成功！");
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}
finally
{
data.Dispose();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string sql = "update teacherinfo set name='" + TextName.Text + "',sex='" + DDLSex.SelectedValue + "',age=" + TextAge.Text + ",teacher_profile='" + TextTeacher_Profile.Text + "',refresh_time='" + DateTime.Now.ToString() + "' where teacher_id=" + ViewState["id"].ToString();
DataBase data = new DataBase();
try
{
data.Exesql(sql);
WebJS.AlertAndRefresh("编辑成功！");
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}
finally
{
data.Dispose();
}
}
protected void btnOk_Click(object sender, EventArgs e)
{
string sql1 = "select * from web_admin where username='******' and UserPassword='******'";
DataBase data = new DataBase();
using (SqlDataReader dr1 = data.ExeSqlFillDr(sql1))
{
if (dr1.Read())
{
string sql = "update web_admin set UserPassword='******' where username='******'";
data.Exesql(sql);
WebJS.AlertAndRefresh("修改密码成功，请牢记！");
}
else
{
WebJS.AlertAndRefresh("旧密码不正确！");
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string sql = "update awardinfo set time='" + TextTime.Text + "',award_number='" + TextAward_number.Text + "',award_level='" + TextLevel.Text + "',teacher_number='" + DdlTeacher_Number.SelectedValue + "',type='" + TextType.Text + "',presenter='" + TextPresenter.Text + "',organization='" + TextOrganization.Text + "',prizewinner='" + TextPrizewinner.Text + "',form='" + TextForm.Text + "',refresh_time='" + "' where id=" + ViewState["id"].ToString();
DataBase data = new DataBase();
try
{
data.Exesql(sql);
WebJS.AlertAndRefresh("编辑成功！");
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}
finally
{
data.Dispose();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string sql = "insert into patentinfo (patent_number,teacher_number,patent_name,type,time,log_time,refresh_time) values('" + TextPatent_Number.Text /*DdlTeacher_Number.SelectedItem.Text*/ + "','" + DdlTeacher_Number.SelectedValue + "','" + TextPatent_Name.Text
+ "','" + TextType.Text + "','" + TextTime.Text + "','" + DateTime.Now.ToString() + "','" + DateTime.Now.ToString() + "')";
DataBase data = new DataBase();
try
{
data.Exesql(sql);
WebJS.AlertAndRefresh("添加完成，继续添加！");
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}
finally
{
data.Dispose();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string sql = "insert into paperinfo (paper_number,teacher_number,title,publication_name,publish_time,form,paper_level,log_time,refresh_time) values('" + TextPaper_Number.Text + "','" + DdlTeacher_Number.SelectedValue + "', '" +
TextTitle.Text + "','" + TextPublication_Name.Text + "','" + TextTime.Text + "','" + TextForm.Text + "','" + TextLevel.Text + "','" + DateTime.Now.ToString() + "','" + DateTime.Now.ToString() + "')";
DataBase data = new DataBase();
try
{
data.Exesql(sql);
WebJS.AlertAndRefresh("添加完成，继续添加！");
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}
finally
{
data.Dispose();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string sql = "insert into awardinfo (award_number,teacher_number,organization,presenter,prizewinner,time,type,award_level,form,log_time,refresh_time) values('" + TextAward_number.Text + "','" + DdlTeacher_Number.SelectedValue + "','" +
TextOrganization.Text + "','" + TextPresenter.Text + "','" + TextPrizewinner.Text + "','" + TextTime.Text + "','" + TextType.Text + "','" + TextLevel.Text + "','" + TextForm.Text + "','" + DateTime.Now.ToString() + "','" + DateTime.Now.ToString() + "')";
DataBase data = new DataBase();
try
{
data.Exesql(sql);
WebJS.AlertAndRefresh("添加完成，继续添加！");
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}
finally
{
data.Dispose();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string sql = "insert into projectinfo (project_number,teacher_number,project_name,id,time,organization,director,funds,log_time,refresh_time)values('" + TextProject_Number.Text + "','" + DdlTeacher_Number.SelectedValue + "','" +
TextProject_Name.Text + "','" + TextId.Text + "','" + TextTime.Text + "','" + TextOrganization.Text + "','" + TextDirector.Text + "','" + TextFunds.Text + "','" + DateTime.Now.ToString() + "','" + DateTime.Now.ToString() + "')";
DataBase data = new DataBase();
try
{
data.Exesql(sql);
WebJS.AlertAndRefresh("添加完成，继续添加！");
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}
finally
{
data.Dispose();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string sql = "insert into teacherinfo (name,sex,age,teacher_profile,log_time,refresh_time) values('" + TextName.Text + "','" + DDLSex.SelectedValue + "', '" +
TextAge.Text + "','" + TextTeacher_Profile.Text + "','" + DateTime.Now.ToString() + "','" + DateTime.Now.ToString() + "')";
DataBase data = new DataBase();
try
{
data.Exesql(sql);
WebJS.AlertAndRefresh("添加完成，继续添加！");
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}
finally
{
data.Dispose();
}
}
//protected void BindTree()
//{
// TreeNode node = new TreeNode(); //这里是创建一个根节点,就是dome中看到的Root
// node.Text = "新闻菜单权限";
// CreateChildTree(node, 0);
// TreeView1.Nodes.Add(node);
//}
//protected void CreateChildTree(TreeNode _parentNode, int _parentID)
//{
// string sql = "select CategoryID,CategoryName from Web_category where CategoryParent=" + _parentID + " order by CategoryRoot";
// DataBase data = new DataBase();
// using (SqlDataReader r = data.ExeSqlFillDr(sql))
// {
// while (r.Read())
// {
// TreeNode _node = new TreeNode(r["CategoryName"].ToString(), r["CategoryID"].ToString());
// CreateChildTree(_node, (int)r["CategoryID"]); //递归出子节点
// _parentNode.ChildNodes.Add(_node);
// }
// }
//}
//protected void chkNodes()
//{//先调用这个方法 把treeView1改成你的名字就可以了
// foreach (TreeNode tn in this.TreeView1.Nodes)
// {
// fff(tn);
// }
//}
//protected void fff(TreeNode tnp)
//{
// if (tnp.Checked)
// {
// //这里就是选中的节点tn
// rightstr_ls += tnp.Value + "|";
// }
// foreach (TreeNode tn in tnp.ChildNodes)
// {
// fff(tn);
// }
//}
protected void Button1_Click(object sender, EventArgs e)
{
//chkNodes();
if (password.Text != rpassword.Text)
{
WebJS.Alert("两次输入的密码不一样！");
}
if (username.Text.Trim() == "")
{
WebJS.Alert("用户名不能为空！");
}
else
{
//Class cls = new Class();
string rightstr = rightstr_ls;//"-1|";
//权限分配 隐藏
//foreach (ListItem item in userRight.Items)
//{
// if (item.Selected == true)
// {
// rightstr += item.Value + "|"; //权限值
// }
//}
string sql = "insert into userinfo (Username,user_password,log_time,refresh_time) values('" + username.Text + "','" + password.Text + "','" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "','" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "')";
DataBase data = new DataBase();
try
{
data.Exesql(sql);
WebJS.AlertAndRedirect("添加完成！", "admin.aspx");
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}
finally
{
data.Dispose();
}
//cls.GonggaoAction("insert into zs_admin(username,userpassword) values('" + username.Text + "','" + admin.GetHash(password.Text) + "')", Session["ZS_AdminUserID"].ToString());
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string ggid = "";
foreach (GridViewRow Gvr in Gridadmin.Rows)
{
CheckBox cb = (CheckBox)Gvr.Cells[0].Controls[1];
if (cb.Checked)
{
int k = Gvr.RowIndex;
ggid += "," + Gridadmin.DataKeys[k].Value.ToString();
}
}
if (ggid == "")
{
WebJS.Alert("请选择要删除的信息！");
}
else
{
ggid = ggid.Substring(1);
Class.DelInfo("delete from userinfo where user_id in (" + ggid + " )");
WebJS.AlertAndRedirect("删除完成", "admin.aspx");
}
}
protected void btnLogin_Click(object sender, EventArgs e)
{
if (CheckCode.Text == Session["x2_validate_code"].ToString())
{
string UserIp;
if (Request.ServerVariables["HTTP_VIA"] != null)
{
UserIp = Request.ServerVariables["HTTP_X_FORWARDED_FOR"].ToString();
}
else
{
UserIp = Request.ServerVariables["REMOTE_ADDR"].ToString();
}
if (IsSafeRequst(this.username.Text, "'"))
{
WebJS.AlertAndRefresh("用户名或密码不正确！");
return;
}
Class cls = new Class();
if (cls.Login(this.username.Text, password.Text, UserIp)) //Chkadmin.GetHash(password.Text)
{
//cls.Log("管理员ID：" + Session["RC_AdminUserID"].ToString() + "-登录", UserIp);
Response.Redirect("index.aspx");
}
else
{
WebJS.AlertAndRefresh("用户名或密码不正确！");
}
}
else
{
WebJS.Alert("验证码不正确！");
}
}
