private void btnUpdate_Click(object sender, EventArgs e)
{
using (ASRS_ServiceSoapClient srv = new ASRS_ServiceSoapClient())
{
PW_User one = new PW_User();
var row = dGVPeopleInfo.SelectedRows[0];
List <PW_User> lst = dGVPeopleInfo.DataSource as List <PW_User>;
one.ID = row.Cells["ID"].Value.ToString();
PW_User findOne = lst.Find(delegate(PW_User user)
{
return(user.ID == one.ID);
});//用Find方法按工号找到此人的密码
if (findOne.USERNAME == "001")
{
MessageBox.Show("不允许修改001管理员账号!");
return;
}
one.PASSWORD = findOne.PASSWORD;
one.USERNAME = row.Cells[1].Value.ToString();
one.USERGROUP = row.Cells["UserGroup"].Value == null ? "" : row.Cells["UserGroup"].Value.ToString();
FormEditPeopleInfo f = new FormEditPeopleInfo(one);
f.ShowDialog();
}
FormEmpSetting_Load(null, e);
}
private static List <PW_User> DoQuery(string sql_str)
{
List <PW_User> rtn = new List <PW_User>();
DBHelper DBHelper_SqlServer = new DBLink();
try
{
using (IDataReader dr = DBHelper_SqlServer.ExecuteReader(sql_str))
{
while (dr.Read())
{
var p = new PW_User();
p.ID = DBHelper_SqlServer.GetDataValue <string>(dr, "ID");
p.USERNAME = DBHelper_SqlServer.GetDataValue <string>(dr, "USERNAME");
p.PASSWORD = DBHelper_SqlServer.GetDataValue <string>(dr, "PASSWORD");
p.USERGROUP = DBHelper_SqlServer.GetDataValue <string>(dr, "USERGROUP");
p.DEPARTMENT = DBHelper_SqlServer.GetDataValue <string>(dr, "DEPARTMENT");
p.UPDATETIME = DBHelper_SqlServer.GetDataValue <string>(dr, "UPDATETIME");
p.PASSWORDUPDATETIME = DBHelper_SqlServer.GetDataValue <string>(dr, "PASSWORDUPDATETIME");
p.PASSWORDEXPIRETIME = DBHelper_SqlServer.GetDataValue <string>(dr, "PASSWORDEXPIRETIME");
p.LASTLOGINTIME = DBHelper_SqlServer.GetDataValue <string>(dr, "LASTLOGINTIME");
p.ISLOGININ = DBHelper_SqlServer.GetDataValue <string>(dr, "ISLOGININ");
p.HANDSHAKE = DBHelper_SqlServer.GetDataValue <string>(dr, "HANDSHAKE");
p.PW_BACKUP1 = DBHelper_SqlServer.GetDataValue <string>(dr, "PW_BACKUP1");
p.PW_BACKUP2 = DBHelper_SqlServer.GetDataValue <string>(dr, "PW_BACKUP2");
p.PW_BACKUP3 = DBHelper_SqlServer.GetDataValue <string>(dr, "PW_BACKUP3");
rtn.Add(p);
}
}
}
catch
{
}
return(rtn);
}
/// <summary>
/// 密码校验
/// </summary>
/// <param name="EmpNo"></param>
/// <param name="password"></param>
/// <returns></returns>
private bool CheckLoginSuss(string EmpNo, string password)
{
user = new PW_User();
using (ASRS_Volvo.ServiceForVolvo.ASRS_ServiceSoapClient srv = new ASRS_ServiceSoapClient())
{
string cesarPassword = srv.CommonMethod_StringEncoding(password);
var _user = srv.PW_User_GetUserInfoByEmpno(EmpNo);
if (_user.PASSWORD == cesarPassword)
{
user = _user;
}
else
{
user = new PW_User();
return(false);
}
if (ckBForce.Checked)
{
_user.ISLOGININ = "N";
srv.PW_User_UpdateUserInfo(user);
wait(1000);
}
return(true);
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
List <PW_User> lst = new List <PW_User>();
try
{
lst = dGVPeopleInfo.DataSource as List <PW_User>;
}
catch (Exception ex)
{
return;
}
int index = -1;
try
{
index = dGVPeopleInfo.SelectedRows[0].Index;
}
catch
{
index = -1;
}
if (index > -1)
{
PW_User one = lst[index];
if (one.USERNAME == "001")
{
MessageBox.Show("不允许删除001管理员账号!");
return;
}
using (ASRS_ServiceSoapClient srv = new ASRS_ServiceSoapClient())
{
if (!srv.PW_User_DeleteUser(one.ID))
{
MessageBox.Show("删除失败!");
return;
}
}
lst.RemoveAt(index);
dGVPeopleInfo.DataSource = null;
dGVPeopleInfo.DataSource = lst;
if (index > 0)
{
index -= 1;
dGVPeopleInfo.Rows[index].Selected = true;
}
}
}
public FormEditPeopleInfo(PW_User newone)
{
InitializeComponent();
getGroupToControl();
one = newone;
tBUserId.Enabled = false;
tBUserId.Text = one.ID;
tBName.Enabled = false;
tBName.Text = one.USERNAME;
List <PW_GROUP> ds = cmB_Group.DataSource as List <PW_GROUP>;
try
{
cmB_Group.SelectedIndex = int.Parse(ds.Find(x => x.GROUPNAME == one.USERGROUP).ID);
}
catch (Exception)
{
cmB_Group.SelectedIndex = 0;
}
using (ASRS_Volvo.ServiceForVolvo.ASRS_ServiceSoapClient srv = new ASRS_ServiceSoapClient())
tBPassWord.Text = srv.CommonMethod_StringDecoding(one.PASSWORD);
}
public ActionResult InsertUser(PW_User pw_User)//新增用户
{
try
{
pw_User.Password = Common.AESEncryptHelper.Encrypt(pw_User.Password);
myModels.PW_User.Add(pw_User);
myModels.SaveChanges();
var UserID = pw_User.UserID;
for (int i = 1; i < 94; i++)
{
PW_Jurisdiction pw_Jurisdiction = new PW_Jurisdiction();
pw_Jurisdiction.UserID = UserID;
pw_Jurisdiction.ModularID = i;
if (pw_User.UserTypeID == 2)
{
pw_Jurisdiction.ToJdtion = true;
}
else
{
if (i == 84 || i == 85)
{
pw_Jurisdiction.ToJdtion = false;
}
else
{
pw_Jurisdiction.ToJdtion = true;
}
}
myModels.PW_Jurisdiction.Add(pw_Jurisdiction);
myModels.SaveChanges();
}
}
catch (Exception)
{
return(Json(false, JsonRequestBehavior.AllowGet));
}
return(Json(true, JsonRequestBehavior.AllowGet));
}
private void btnSave_Click(object sender, EventArgs e)
{
string peoplenName = tBName.Text.Trim();
string userid = tBUserId.Text.Trim();
string Password = tBPassWord.Text.Trim();
string GroupId = cmB_Group.SelectedValue.ToString();
if (tBPassWord.Text.Length < 8)
{
MessageBox.Show("密码长度小于8位!");
tBPassWord.SelectAll();
tBPassWord.Focus();
return;
}
if (tBUserId.Text.Trim() == string.Empty)
{
MessageBox.Show("工号不能为空!");
tBUserId.SelectAll();
tBUserId.Focus();
return;
}
PW_User wkrs = new PW_User();
using (ASRS_Volvo.ServiceForVolvo.ASRS_ServiceSoapClient srv = new ASRS_ServiceSoapClient())
{
srv.PW_User_GetOneByUserID(userid);
wkrs.PASSWORD = srv.CommonMethod_StringEncoding(Password);//解密
wkrs.ID = userid;
wkrs.USERNAME = peoplenName;
wkrs.USERGROUP = GroupId;
if (tBUserId.Enabled == false)
{
if (srv.PW_User_UpdateUserInfo(wkrs))
{
tBUserId.Clear();
tBPassWord.Clear();
tBName.Clear();
tBUserId.Focus();
Close();
}
else
{
MessageBox.Show("保存失败!");
tBUserId.Focus();
tBUserId.SelectAll();
return;
}
}
else if (tBUserId.Enabled == true)
{
if (srv.PW_User_InsertOne(wkrs))
{
tBUserId.Clear();
tBPassWord.Clear();
tBName.Clear();
tBUserId.Focus();
}
else
{
MessageBox.Show("保存失败!");
tBUserId.Focus();
tBUserId.SelectAll();
return;
}
}
}
}
/// <summary>
/// 插入一条数据
/// </summary>
/// <param name="t_new"></param>
/// <returns></returns>
public static bool InsertNew(PW_User t_new)
{
try
{
PW_User tt = t_new;
StringBuilder sb = new StringBuilder();
sb.Append(" Insert into PW_User ( ");
sb.Append("ID, ");
sb.Append("USERNAME, ");
sb.Append("PASSWORD, ");
sb.Append("USERGROUP, ");
sb.Append("DEPARTMENT, ");
sb.Append("UPDATETIME, ");
sb.Append("PASSWORDUPDATETIME, ");
sb.Append("PASSWORDEXPIRETIME, ");
sb.Append("LASTLOGINTIME, ");
sb.Append("ISLOGININ, ");
sb.Append("HANDSHAKE, ");
sb.Append("PW_BACKUP1, ");
sb.Append("PW_BACKUP2, ");
sb.Append("PW_BACKUP3 )");
sb.Append(" values ( ");
sb.Append("@ID,");
sb.Append("@USERNAME,");
sb.Append("@PASSWORD,");
sb.Append("@USERGROUP,");
sb.Append("@DEPARTMENT,");
sb.Append("@UPDATETIME,");
sb.Append("@PASSWORDUPDATETIME,");
sb.Append("@PASSWORDEXPIRETIME,");
sb.Append("@LASTLOGINTIME,");
sb.Append("@ISLOGININ,");
sb.Append("@HANDSHAKE,");
sb.Append("@PW_BACKUP1,");
sb.Append("@PW_BACKUP2,");
sb.Append(" @PW_BACKUP3 )");
DbCommand cmd = new SqlCommand();
cmd.CommandText = sb.ToString();
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add(new SqlParameter("@ID", DbType.String)
{
Value = tt.ID
});
cmd.Parameters.Add(new SqlParameter("@USERNAME", DbType.String)
{
Value = tt.USERNAME
});
cmd.Parameters.Add(new SqlParameter("@PASSWORD", DbType.String)
{
Value = tt.PASSWORD
});
cmd.Parameters.Add(new SqlParameter("@USERGROUP", DbType.String)
{
Value = tt.USERGROUP
});
cmd.Parameters.Add(new SqlParameter("@DEPARTMENT", DbType.String)
{
Value = tt.DEPARTMENT
});
cmd.Parameters.Add(new SqlParameter("@UPDATETIME", DbType.String)
{
Value = tt.UPDATETIME
});
cmd.Parameters.Add(new SqlParameter("@PASSWORDUPDATETIME", DbType.String)
{
Value = tt.PASSWORDUPDATETIME
});
cmd.Parameters.Add(new SqlParameter("@PASSWORDEXPIRETIME", DbType.String)
{
Value = tt.PASSWORDEXPIRETIME
});
cmd.Parameters.Add(new SqlParameter("@LASTLOGINTIME", DbType.String)
{
Value = tt.LASTLOGINTIME
});
cmd.Parameters.Add(new SqlParameter("@ISLOGININ", DbType.String)
{
Value = tt.ISLOGININ
});
cmd.Parameters.Add(new SqlParameter("@HANDSHAKE", DbType.String)
{
Value = tt.HANDSHAKE
});
cmd.Parameters.Add(new SqlParameter("@PW_BACKUP1", DbType.String)
{
Value = tt.PW_BACKUP1
});
cmd.Parameters.Add(new SqlParameter("@PW_BACKUP2", DbType.String)
{
Value = tt.PW_BACKUP2
});
cmd.Parameters.Add(new SqlParameter("@PW_BACKUP3", DbType.String)
{
Value = tt.PW_BACKUP3
});
foreach (SqlParameter p in cmd.Parameters)
{
p.IsNullable = true;
if (p.Value == null)
{
p.Value = DBNull.Value;
}
}
DBLink DBHelper_SqlServer = new DAL.DBLink();
int val = DBHelper_SqlServer.ExecuteNonQuery(cmd);
if (val > 0)
{
return(true);
}
else
{
return(false);
}
}
catch
{
return(false);
}
}
public bool PW_User_UpdateUserInfo(PW_User user)
{
return(SQL_Da_PW_User.UpdateOne(user));
}
public bool PW_User_InsertOne(PW_User t_new)
{
return(SQL_Da_PW_User.InsertNew(t_new));
}
