public ActionResult List(GridCommand command, HuSearchModel searchModel) { TempData["HuSearchModel"] = searchModel; ViewBag.PageSize = base.ProcessPageSize(command.PageSize); return View(); }
public ActionResult ShelfLifeWarningList(GridCommand command, HuSearchModel searchModel) { TempData["HuSearchModel"] = searchModel; ViewBag.SearchCondition = searchModel.SearchCondition; ViewBag.IsSumByItem = searchModel.IsSumByItem; ViewBag.PageSize = base.ProcessPageSize(command.PageSize); return View(); }
public ActionResult List(GridCommand command, HuSearchModel searchModel) { SearchCacheModel searchCacheModel = this.ProcessSearchModel(command, searchModel); if (searchCacheModel.isBack == true) { ViewBag.Page = searchCacheModel.Command.Page == 0 ? 1 : searchCacheModel.Command.Page; } ViewBag.PageSize = base.ProcessPageSize(command.PageSize); return View(); }
public ActionResult _AjaxList(GridCommand command, HuSearchModel searchModel) { TempData["HuSearchModel"] = searchModel; this.GetCommand(ref command, searchModel); SearchStatementModel searchStatementModel = PrepareSearchStatement(command, searchModel); var list = GetAjaxPageData<Hu>(searchStatementModel, command); foreach (var data in list.Data) { data.HuStatus = huMgr.GetHuStatus(data.HuId); data.ItemDescription = string.IsNullOrWhiteSpace(data.ReferenceItemCode) ? data.ItemDescription : data.ItemDescription + "[" + data.ReferenceItemCode + "]"; } return PartialView(list); }
private SearchStatementModel PrepareSearchStatementTime(GridCommand command, HuSearchModel searchModel) { string whereStatement = string.Empty; IList<object> param = new List<object>(); HqlStatementHelper.AddEqStatement("Item", searchModel.HuId, "h", ref whereStatement, param); HqlStatementHelper.AddEqStatement("LocTo", searchModel.Location, "h", ref whereStatement, param); //if (searchModel.RemindExpireDate_start != null & searchModel.RemindExpireDate_End != null) //{ // HqlStatementHelper.AddBetweenStatement("RemindExpireDate", searchModel.RemindExpireDate_start, searchModel.RemindExpireDate_End, "h", ref whereStatement, param); //} //else if (searchModel.RemindExpireDate_start != null & searchModel.RemindExpireDate_End == null) //{ // HqlStatementHelper.AddGeStatement("RemindExpireDate", searchModel.RemindExpireDate_start, "h", ref whereStatement, param); //} //else if (searchModel.RemindExpireDate_start == null & searchModel.RemindExpireDate_End != null) //{ // HqlStatementHelper.AddLeStatement("RemindExpireDate", searchModel.RemindExpireDate_End, "h", ref whereStatement, param); //} //else //{ //HqlStatementHelper.AddLeStatement("RemindExpireDate", DateTime.Now, "h", ref whereStatement, param); //} if (searchModel.StartDate != null & searchModel.EndDate != null) { HqlStatementHelper.AddBetweenStatement("CreateDate", searchModel.StartDate, searchModel.EndDate, "h", ref whereStatement, param); } else if (searchModel.StartDate != null & searchModel.EndDate == null) { HqlStatementHelper.AddGeStatement("CreateDate", searchModel.StartDate, "h", ref whereStatement, param); } else if (searchModel.StartDate == null & searchModel.EndDate != null) { HqlStatementHelper.AddLeStatement("CreateDate", searchModel.EndDate, "h", ref whereStatement, param); } string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors); SearchStatementModel searchStatementModel = new SearchStatementModel(); searchStatementModel.SelectCountStatement = selectCountStatement; searchStatementModel.SelectStatement = selectStatement; searchStatementModel.WhereStatement = whereStatement; searchStatementModel.SortingStatement = sortingStatement; searchStatementModel.Parameters = param.ToArray<object>(); return searchStatementModel; }
private SearchStatementModel PrepareSearchStatement(GridCommand command, HuSearchModel searchModel) { string whereStatement = string.Empty; IList<object> param = new List<object>(); HqlStatementHelper.AddLikeStatement("HuId", searchModel.HuId, HqlStatementHelper.LikeMatchMode.Anywhere, "h", ref whereStatement, param); HqlStatementHelper.AddLikeStatement("CreateUserName", searchModel.CreateUserName, HqlStatementHelper.LikeMatchMode.Start, "h", ref whereStatement, param); HqlStatementHelper.AddEqStatement("Item", searchModel.Item, "h", ref whereStatement, param); HqlStatementHelper.AddEqStatement("SupplierLotNo", searchModel.SupplierLotNo, "h", ref whereStatement, param); if (searchModel.LotNo != null & searchModel.LotNoTo != null) { HqlStatementHelper.AddBetweenStatement("LotNo", searchModel.LotNo, searchModel.LotNoTo, "h", ref whereStatement, param); } else if (searchModel.LotNo != null & searchModel.LotNoTo == null) { HqlStatementHelper.AddGeStatement("LotNo", searchModel.LotNo, "h", ref whereStatement, param); } else if (searchModel.LotNo == null & searchModel.LotNoTo != null) { HqlStatementHelper.AddLeStatement("LotNo", searchModel.LotNoTo, "h", ref whereStatement, param); } if (searchModel.StartDate != null & searchModel.EndDate != null) { HqlStatementHelper.AddBetweenStatement("CreateDate", searchModel.StartDate, searchModel.EndDate, "h", ref whereStatement, param); } else if (searchModel.StartDate != null & searchModel.EndDate == null) { HqlStatementHelper.AddGeStatement("CreateDate", searchModel.StartDate, "h", ref whereStatement, param); } else if (searchModel.StartDate == null & searchModel.EndDate != null) { HqlStatementHelper.AddLeStatement("CreateDate", searchModel.EndDate, "h", ref whereStatement, param); } if (searchModel.RemindExpireDate_start != null & searchModel.RemindExpireDate_End != null) { HqlStatementHelper.AddBetweenStatement("RemindExpireDate", searchModel.RemindExpireDate_start, searchModel.RemindExpireDate_End, "h", ref whereStatement, param); } else if (searchModel.RemindExpireDate_start != null & searchModel.RemindExpireDate_End == null) { HqlStatementHelper.AddGeStatement("RemindExpireDate", searchModel.RemindExpireDate_start, "h", ref whereStatement, param); } else if (searchModel.RemindExpireDate_start == null & searchModel.RemindExpireDate_End != null) { HqlStatementHelper.AddLeStatement("RemindExpireDate", searchModel.RemindExpireDate_End, "h", ref whereStatement, param); } string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors); if (command.SortDescriptors.Count == 0) { sortingStatement = " order by CreateDate desc"; } SearchStatementModel searchStatementModel = new SearchStatementModel(); searchStatementModel.SelectCountStatement = selectCountStatement; searchStatementModel.SelectStatement = selectStatement; searchStatementModel.WhereStatement = whereStatement; searchStatementModel.SortingStatement = sortingStatement; searchStatementModel.Parameters = param.ToArray<object>(); return searchStatementModel; }
public ActionResult _AjaxList(GridCommand command, HuSearchModel searchModel) { SearchStatementModel searchStatementModel = this.PrepareSearchStatement(command, searchModel); return PartialView(GetAjaxPageData<SmallSparePartChk>(searchStatementModel, command)); }
public ActionResult List(GridCommand command, HuSearchModel searchModel) { SearchCacheModel searchCacheModel = this.ProcessSearchModel(command, searchModel); ViewBag.PageSize = base.ProcessPageSize(command.PageSize); return View(); }
public void ExportXLS(HuSearchModel searchModel) { int value = System.Convert.ToInt32(base.systemMgr.GetEntityPreferenceValue(EntityPreference.CodeEnum.MaxRowSizeOnPage)); GridCommand command = new GridCommand(); command.Page = 1; command.PageSize = value; SearchStatementModel searchStatementModel = this.PrepareSearchStatement(command, searchModel); GridModel<SmallSparePartChk> gridModel = GetAjaxPageData<SmallSparePartChk>(searchStatementModel, command); var fileName = string.Format("SmallMatchSparePartCheck.xls"); ExportToXLS<SmallSparePartChk>(fileName, gridModel.Data.ToList()); }
/// <summary> /// Search Statement /// </summary> /// <param name="command">Telerik GridCommand</param> /// <param name="searchModel">SmallSparePartChk Search Model</param> /// <returns>return Search Statement</returns> private SearchStatementModel PrepareSearchStatement(GridCommand command, HuSearchModel searchModel) { string whereStatement = string.Empty; IList<object> param = new List<object>(); HqlStatementHelper.AddLikeStatement("Huid", searchModel.HuId, HqlStatementHelper.LikeMatchMode.Start, "i", ref whereStatement, param); HqlStatementHelper.AddLikeStatement("SpareItem", searchModel.SpareItem, HqlStatementHelper.LikeMatchMode.Start, "i", ref whereStatement, param); HqlStatementHelper.AddLikeStatement("HuItem", searchModel.HuItem, HqlStatementHelper.LikeMatchMode.Start, "i", ref whereStatement, param); HqlStatementHelper.AddLikeStatement("CreateUserName", searchModel.CreateUserName, HqlStatementHelper.LikeMatchMode.Start, "i", ref whereStatement, param); if (searchModel.StartDate != null & searchModel.EndDate != null) { HqlStatementHelper.AddBetweenStatement("CreateDate", searchModel.StartDate, searchModel.EndDate, "i", ref whereStatement, param); } else if (searchModel.StartDate != null & searchModel.EndDate == null) { HqlStatementHelper.AddGeStatement("CreateDate", searchModel.StartDate, "i", ref whereStatement, param); } else if (searchModel.StartDate == null & searchModel.EndDate != null) { HqlStatementHelper.AddLeStatement("CreateDate", searchModel.EndDate, "i", ref whereStatement, param); } string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors); if (string.IsNullOrWhiteSpace(sortingStatement)) { sortingStatement = " order by i.CreateDate "; } SearchStatementModel searchStatementModel = new SearchStatementModel(); searchStatementModel.SelectCountStatement = selectCountStatement; searchStatementModel.SelectStatement = selectStatement; searchStatementModel.WhereStatement = whereStatement; searchStatementModel.SortingStatement = sortingStatement; searchStatementModel.Parameters = param.ToArray<object>(); return searchStatementModel; }
public ActionResult _AjaxList(GridCommand command, HuSearchModel searchModel) { TempData["HuSearchModel"] = searchModel; SearchStatementModel searchStatementModel = PrepareSearchStatement(command, searchModel); return PartialView(GetAjaxPageData<Hu>(searchStatementModel, command)); }
public ActionResult _AjaxShelfLifeWarningList(GridCommand command, HuSearchModel searchModel) { SearchStatementModel searchStatementModel = PrepareSearchStatementTime(command, searchModel); return PartialView(GetAjaxPageData<Hu>(searchStatementModel, command)); }
private SearchStatementModel PrepareSearchStatement(GridCommand command, HuSearchModel searchModel) { string whereStatement = string.Empty; com.Sconit.Entity.ACC.User user = SecurityContextHolder.Get(); IList<object> param = new List<object>(); HqlStatementHelper.AddLikeStatement("HuId", searchModel.HuId, HqlStatementHelper.LikeMatchMode.Start, "h", ref whereStatement, param); HqlStatementHelper.AddEqStatement("Item", searchModel.Item, "h", ref whereStatement, param); HqlStatementHelper.AddLikeStatement("LotNo", searchModel.lotNo, HqlStatementHelper.LikeMatchMode.Start, "h", ref whereStatement, param); HqlStatementHelper.AddEqStatement("ManufactureParty", searchModel.ManufactureParty, "h", ref whereStatement, param); HqlStatementHelper.AddEqStatement("CreateUserId", user.Id, "h", ref whereStatement, param); if (searchModel.StartDate != null & searchModel.EndDate != null) { HqlStatementHelper.AddBetweenStatement("CreateDate", searchModel.StartDate, searchModel.EndDate, "h", ref whereStatement, param); } else if (searchModel.StartDate != null & searchModel.EndDate == null) { HqlStatementHelper.AddGeStatement("CreateDate", searchModel.StartDate, "h", ref whereStatement, param); } else if (searchModel.StartDate == null & searchModel.EndDate != null) { HqlStatementHelper.AddLeStatement("CreateDate", searchModel.EndDate, "h", ref whereStatement, param); } string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors); if (command.SortDescriptors.Count == 0) { sortingStatement = " order by CreateDate desc"; } SearchStatementModel searchStatementModel = new SearchStatementModel(); searchStatementModel.SelectCountStatement = selectCountStatement; searchStatementModel.SelectStatement = selectStatement; searchStatementModel.WhereStatement = whereStatement; searchStatementModel.SortingStatement = sortingStatement; searchStatementModel.Parameters = param.ToArray<object>(); return searchStatementModel; }