public int getLastISN()
{
if (ContractRegistrationLogLastRecord != null)
{
return(ContractRegistrationLogLastRecord.ISN);
}
// Смотрим, какой наибольший номер есть в базе
//CriteriaOperator criteriaISN = CriteriaOperator.Parse("ISN = Max(ISN)");
//SortingCollection sorting = new SortingCollection();
////sorting.Add(new SortProperty("", SortingDirection.Ascending));
//sorting.Add(new SortProperty("ISN", DevExpress.Xpo.DB.SortingDirection.Descending));
SortProperty[] sorting = { new SortProperty("ISN", DevExpress.Xpo.DB.SortingDirection.Descending) };
//XPCollection<crmContractRegistrationLog> crl = new XPCollection<crmContractRegistrationLog>(this.Session, criteriaISN, sorting);
XPCollection <crmContractRegistrationLog> crl = new XPCollection <crmContractRegistrationLog>(this.Session, null, sorting);
crl.TopReturnedObjects = 1;
if (!crl.IsLoaded)
{
crl.Load();
}
if (crl.Count > 0)
{
ContractRegistrationLogLastRecord = crl[0];
return(crl[0].ISN);
}
else
{
return(0);
}
}
public int getConditionalLastISN()
{
if (ContractRegistrationLogConditionalLastRecord != null)
{
return(ContractRegistrationLogConditionalLastRecord.ISN);
}
// Смотрим, какой наибольший номер есть в базе
CriteriaOperator criteria = null;
criteria = new GroupOperator();
((GroupOperator)criteria).OperatorType = GroupOperatorType.And;
CriteriaOperator criteriaDocNumberYear = new BinaryOperator("DocNumberYear", DocNumberYear, BinaryOperatorType.Equal);
((GroupOperator)criteria).Operands.Add(criteriaDocNumberYear);
//CriteriaOperator criteriaDocNumberDepartment = null;
//if (!string.IsNullOrEmpty(DocNumberDepartment)) {
// criteriaDocNumberDepartment = new BinaryOperator("DocNumberDepartment", DocNumberDepartment, BinaryOperatorType.Equal);
// ((GroupOperator)criteria).Operands.Add(criteriaDocNumberDepartment);
//}
CriteriaOperator criteriaDocNumberDepartment = null;
if (DepartmentRegistrator != null)
{
criteriaDocNumberDepartment = new BinaryOperator("DepartmentRegistrator", DepartmentRegistrator, BinaryOperatorType.Equal);
((GroupOperator)criteria).Operands.Add(criteriaDocNumberDepartment);
}
SortProperty[] sorting = { new SortProperty("ISN", DevExpress.Xpo.DB.SortingDirection.Descending) };
//XPCollection<crmContractRegistrationLog> crl = new XPCollection<crmContractRegistrationLog>(this.Session, criteriaISN, sorting);
XPCollection <crmContractRegistrationLog> crl = new XPCollection <crmContractRegistrationLog>(this.Session, criteria, sorting);
crl.TopReturnedObjects = 1;
if (!crl.IsLoaded)
{
crl.Load();
}
if (crl.Count > 0)
{
ContractRegistrationLogConditionalLastRecord = crl[0];
return(crl[0].ISN);
}
else
{
return(0);
}
}