public JsonResult GetCommentList(MvcAdapter.QueryBuilder qb) { string type = CommentType.Posting.ToString(); MvcAdapter.GridData gridData = entities.Set <S_D_Comment>().Where(c => c.Type == type && c.IsTemplate == "1").WhereToGridData(qb); return(Json(gridData)); }
public JsonResult GetListView(MvcAdapter.QueryBuilder qb) { string status = PostingStatus.Complete.ToString(); IQueryable <S_D_Incoming> query = entities.Set <S_D_Incoming>().Where(c => c.Status == status); MvcAdapter.GridData gridData = query.WhereToGridData(qb); return(Json(gridData, JsonRequestBehavior.AllowGet)); }
public JsonResult GetListView(MvcAdapter.QueryBuilder qb) { string status = PostingStatus.Complete.ToString(); IQueryable <S_D_Posting> query = entities.Set <S_D_Posting>().Where(c => c.Status == status); string companyDeptID = GetQueryString("CompanyDeptID"); UserInfo user = FormulaHelper.GetUserInfo(); string userID = user.UserID; if (!string.IsNullOrEmpty(companyDeptID)) { query = query.Where(c => c.CompanyDeptID == companyDeptID); } MvcAdapter.GridData gridData = query.WhereToGridData(qb); return(Json(gridData, JsonRequestBehavior.AllowGet)); }
public JsonResult GetListFlow(MvcAdapter.QueryBuilder qb) { MvcAdapter.GridData gridData = entities.Set <S_D_Posting>().Where(c => !string.IsNullOrEmpty(c.InsFlowID)).WhereToGridData(qb); return(Json(gridData)); }