public List <CheckClient> Check_Client(CheckClientSearchCriteria criteria) { List <SqlParameter> parameters = new List <SqlParameter>(); parameters.AddInputParameter("@IsLastname", SqlDbType.Bit, criteria.IsLastname); parameters.AddInputParameter("@IsFirstname", SqlDbType.Bit, criteria.IsFirstname); parameters.AddInputParameter("@IsSecondname", SqlDbType.Bit, criteria.IsSecondname); parameters.AddInputParameter("@IsBirthday", SqlDbType.Bit, criteria.IsBirthday); parameters.AddInputParameter("@IsSex", SqlDbType.Bit, criteria.IsSex); parameters.AddInputParameter("@IsPolicySeries", SqlDbType.Bit, criteria.IsPolicySeries); parameters.AddInputParameter("@IsPolicyNumber", SqlDbType.Bit, criteria.IsPolicyNumber); parameters.AddInputParameter("@IsUnifiedPolicyNumber", SqlDbType.Bit, criteria.IsUnifiedPolicyNumber); parameters.AddInputParameter("@IsDocumentSeries", SqlDbType.Bit, criteria.IsDocumentSeries); parameters.AddInputParameter("@IsDocumentNumber", SqlDbType.Bit, criteria.IsDocumentNumber); List <CheckClient> result = Execute_GetList(CheckClientMaterializer.Instance, "Check_Client", parameters); return(result); }
public CheckClientSearchCriteria GetCheckClientSearchCriteria() { CheckClientSearchCriteria criteria = new CheckClientSearchCriteria() { IsLastname = this.IsLastname, IsFirstname = this.IsFirstname, IsSecondname = this.IsSecondname, IsBirthday = this.IsBirthday, IsSex = this.IsSex, IsPolicySeries = this.IsPolicySeries, IsPolicyNumber = this.IsPolicyNumber, IsUnifiedPolicyNumber = this.IsUnifiedPolicyNumber, IsDocumentSeries = this.IsDocumentSeries, IsDocumentNumber = this.IsDocumentNumber }; return(criteria); }
public List <CheckClient> Check_Client(CheckClientSearchCriteria criteria) { return(CheckDao.Instance.Check_Client(criteria)); }
public CheckClientReport(List <CheckClient> listCheckClient, long?countDublicate, CheckClientSearchCriteria criteriaSearch, ViewColumn viewColumn) { ListCheckClient = listCheckClient; CountDublicate = countDublicate; ViewColumn = viewColumn; TextCheck = string.Empty; if (criteriaSearch.IsLastname) { TextCheck = TextCheck + "Фамилия, "; } if (criteriaSearch.IsFirstname) { TextCheck = TextCheck + "Имя, "; } if (criteriaSearch.IsSecondname) { TextCheck = TextCheck + "Отчество, "; } if (criteriaSearch.IsBirthday) { TextCheck = TextCheck + "Дата рождения, "; } if (criteriaSearch.IsSex) { TextCheck = TextCheck + "Пол, "; } if (criteriaSearch.IsPolicySeries) { TextCheck = TextCheck + "Серия полиса, "; } if (criteriaSearch.IsPolicyNumber) { TextCheck = TextCheck + "Номер полиса, "; } if (criteriaSearch.IsUnifiedPolicyNumber) { TextCheck = TextCheck + "ЕНП, "; } if (criteriaSearch.IsDocumentSeries) { TextCheck = TextCheck + "Серия паспорта, "; } if (criteriaSearch.IsDocumentNumber) { TextCheck = TextCheck + "Номер паспорта, "; } if (!string.IsNullOrEmpty(TextCheck)) { TextCheck = TextCheck.Trim(',', ' '); } TemplatePath = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "bin", "Templates", "CheckClientReport.xlsx"); }