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