public Models.ATTModels.UserInfoList GetYGInfo(int PageSize, int CurPage, bool isall, string Key)
{
try
{
Models.ATTModels.UserInfoList list = new ATTModels.UserInfoList();
using (kaoqingEntities db = new kaoqingEntities())
{
list.listtime = db.wokeday.Select(p => p.day).ToList();
if (isall)
{
if (Key == null)
{
list.all = db.USERINFO.ToList().Skip((CurPage - 1) * PageSize).Take(PageSize).ToList();
}
else
{
list.all = db.USERINFO.Where(p => p.Name.Contains(Key)).ToList().Skip((CurPage - 1) * PageSize).Take(PageSize).ToList();
}
}
else
{
if (Key == null)
{
list.all = db.USERINFO.Where(p => p.StateATT == 1).ToList().Skip((CurPage - 1) * PageSize).Take(PageSize).ToList();
}
else
{
list.all = db.USERINFO.Where(p => p.StateATT == 1 && p.Name.Contains(Key)).ToList().Skip((CurPage - 1) * PageSize).Take(PageSize).ToList();
}
}
list.ErrorCode = 0;
if (isall)
{
if (Key == null)
{
list.tbCount = db.USERINFO.Count();
}
else
{
list.tbCount = db.USERINFO.Where(p => p.Name.Contains(Key)).Count();
}
}
else
{
if (Key == null)
{
list.tbCount = db.USERINFO.Where(p => p.StateATT == 1).Count();
}
else
{
list.tbCount = db.USERINFO.Where(p => p.StateATT == 1 && p.Name.Contains(Key)).Count();
}
}
return(list);
}
}
catch { return(null); }
}
public Models.ATTModels.UserInfoList GetUserInfo()
{
List <Models.ATTModels.UserInfo> list = new List <Models.ATTModels.UserInfo>();
List <Models.ATTModels.UserInfo> listALL = new List <Models.ATTModels.UserInfo>();
Models.ATTModels.UserInfoList infoList = new ATTModels.UserInfoList();
try
{
using (kaoqingEntities db = new kaoqingEntities())
{
var T_list = db.USERINFO.Where(p => p.StateATT == 1).ToList();
foreach (var a in T_list)
{
Models.ATTModels.UserInfo userInfo = new ATTModels.UserInfo();
userInfo.NAME = a.Name;
userInfo.StateATT = 1;
userInfo.USERID = a.USERID;
userInfo.OPHONE = a.OPHONE;
list.Add(userInfo);
}
T_list = db.USERINFO.ToList();
foreach (var a in T_list)
{
Models.ATTModels.UserInfo userInfo = new ATTModels.UserInfo();
userInfo.NAME = a.Name;
userInfo.StateATT = 0;
userInfo.USERID = a.USERID;
userInfo.OPHONE = a.OPHONE;
listALL.Add(userInfo);
}
infoList.list = list;
infoList.listAll = listALL;
infoList.ErrorCode = 0;
return(infoList);
}
}catch (Exception ex)
{
infoList.list = null;
infoList.listAll = null;
infoList.ErrorCode = -1;
return(infoList);
}
}
