private SearchStatementModel PrepareSearchShipAddressStatement(GridCommand command, PartyAddressSearchModel searchModel, string partyCode) { string whereStatement = " where pa.Party='" + partyCode + "' and pa.Type='0' "; IList<object> param = new List<object>(); //HqlStatementHelper.AddLikeStatement("Party", searchModel.Party, HqlStatementHelper.LikeMatchMode.Start, "pa", ref whereStatement, param); HqlStatementHelper.AddLikeStatement("Address.Code", searchModel.AddressCode, HqlStatementHelper.LikeMatchMode.Start, "pa", ref whereStatement, param); HqlStatementHelper.AddLikeStatement("Address.AddressContent", searchModel.AddressContent, HqlStatementHelper.LikeMatchMode.Start, "pa", ref whereStatement, param); string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors); SearchStatementModel searchStatementModel = new SearchStatementModel(); searchStatementModel.SelectCountStatement = selectShipAddressCountStatement; searchStatementModel.SelectStatement = selectShipAddressStatement; searchStatementModel.WhereStatement = whereStatement; searchStatementModel.SortingStatement = sortingStatement; searchStatementModel.Parameters = param.ToArray<object>(); return searchStatementModel; }
public ActionResult _AjaxShipAddressList(GridCommand command, PartyAddressSearchModel searchModel, string PartyCode) { SearchStatementModel searchStatementModel = PrepareSearchShipAddressStatement(command, searchModel, PartyCode); return PartialView(GetAjaxPageData<PartyAddress>(searchStatementModel, command)); }
public ActionResult _ShipAddressList(GridCommand command, PartyAddressSearchModel searchModel, string PartyCode) { ViewBag.PartyCode = PartyCode; SearchCacheModel searchCacheModel = ProcessSearchModel(command, searchModel); return PartialView(); }
public ActionResult _ShipAddressList(GridCommand command, PartyAddressSearchModel searchModel, string PartyCode) { ViewBag.PartyCode = PartyCode; SearchCacheModel searchCacheModel = ProcessSearchModel(command, searchModel); SearchStatementModel searchStatementModel = PrepareSearchShipAddressStatement(command, (PartyAddressSearchModel)searchCacheModel.SearchObject, PartyCode); return PartialView(GetPageData<PartyAddress>(searchStatementModel, command)); }
public ActionResult _BillAddressList(GridCommand command, PartyAddressSearchModel searchModel, string PartyCode) { ViewBag.PartyCode = PartyCode; SearchCacheModel searchCacheModel = this.ProcessSearchModel(command, searchModel); ViewBag.PageSize = this.ProcessPageSize(command.PageSize); return PartialView(); }