Exemple #1
0
        public List<UsersList> ConvertUsersList(DataSet ds)
        {
            List<UsersList> ul = new List<UsersList>();
            if (ds == null || ds.Tables.Count == 0) return ul;

            DataTable dt = ds.Tables[0];
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                UsersList us = new UsersList();
                us.ID = dt.Rows[i]["ID"].ToString();
                us.UserId = dt.Rows[i]["UserId"].ToString().ToInteger();
                us.UserName = dt.Rows[i]["UserName"].ToString();
                us.EngName = dt.Rows[i]["EngName"].ToString();
                us.LoginName = dt.Rows[i]["LoginName"].ToString();
                us.Sex = dt.Rows[i]["Sex"].ToString().ToInteger();
                us.JobTitle = dt.Rows[i]["JobTitle"].ToString().ToInteger();
                us.DeptId = dt.Rows[i]["DeptId"].ToString().ToInteger();
                us.ParentId = dt.Rows[i]["ParentId"].ToString().ToInteger();
                us.ParentName = dt.Rows[i]["ParentName"].ToString();
                us.JoinDate = dt.Rows[i]["JoinDate"].ToString().ToDateTime();
                us.LeaveDate = dt.Rows[i]["LeaveDate"].ToString().ToDateTime();
                us.Status = dt.Rows[i]["Status"].ToString().ToInteger();

                ul.Add(us);
            }

            return ul;
        }
Exemple #2
0
        /// <summary>
        /// 查询用户列表,三个条件 部门、职位、状态
        /// </summary>
        /// <returns></returns>
        public List<UsersList> GetUserList(string deptId, string jobTitle, string status)
        {
            UsersList ul = new UsersList();
            UsersListDao uld = new UsersListDao();
            ul.Status = string.IsNullOrEmpty(status) ? (int)AccountStatusEnum.Active : status.ToInteger();

            var tag = false;
            if (!string.IsNullOrEmpty(deptId))
            {
                ul.Where += string.Format("u.DeptId = {0} ", deptId.ToInteger());
                tag = true;
            }
            if (!string.IsNullOrEmpty(jobTitle))
            {
                if (tag)
                {
                    ul.Where += string.Format("AND u.JobTitle = {0}", jobTitle.ToInteger());
                }
                else
                {
                    ul.Where += string.Format("u.JobTitle = {0}", jobTitle.ToInteger());
                }
            }

            DataSet ds = uld.SelectUsersList(ul);

            return ConvertUsersList(ds);
        }