/* * 功能:登陆 */ 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("提交成功!"); }