public ActionResult List(GridCommand command, AliquotStartTaskSearchModel searchModel) { if (string.IsNullOrWhiteSpace(searchModel.SearchFlow)) { SaveWarningMessage(Resources.ErrorMessage.Errors_Common_FieldRequired, Resources.ORD.AliquotStartTask.AliquotStartTask_KitFlow); } this.ProcessSearchModel(command, searchModel); return View(); }
public ActionResult _AjaxList(GridCommand command, AliquotStartTaskSearchModel searchModel) { if (string.IsNullOrWhiteSpace(searchModel.SearchFlow)) { return PartialView(new GridModel<AliquotStartTask> { Data = new List<AliquotStartTask>() }); } SearchNativeSqlStatementModel searchStatementModel = this.PrepareStartSearchStatement(command, searchModel); var list = GetPageDataEntityWithNativeSql<AliquotStartTaskView>(searchStatementModel, command); return PartialView(list); }
public ActionResult _StartSearchResult(GridCommand command, AliquotStartTaskSearchModel searchModel) { SearchCacheModel searchCacheModel = this.ProcessSearchModel(command, searchModel); ViewBag.PageSize = base.ProcessPageSize(command.PageSize); return View(); }
/// <summary> /// Search Statement /// </summary> /// <param name="command">Telerik GridCommand</param> /// <param name="searchModel">AliquotStartTask Search Model</param> /// <returns>return AliquotStartTask search model</returns> private SearchNativeSqlStatementModel PrepareStartSearchStatement(GridCommand command, AliquotStartTaskSearchModel searchModel) { int coveredDays = int.Parse(systemMgr.GetEntityPreferenceValue(com.Sconit.Entity.SYS.EntityPreference.CodeEnum.CoveredDaysOfKitProduction)); var selectStatement = string.Empty; if (searchModel.SearchIsStart) { selectStatement = " select m.OrderNo,m.Flow,m.TraceCode,d.Item,d.ItemDesc,t.StartTime from ORD_AliquotStartTask t WITH(NOLOCK) " + " inner join ORD_OrderMstr_4 m WITH(NOLOCK) on t.OrderNo=m.OrderNo inner join ORD_OrderDet_4 d WITH(NOLOCK) on m.Orderno=d.OrderNo" + " where t.Flow='" + searchModel.SearchFlow + "' and t.StartTime Between '" + DateTime.Today.AddDays(1 - coveredDays) + "' and '" + DateTime.Today.AddDays(1) + "'"; } else { selectStatement = "select m.OrderNo,m.Flow,m.TraceCode,d.Item,d.ItemDesc,Min(p.CPTime) as StartTime from ORD_OrderOpCPTime p WITH(NOLOCK) " + " inner join ORD_OrderMstr_4 m WITH(NOLOCK) on p.OrderNo=m.OrderNo inner join ORD_OrderDet_4 d WITH(NOLOCK) on m.OrderNo=d.OrderNo" + " where not exists(select 1 from ORD_AliquotStartTask t WITH(NOLOCK) where t.Flow=p.AssProdLine and m.TraceCode =t.VanNo and m.OrderNo=t.OrderNo) " + " and p.AssProdLine ='" + searchModel.SearchFlow + "'"; if (!string.IsNullOrWhiteSpace(searchModel.SearchVanFlow)) selectStatement += string.Format(" and p.VanProdLine ='{0}'", searchModel.SearchVanFlow); selectStatement += " group by m.OrderNo,m.Flow,m.TraceCode,d.Item,d.ItemDesc"; } string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors); if (string.IsNullOrWhiteSpace(sortingStatement)) { if (!searchModel.SearchIsStart) sortingStatement = " order by StartTime asc "; else sortingStatement = " order by StartTime desc "; } SearchNativeSqlStatementModel searchStatementModel = new SearchNativeSqlStatementModel(); searchStatementModel.SelectSql = selectStatement; searchStatementModel.SortingStatement = sortingStatement; return searchStatementModel; }
public void ExportXLS(GridCommand command, AliquotStartTaskSearchModel searchModel) { string maxRows = this.systemMgr.GetEntityPreferenceValue(EntityPreference.CodeEnum.ExportMaxRows); command.PageSize = int.Parse(maxRows); SearchNativeSqlStatementModel searchStatementModel = this.PrepareStartSearchStatement(command, searchModel); var list = GetPageDataEntityWithNativeSql<AliquotStartTaskView>(searchStatementModel, command); ExportToXLS<AliquotStartTaskView>("AliquotStartTaskView", "XLS", list.Data.ToList()); }