/*
* 功能：登陆
*/
private void Login(object sender, RoutedEventArgs e)
{
if (RememberPassword.IsChecked == true)
{
SaveConfig();
}
else
{
ClearSaveConfig();
}
if (Temp.SqlConn() == 1 && TempInt == 1)
{
MessageBox.Show("服务器连接失败！");
return;
}
TempInt++;//使开启数据库连接只一次
user = (userIdentity)Identity.SelectedIndex;
try
{
string StrSql_1 = "select * from ArmsUsers where Usersname='" + Account.Text + "'and Userspwd='" + md5.MD5Encoding(PasswordBox.Password.ToString()) + "'";
SqlCommand CMD_1 = new SqlCommand(StrSql_1, Temp.GetConn());
SqlDataReader Sdr_1 = CMD_1.ExecuteReader();
if (Sdr_1.Read())
{
string TempStr = Sdr_1[2].ToString();
Sdr_1.Close();
if ((TempStr == "普通用户" && user != userIdentity.Ordinary_users) ||
(TempStr == "系统管理员" && user != userIdentity.System_administrator) ||
(TempStr == "仓库管理员" && user != userIdentity.Warehouse_manager) ||
(TempStr == "维修管理员" && user != userIdentity.Maintenance_man) ||
(TempStr == "财务部管理员" && user != userIdentity.Finance_department) ||
(TempStr == "保密员" && user != userIdentity.Confidential_clerk)) //权限判断，属于普通用户不能选择了其他用户组
{
MessageBox.Show("当前用户权限不足，请核对权限选择下拉框！");
return;
}
CurrentUser = Account.Text;//满足一切登陆条件后，保存当前账号名，以备各模块使用
EimsWindow win1 = new EimsWindow();
win1.Show();
this.Close();
}
else
{
Sdr_1.Close();
MessageBox.Show("登陆失败，账号或密码错误！");
}
}
catch
{
MessageBox.Show("服务器异常,登陆失败！");
return;
}
}
public static userIdentity getDummyCurrentUser()
{
using (var db = new edShortenerModel())
{
var queryResult = from User in db.Users
where User.userName == "dummyDefault"
select User;
userIdentity ui = new userIdentity();
if (queryResult.Count() == 1)
{
var userResult = queryResult.FirstOrDefault();
ui.guid = userResult.idUser;
ui.UserName = userResult.userName;
return(ui);
}
return(null);
}
}
public static Guid getGuidByName(string name)
{
using (var db = new edShortenerModel())
{
var queryResult = from User in db.Users
where User.userName == name
select User;
userIdentity ui = new userIdentity();
if (queryResult.Count() == 1)
{
var userResult = queryResult.FirstOrDefault();
ui.guid = userResult.idUser;
ui.UserName = userResult.userName;
return(ui.guid);
}
return(new Guid());
}
}
private void Users_submit_Click(object sender, RoutedEventArgs e)
{
try
{
if (!Status())
{
throw (new Exception());
}
}
catch (Exception s)
{
MessageBox.Show("提交页面信息错误！");
return;
}
user = (userIdentity)addgroup_registerText_cb.SelectedIndex;
string userstring = user.ToString();
string sexstring = addgroup_registerText_sex.SelectionBoxItem.ToString();
string username = register_account.Text;
string SearchSQL = "select * from ArmsUsers where Usersname='" + username + "'";
try
{
SqlCommand searchcmd = new SqlCommand(SearchSQL, Temp.GetConn());
SqlDataReader sread = searchcmd.ExecuteReader();
if (sread.Read())
{
throw new Exception();
}
sread.Close();
}
catch (Exception a)
{
MessageBox.Show("账号已注册！" + a);
return;
}
string RyIdExist = "select * from ArmsPerson where RyId='" + addgroup_registerText_rennum.Text + "'";
string DepartMent = "select * from Departments where DepId ='" + addgroup_registerText_departnum.Text + "'";
string RyIdInsert = "insert into ArmsPerson(RyId,RyName,Sex,Dep_Id,Marital_Condition) values('" + addgroup_registerText_rennum.Text + "','" + register_AffiliationPeople.Text + "','" + sexstring
+ "','" + addgroup_registerText_departnum.Text + "','0')";
try
{
if (addgroup_registerText_departnum.Text != "")
{
SqlCommand DepId = new SqlCommand(DepartMent, Temp.GetConn());
if (DepId.ExecuteScalar() == null)
{
MessageBox.Show("无此部门!");
return;
}
}
SqlCommand RyId = new SqlCommand(RyIdExist, Temp.GetConn());
if (RyId.ExecuteScalar() == null)
{
SqlCommand RyInsert = new SqlCommand(RyIdInsert, Temp.GetConn());
RyInsert.ExecuteNonQuery();
}
}
catch (Exception a)
{
MessageBox.Show("提交失败！" + a);
return;
}
//注意账号所属人姓名，编号，性别，部门编号需要与ArmsPerson一致
string StrSQL = "insert into ArmsUsers values('" + username + "','" + md5.MD5Encoding(register_pwd.Text) + "','" + userstring + "','" + addgroup_registerText_rennum.Text + "')";
try
{
SqlCommand cmd = new SqlCommand(StrSQL, Temp.GetConn());
cmd.ExecuteNonQuery();
}
catch (Exception se)
{
MessageBox.Show("提交失败！" + se);
return;
}
MessageBox.Show("提交成功！");
}
