public DataPage <ClientBaseInfo> Client_Find( ClientSearchCriteria criteria, List <SortCriteria <ClientSortField> > sortCriteria, PageRequest pageRequest) { List <SqlParameter> parameters = new List <SqlParameter>(); parameters.AddInputParameter("@Firstname", SqlDbType.NVarChar, criteria.Firstname); parameters.AddInputParameter("@Secondname", SqlDbType.NVarChar, criteria.Secondname); parameters.AddInputParameter("@Lastname", SqlDbType.NVarChar, criteria.Lastname); parameters.AddInputParameter("@Birthday", SqlDbType.Date, criteria.Birthday); parameters.AddInputParameter("@TemporaryPolicyDateFrom", SqlDbType.Date, criteria.TemporaryPolicyDateFrom); parameters.AddInputParameter("@TemporaryPolicyDateTo", SqlDbType.Date, criteria.TemporaryPolicyDateTo); parameters.AddInputParameter("@TemporaryPolicyNumber", SqlDbType.NVarChar, criteria.TemporaryPolicyNumber); parameters.AddInputParameter("@PolicySeries", SqlDbType.NVarChar, criteria.PolicySeries); parameters.AddInputParameter("@PolicyNumber", SqlDbType.NVarChar, criteria.PolicyNumber); parameters.AddInputParameter("@PolicyDateFrom", SqlDbType.Date, criteria.PolicyDateFrom); parameters.AddInputParameter("@PolicyDateTo", SqlDbType.Date, criteria.PolicyDateTo); parameters.AddInputParameter("@UnifiedPolicyNumber", SqlDbType.NVarChar, criteria.UnifiedPolicyNumber); SqlParameter totalCountParameter = parameters.AddOutputParameter("@total_count", SqlDbType.Int); parameters.AddInputParameter("@sort_criteria", SqlDbType.Structured, DaoHelper.GetSortFieldsTable(sortCriteria)); parameters.AddInputParameter("@Page_size", SqlDbType.Int, pageRequest.PageSize); parameters.AddInputParameter("@Page_number", SqlDbType.Int, pageRequest.PageNumber); List <ClientBaseInfo> clients = Execute_GetList(ClientBaseInfoMaterializer.Instance, "Client_Find", parameters); return(DaoHelper.GetDataPage(clients, totalCountParameter, pageRequest)); }
public DataPage <BSOInfo> BSO_Find( BSOSearchCriteria criteria, List <SortCriteria <BSOSortField> > sortCriteria, PageRequest pageRequest) { List <SqlParameter> parameters = new List <SqlParameter>(); parameters.AddInputParameter("@TemporaryPolicyNumberFrom", SqlDbType.NVarChar, criteria.TemporaryPolicyNumberFrom); parameters.AddInputParameter("@TemporaryPolicyNumberTo", SqlDbType.NVarChar, criteria.TemporaryPolicyNumberTo); parameters.AddInputParameter("@PolicyPartyNumber", SqlDbType.NVarChar, criteria.PolicyPartyNumber); parameters.AddInputParameter("@StatusId", SqlDbType.BigInt, criteria.StatusId); parameters.AddInputParameter("@ResponsibleID", SqlDbType.BigInt, criteria.ResponsibleID); parameters.AddInputParameter("@StatusDateFrom", SqlDbType.Date, criteria.StatusDateFrom); parameters.AddInputParameter("@StatusDateTo", SqlDbType.Date, criteria.StatusDateTo); parameters.AddInputParameter("@ChangeDateFrom", SqlDbType.DateTime, criteria.ChangeDateFrom); parameters.AddInputParameter("@ChangeDateTo", SqlDbType.DateTime, criteria.ChangeDateTo); parameters.AddInputParameter("@DeliveryCenterIds", SqlDbType.Structured, DaoHelper.GetObjectIds(criteria.DeliveryCenterIds)); parameters.AddInputParameter("@DeliveryPointIds", SqlDbType.Structured, DaoHelper.GetObjectIds(criteria.DeliveryPointIds)); //parameters.AddInputParameter("@ResponsibleIDs", SqlDbType.Structured, DaoHelper.GetObjectIds(criteria.ResponsibleIDs)); SqlParameter totalCountParameter = parameters.AddOutputParameter("@total_count", SqlDbType.Int); parameters.AddInputParameter("@sort_criteria", SqlDbType.Structured, DaoHelper.GetSortFieldsTable(sortCriteria)); parameters.AddInputParameter("@Page_size", SqlDbType.Int, pageRequest.PageSize); parameters.AddInputParameter("@Page_number", SqlDbType.Int, pageRequest.PageNumber); List <BSOInfo> bsos = Execute_GetList(BSOInfoMaterializer.Instance, "BSO_Find", parameters); return(DaoHelper.GetDataPage(bsos, totalCountParameter, pageRequest)); }
public DataPage <ClientVisitInfo> ClientVisit_Find( ClientVisitSearchCriteria criteria, List <SortCriteria <ClientVisitSortField> > sortCriteria, PageRequest pageRequest) { List <SqlParameter> parameters = new List <SqlParameter>(); parameters.AddInputParameter("@ID", SqlDbType.BigInt, criteria.Id); parameters.AddInputParameter("@UnifiedPolicyNumber", SqlDbType.NVarChar, criteria.UnifiedPolicyNumber); parameters.AddInputParameter("@SNILS", SqlDbType.NVarChar, criteria.SNILS); parameters.AddInputParameter("@DocumentTypeId", SqlDbType.BigInt, criteria.DocumentTypeId); parameters.AddInputParameter("@DocumentNumber", SqlDbType.NVarChar, criteria.DocumentNumber); parameters.AddInputParameter("@DocumentSeries", SqlDbType.NVarChar, criteria.DocumentSeries); parameters.AddInputParameter("@TemporaryPolicyNumber", SqlDbType.NVarChar, criteria.TemporaryPolicyNumber); parameters.AddInputParameter("@TemporaryPolicyDateFrom", SqlDbType.DateTime, criteria.TemporaryPolicyDateFrom); parameters.AddInputParameter("@TemporaryPolicyDateTo", SqlDbType.DateTime, criteria.TemporaryPolicyDateTo); parameters.AddInputParameter("@PolicyNumber", SqlDbType.NVarChar, criteria.PolicyNumber); parameters.AddInputParameter("@PolicySeries", SqlDbType.NVarChar, criteria.PolicySeries); parameters.AddInputParameter("@PolicyDateFrom", SqlDbType.DateTime, criteria.PolicyDateFrom); parameters.AddInputParameter("@PolicyDateTo", SqlDbType.DateTime, criteria.PolicyDateTo); parameters.AddInputParameter("@UpdateDateFrom", SqlDbType.DateTime, criteria.UpdateDateFrom); parameters.AddInputParameter("@UpdateDateTo", SqlDbType.DateTime, criteria.UpdateDateTo); parameters.AddInputParameter("@StatusDateFrom", SqlDbType.DateTime, criteria.StatusDateFrom); parameters.AddInputParameter("@StatusDateTo", SqlDbType.DateTime, criteria.StetusDateTo); parameters.AddInputParameter("@Firstname", SqlDbType.NVarChar, criteria.Firstname); parameters.AddInputParameter("@Secondname", SqlDbType.NVarChar, criteria.Secondname); parameters.AddInputParameter("@Lastname", SqlDbType.NVarChar, criteria.Lastname); parameters.AddInputParameter("@UserId", SqlDbType.BigInt, criteria.UserId); parameters.AddInputParameter("@Birthday", SqlDbType.Date, criteria.Birthday); parameters.AddInputParameter("@PartyNumber", SqlDbType.NVarChar, criteria.PartyNumber); parameters.AddInputParameter("@DeliveryCenterIds", SqlDbType.Structured, DaoHelper.GetObjectIds(criteria.DeliveryCenterIds)); parameters.AddInputParameter("@DeliveryPointIds", SqlDbType.Structured, DaoHelper.GetObjectIds(criteria.DeliveryPointIds)); parameters.AddInputParameter("@StatusIds", SqlDbType.Structured, DaoHelper.GetObjectIds(criteria.StatusIds)); parameters.AddInputParameter("@ScenarioIds", SqlDbType.Structured, DaoHelper.GetObjectIds(criteria.ScenarioIds)); parameters.AddInputParameter("@IsTemporaryPolicyNumberNotEmpty", SqlDbType.Bit, criteria.IsTemporaryPolicyNumberNotEmpty); parameters.AddInputParameter("@IsActualInVisitGroup", SqlDbType.Bit, criteria.IsActualInVisitGroup); parameters.AddInputParameter("@IsReadyToFundSubmitRequest", SqlDbType.Bit, criteria.IsReadyToFundSubmitRequest); parameters.AddInputParameter("@IsDifficultCase", SqlDbType.Bit, criteria.IsDifficultCase); SqlParameter totalCountParameter = parameters.AddOutputParameter("@total_count", SqlDbType.Int); parameters.AddInputParameter("@sort_criteria", SqlDbType.Structured, DaoHelper.GetSortFieldsTable(sortCriteria)); parameters.AddInputParameter("@Page_size", SqlDbType.Int, pageRequest.PageSize); parameters.AddInputParameter("@Page_number", SqlDbType.Int, pageRequest.PageNumber); List <ClientVisitInfo> clients = Execute_GetList(ClientVisitInfoMaterializer.Instance, "ClientVisit_Find", parameters); return(DaoHelper.GetDataPage(clients, totalCountParameter, pageRequest)); }