public Maticsoft.Model.Members.Users GetUserIdByDepartmentID(string DepartmentID) { StringBuilder builder = new StringBuilder(); builder.Append("select UserID FROM Accounts_Users "); builder.Append(" where DepartmentID=@DepartmentID"); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@DepartmentID", SqlDbType.NVarChar, 15) }; cmdParms[0].Value = DepartmentID; Maticsoft.Model.Members.Users users = new Maticsoft.Model.Members.Users(); DataSet set = DbHelperSQL.Query(builder.ToString(), cmdParms); if (set.Tables[0].Rows.Count <= 0) { return null; } if ((set.Tables[0].Rows[0]["UserID"] != null) && (set.Tables[0].Rows[0]["UserID"].ToString() != "")) { users.UserID = int.Parse(set.Tables[0].Rows[0]["UserID"].ToString()); } return users; }
public List<Maticsoft.Model.Members.Users> DataTableToList(DataTable dt) { List<Maticsoft.Model.Members.Users> list = new List<Maticsoft.Model.Members.Users>(); int count = dt.Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { Maticsoft.Model.Members.Users item = new Maticsoft.Model.Members.Users(); if ((dt.Rows[i]["UserID"] != null) && (dt.Rows[i]["UserID"].ToString() != "")) { item.UserID = int.Parse(dt.Rows[i]["UserID"].ToString()); } if ((dt.Rows[i]["UserName"] != null) && (dt.Rows[i]["UserName"].ToString() != "")) { item.UserName = dt.Rows[i]["UserName"].ToString(); } if ((dt.Rows[i]["Password"] != null) && (dt.Rows[i]["Password"].ToString() != "")) { item.Password = (byte[]) dt.Rows[i]["Password"]; } if ((dt.Rows[i]["TrueName"] != null) && (dt.Rows[i]["TrueName"].ToString() != "")) { item.TrueName = dt.Rows[i]["TrueName"].ToString(); } if ((dt.Rows[i]["Sex"] != null) && (dt.Rows[i]["Sex"].ToString() != "")) { item.Sex = dt.Rows[i]["Sex"].ToString(); } if ((dt.Rows[i]["Phone"] != null) && (dt.Rows[i]["Phone"].ToString() != "")) { item.Phone = dt.Rows[i]["Phone"].ToString(); } if ((dt.Rows[i]["Email"] != null) && (dt.Rows[i]["Email"].ToString() != "")) { item.Email = dt.Rows[i]["Email"].ToString(); } if ((dt.Rows[i]["EmployeeID"] != null) && (dt.Rows[i]["EmployeeID"].ToString() != "")) { item.EmployeeID = new int?(int.Parse(dt.Rows[i]["EmployeeID"].ToString())); } if ((dt.Rows[i]["DepartmentID"] != null) && (dt.Rows[i]["DepartmentID"].ToString() != "")) { item.DepartmentID = dt.Rows[i]["DepartmentID"].ToString(); } if ((dt.Rows[i]["Activity"] != null) && (dt.Rows[i]["Activity"].ToString() != "")) { if ((dt.Rows[i]["Activity"].ToString() == "1") || (dt.Rows[i]["Activity"].ToString().ToLower() == "true")) { item.Activity = true; } else { item.Activity = false; } } if ((dt.Rows[i]["UserType"] != null) && (dt.Rows[i]["UserType"].ToString() != "")) { item.UserType = dt.Rows[i]["UserType"].ToString(); } if ((dt.Rows[i]["Style"] != null) && (dt.Rows[i]["Style"].ToString() != "")) { item.Style = new int?(int.Parse(dt.Rows[i]["Style"].ToString())); } if ((dt.Rows[i]["User_iCreator"] != null) && (dt.Rows[i]["User_iCreator"].ToString() != "")) { item.User_iCreator = new int?(int.Parse(dt.Rows[i]["User_iCreator"].ToString())); } if ((dt.Rows[i]["User_dateCreate"] != null) && (dt.Rows[i]["User_dateCreate"].ToString() != "")) { item.User_dateCreate = new DateTime?(DateTime.Parse(dt.Rows[i]["User_dateCreate"].ToString())); } if ((dt.Rows[i]["User_dateValid"] != null) && (dt.Rows[i]["User_dateValid"].ToString() != "")) { item.User_dateValid = new DateTime?(DateTime.Parse(dt.Rows[i]["User_dateValid"].ToString())); } if ((dt.Rows[i]["User_dateExpire"] != null) && (dt.Rows[i]["User_dateExpire"].ToString() != "")) { item.User_dateExpire = new DateTime?(DateTime.Parse(dt.Rows[i]["User_dateExpire"].ToString())); } if ((dt.Rows[i]["User_iApprover"] != null) && (dt.Rows[i]["User_iApprover"].ToString() != "")) { item.User_iApprover = new int?(int.Parse(dt.Rows[i]["User_iApprover"].ToString())); } if ((dt.Rows[i]["User_dateApprove"] != null) && (dt.Rows[i]["User_dateApprove"].ToString() != "")) { item.User_dateApprove = new DateTime?(DateTime.Parse(dt.Rows[i]["User_dateApprove"].ToString())); } if ((dt.Rows[i]["User_iApproveState"] != null) && (dt.Rows[i]["User_iApproveState"].ToString() != "")) { item.User_iApproveState = new int?(int.Parse(dt.Rows[i]["User_iApproveState"].ToString())); } if ((dt.Rows[i]["User_cLang"] != null) && (dt.Rows[i]["User_cLang"].ToString() != "")) { item.User_cLang = dt.Rows[i]["User_cLang"].ToString(); } list.Add(item); } } return list; }
public Maticsoft.Model.Members.Users GetModel(int UserID) { StringBuilder builder = new StringBuilder(); builder.Append("select top 1 UserID,UserName,NickName,Password,TrueName,Sex,Phone,Email,EmployeeID,DepartmentID,Activity,UserType,Style,User_iCreator,User_dateCreate,User_dateValid,User_dateExpire,User_iApprover,User_dateApprove,User_iApproveState,User_cLang from Accounts_Users "); builder.Append(" where UserID=@UserID"); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@UserID", SqlDbType.Int, 4) }; cmdParms[0].Value = UserID; Maticsoft.Model.Members.Users users = new Maticsoft.Model.Members.Users(); DataSet set = DbHelperSQL.Query(builder.ToString(), cmdParms); if (set.Tables[0].Rows.Count <= 0) { return null; } if ((set.Tables[0].Rows[0]["UserID"] != null) && (set.Tables[0].Rows[0]["UserID"].ToString() != "")) { users.UserID = int.Parse(set.Tables[0].Rows[0]["UserID"].ToString()); } if ((set.Tables[0].Rows[0]["UserName"] != null) && (set.Tables[0].Rows[0]["UserName"].ToString() != "")) { users.UserName = set.Tables[0].Rows[0]["UserName"].ToString(); } if ((set.Tables[0].Rows[0]["Password"] != null) && (set.Tables[0].Rows[0]["Password"].ToString() != "")) { users.Password = (byte[]) set.Tables[0].Rows[0]["Password"]; } if ((set.Tables[0].Rows[0]["TrueName"] != null) && (set.Tables[0].Rows[0]["TrueName"].ToString() != "")) { users.TrueName = set.Tables[0].Rows[0]["TrueName"].ToString(); } if ((set.Tables[0].Rows[0]["NickName"] != null) && (set.Tables[0].Rows[0]["NickName"].ToString() != "")) { users.NickName = set.Tables[0].Rows[0]["NickName"].ToString(); } if ((set.Tables[0].Rows[0]["Sex"] != null) && (set.Tables[0].Rows[0]["Sex"].ToString() != "")) { users.Sex = set.Tables[0].Rows[0]["Sex"].ToString(); } if ((set.Tables[0].Rows[0]["Phone"] != null) && (set.Tables[0].Rows[0]["Phone"].ToString() != "")) { users.Phone = set.Tables[0].Rows[0]["Phone"].ToString(); } if ((set.Tables[0].Rows[0]["Email"] != null) && (set.Tables[0].Rows[0]["Email"].ToString() != "")) { users.Email = set.Tables[0].Rows[0]["Email"].ToString(); } if ((set.Tables[0].Rows[0]["EmployeeID"] != null) && (set.Tables[0].Rows[0]["EmployeeID"].ToString() != "")) { users.EmployeeID = new int?(int.Parse(set.Tables[0].Rows[0]["EmployeeID"].ToString())); } if ((set.Tables[0].Rows[0]["DepartmentID"] != null) && (set.Tables[0].Rows[0]["DepartmentID"].ToString() != "")) { users.DepartmentID = set.Tables[0].Rows[0]["DepartmentID"].ToString(); } if ((set.Tables[0].Rows[0]["Activity"] != null) && (set.Tables[0].Rows[0]["Activity"].ToString() != "")) { if ((set.Tables[0].Rows[0]["Activity"].ToString() == "1") || (set.Tables[0].Rows[0]["Activity"].ToString().ToLower() == "true")) { users.Activity = true; } else { users.Activity = false; } } if ((set.Tables[0].Rows[0]["UserType"] != null) && (set.Tables[0].Rows[0]["UserType"].ToString() != "")) { users.UserType = set.Tables[0].Rows[0]["UserType"].ToString(); } if ((set.Tables[0].Rows[0]["Style"] != null) && (set.Tables[0].Rows[0]["Style"].ToString() != "")) { users.Style = new int?(int.Parse(set.Tables[0].Rows[0]["Style"].ToString())); } if ((set.Tables[0].Rows[0]["User_iCreator"] != null) && (set.Tables[0].Rows[0]["User_iCreator"].ToString() != "")) { users.User_iCreator = new int?(int.Parse(set.Tables[0].Rows[0]["User_iCreator"].ToString())); } if ((set.Tables[0].Rows[0]["User_dateCreate"] != null) && (set.Tables[0].Rows[0]["User_dateCreate"].ToString() != "")) { users.User_dateCreate = new DateTime?(DateTime.Parse(set.Tables[0].Rows[0]["User_dateCreate"].ToString())); } if ((set.Tables[0].Rows[0]["User_dateValid"] != null) && (set.Tables[0].Rows[0]["User_dateValid"].ToString() != "")) { users.User_dateValid = new DateTime?(DateTime.Parse(set.Tables[0].Rows[0]["User_dateValid"].ToString())); } if ((set.Tables[0].Rows[0]["User_dateExpire"] != null) && (set.Tables[0].Rows[0]["User_dateExpire"].ToString() != "")) { users.User_dateExpire = new DateTime?(DateTime.Parse(set.Tables[0].Rows[0]["User_dateExpire"].ToString())); } if ((set.Tables[0].Rows[0]["User_iApprover"] != null) && (set.Tables[0].Rows[0]["User_iApprover"].ToString() != "")) { users.User_iApprover = new int?(int.Parse(set.Tables[0].Rows[0]["User_iApprover"].ToString())); } if ((set.Tables[0].Rows[0]["User_dateApprove"] != null) && (set.Tables[0].Rows[0]["User_dateApprove"].ToString() != "")) { users.User_dateApprove = new DateTime?(DateTime.Parse(set.Tables[0].Rows[0]["User_dateApprove"].ToString())); } if ((set.Tables[0].Rows[0]["User_iApproveState"] != null) && (set.Tables[0].Rows[0]["User_iApproveState"].ToString() != "")) { users.User_iApproveState = new int?(int.Parse(set.Tables[0].Rows[0]["User_iApproveState"].ToString())); } if ((set.Tables[0].Rows[0]["User_cLang"] != null) && (set.Tables[0].Rows[0]["User_cLang"].ToString() != "")) { users.User_cLang = set.Tables[0].Rows[0]["User_cLang"].ToString(); } return users; }
private bool CreateUser(out string errorMsg) { try { Maticsoft.Model.Members.Users users; errorMsg = ""; users = new Maticsoft.Model.Members.Users { Activity = true, DepartmentID = "", EmployeeID = -1, Email = this.txtEmail.Text.Trim(), UserName = users.NickName = this.txtUserName.Text.Trim(), Password = AccountsPrincipal.EncryptPassword(this.txtPassword.Text), UserType = "AA", Style = 1, User_dateCreate = new DateTime?(DateTime.Now) }; if (!this.AddUser(users)) { errorMsg = "创建管理员帐号失败"; return false; } UsersExp model = new UsersExp { UserID = 1, BirthdayVisible = 0, BirthdayIndexVisible = false, Gravatar = "/Upload/User/Gravatar/1", ConstellationVisible = 0, ConstellationIndexVisible = false, NativePlaceVisible = 0, NativePlaceIndexVisible = false, RegionId = 0, AddressVisible = 0, AddressIndexVisible = false, BodilyFormVisible = 0, BodilyFormIndexVisible = false, BloodTypeVisible = 0, BloodTypeIndexVisible = false, MarriagedVisible = 0, MarriagedIndexVisible = false, PersonalStatusVisible = 0, PersonalStatusIndexVisible = false, LastAccessIP = "", LastAccessTime = new DateTime?(DateTime.Now), LastLoginTime = DateTime.Now, LastPostTime = new DateTime?(DateTime.Now) }; if (!this.AddUserExp(model)) { errorMsg = "创建管理员帐号扩展数据添加失败"; return false; } if (!this.AddUserRoles(1, 1)) { errorMsg = "创建管理员角色数据失败"; return false; } return true; } catch (Exception exception) { errorMsg = exception.Message; return false; } }