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());
}
