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 List <FundRequestRecid> ClientVisitId_GetByFundRequesetRecid(IEnumerable <long> recids) { List <SqlParameter> parameters = new List <SqlParameter>(); parameters.AddInputParameter("@Recids", SqlDbType.Structured, DaoHelper.GetObjectIds(recids)); return(Execute_GetList <FundRequestRecid>(FundRequestRecidMaterializer.Instance, "ClientVisitId_GetByFundRequesetRecid", parameters)); }
public List <Nomernik.ClientShotInfo> ClientsShotInfo_Get(IEnumerable <long> listClientIds) { List <SqlParameter> parameters = new List <SqlParameter>(); parameters.AddInputParameter("@ClientIDs", SqlDbType.Structured, DaoHelper.GetObjectIds(listClientIds)); List <Nomernik.ClientShotInfo> list = Execute_GetList(NomernikClientShotInfoMaterializer.Instance, "NomernikClientsShotInfo_Get", parameters); return(list); }
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)); }
public List <BSOHistoryItem> BSO_GetListHistory(DateTime StatusDateFrom, DateTime StatusDateTo, List <long> BSO_IDs) { List <SqlParameter> parameters = new List <SqlParameter>(); parameters.AddInputParameter("@StatusDateFrom", SqlDbType.DateTime, StatusDateFrom); parameters.AddInputParameter("@StatusDateTo", SqlDbType.DateTime, StatusDateTo); var temp = DaoHelper.GetObjectIds(BSO_IDs); parameters.AddInputParameter("@BSO_IDs", SqlDbType.Structured, DaoHelper.GetObjectIds(BSO_IDs)); List <BSOHistoryItem> result = Execute_GetList(BSOHistoryItemMaterializer.Instance, "BSO_GetListHistory", parameters); return(result); }
public long User_Save(User.SaveData data) { List <SqlParameter> parameters = new List <SqlParameter>(); parameters.AddInputParameter("@Login", SqlDbType.NVarChar, data.Login); parameters.AddInputParameter("@PasswordHash", SqlDbType.NVarChar, data.PasswordHash); parameters.AddInputParameter("@DepartmentId", SqlDbType.BigInt, data.DepartmentId); parameters.AddInputParameter("@DeliveryPointId", SqlDbType.BigInt, data.DeliveryPointId); parameters.AddInputParameter("@Firstname", SqlDbType.NVarChar, data.Firstname); parameters.AddInputParameter("@Secondname", SqlDbType.NVarChar, data.Secondname); parameters.AddInputParameter("@Lastname", SqlDbType.NVarChar, data.Lastname); parameters.AddInputParameter("@Roles", SqlDbType.Structured, DaoHelper.GetObjectIds(data.Roles)); parameters.AddInputParameter("@SaveDate", SqlDbType.DateTime, DateTime.Now); parameters.AddInputParameter("@Position", SqlDbType.NVarChar, data.Position); parameters.AddInputParameter("@Email", SqlDbType.NVarChar, data.Email); parameters.AddInputParameter("@Phone", SqlDbType.NVarChar, data.Phone); SqlParameter userId = parameters.AddInputOutputParameter("@UserID", SqlDbType.BigInt, data.Id); Execute_StoredProcedure("User_Save", parameters); return((long)userId.Value); }