public IActionResult getFinderByType()
{
int code = 200;
List <Finder> list = new List <Finder>();
List <Hashtable> infolist = new List <Hashtable>();
//前端向后端发送数据
string type = Request.Form["type"];
string temp = Request.Form["index"];
int index = (temp == "" || type == null) ? 0 : Convert.ToInt32(temp);
type = (temp == "" || type == null) ? null : type;
list = service.GetFinderByType(type, index);
var all = service.GetFinderByType(type, 0);
if (list == null)
{
code = 500;
}
else
{
foreach (Finder item in list)
{
String completetext = null;
if (item.Complete)
{
completetext = "已找到";
}
else
{
completetext = "未找到";
}
LoseType losttype = service.GetLoseTypesBuName(item.LoseType.Name);
Hashtable table = new Hashtable();
table.Add("id", item.User.ID);
table.Add("avatarURL", item.User.head);
table.Add("username", item.User.UserName);
table.Add("infoId", item.ID);
table.Add("infoTitle", item.Title);
table.Add("fatherType", losttype.FatherType.Name);
table.Add("type", item.LoseType.Name);
table.Add("hidden", item.hidden);
table.Add("complete", item.Complete);
table.Add("completetext", completetext);
table.Add("infourl", "/Finding/FinderDetail?id=" + item.ID.ToString());
infolist.Add(table);
}
}
return(Ok(new
{
infolist = infolist,
total = all.Count,
code = code
}));
}
public bool Create(LoseType type)
{
try
{
_context.Add(type);
_context.SaveChanges();
return(true);
}
catch (Exception e)
{
Console.Write(e.StackTrace);
return(false);
}
}
public List <Finder> GetFinderAndTextByType(String type, String text, int index)
{
LoseType loseType = null;
var items = loseTypesDao.Select(null, type, null);
if (items.Count == 1)
{
foreach (LoseType item in items)
{
loseType = item;
}
return(finderDao.SearchSelect(text, text, loseType, index));
}
else
{
return(finderDao.SearchSelect(text, text, null, index));
}
}
public List <Owner> GetOwnerByType(String type, int index)
{
LoseType loseType = null;
var items = loseTypesDao.Select(null, type, null);
if (items.Count == 1)
{
foreach (LoseType item in items)
{
loseType = item;
}
return(ownerDao.Select(null, null, null, null, null, null, loseType, null, null, index));
}
else
{
return(ownerDao.Select(null, null, null, null, null, null, null, null, null, index));
}
}
public List <LoseType> Select(int?id, string name, LoseType fathertype)
{
try
{
var items = from s in _context.LoseTypes.Include("FatherType")
where ((id == null || s.ID == id) && (name == null || s.Name == name) && (fathertype == null || s.FatherType == fathertype))
select s;
List <LoseType> list = new List <LoseType>();
foreach (var item in items)
{
list.Add(item);
}
return(list);
}
catch (Exception e)
{
Console.Write(e.StackTrace);
return(null);
}
}
public bool saveInfomation(String title, String fathertype, String type, String content, String account, String question)
{
bool result = false;
LoseType loseType = null;
LoseType fatherType = fatherType = loseTypesDao.Select(null, fathertype, null)[0];
User user = null;
if (loseTypesDao.Select(null, type, fatherType).Count > 0)
{
loseType = loseTypesDao.Select(null, type, fatherType)[0];
}
else
{
return(result);
}
if (userDao.Select(null, account, null, null, null, null, null, null, null, null, null, null, null).Count > 0)
{
user = userDao.Select(null, account, null, null, null, null, null, null, null, null, null, null, null)[0];
}
else
{
return(result);
}
Finder finder = new Finder();
finder.hidden = false;
finder.Complete = false;
finder.Time = DateTime.Now;
finder.LastReplyTime = finder.Time;
finder.LoseType = loseType;
finder.Content = content;
finder.User = user;
finder.Question = question;
finder.Title = title;
if (finderDao.Create(finder))
{
result = true;
}
return(result);
}
public bool Delete(int?id)
{
try
{
LoseType type = _context.LoseTypes.Find(id);
if (type != null)
{
_context.LoseTypes.Remove(type);
_context.SaveChanges();
return(true);
}
else
{
return(false);
}
}
catch (Exception e)
{
Console.Write(e.StackTrace);
return(false);
}
}
public List <Finder> SearchSelect(String content, String title, LoseType losetype, int index)
{
try
{
var items = from s in _context.Finders.Include("LoseType").Include("User")
where (s.Content.Contains(content)) || (s.Title.Contains(title)) && ((losetype == null) || s.LoseType == losetype)
select s;
if (index != 0)
{
items = items.OrderByDescending(u => u.LastReplyTime).Skip(10 * (index - 1)).Take(10);
}
List <Finder> list = new List <Finder>();
foreach (var item in items)
{
list.Add(item);
}
return(list);
}
catch (Exception e)
{
Console.Write(e.StackTrace);
return(null);
}
}
public List <LoseType> GetChildrenLoseTypes(LoseType fathertype)
{
return(loseTypesDao.Select(null, null, fathertype));
}
public List <Finder> Select(int?id, User user, String content, bool?complete, String question, String title, DateTime?time, DateTime?lasttime, LoseType losetype, bool?hidden, int index)
{
try
{
var items = from s in _context.Finders.Include("LoseType").Include("User")
where ((id == null) || s.ID == id) && ((user == null) || s.User == user) && ((content == null) || s.Content == content) && ((complete == null) || s.Complete == complete) &&
((question == null) || s.Question == question) && ((title == null) || s.Title == title) && ((time == null) || s.Time == time) && ((lasttime == null) || s.LastReplyTime == lasttime) &&
((losetype == null) || s.LoseType == losetype) && ((hidden == null) || s.hidden == hidden)
select s;
if (index != 0)
{
items = items.OrderByDescending(u => u.LastReplyTime).Skip(10 * (index - 1)).Take(10);
}
List <Finder> list = new List <Finder>();
foreach (var item in items)
{
list.Add(item);
}
return(list);
}
catch (Exception e)
{
Console.Write(e.StackTrace);
return(null);
}
}
public IActionResult Search()
{
int code = 200;
List <Hashtable> infolist = new List <Hashtable>();
//前端向后端发送数据
string text = Request.Form["searchtext"];
string temp = Request.Form["missingorfind"];
string type = Request.Form["type"];
string temp2 = Request.Form["index"];
int index = (temp2 == "" || temp2 == null) ? 0 : Convert.ToInt32(temp2);
int missingorfind = (temp == null) ? 0 : Convert.ToInt32(temp);
int all = 0;
type = (type == "") ? null : type;
if (missingorfind == 1)
{
List <Owner> list = new List <Owner>();
if (text != "")
{
list = service.GetOwnerAndTextByType(type, text, index);
all = service.GetOwnerAndTextByType(type, text, 0).Count;
foreach (var item in list)
{
String completetext = null;
if (item.Complete)
{
completetext = "已找到";
}
else
{
completetext = "未找到";
}
LoseType losttype = service.GetLoseTypesBuName(item.LoseType.Name);
Hashtable table = new Hashtable();
table.Add("id", item.User.ID);
table.Add("avatarURL", item.User.head);
table.Add("username", item.User.UserName);
table.Add("infoId", item.ID);
table.Add("infoTitle", item.Title);
table.Add("fatherType", losttype.FatherType.Name);
table.Add("type", item.LoseType.Name);
table.Add("hidden", item.hidden);
table.Add("complete", item.Complete);
table.Add("completetext", completetext);
table.Add("infourl", "/Missing/MissingDetail?id=" + item.ID.ToString());
infolist.Add(table);
}
}
else
{
list = service.GetOwnerByType(type, index);
all = service.GetOwnerByType(type, 0).Count;
foreach (var item in list)
{
String completetext = null;
if (item.Complete)
{
completetext = "已找到";
}
else
{
completetext = "未找到";
}
LoseType losttype = service.GetLoseTypesBuName(item.LoseType.Name);
Hashtable table = new Hashtable();
table.Add("id", item.User.ID);
table.Add("avatarURL", item.User.head);
table.Add("username", item.User.UserName);
table.Add("infoId", item.ID);
table.Add("infoTitle", item.Title);
table.Add("fatherType", losttype.FatherType.Name);
table.Add("type", item.LoseType.Name);
table.Add("hidden", item.hidden);
table.Add("complete", item.Complete);
table.Add("completetext", completetext);
table.Add("infourl", "/Missing/MissingDetail?id=" + item.ID.ToString());
infolist.Add(table);
}
}
return(Ok(new
{
infolist = infolist,
total = all,
code = code
}));
}
else if (missingorfind == 2)
{
List <Finder> list = new List <Finder>();
if (text != "")
{
list = service.GetFinderAndTextByType(type, text, index);
all = service.GetFinderAndTextByType(type, text, 0).Count;
foreach (var item in list)
{
String completetext = null;
if (item.Complete)
{
completetext = "已找到";
}
else
{
completetext = "未找到";
}
LoseType losttype = service.GetLoseTypesBuName(item.LoseType.Name);
Hashtable table = new Hashtable();
table.Add("id", item.User.ID);
table.Add("avatarURL", item.User.head);
table.Add("username", item.User.UserName);
table.Add("infoId", item.ID);
table.Add("infoTitle", item.Title);
table.Add("fatherType", losttype.FatherType.Name);
table.Add("type", item.LoseType.Name);
table.Add("hidden", item.hidden);
table.Add("complete", item.Complete);
table.Add("completetext", completetext);
table.Add("infourl", "/Finding/FinderDetail?id=" + item.ID.ToString());
infolist.Add(table);
}
}
else
{
list = service.GetFinderByType(type, index);
all = service.GetFinderByType(type, 0).Count;
foreach (var item in list)
{
String completetext = null;
if (item.Complete)
{
completetext = "已找到";
}
else
{
completetext = "未找到";
}
LoseType losttype = service.GetLoseTypesBuName(item.LoseType.Name);
Hashtable table = new Hashtable();
table.Add("id", item.User.ID);
table.Add("avatarURL", item.User.head);
table.Add("username", item.User.UserName);
table.Add("infoId", item.ID);
table.Add("infoTitle", item.Title);
table.Add("fatherType", losttype.FatherType.Name);
table.Add("type", item.LoseType.Name);
table.Add("hidden", item.hidden);
table.Add("complete", item.Complete);
table.Add("completetext", completetext);
table.Add("infourl", "/Finding/FinderDetail?id=" + item.ID.ToString());
infolist.Add(table);
}
}
return(Ok(new
{
infolist = infolist,
total = all,
code = code
}));
}
else
{
code = 500;
return(Ok(new
{
infolist = infolist,
total = all,
code = code
}));
}
}
