public ActionResult Index()
{
UserDTO user = UserDAC.RestoreByName(Membership.GetUser().UserName);
List <UserDTO> users = UserDAC.GetUsers(user.Company_ID);
List <AreaDTO> areas = null;//UserDAC.GetAreas(user.ID);
Dictionary <string, List <SelectListItem> > areaNameList = new Dictionary <string, List <SelectListItem> >();
foreach (UserDTO thisUser in users)
{
areas = UserDAC.GetAreas(thisUser.ID);
List <SelectListItem> areaNames = new List <SelectListItem>();
foreach (AreaDTO area in areas)
{
SelectListItem item = new SelectListItem {
Text = area.Title, Value = area.ID.ToString()
};
if (area.ID == thisUser.DefaultAreaID)
{
item.Selected = true;
}
areaNames.Add(item);
}
areaNameList.Add(thisUser.ID, areaNames);
}
areas = UserDAC.GetAreas(user.ID);
//SelectList testList = new SelectList(areaNames, 2);
//ViewData.s .CategoryId = new SelectList(query.AsEnumerable(), "CategoryID", "CategoryName", 3);
//return View("Index", new UserIndexModel { Users = users, AreaNames = testList });
return(View("Index", new UserIndexModel {
Users = users, AreaNameList = areaNameList, Areas = areas
}));
}
private void lvUser_ItemSelectionChanged(object sender, ListViewItemSelectionChangedEventArgs e)
{
if (lvUser.SelectedItems.Count == 0)
{
return;
}
int userId = int.Parse(lvUser.SelectedItems[0].Text);
User user;
try
{
UserDAC dac = new UserDAC();
user = dac.Select(userId);
}
catch (Exception ex)
{
MessageBox.Show("读取数据库失败，请检查网络是否异常！\r\n原因如下:" + ex.Message);
return;
}
userid.Text = user.userid.ToString();
loginid.Text = user.loginid;
username.Text = user.username;
password.Text = user.password;
dodelivery.Checked = user.dodelivery;
dotracking.Checked = user.dotracking;
dousermanage.Checked = user.dousermanage;
}
private void RefreshData()
{
lvUser.Items.Clear();
List <User> lstUser;
try
{
UserDAC dac = new UserDAC();
lstUser = dac.SelectAll();
}
catch (Exception ex)
{
MessageBox.Show("读取数据库失败，请检查网络是否异常！\r\n原因如下:" + ex.Message);
return;
}
int i = 0;
foreach (User user in lstUser)
{
//lvUser.Items.Add
ListViewItem item = new ListViewItem(user.userid.ToString());
item.SubItems.Add(user.loginid);
item.SubItems.Add(user.username);
item.SubItems.Add(user.dodelivery.ToString());
item.SubItems.Add(user.dotracking.ToString());
item.SubItems.Add(user.dousermanage.ToString());
if (i == 0)
{
item.Selected = true;
}
lvUser.Items.Add(item);
i++;
}
}
public ActionResult SaveUser(UserEditModel model)
{
if (ModelState.IsValid)
{
UserDTO loggedInUser = UserDAC.RestoreByName(Membership.GetUser().UserName);
MembershipUser User = Membership.GetUser(model.Email);
UserDTO user = new UserDTO(model.UserID, model.Email, loggedInUser.Company_ID, model.Email, loggedInUser.DefaultAreaID);
if (UserDAC.IsUserNameFree(model.Email))
{
UserDAC.Store(user);
}
if (model.IsAdministrator)
{
UserDAC.AddUserRole(model.Email, "Administrator");
}
else
{
UserDAC.RemoveUserRole(model.Email, "Administrator");
}
//return RedirectToAction("Index", "User");
return(Redirect("Index"));
}
else
{
return(Redirect("Index"));
}
}
/// <summary>
/// Insert a new user into the table and returns the complete User object
/// </summary>
/// <param name="user">User to be added</param>
/// <returns></returns>
public User Add(User user)
{
User result = default(User);
var userDAC = new UserDAC();
result = userDAC.Create(user);
return(result);
}
public List <UserEntity> bindManagersForNewEmp(int accid, int prjid, int c_prjid)
//public List<ManagerEntity> bindManagersForNewEmp(int accid, int prjid, int c_prjid)
{
var count = new UserDAC();
return(count.bindManagersForNewEmp(accid, prjid, c_prjid));
//return count.TESTONE(accid, prjid, c_prjid);
}
/// <summary>
/// Obtains a list of user for a quick view
/// </summary>
/// <returns></returns>
public IList <User> GetTop1000()
{
var result = default(IList <User>);
var userDAC = new UserDAC();
result = userDAC.Read();
return(result);
}
/// <summary>
/// Obains the user that match with the id
/// </summary>
/// <param name="id">User id to be searched</param>
/// <returns></returns>
public User GetById(int id)
{
User result = default(User);
var userDAC = new UserDAC();
result = userDAC.ReadBy(id);
return(result);
}
public ActionResult EditUser(String id)
{
UserDTO user = UserDAC.Restore(id);
string[] rolelist = Roles.GetRolesForUser();
//ViewData["PasswordLength"] = MembershipService.MinPasswordLength;
UserEditModel model = new UserEditModel();
//model.UserName = user.UserName;
model.Email = user.Email;
model.IsAdministrator = user.IsAdministrator;
model.UserID = id;
return(View(model));
}
public ActionResult Areas(string id)
{
UserDTO loggedInUser = UserDAC.RestoreByName(Membership.GetUser().UserName);
List <AreaDTO> allAreas = AreaDAC.GetAreasByUserCompany(loggedInUser.ID);
List <AreaDTO> userAreas = AreaDAC.GetAreas(id);
UserDTO selectedUser = UserDAC.Restore(id);
List <UserDTO> reloadedUsers = UserDAC.GetUsers(loggedInUser.Company_ID);
Dictionary <string, List <SelectListItem> > areaNameList = new Dictionary <string, List <SelectListItem> >();
List <SelectListItem> areaNames = new List <SelectListItem>();
foreach (AreaDTO area in allAreas)
{
foreach (AreaDTO userArea in userAreas)
{
if (userArea.ID == area.ID)
{
area.Selected = true;
}
}
SelectListItem item = new SelectListItem {
Text = area.Title, Value = area.ID.ToString()
};
if (area.ID == selectedUser.DefaultAreaID)
{
item.Selected = true;
}
areaNames.Add(item);
}
areaNameList.Add("0", areaNames);
//foreach (UserDTO thisUser in reloadedUsers)
//{
// List<SelectListItem> areaNames = new List<SelectListItem>();
// foreach (AreaDTO area in areas)
// {
// SelectListItem item = new SelectListItem { Text = area.Title, Value = area.ID.ToString() };
// if (area.ID == thisUser.DefaultAreaID)
// item.Selected = true;
// areaNames.Add(item);
// }
// areaNameList.Add(thisUser.ID, areaNames);
//}
return(View("UserAreasControl", new UserIndexModel {
Users = reloadedUsers, AreaNameList = areaNameList, Areas = allAreas, SelectedUser = selectedUser
}));
}
public ActionResult EditUser(String userID)
{
UserDTO user = UserDAC.Restore(userID);
string[] rolelist = Roles.GetRolesForUser();
ViewData["PasswordLength"] = MembershipService.MinPasswordLength;
RegisterModel model = new RegisterModel();
//model.UserName = user.UserName;
model.Email = user.Email;
model.IsAdministrator = true;
model.Password = "******";
model.ConfirmPassword = "******";
return(View("Register", model));
}
private void btnOk_Click(object sender, EventArgs e)
{
string oldpass = txtOldPass.Text.Trim();
string newpass = txtNewPass.Text.Trim();
string newpass1 = txtNewPass1.Text.Trim();
if (oldpass.Length == 0)
{
txtOldPass.Focus();
MessageBox.Show("请输入旧密码");
return;
}
if (newpass.Length == 0)
{
txtNewPass.Focus();
MessageBox.Show("请输入新密码");
return;
}
if (newpass1.Length == 0)
{
txtNewPass1.Focus();
MessageBox.Show("请输入确认密码");
return;
}
if (newpass != newpass1)
{
MessageBox.Show("两次输入密码不一致");
return;
}
try
{
UserDAC dac = new UserDAC();
dac.ChangePwd(Global.LoginUser.userid, newpass);
}
catch (Exception ex)
{
MessageBox.Show("更改失败!");
return;
}
this.Close();
}
public ActionResult SaveUsers(IList <UserDTO> users)
{
string[] rolelist = Roles.GetRolesForUser();
if (ModelState.IsValid)
{
foreach (UserDTO user in users)
{
if (!String.IsNullOrEmpty(user.ID))
{
UserDAC.Store(user);
}
}
UserDTO loggedInUser = UserDAC.RestoreByName(Membership.GetUser().UserName);
List <UserDTO> reloadedUsers = UserDAC.GetUsers(loggedInUser.Company_ID);
List <AreaDTO> areas = UserDAC.GetAreas(loggedInUser.ID);
Dictionary <string, List <SelectListItem> > areaNameList = new Dictionary <string, List <SelectListItem> >();
foreach (UserDTO thisUser in users)
{
//thisUser.UserName = thisUser.Email;
List <SelectListItem> areaNames = new List <SelectListItem>();
foreach (AreaDTO area in areas)
{
SelectListItem item = new SelectListItem {
Text = area.Title, Value = area.ID.ToString()
};
if (area.ID == thisUser.DefaultAreaID)
{
item.Selected = true;
}
areaNames.Add(item);
}
areaNameList.Add(thisUser.ID, areaNames);
}
return(View("UserListControl", new UserIndexModel {
Users = reloadedUsers, AreaNameList = areaNameList, Areas = areas
}));
}
else
{
return(Redirect("Index"));
}
}
public ActionResult Login(string UserName, string Password)
{
try
{
bool authenticated = UserDAC.Login(UserName, Password);
if (authenticated)
{
return(RedirectToAction("Index"));
}
else
{
ViewBag.Error = "Usuario y/o Contraseña incorrectos";
}
}
catch (Exception)
{
return(View("Login"));
}
return(View("Login"));
}
private void btnRemove_Click(object sender, EventArgs e)
{
if (lvUser.SelectedItems.Count == 0)
{
MessageBox.Show("请先选择要删除的用户");
return;
}
int userId = int.Parse(lvUser.SelectedItems[0].Text);
try
{
UserDAC dac = new UserDAC();
dac.Delete(userId);
}
catch (Exception ex)
{
MessageBox.Show("读取数据库失败，请检查网络是否异常！\r\n原因如下:" + ex.Message);
return;
}
RefreshData();
MessageBox.Show("删除成功");
}
public int EndUser(int user_id)
{
UserDAC dac = new UserDAC();
return(dac.EndUser(user_id));
}
public int UpdateUser(UserVO vo)
{
UserDAC dac = new UserDAC();
return(dac.UpdateUser(vo));
}
public UserVO userDetail(int user_id)
{
UserDAC dac = new UserDAC();
return(dac.userDetail(user_id));
}
public int RegistUser(UserVO vo)
{
UserDAC dac = new UserDAC();
return(dac.RegistUser(vo));
}
public List <UserVO> UserList()
{
UserDAC dac = new UserDAC();
return(dac.UserList());
}
private void btnSave_Click(object sender, EventArgs e)
{
if (loginid.Text.Trim().Length == 0)
{
MessageBox.Show("请输入登陆名");
loginid.Focus();
return;
}
if (username.Text.Trim().Length == 0)
{
MessageBox.Show("请输入真实姓名");
username.Focus();
return;
}
if (password.Text.Trim().Length == 0)
{
MessageBox.Show("请输入密码");
password.Focus();
return;
}
bool isAdd = true;
User user = new User();
if (userid.Text.Length > 0)
{
user.userid = int.Parse(userid.Text);
isAdd = false;
}
user.loginid = loginid.Text.Trim();
user.username = username.Text.Trim();
user.password = password.Text.Trim();
user.dodelivery = dodelivery.Checked;
user.dotracking = dotracking.Checked;
user.dousermanage = dousermanage.Checked;
UserDAC dac = new UserDAC();
try
{
User dbUser = dac.Select(user.loginid, user.userid);
if (dbUser != null)
{
MessageBox.Show("登陆名已存在!");
return;
}
if (isAdd)
{
dac.Add(user);
}
else
{
dac.Update(user);
}
MessageBox.Show("保存成功");
}
catch (Exception ex)
{
MessageBox.Show("读取数据库失败，请检查网络是否异常！\r\n原因如下:" + ex.Message);
return;
}
RefreshData();
}
/// <summary>
/// Deletes the user that match with the id
/// </summary>
/// <param name="Id">User id to be deleted</param>
public void Delete(int Id)
{
var userDAC = new UserDAC();
userDAC.Delete(Id);
}
/// <summary>
/// Edit the user that match with the current id
/// </summary>
/// <param name="user">Data to be edited</param>
public void Edit(User user)
{
var userDAC = new UserDAC();
userDAC.Update(user);
}
public int AddUser(UserEntity _uesrtype)
{
var UserDAC = new UserDAC();
return(UserDAC.AddUser(_uesrtype));
}
public List <UserEntity> GetManagerNames(int AccountId)
{
var UserDAC = new UserDAC();
return(UserDAC.GetManagerNames(AccountId));
}
public List <UserEntity> GetUserRolenames(int AccountId, string RoleId)
{
var UserDAC = new UserDAC();
return(UserDAC.GetRoleNames(AccountId, RoleId));
}
public UserBC()
{
userDAC = new UserDAC();
}
private void btnLogin_Click_1(object sender, EventArgs e)
{
string sLoginId = txtUserName.Text.Trim();
string sPass = txtPassword.Text.Trim();
if (sLoginId.Length == 0)
{
txtUserName.Focus();
MessageBox.Show("请输入用户名!");
return;
}
if (sPass.Length == 0)
{
txtPassword.Focus();
MessageBox.Show("请输入密码!");
return;
}
User user;
try
{
UserDAC dac = new UserDAC();
user = dac.Select(sLoginId, 0);
}
catch (Exception ex)
{
MessageBox.Show("操作数据库出错，请检查网络;\r\n原因:" + ex.Message);
return;
}
if (user == null)
{
MessageBox.Show("用户不存在!");
return;
}
if (user.password != sPass)
{
MessageBox.Show("密码不正确!");
return;
}
if (checkSave.Checked)
{
SaveUserInfo2File(sLoginId, sPass);
}
else
{
try
{
File.Delete("config.ini");
}
catch { }
}
Global.LoginUser = user;
this.DialogResult = DialogResult.OK;
this.Close();
}
public UserBC(IProject_ManagerContext context)
{
userDAC = new UserDAC(context);
}
public User Login(User users)
{
var userDac = new UserDAC();
return(userDac.Login(users.Email, "password"));
}
