protected void Page_Load(object sender, EventArgs e) { sqlTable st = new sqlTable(); string[] value = new string[5]; string[] list = { "power", "username", "password", "name", "team" }; st.select_login("root", value, "Login", list); try { if (HttpContext.Current.Session["username"].ToString() != "root" || HttpContext.Current.Session["userpwd"].ToString() != value[2]) { Response.Write(" <script> alert( '您无权访问此页面');window.location.href= 'Default.aspx ' </script> "); } } catch (Exception) { Response.Write(" <script> alert( '您无权访问此页面');window.location.href= '../Default.aspx' </script> "); } string name = null; try { name = HttpContext.Current.Session["name"].ToString(); } catch (Exception) { Response.Write(" <script> alert( '登录超时,请重新登录');window.location.href= '../Default.aspx' </script> "); } Response.Write(" <script>window.onload=function(){ var name=document.getElementById('name'); name.innerHTML='欢迎你," + name + "'} </script> "); }
//借调结束 protected void OnJob_Click(object sender, EventArgs e) { string username = HttpContext.Current.Session["username"].ToString(); //查找借调状态 string[] onJob = new string[1]; string[] seList = { "transfer" }; sqlTable st = new sqlTable(); st.select_login(username, onJob, "Login", seList); if (onJob[0] == "0") { Response.Write("<script>alert('您未被调至其他部门')</script>"); } else if (onJob[0] == "1") { string[] soList = { "0" }; string[] usese = { "username", "password" }; string[] useso = { HttpContext.Current.Session["username"].ToString(), HttpContext.Current.Session["userpwd"].ToString() }; int res2 = st.table_update("Login", seList, soList, usese, useso); //删除本月借调 string tableName = "Jiediao"; string[] delist = { "year", "month", "username" }; string[] deValue = { DateTime.Now.Year.ToString(), DateTime.Now.Month.ToString(), HttpContext.Current.Session["username"].ToString() }; int res3 = st.table_delete(tableName, delist, deValue); } Response.Write("<script>alert('借调结束');;window.location.href= 'work.aspx ' </script>"); }
protected void submit_Click(object sender, EventArgs e) { string NewUserName = add_username.Text; //用户名 string NewUserPass = add_userpass.Text; //密码 string newPass = add_newPass.Text; //新密码 string confirm = add_confirm.Text; //确认新密码 sqlTable st = new sqlTable(); string[] value = new string[5]; string[] list = { "power", "username", "password", "name", "team" }; st.select_login(NewUserName, value, "Login", list); //查找用户,修改密码 if (value[1] != "root") { if (NewUserName == value[1]) { if (NewUserPass == value[2]) { if (newPass == confirm) { string[] newPwdList = { "password" }; string[] newPwdSource = { newPass }; string[] userNameList = { "username" }; string[] userNameSource = { NewUserName }; int res = st.table_update("Login", newPwdList, newPwdSource, userNameList, userNameSource); Response.Write(" <script> alert( '修改成功! ');window.location.href= 'Default.aspx' </script> "); } else { Response.Write(@"<script>alert('新密码两次输入不一致,请重新输入!');</script>"); } } else { Response.Write(@"<script>alert('原密码输入有误,请重新输入!');</script>"); } } else { Response.Write(@"<script>alert('用户名输入有误,请重新输入!');</script>"); } } else { Response.Write(@"<script>alert('ROOT用户名不可更改密码!');</script>"); } }
protected void submit_Click(object sender, EventArgs e) { string username = off_username.Text.Trim(); //用户名 string jobStatus = Request.Form["jobstatus"].ToString().Trim(); //工作状态 //查找是否有此用户 string[] pwd = new string[1]; string[] list01 = { "password" }; sqlTable st = new sqlTable(); st.select_login(username, pwd, "Login", list01); //更新状态 string[] list = { "on_job" }; string[] source = { jobStatus }; string[] selectList = { "username" }; string[] selectSource = { username }; if (pwd[0] == "NULL" || pwd[0] == "null") { Response.Write("<script>alert('输入用户名有误,请重新输入')</script>"); } else { int res = st.table_update("Login", list, source, selectList, selectSource); if (res == 1) { Response.Write("<script>alert('修改成功')</script>"); } else { Response.Write("<script>alert('语法错误')</script>"); } } }
//登录 protected void login_Click(object sender, EventArgs e) { sqlTable st = new sqlTable(); string[] value = new string[7]; string[] list = { "power", "username", "password", "name", "team", "transfer", "on_job" }; string username = UserName.Text.Trim(); string password = Password.Text.Trim(); if (username == "") { Response.Write(@"<script>alert('用户名不能为空!');</script>"); } else if (password == "") { Response.Write(@"<script>alert('密码不能为空!');</script>"); } else { st.select_login(username, value, "Login", list); // root 跳转 if (int.Parse(value[6]) == 1) { if (username == value[1]) { if (password == value[2]) { if (int.Parse(value[0]) == 0) { //session存储用户信息 HttpContext.Current.Session["power"] = value[0]; //权限 HttpContext.Current.Session["username"] = value[1]; //获取用户名 HttpContext.Current.Session["userpwd"] = value[2]; //获取密码 HttpContext.Current.Session["name"] = value[3]; //获取用户名字 HttpContext.Current.Session["team"] = value[4]; //获取用户小组 HttpContext.Current.Session["transfer"] = value[5]; //获取用户借调状态 Response.Redirect("Root.aspx"); } else if (int.Parse(value[0]) == 1) { //session存储用户信息 HttpContext.Current.Session["power"] = value[0]; //权限 HttpContext.Current.Session["username"] = value[1]; //获取用户名 HttpContext.Current.Session["userpwd"] = value[2]; //获取密码 HttpContext.Current.Session["name"] = value[3]; //获取用户名字 HttpContext.Current.Session["team"] = value[4]; //获取用户小组 HttpContext.Current.Session["transfer"] = value[5]; //获取用户借调状态 Response.Redirect("root/work.aspx"); } else { //session存储用户信息 HttpContext.Current.Session["power"] = value[0]; //权限 HttpContext.Current.Session["username"] = value[1]; //获取用户名 HttpContext.Current.Session["userpwd"] = value[2]; //获取密码 HttpContext.Current.Session["name"] = value[3]; //获取用户名字 HttpContext.Current.Session["team"] = value[4]; //获取用户小组 HttpContext.Current.Session["transfer"] = value[5]; //获取用户借调状态 if (value[5] == "1") { Response.Redirect("workbra.aspx"); } else { Response.Redirect("work.aspx"); } } } else { Response.Write(@"<script>alert('密码输入有误!');</script>"); } } else { Response.Write(@"<script>alert('用户名输入有误!');</script>"); } } else { Response.Write(@"<script>alert('您已离职,无登录权限!');</script>"); } } }
//查询 protected void Select_Click(object sender, EventArgs e) { string NewUserName = Username.Text.ToString().Trim();//用户名 string[] value = new string[8]; string[] list01 = { "power", "username", "password", "name", "team", "transfer", "peoplenumber", "on_job" }; sqlTable st = new sqlTable(); st.select_login(NewUserName, value, "Login", list01); if (value[0] == "18") { Post.Value = "18"; } else if (value[0] == "1") { Post.Value = "1"; } else if (value[0] == "2" || value[0] == "3" || value[0] == "4" || value[0] == "5" || value[0] == "6") { switch (value[0]) { case "2": Post.Value = "2"; fzr.Value = "2"; break; case "3": Post.Value = "2"; fzr.Value = "3"; break; case "4": Post.Value = "2"; fzr.Value = "4"; break; case "5": Post.Value = "2"; fzr.Value = "5"; break; default: Post.Value = "2"; fzr.Value = "6"; break; } } Username.Text = value[1]; Pwd.Text = value[2]; PeopleName.Text = value[3]; group2.Value = value[4]; if (value[5] == "1") { JieDiao.Text = "已借调"; } else { JieDiao.Text = "未借调"; } StaffNumber.Text = value[6]; if (value[7] == "1") { OnJob.Text = "在职"; } else { OnJob.Text = "已离职"; } }
//借调 protected void add_Click(object sender, EventArgs e) { int res = 5; int res2 = 5; string branch = "借调至"; branch += add_index.Text.Trim();//借调部门 string username = HttpContext.Current.Session["username"].ToString(); //查找借调状态 string[] onJob = new string[1]; string[] seList = { "transfer" }; sqlTable st = new sqlTable(); st.select_login(username, onJob, "Login", seList); if (onJob[0] == "1") { Response.Write("<script>alert('您已被借调至其他部门')</script>"); } else if (onJob[0] == "0") { string[] bra = new string[1]; string[] list = { "year", "month", "username" }; string[] source = { DateTime.Now.Year.ToString(), DateTime.Now.Month.ToString(), username }; st.select_easy(list, source, bra, "Jiediao", seList); if (bra[0] == "null" || bra[0] == null || bra[0] == "NULL") { string[] list02 = { "year", "month", "username", "team", "transfer", "ratio" }; string t = HttpContext.Current.Session["team"].ToString(); string[] source02 = { DateTime.Now.Year.ToString(), DateTime.Now.Month.ToString(), username, t, branch, "无" }; res = st.table_insert("Jiediao", list02, source02); string[] soList = { "1" }; string[] usese = { "username", "password" }; string[] useso = { HttpContext.Current.Session["username"].ToString(), HttpContext.Current.Session["userpwd"].ToString() }; res2 = st.table_update("Login", seList, soList, usese, useso); #region 提示 if (res == 1 && res2 == 1) { Response.Write("<script>alert('借调成功')</script>"); } else if (res == 0 || res2 == 0) { Response.Write("<script>alert('数组长度不一致,请联系管理员')</script>"); } else if (res == 2 || res2 == 2) { Response.Write("<script>alert('程序异常,请联系管理员')</script>"); } #endregion } else { string[] sour = { branch }; res = st.table_update("Jiediao", seList, sour, list, source); string[] soList = { "1" }; string[] usese = { "username", "password" }; string[] useso = { HttpContext.Current.Session["username"].ToString(), HttpContext.Current.Session["userpwd"].ToString() }; res2 = st.table_update("Login", seList, soList, usese, useso); #region 提示 if (res == 1 && res2 == 1) { Response.Write("<script>alert('借调成功') </script>"); } else if (res == 0 || res2 == 0) { Response.Write("<script>alert('数组长度不一致,请联系管理员')</script>"); } else if (res == 2 || res2 == 2) { Response.Write("<script>alert('程序异常,请联系管理员')</script>"); } #endregion } } else { Response.Write("<script>alert('借调状态错误,请联系管理员')</script>"); } if (res == 1 && res2 == 1) { Response.Write("<script>parent.document.location.href = '../workbra.aspx' </script>"); } }