private QueryResult <SystemUser> _UserQuery(QF_SystemUser filter)
{
var data = new List <SystemUser> ();
foreach (var user in UserData)
{
if (
(!filter.SysNo.HasValue || filter.SysNo.Value == user.SysNo) &&
(!filter.CommonStatus.HasValue || filter.CommonStatus.Value == user.CommonStatus) &&
(string.IsNullOrWhiteSpace(filter.LoginName) || filter.LoginName == user.LoginName) &&
(string.IsNullOrWhiteSpace(filter.UserFullName) || filter.UserFullName == user.UserFullName) &&
(string.IsNullOrWhiteSpace(filter.CellPhone) || filter.CellPhone == user.CellPhone)
)
{
data.Add(user);
}
}
QueryResult <SystemUser> result = new QueryResult <SystemUser>();
result.PageIndex = filter.PageIndex;
result.PageSize = filter.PageSize;
result.SortFields = filter.SortFields;
result.data = data;
result.recordsTotal = data.Count();
return(result);
}
public IActionResult UserQuery()
{
QF_SystemUser filter = BuildQueryFilterEntity <QF_SystemUser>();
var result = _UserQuery(filter);
return(AjaxGridJson(result));
}
public JsonResult QueryInstallers()
{
QF_SystemUser filter = new QF_SystemUser {
PageSize = 10000, CommonStatus = CommonStatus.Actived, IsPlatformManager = true
};
var result = user_service.QuerySystemUserList(filter);
return(Json(new AjaxResult {
Success = true, Data = result.data
}));
}
public ActionResult List(int?companySysNo)
{
int no = companySysNo.GetValueOrDefault();
if (!companySysNo.HasValue)
{
if (CurrUser.CompanySysNo > 0)
{
no = CurrUser.CompanySysNo;
}
}
AddressManagerModel model = new AddressManagerModel {
CompanySysNo = no
};
var company = CompanyService.LoadCompany(no);
if (company != null)
{
model.AreaSysNo = company.AreaSysNo;
model.Address = company.Address;
}
else
{
model.HasError = true;
model.ErrorMessage = "客户信息不存在可能已经被删除，请刷新页面重试。";
}
QF_SystemUser filter = new QF_SystemUser()
{
PageSize = 10000,
PageIndex = 0,
MasterSysNo = no,
CommonStatus = CommonStatus.Actived
};
AddressFilter addFilter = new AddressFilter {
PageSize = 5, AddressGrade = AddressGrade.Building, CompanySysNo = no
};
QueryResult <Address> addResult = AddressService.QueryAddressList(addFilter);
if (addResult != null && addResult.data != null)
{
var root = addResult.data.Find(a => a.ParentSysNo.GetValueOrDefault() == 0);
if (root != null)
{
model.AreaSysNo = root.AreaSysNo;
model.Address = root.PathName;
}
}
SystemUserService user_service = new SystemUserService();
var result = user_service.QuerySystemUserList(filter);
model.ManagerList = result.data;
return(View(model));
}
public ActionResult QueryCompanyUser()
{
QF_SystemUser filter = BuildQueryFilterEntity <QF_SystemUser>();
if (CurrUser.MasterSysNo.GetValueOrDefault() > 0)
{
filter.MasterSysNo = CurrUser.MasterSysNo;
}
var result = user_service.QuerySystemUserList(filter);
return(AjaxGridJson(result));
}
public ActionResult Query()
{
string json = Request["data"];
if (string.IsNullOrWhiteSpace(json))
{
throw new BusinessException("传入数据不能为空");
}
QF_SystemUser qf = JsonConvert.DeserializeObject <QF_SystemUser>(json);
qf.ApplicationID = ConstValue.ApplicationID;
var result = user_service.QuerySystemUserList(qf);
return(AjaxJsonTableData(result));
}
/// <summary>
/// 分页查询SystemUser信息
/// </summary>
public QueryResult <SystemUser> QuerySystemUserList(QF_SystemUser filter)
{
return(SystemUserDA.QuerySystemUserList(filter));
}
/// <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;
//}
}
