46 lines
1.4 KiB
C#
46 lines
1.4 KiB
C#
using System;
|
|
using System.Collections.Generic;
|
|
using System.Linq;
|
|
using System.Text;
|
|
using BeWo.Data.Access;
|
|
using BeWo.Service.Plugins;
|
|
using BS.Shared;
|
|
using BS.Shared.Core;
|
|
using BS.Shared.DataContracts;
|
|
using BS.Shared.Extensions;
|
|
using BS.Shared.Services;
|
|
|
|
namespace ASBHammReports.Service
|
|
{
|
|
|
|
public class CustomSaveInterceptor : SaveInterceptor
|
|
{
|
|
public override string AllowSaveCustomer(CustomerDC c)
|
|
{
|
|
if (String.IsNullOrWhiteSpace(c.DebitorNumber))
|
|
{
|
|
int newNummer = 1;
|
|
|
|
var result = DAOFactory.SearchDAO.GetSqlResult("SELECT Max(CONVERT(DebitorNumber, UNSIGNED INTEGER)) FROM customer");
|
|
//
|
|
//update customer set debitornumber = '5' + debitornumber where debitornumber is not null
|
|
if (result.Count > 0)
|
|
{
|
|
var test = result[0];
|
|
int p = 0;
|
|
if (test != null && Int32.TryParse(test.ToString(), out p))
|
|
{
|
|
if (p < 5330099)
|
|
{
|
|
p = 5330099;
|
|
}
|
|
newNummer = p + 1;
|
|
}
|
|
}
|
|
|
|
c.DebitorNumber = newNummer.ToString();
|
|
}
|
|
return base.AllowSaveCustomer(c);
|
|
}
|
|
}
|
|
} |