public ResponseResult <PageList <Plan> > GetPlanList([FromBody] PlanSearch search)
{
return(ToResponse(() =>
{
return _PlanRepo.GetPlans(search);
}));
}
public ActionResult Search(PlanSearch condition)
{
_DatatableResponseModel response = new _DatatableResponseModel();
PlanModel model = new PlanModel();
model.Search(condition);
return Json(model.Items);
}
public CurPageViewModel()
{
SearchCondition = new PlanSearch()
{
UnitName = AppSet.LoginUser.UnitName,
PageIndex = 1,
PageSize = 15
};
EntityPlans = new ObservableCollection <Lib.PlanEntity>();
CanVisible = "Collapsed";
}
public void Search(PlanSearch condition)
{
using (var entities = new DB_SWQUALEntities())
{
Items = new _DatatableResponseModel();
var result = from o in entities.plan
select o;
Items.data = result.ToList().Skip(condition.start).Take(condition.length).Select(MediaItemSelector).Cast<object>().ToList();
Items.draw = condition.draw;
Items.recordsFiltered = result.Count();
Items.recordsTotal = result.Count();
}
}
public PageList <Plan> GetPlans(PlanSearch search)
{
search.Page.OrderField = "p.CreateTime";
string sql = @" SELECT p.[AutoID],
p.[ID],
p.[Title],
p.[Author],
p.[Description],
p.[CreateTime],
p.[PlanType],
p.[DeleteFlag],
p.[AuthFlag],
p.[PlanCategory],
COUNT(jp.JobPlanID) ReferenceCount
FROM [Cherimoya].[dbo].[PlanDB] p (NOLOCK)
LEFT JOIN dbo.JobPlanDB jp (NOLOCK)
ON p.AutoID = jp.AutoID
AND jp.DeleteFlag = 0
WHERE p.DeleteFlag = 0 {0}
GROUP BY p.[AutoID],
p.[ID],
p.[Title],
p.[Author],
p.[Description],
p.[CreateTime],
p.[PlanType],
p.[DeleteFlag],
p.[AuthFlag],
p.[PlanCategory] ";
var param = "";
if (search.BeginDate.HasValue)
{
param += " AND p.CreateTime >= @BeginDate ";
}
if (search.EndDate.HasValue)
{
param += " AND p.CreateTime <= @EndDate ";
}
if (search.PlanType >= 0)
{
param += " AND p.PlanType = @PlanType ";
}
if (search.AuthFlag >= 0)
{
param += " AND p.AuthFlag = @PlanType ";
}
if (!string.IsNullOrEmpty(search.PlanCategory))
{
param += " AND p.PlanCategory = @PlanCategory ";
}
if (!string.IsNullOrEmpty(search.Author))
{
param += " AND p.Author = @Author ";
}
if (!string.IsNullOrEmpty(search.PlanName))
{
param += " AND p.Title Like '%" + search.PlanName + "%' ";
}
if (!string.IsNullOrEmpty(search.Desc))
{
param += " AND p.Description Like '%" + search.Desc + "%' ";
}
return(QueryPage <Plan>(string.Format(sql, param), search, search.Page));
}
