private SearchStatementModel PrepareInstanceSearchStatement(GridCommand command, ProdLineExInstanceSearchModel searchModel)
{
string whereStatement = string.Empty;
IList<object> param = new List<object>();
if (searchModel.DateType != null)
{
if (searchModel.DateType.Value == 4)
{
if (searchModel.DateIndexDate != null & searchModel.DateIndexToDate != null)
{
HqlStatementHelper.AddBetweenStatement("DateIndex", searchModel.DateIndexDate.Value.ToString("yyyy-MM-dd"), searchModel.DateIndexToDate.Value.ToString("yyyy-MM-dd"), "p", ref whereStatement, param);
}
else if (searchModel.DateIndexDate != null & searchModel.DateIndexToDate == null)
{
HqlStatementHelper.AddGeStatement("DateIndex", searchModel.DateIndexDate.Value.ToString("yyyy-MM-dd"), "p", ref whereStatement, param);
}
else if (searchModel.DateIndexDate == null & searchModel.DateIndexToDate != null)
{
HqlStatementHelper.AddLeStatement("DateIndex", searchModel.DateIndexToDate.Value.ToString("yyyy-MM-dd"), "p", ref whereStatement, param);
}
}
else
{
if (!string.IsNullOrEmpty(searchModel.DateIndex) & !string.IsNullOrEmpty(searchModel.DateIndexTo))
{
HqlStatementHelper.AddBetweenStatement("DateIndex", searchModel.DateIndex, searchModel.DateIndexTo, "p", ref whereStatement, param);
}
else if (!string.IsNullOrEmpty(searchModel.DateIndex) & string.IsNullOrEmpty(searchModel.DateIndexTo))
{
HqlStatementHelper.AddGeStatement("DateIndex", searchModel.DateIndex, "p", ref whereStatement, param);
}
else if (string.IsNullOrEmpty(searchModel.DateIndex) & !string.IsNullOrEmpty(searchModel.DateIndexTo))
{
HqlStatementHelper.AddLeStatement("DateIndex", searchModel.DateIndexTo, "p", ref whereStatement, param);
}
}
}
HqlStatementHelper.AddEqStatement("ProductLine", searchModel.ProductLine, "p", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("Item", searchModel.Item, "p", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("SnapTime", searchModel.SnapTime, "p", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("ShiftType", searchModel.ShiftType, "p", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("ApsPriority", searchModel.ApsPriority, "p", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("DateType", searchModel.DateType, "p", ref whereStatement, param);
string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors);
if (command.SortDescriptors.Count == 0)
{
sortingStatement = " order by p.DateType,p.ProductLine,p.DateIndex,p.Item";
}
SearchStatementModel searchStatementModel = new SearchStatementModel();
searchStatementModel.SelectCountStatement = selectInstanceCountStatement;
searchStatementModel.SelectStatement = selectInstanceStatement;
searchStatementModel.WhereStatement = whereStatement;
searchStatementModel.SortingStatement = sortingStatement;
searchStatementModel.Parameters = param.ToArray<object>();
return searchStatementModel;
}
public ActionResult _AjaxInstanceList(GridCommand command, ProdLineExInstanceSearchModel searchModel)
{
SearchStatementModel searchStatementModel = this.PrepareInstanceSearchStatement(command, searchModel);
var list = GetAjaxPageData<SnapProdLineEx>(searchStatementModel, command);
var productType = genericMgr.FindAll<ProductType>("from ProductType as i");
foreach (var listdata in list.Data)
{
listdata.ItemDesc = itemMgr.GetCacheItem(listdata.Item).Description;
listdata.ProductTypeDescription = productType.Where(p => p.Code == listdata.ProductType).FirstOrDefault().Description;
}
return PartialView(list);
}
public void ExportXLS(ProdLineExInstanceSearchModel searchModel)
{
int value = Convert.ToInt32(base.systemMgr.GetEntityPreferenceValue(com.Sconit.Entity.SYS.EntityPreference.CodeEnum.MaxRowSizeOnPage));
GridCommand command = new GridCommand();
command.Page = 1;
command.PageSize = value;
SearchStatementModel searchStatementModel = this.PrepareInstanceSearchStatement(command, searchModel);
var fileName = string.Format("EXCalendar.xls");
ExportToXLS<SnapProdLineEx>(fileName, GetAjaxPageData<SnapProdLineEx>(searchStatementModel, command).Data.ToList());
}
public ActionResult InstanceList(GridCommand command, ProdLineExInstanceSearchModel searchModel)
{
SearchCacheModel searchCacheModel = this.ProcessSearchModel(command, searchModel);
ViewBag.PageSize = base.ProcessPageSize(command.PageSize);
ViewBag.DateType = searchModel.DateType == null ? null : searchModel.DateType.ToString();
return View();
}