public Smmuser GetOneByKey( Smmuser data) { Smmuser user= SqlMapHelper.DefaultSqlMap.QueryForObject<Smmuser>(string.Format("Select{0}ByKey", t.Name), data); if (user != null) user.Password = MainDataModule.Decrypt(user.Password); return user; }
private void btnLogin_Click(object sender, EventArgs e) { if (utxtuser.tbox.Text == string.Empty) { MsgBox.Show("工号没有输入"); utxtuser.Focus(); return; } Smmuser user = new Smmuser(); user.Userid = utxtuser.tbox.Text.Trim().ToLower(); user.Password = utxtpwd.tbox.Text.Trim(); IList<Smmuser> ulist; try { ulist = UserService.GetStrongList(); } catch (Exception) { MessageBox.Show("无法连接到服务器! 请点击配置确保服务器参数正确并确认服务器已启动"); return; } bool result = false; foreach (Smmuser us in ulist) { if (us.Userid==user.Userid&&us.Password==user.Password) { result = true; } } if (result) { if (user.Userid!="admin") { MsgBox.Show("非管理员不能使用此项功能!"); return; } else { this.DialogResult = DialogResult.OK; } } else { MsgBox.Show("用户名或密码错误!"); } }
/// <summary> /// ����û��Ƿ�Ϸ� /// </summary> /// <param name="smmuser">�û�</param> /// <param name="strErr">������Ϣ</param> /// <param name="isnew">�Ƿ��¼�¼</param> /// <returns>True�Ϸ�</returns> public static bool Check(Smmuser smmuser,ref string strErr,bool isnew) { if (string.IsNullOrEmpty(smmuser.Userid)) { strErr = "�û��Ų���Ϊ�գ�"; return false; } if (string.IsNullOrEmpty(smmuser.UserName)) { strErr = "�û�������Ϊ�գ�"; return false; } //����������¼,����û����Ƿ���� if (isnew) { IBaseService service = RemotingHelper.GetRemotingService<IBaseService>(); Smmuser user1 = service.GetOneByKey<Smmuser>(smmuser.Userid); if (user1 != null) { strErr = "�Ѿ������û���Ϊ[" + smmuser.Userid + "]���û�."; return false; } } return true; }
private void FrmPersonEdit_Load(object sender, EventArgs e) { if (_smmuser == null) { _smmuser = new Smmuser(); isNew = true; } else { tbUserid.Enabled = false; } tbUserid.DataBindings.Add("Text", DataObject, "Userid"); tbUserName.DataBindings.Add("Text", DataObject, "UserName"); tbPassword.DataBindings.Add("Text", DataObject, "Password"); tbExpireDate.DataBindings.Add("Text", DataObject, "ExpireDate"); //tbDisableflg.DataBindings.Add("Text", DataObject, "Disableflg"); tbLastlogon.DataBindings.Add("Text", DataObject, "Lastlogon"); tbRemark.DataBindings.Add("Text", DataObject, "Remark"); if (DataObject.Disableflg == "Y") { tbDisableflg.Checked = true; } }
//显示系统所有用户 private void CreateView() { treeView1.Nodes.Clear(); TreeNode node = treeView1.Nodes.Add("system", "系统用户和组", rootimage, rootimage); node.Tag = "根"; IList<Smmgroup> list = Services.BaseService.GetStrongList<Smmgroup>(); for (int i = 0; i < list.Count; i++) { IList<Smugroup> listUser = Services.BaseService.GetList<Smugroup>("SelectSmugroupByWhere", "Groupno='" + list[i].Groupno + "'"); if ( listUser.Count>0) { TreeNode tempnode = node.Nodes.Add(list[i].Groupno, list[i].Groupname, groupimage, groupimage); tempnode.Tag = "组"; for (int j = 0; j < listUser.Count; j++) { Smmuser user = new Smmuser(); user.Userid = listUser[j].Userid; Smmuser tempuser = Services.BaseService.GetOneByKey<Smmuser>(user); //tempuser.Lastlogon 存放用户图标id if (tempuser != null) { int useimage = 0; if (int.TryParse(tempuser.Lastlogon, out useimage)) { useimage = int.Parse(tempuser.Lastlogon.ToString()); } TreeNode tempnodeuser = tempnode.Nodes.Add(listUser[j].Userid, tempuser.UserName, useimage, useimage); tempnodeuser.Tag = "用户"; } } } } // 将未分组用户添加进一个组 IList<Smmuser> list_user = Services.BaseService.GetStrongList<Smmuser>(); TreeNode un_groupnode = new TreeNode(); un_groupnode.Name = "未分组"; un_groupnode.Text = "未分组用户"; un_groupnode.ImageIndex = un_group; un_groupnode.SelectedImageIndex = un_group; un_groupnode.Tag = "未分组"; bool un_groupuser = false; for (int k = 0; k < list_user.Count; k++) { string tempuserno = list_user[k].Userid; IList<Smugroup> listUsergroup = Services.BaseService.GetList<Smugroup>("SelectSmugroupByWhere", "Userid='" + tempuserno + "'"); if (listUsergroup.Count == 0) { un_groupuser = true; int useimage = 0; if (int.TryParse(list_user[k].Lastlogon, out useimage)) { useimage = int.Parse(list_user[k].Lastlogon.ToString()); } TreeNode tempnodeuser = un_groupnode.Nodes.Add(list_user[k].Userid, list_user[k].UserName, useimage, useimage); tempnodeuser.Tag = "用户"; } } if (un_groupuser) { node.Nodes.Add(un_groupnode); } node.Expand(); node.ExpandAll(); }
private void FrmSmmuserEdit_new_Load(object sender, EventArgs e) { listView1.View = System.Windows.Forms.View.List; if (_smmuser == null) { _smmuser = new Smmuser(); isNew = true; } else { tbUserid.Enabled = false; } for (int i = 0; i < imageList2.Images.Count; i++) { //imageComboBoxEdit1 ImageComboBoxItem tempItem = new ImageComboBoxItem(); //tempItem.Description = i.ToString(); tempItem.ImageIndex = i; tempItem.Value = i; imageComboBoxEdit1.Properties.Items.Add(tempItem); } tbUserid.DataBindings.Add("Text", DataObject, "Userid"); tbUserName.DataBindings.Add("Text", DataObject, "UserName"); tbPassword.DataBindings.Add("Text", DataObject, "Password"); tbExpireDate.DataBindings.Add("Text", DataObject, "ExpireDate"); //tbDisableflg.DataBindings.Add("Text", DataObject, "Disableflg"); //tbLastlogon.DataBindings.Add("Text", DataObject, "Lastlogon"); tbRemark.DataBindings.Add("Text", DataObject, "Remark"); int tempint = 0; if (int.TryParse(DataObject.Lastlogon,out tempint)) { imageComboBoxEdit1.SelectedIndex = tempint; } else { imageComboBoxEdit1.SelectedIndex = tempint; } if (DataObject.Disableflg == "Y") { tbDisableflg.Checked = true; } smuGroupTable = DataConverter.ToDataTable(SmmprogService.GetList("SelectSmugroupByUserid", userNo), typeof(Smugroup)); foreach (DataRow row in smuGroupTable.Rows) { groupItems.Add(row["Groupno"], row); ListViewItem listItem = new ListViewItem(); listItem.Name = row["Groupno"].ToString(); listItem.Text = row["Groupname"].ToString(); listItem.ImageIndex = 0; listItem.Tag = DataConverter.RowToObject<Smugroup>(row); listView1.Items.Add(listItem); } if (currentuser!="admin") { btn_addgroup.Enabled = false; btn_DeleteGroup.Enabled = false; } }
public int GetRowCount( Smmuser data) { return (int)SqlMapHelper.DefaultSqlMap.QueryForObject(string.Format("Select{0}CountByObject", t.Name), data); }
public int Delete( Smmuser data) { return SqlMapHelper.DefaultSqlMap.Delete(string.Format("Delete{0}", t.Name), data); }
public object Create( Smmuser data) { data.Password = MainDataModule.Encrypt(data.Password); return SqlMapHelper.DefaultSqlMap.Insert(string.Format("Insert{0}", t.Name), data); }
public int Update(Smmuser data) { data.Password = MainDataModule.Encrypt(data.Password); return SqlMapHelper.DefaultSqlMap.Update(string.Format("Update{0}", t.Name), data); //System.Windows.Forms.MessageBox.Show(t.Name); }