/// <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);
}
