/// <summary> /// 通过id查询用户 /// </summary> /// <param name="id">用户id</param> /// <returns>查询到的用户信息</returns> public List <view_sys_u2g> SelectById(int id) { try { List <view_sys_u2g> user = new List <view_sys_u2g>(); string sql = "SELECT * from view_sys_u2g where id ='" + id + "'"; DataSet ds = new DataSet(); ds = SqlHelper.ExecuteDataset(ConStr, CommandType.Text, sql); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { view_sys_u2g user1 = new view_sys_u2g(); user1.id = (int)ds.Tables[0].Rows[i][nameof(view_sys_u2g.id)]; user1.name = (string)ds.Tables[0].Rows[i][nameof(view_sys_u2g.name)]; user1.username = (string)ds.Tables[0].Rows[i][nameof(view_sys_u2g.username)]; user1.password = (string)ds.Tables[0].Rows[i][nameof(view_sys_u2g.password)]; user1.gender = (string)ds.Tables[0].Rows[i][nameof(view_sys_u2g.gender)]; user1.phone = (string)ds.Tables[0].Rows[i][nameof(view_sys_u2g.phone)]; user1.email = (string)ds.Tables[0].Rows[i][nameof(view_sys_u2g.email)]; user1.job = (string)ds.Tables[0].Rows[i][nameof(view_sys_u2g.job)]; user1.status = (bool)ds.Tables[0].Rows[i][nameof(view_sys_u2g.status)]; user1.org_name = (string)ds.Tables[0].Rows[i][nameof(view_sys_u2g.org_name)]; user.Add(user1); } return(user); } catch (Exception e) { new LogSysDAL().Add(LogOperations.LogSys("查询用户信息" + e.Message)); return(null); } }
/// <summary> /// 查询用户组中的用户 /// </summary> /// <param name="groupId">用户组id</param> /// <returns>用户组信息</returns> public List <view_sys_u2g> SelectU2g(int groupId) { try { DataSet ds = new DataSet(); string sql = "Select * from view_sys_u2g where group_id= '" + groupId + "'"; List <view_sys_u2g> group = new List <view_sys_u2g>(); ds = SqlHelper.ExecuteDataset(ConStr, CommandType.Text, sql); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { view_sys_u2g group1 = new view_sys_u2g(); group1.group_name = (string)ds.Tables[0].Rows[i][nameof(view_sys_u2g.group_name)]; group1.username = (string)ds.Tables[0].Rows[i][nameof(view_sys_u2g.username)]; group1.name = (string)ds.Tables[0].Rows[i][nameof(view_sys_u2g.name)]; group1.phone = (string)ds.Tables[0].Rows[i][nameof(view_sys_u2g.phone)]; group1.job = (string)ds.Tables[0].Rows[i][nameof(view_sys_u2g.job)]; group.Add(group1); } return(group); } catch (Exception e) { new LogSysDAL().Add(LogOperations.LogSys(e.Message)); return(null); } }
/// <summary> /// 通过输入条件查询用户 /// </summary> /// <param name="UserInfo">查询条件</param> /// <returns>查询到的用户信息</returns> public List <view_sys_u2g> Select(sys_user UserInfo) { try { List <view_sys_u2g> user = new List <view_sys_u2g>(); string sql = "SELECT * from view_sys_u2g where 1=1 "; List <SqlParameter> SqlPara = new List <SqlParameter>(); if (!string.IsNullOrEmpty(UserInfo.username)) { sql += " and username like @username"; SqlPara.Add(new SqlParameter("@username", "%" + UserInfo.username + "%")); } if (!string.IsNullOrEmpty(UserInfo.name)) { sql += " and name like @name"; SqlPara.Add(new SqlParameter("@name", "%" + UserInfo.name + "%")); } if (!string.IsNullOrEmpty(UserInfo.gender)) { sql += " and gender like @gender"; SqlPara.Add(new SqlParameter("@gender", "%" + UserInfo.gender + "%")); } if (!string.IsNullOrEmpty(UserInfo.job)) { sql += " and job like @job"; SqlPara.Add(new SqlParameter("@job", "%" + UserInfo.job + "%")); } DataSet ds = new DataSet(); ds = SqlHelper.ExecuteDataset(ConStr, CommandType.Text, sql, SqlPara.ToArray()); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { view_sys_u2g user1 = new view_sys_u2g(); user1.id = (int)ds.Tables[0].Rows[i][nameof(view_sys_u2g.id)]; user1.name = (string)ds.Tables[0].Rows[i][nameof(view_sys_u2g.name)]; user1.username = (string)ds.Tables[0].Rows[i][nameof(view_sys_u2g.username)]; user1.gender = (string)ds.Tables[0].Rows[i][nameof(view_sys_u2g.gender)]; user1.phone = (string)ds.Tables[0].Rows[i][nameof(view_sys_u2g.phone)]; user1.job = (string)ds.Tables[0].Rows[i][nameof(view_sys_u2g.job)]; user1.status = (bool)ds.Tables[0].Rows[i][nameof(view_sys_u2g.status)]; user1.org_name = (string)ds.Tables[0].Rows[i][nameof(view_sys_u2g.org_name)]; user.Add(user1); } return(user); } catch (Exception e) { new LogSysDAL().Add(LogOperations.LogSys("查询用户信息" + e.Message)); return(null); } //return new DBOperationsSelect<sys_user>().SelectByConditions(conditions); }