/// <summary>
/// 修改用户
/// </summary>
private void EditUser()
{
string currentuser = MIS.UserNumber;
string id = treeView1.SelectedNode.Name;
if (currentuser != "admin" && currentuser != id)
{
MessageBox.Show("您无权进行此操作！");
return;
}
Smmuser data = UserService.GetOneByKey(id);
using (FrmSmmuserEdit_new dlg = new FrmSmmuserEdit_new())
{
dlg.DataObject = data;
dlg.UserNo = data.Userid;
dlg.UserName = data.UserName;
dlg.currentuser = currentuser;
if (dlg.ShowDialog() == DialogResult.OK)
{
UserService.Update(data);
CreateView();
}
MainForm.CurrentForm.SetStatusLabel();
}
}
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 CreateViewProj()
{
treeView2.Nodes.Clear();
TreeNode node = treeView2.Nodes.Add("system", "当前项目用户", groupimage, groupimage);
node.Tag = "根";
//添加当前用户
Smmuser user = Services.BaseService.GetOneByKey <Smmuser>(userid);
int useimage = 0;
if (int.TryParse(user.Lastlogon, out useimage))
{
useimage = int.Parse(user.Lastlogon.ToString());
}
TreeNode currtennode = node.Nodes.Add(user.Userid, user.UserName + "（项目创建人）", useimage, useimage);
currtennode.Tag = "创建人";
IList <ProjectUser> list = Services.BaseService.GetList <ProjectUser>("SelectProjectUserbyWhere", " UID='" + projid + "'");
for (int i = 0; i < list.Count; i++)
{
TreeNode tempnode = node.Nodes.Add(list[i].UserID, list[i].UserName, list[i].Sort, list[i].Sort);
tempnode.Tag = "用户";
}
node.ExpandAll();
}
/// <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);
}
public void Login(LoginData data, out string token, out LoginStatus status)
{
Smmuser user = SqlMapHelper.DefaultSqlMap.QueryForObject <Smmuser>("SelectSmmuserByKey", data.UserNumber);
if (user == null)
{
status = LoginStatus.InvalidUser;
}
else
{
if (MainDataModule.Decrypt(user.Password) == data.Password)
{
status = LoginStatus.OK;
}
else
{
status = LoginStatus.InvalidPassword;
}
}
token = string.Empty;
if (status == LoginStatus.OK)
{
token = Guid.NewGuid().ToString();
UserStateSingleton.Instance.AddUser(new UserInfo(token, data.UserNumber));
}
}
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);
}
public string GetUserName(UserInfo userInfo, string userNumber)
{
if (!UserStateSingleton.Instance.IsValidUser(userInfo))
{
return(string.Empty);
}
Smmuser user = SqlMapHelper.DefaultSqlMap.QueryForObject <Smmuser>("SelectSmmuserByKey", userInfo.Number);
return(user.UserName);
}
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("用户名或密码错误!");
}
}
private void RetrieveUser()
{
IList <Smmuser> list = UserService.GetStrongList();
IEnumerator <Smmuser> ie = list.GetEnumerator();
while (ie.MoveNext())
{
Smmuser data = ie.Current;
ListViewItem item = listView1.Items.Add(data.Userid, 0);
item.SubItems.Add(data.UserName);
item.SubItems.Add(data.Remark);
item.Tag = data;
}
}
private void EditUser()
{
if (listView1.SelectedItems.Count > 0)
{
ListViewItem item = listView1.SelectedItems[0];
string id = item.SubItems[0].Text;
Smmuser data = UserService.GetOneByKey(id);
using (FrmPersonEdit dlg = new FrmPersonEdit()) {
dlg.DataObject = data;
if (dlg.ShowDialog() == DialogResult.OK)
{
UserService.Update(data);
Retrieve();
}
}
}
}
//添加所有用户
private void btnAddAll_Click(object sender, EventArgs e)
{
IList <Smmuser> list_user = Services.BaseService.GetStrongList <Smmuser>();
for (int i = 0; i < list_user.Count; i++)
{
if (!treeView2.Nodes[0].Nodes.ContainsKey(list_user[i].Userid))
{
Smmuser user = list_user[i];
int useimage = 0;
if (int.TryParse(user.Lastlogon, out useimage))
{
useimage = int.Parse(user.Lastlogon.ToString());
}
TreeNode currtennode = treeView2.Nodes[0].Nodes.Add(user.Userid, user.UserName, useimage, useimage);
currtennode.Tag = "用户";
havechange = true;
}
}
}
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);
}
//private void CreateView() {
// treeView1.Nodes.Clear();
// TreeNode node = treeView1.Nodes.Add("system", "系统用户和组", rootimage, rootimage);
// node.Tag="根";
// IList<Smmgroup> list = GroupService.GetStrongList<Smmgroup>();
// for (int i = 0; i < list.Count; i++)
// {
// TreeNode tempnode = node.Nodes.Add(list[i].Groupno, list[i].Groupname, groupimage, groupimage);
// tempnode.Tag="组";
// IList<Smugroup> listUser = GroupService.GetList<Smugroup>("SelectSmugroupByWhere", "Groupno='" + list[i].Groupno + "'");
// for (int j = 0; j < listUser.Count; j++)
// {
// Smmuser user = new Smmuser();
// user.Userid = listUser[j].Userid;
// Smmuser tempuser= GroupService.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 = GroupService.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 = GroupService.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();
// Btn_Show();
//}
private void CreateView()
{
Hashtable usertable = new Hashtable();
usertable.Add(MIS.ProgUserID, "创建人");
IList <ProjectUser> listuser = GroupService.GetList <ProjectUser>("SelectProjectUserbyWhere", " UID='" + MIS.ProgUID + "'");
for (int i = 0; i < listuser.Count; i++)
{
usertable.Add(listuser[i].UserID, listuser[i].UserName);
}
treeView1.Nodes.Clear();
TreeNode node = treeView1.Nodes.Add("system", "系统用户和组", rootimage, rootimage);
node.Tag = "根";
IList <Smmgroup> list = GroupService.GetStrongList <Smmgroup>();
for (int i = 0; i < list.Count; i++)
{
TreeNode tempnode = node.Nodes.Add(list[i].Groupno, list[i].Groupname, groupimage, groupimage);
tempnode.Tag = "组";
IList <Smugroup> listUser = GroupService.GetList <Smugroup>("SelectSmugroupByWhere", "Groupno='" + list[i].Groupno + "'");
if (listUser.Count > 0)
{
for (int j = 0; j < listUser.Count; j++)
{
Smmuser tempuser = GroupService.GetOneByKey <Smmuser>(listUser[j].Userid);
//tempuser.Lastlogon 存放用户图标id
if (tempuser != null)
{
if (tempuser.Userid == MIS.ProgUserID)
{
tempuser.UserName += "(项目创建人)";
}
else if (usertable.ContainsKey(tempuser.Userid))
{
tempuser.UserName += "(项目用户)";
}
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 = GroupService.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 = GroupService.GetList <Smugroup>("SelectSmugroupByWhere", "Userid='" + tempuserno + "'");
if (listUsergroup.Count == 0)
{
if (list_user[k].Userid == MIS.ProgUserID)
{
list_user[k].UserName += "(项目创建人)";
}
else if (usertable.ContainsKey(list_user[k].Userid))
{
list_user[k].UserName += "(项目用户)";
}
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.ExpandAll();
Btn_Show();
}
//显示系统所有用户
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 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 GetRowCount(Smmuser data)
{
return((int)SqlMapHelper.DefaultSqlMap.QueryForObject(string.Format("Select{0}CountByObject", t.Name), data));
}
