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