public static List <SystemUser> QuerySystemUserListBySysNos(IEnumerable <int> sysNos, string applicationID)
{
DataCommand cmd = new DataCommand("QuerySystemUserListBySysNos");
cmd.SetParameter("@ApplicationID", DbType.String, applicationID);
cmd.CommandText = cmd.CommandText.Replace("#SysNos#", string.Join(",", sysNos));
List <SystemUser> result = cmd.ExecuteEntityList <SystemUser>();
if (result != null && result.Count > 0)
{
List <SystemApplication> apps = AuthDA.GetSystemApplicationsByUserSysNo(from s in result select s.SysNo);
result.ForEach(x =>
{
x.Applications = apps.FindAll(y => y.BizSysNo == x.SysNo);
});
}
return(result);
}
/// <summary>
/// 分页查询SystemUser信息
/// </summary>
public static QueryResult <SystemUser> QuerySystemUserList(QF_SystemUser filter)
{
//if (string.IsNullOrEmpty(filter.ApplicationID))
//{
DataCommand cmd = new DataCommand("QuerySystemUserList");
cmd.QuerySetCondition("u.SysNo", ConditionOperation.Equal, DbType.Int32, filter.SysNo);
if (!string.IsNullOrEmpty(filter.KeyWords))
{
cmd.QuerySetCondition($"And (u.CellPhone like '%{cmd.SetSafeParameter(filter.KeyWords)}%' OR u.UserFullName like '%{cmd.SetSafeParameter(filter.KeyWords)}%' OR u.LoginName like '%{cmd.SetSafeParameter(filter.KeyWords)}%' )");
}
//cmd.QuerySetCondition("u.Email", ConditionOperation.Equal, DbType.AnsiString, filter.Email);
cmd.QuerySetCondition("u.CommonStatus", ConditionOperation.Equal, DbType.Int32, filter.CommonStatus);
if (filter.MasterSysNo.HasValue)
{
cmd.QuerySetCondition("u.MasterSysNo", ConditionOperation.Equal, DbType.Int32, filter.MasterSysNo);
}
else if (filter.IsPlatformManager)
{
cmd.QuerySetCondition("And (u.MasterSysNo is NUll Or u.MasterSysNo=0)");
}
QueryResult <SystemUser> result = cmd.Query <SystemUser>(filter, " u.SysNo DESC");
if (result.data != null && result.data.Count > 0)
{
List <SystemApplication> apps = AuthDA.GetSystemApplicationsByUserSysNo(from s in result.data select s.SysNo);
result.data.ForEach(x =>
{
x.Applications = apps.FindAll(y => y.BizSysNo == x.SysNo);
});
}
return(result);
//}
//else
//{
// DataCommand cmd = new DataCommand("QuerySystemUserListBuyApplication");
// cmd.QuerySetCondition("u.SysNo", ConditionOperation.Equal, DbType.Int32, filter.SysNo);
// cmd.QuerySetCondition("u.LoginName", ConditionOperation.Like, DbType.AnsiString, cmd.SetSafeParameter(filter.LoginName));
// cmd.QuerySetCondition("u.UserFullName", ConditionOperation.Like, DbType.String, cmd.SetSafeParameter(filter.UserFullName));
// cmd.QuerySetCondition("u.CellPhone", ConditionOperation.Like, DbType.String, cmd.SetSafeParameter(filter.CellPhone));
// cmd.QuerySetCondition("u.Email", ConditionOperation.Equal, DbType.AnsiString, cmd.SetSafeParameter(filter.Email));
// cmd.QuerySetCondition("u.CommonStatus", ConditionOperation.Equal, DbType.Int32, filter.CommonStatus);
// //cmd.QuerySetCondition("u.CommonStatus", ConditionOperation.NotEqual, DbType.Int32, CommonStatus.Deleted);
// cmd.QuerySetCondition("ua.ApplicationID", ConditionOperation.Equal, DbType.AnsiString, cmd.SetSafeParameter(filter.ApplicationID));
// if (filter.MasterSysNo.HasValue)
// {
// cmd.QuerySetCondition("u.MasterSysNo", ConditionOperation.Equal, DbType.Int32, filter.MasterSysNo);
// }
// else
// {
// cmd.QuerySetCondition("And (u.MasterSysNo is NUll Or u.MasterSysNo=0)");
// }
// QueryResult<SystemUser> result = cmd.Query<SystemUser>(filter, " u.SysNo DESC");
// if (result.data != null && result.data.Count > 0)
// {
// List<SystemApplication> apps = AuthDA.GetSystemApplicationsByUserSysNo(from s in result.data select s.SysNo);
// result.data.ForEach(x =>
// {
// x.Applications = apps.FindAll(y => y.BizSysNo == x.SysNo);
// });
// }
// return result;
//}
}