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