public virtual ISession OpenSession()
{
ISession session = OrmConfig.OpenSession(progressInterceptor);
session.FlushMode = FlushMode.Commit;
return(session);
}
public static void ConfigureNh()
{
if (NhConfigered)
{
return;
}
Console.WriteLine("Инициализация");
var db_config = FluentNHibernate.Cfg.Db.MySQLConfiguration.Standard
.Dialect <NHibernate.Spatial.Dialect.MySQL57SpatialDialect>()
.ConnectionString("server=vod.qsolution.ru;port=3306;database=test-test;user id=test_only;password=7qqKWuNugQF2Y2W1;sslmode=None;");
Console.WriteLine("ORM");
// Настройка ORM
OrmConfig.ConfigureOrm(db_config, new System.Reflection.Assembly[]
{
System.Reflection.Assembly.GetAssembly(typeof(QS.Project.HibernateMapping.UserBaseMap)),
System.Reflection.Assembly.GetAssembly(typeof(Vodovoz.HibernateMapping.OrganizationMap)),
System.Reflection.Assembly.GetAssembly(typeof(QS.Project.HibernateMapping.TypeOfEntityMap)),
System.Reflection.Assembly.GetAssembly(typeof(QS.Banks.HMap.BankMap)),
System.Reflection.Assembly.GetAssembly(typeof(QS.HistoryLog.HistoryMain)),
System.Reflection.Assembly.GetAssembly(typeof(QS.Attachments.Domain.Attachment))
});
NhConfigered = true;
}
public static bool NHibernateStaleObjectStateExceptionHandler(Exception exception, IApplicationInfo application, UserBase user, IInteractiveMessage interactiveMessage)
{
var staleObjectStateException = ExceptionHelper.FindExceptionTypeInInner <NHibernate.StaleObjectStateException>(exception);
if (staleObjectStateException != null)
{
var type = OrmConfig.FindMappingByFullClassName(staleObjectStateException.EntityName).MappedClass;
var objectName = DomainHelper.GetSubjectNames(type);
string message;
switch (objectName?.Gender)
{
case GrammaticalGender.Feminine:
message = "Сохраняемая <b>{0}</b> c номером <b>{1}</b> была кем то изменена.";
break;
case GrammaticalGender.Neuter:
message = "Сохраняемое <b>{0}</b> c номером <b>{1}</b> было кем то изменено.";
break;
case GrammaticalGender.Masculine:
default:
message = "Сохраняемый <b>{0}</b> c номером <b>{1}</b> был кем то изменен.";
break;
}
message = String.Format(message + "\nВаши изменения не будут записаны, чтобы не потерять чужие изменения. \nПереоткройте вкладку.", objectName?.Nominative ?? type.Name, staleObjectStateException.Identifier);
interactiveMessage.ShowMessage(QS.Dialog.ImportanceLevel.Warning, message);
return(true);
}
return(false);
}
public static void ShowExceptionMessage(Exception ex)
{
if (ex is StaleObjectStateException staleObjectStateException)
{
var type = OrmConfig.FindMappingByFullClassName(staleObjectStateException.EntityName).MappedClass;
var objectName = DomainHelper.GetSubjectNames(type);
string message;
switch (objectName.Gender)
{
case GrammaticalGender.Feminine:
message = "Сохраняемая <b>{0}</b> c номером <b>{1}</b> была кем то изменена.";
break;
case GrammaticalGender.Neuter:
message = "Сохраняемое <b>{0}</b> c номером <b>{1}</b> было кем то изменено.";
break;
case GrammaticalGender.Masculine:
default:
message = "Сохраняемый <b>{0}</b> c номером <b>{1}</b> был кем то изменен.";
break;
}
message = String.Format(message + "\nВаши изменения не будут записаны, чтобы не потерять чужие изменения. \nПереоткройте вкладку.", objectName?.Nominative ?? type.Name, staleObjectStateException.Identifier);
MessageDialogHelper.RunErrorDialog(message);
}
}
private void ConfigureDlg()
{
notebook1.Page = 0;
notebook1.ShowTabs = false;
dataentryModel.Binding.AddBinding(Entity, e => e.Model, w => w.Text).InitializeFromSource();
dataentryRegNumber.Binding.AddBinding(Entity, e => e.RegistrationNumber, w => w.Text).InitializeFromSource();
yentryVIN.Binding.AddBinding(Entity, e => e.VIN, w => w.Text).InitializeFromSource();
yentryManufactureYear.Binding.AddBinding(Entity, e => e.ManufactureYear, w => w.Text).InitializeFromSource();
yentryMotorNumber.Binding.AddBinding(Entity, e => e.MotorNumber, w => w.Text).InitializeFromSource();
yentryChassisNumber.Binding.AddBinding(Entity, e => e.ChassisNumber, w => w.Text).InitializeFromSource();
yentryCarcaseNumber.Binding.AddBinding(Entity, e => e.Carcase, w => w.Text).InitializeFromSource();
yentryColor.Binding.AddBinding(Entity, e => e.Color, w => w.Text).InitializeFromSource();
yentryDocSeries.Binding.AddBinding(Entity, e => e.DocSeries, w => w.Text).InitializeFromSource();
yentryDocNumber.Binding.AddBinding(Entity, e => e.DocNumber, w => w.Text).InitializeFromSource();
yentryDocIssuedOrg.Binding.AddBinding(Entity, e => e.DocIssuedOrg, w => w.Text).InitializeFromSource();
ydatepickerDocIssuedDate.Binding.AddBinding(Entity, e => e.DocIssuedDate, w => w.DateOrNull).InitializeFromSource();
var filter = new EmployeeFilter(UoW);
filter.SetAndRefilterAtOnce(x => x.RestrictCategory = EmployeeCategory.driver);
dataentryreferenceDriver.RepresentationModel = new EmployeesVM(filter);
dataentryreferenceDriver.Binding.AddBinding(Entity, e => e.Driver, w => w.Subject).InitializeFromSource();
dataentryFuelType.SubjectType = typeof(FuelType);
dataentryFuelType.Binding.AddBinding(Entity, e => e.FuelType, w => w.Subject).InitializeFromSource();
radiobuttonMain.Active = true;
dataspinbutton1.Binding.AddBinding(Entity, e => e.FuelConsumption, w => w.Value).InitializeFromSource();
maxWeightSpin.Binding.AddBinding(Entity, e => e.MaxWeight, w => w.ValueAsInt).InitializeFromSource();
maxVolumeSpin.Binding.AddBinding(Entity, e => e.MaxVolume, w => w.Value).InitializeFromSource();
minBottlesSpin.Binding.AddBinding(Entity, e => e.MinBottles, w => w.ValueAsInt).InitializeFromSource();
maxBottlesSpin.Binding.AddBinding(Entity, e => e.MaxBottles, w => w.ValueAsInt).InitializeFromSource();
minAddressesSpin.Binding.AddBinding(Entity, e => e.MinRouteAddresses, w => w.ValueAsInt).InitializeFromSource();
maxAddressesSpin.Binding.AddBinding(Entity, e => e.MaxRouteAddresses, w => w.ValueAsInt).InitializeFromSource();
photoviewCar.Binding.AddBinding(Entity, e => e.Photo, w => w.ImageFile).InitializeFromSource();
photoviewCar.GetSaveFileName = () => String.Format("{0}({1})", Entity.Model, Entity.RegistrationNumber);
checkIsCompanyHavings.Binding.AddBinding(Entity, e => e.IsCompanyHavings, w => w.Active).InitializeFromSource();
checkIsRaskat.Binding.AddBinding(Entity, e => e.IsRaskat, w => w.Active).InitializeFromSource();
checkIsArchive.Binding.AddBinding(Entity, e => e.IsArchive, w => w.Active).InitializeFromSource();
comboTypeOfUse.ItemsEnum = typeof(CarTypeOfUse);
comboTypeOfUse.Binding.AddBinding(Entity, e => e.TypeOfUse, w => w.SelectedItemOrNull).InitializeFromSource();
attachmentFiles.AttachToTable = OrmConfig.GetDBTableName(typeof(Car));
if (!UoWGeneric.IsNew)
{
attachmentFiles.ItemId = UoWGeneric.Root.Id;
attachmentFiles.UpdateFileList();
}
OnDataentryreferenceDriverChanged(null, null);
textDriverInfo.Selectable = true;
checkIsCompanyHavings.Sensitive = CarTypeIsEditable();
checkIsRaskat.Sensitive = CarTypeIsEditable();
comboTypeOfUse.Sensitive = CarTypeIsEditable();
}
public static void ConfigureNh()
{
if (NhConfigered)
{
return;
}
//Использование другого способа формировать id объектов, чтобы они не пересекались.
//По умолчанию все первые объекты каждого типа были 1, а вторые 2. Если сравнивать объекты по id, то не всегда можно
//действительно проверить что id правильный. Что в некторых случаях приводило к некоректной проверки в тестах. Когда сравнивались id, разных объектов,
//при этом тест проходил так как номера их совпадали.
MappingParams.UseIdsForTest = true;
Console.WriteLine("Инициализация");
var db_config = FluentNHibernate.Cfg.Db.MonoSqliteConfiguration.Standard.InMemory();
Console.WriteLine("ORM");
// Настройка ORM
OrmConfig.ConfigureOrm(db_config, new System.Reflection.Assembly[] {
System.Reflection.Assembly.GetAssembly(typeof(workwear.Domain.Users.UserSettings)),
System.Reflection.Assembly.GetAssembly(typeof(MeasurementUnits)),
System.Reflection.Assembly.GetAssembly(typeof(UserBase)),
});
NhConfigered = true;
}
public EmailPrepareWorker(ILogger <EmailPrepareWorker> logger, IConfiguration configuration, IModel channel, IEmailRepository emailRepository,
IEmailParametersProvider emailParametersProvider)
{
if (configuration is null)
{
throw new ArgumentNullException(nameof(configuration));
}
_logger = logger ?? throw new ArgumentNullException(nameof(logger));
_channel = channel ?? throw new ArgumentNullException(nameof(channel));
_emailRepository = emailRepository ?? throw new ArgumentNullException(nameof(emailRepository));
_emailParametersProvider = emailParametersProvider ?? throw new ArgumentNullException(nameof(emailParametersProvider));
_emailSendKey = configuration.GetSection(_queuesConfigurationSection)
.GetValue <string>(_emailSendKeyParameter);
_emailSendExchange = configuration.GetSection(_queuesConfigurationSection)
.GetValue <string>(_emailSendExchangeParameter);
_channel.QueueDeclare(_emailSendKey, true, false, false, null);
var conStrBuilder = new MySqlConnectionStringBuilder();
var databaseSection = configuration.GetSection("Database");
conStrBuilder.Server = databaseSection.GetValue("Hostname", "localhost");
conStrBuilder.Port = databaseSection.GetValue <uint>("Port", 3306);
conStrBuilder.UserID = databaseSection.GetValue("Username", "");
conStrBuilder.Password = databaseSection.GetValue("Password", "");
conStrBuilder.Database = databaseSection.GetValue("DatabaseName", "");
conStrBuilder.SslMode = MySqlSslMode.None;
QSMain.ConnectionString = conStrBuilder.GetConnectionString(true);
var db_config = FluentNHibernate.Cfg.Db.MySQLConfiguration.Standard
.Dialect <NHibernate.Spatial.Dialect.MySQL57SpatialDialect>()
.ConnectionString(QSMain.ConnectionString);
OrmMain.ClassMappingList = new List <IOrmObjectMapping> (); // Нужно, чтобы запустился конструктор OrmMain
OrmConfig.ConfigureOrm(db_config,
new System.Reflection.Assembly[] {
System.Reflection.Assembly.GetAssembly(typeof(Vodovoz.HibernateMapping.OrganizationMap)),
System.Reflection.Assembly.GetAssembly(typeof(QS.Banks.Domain.Bank)),
System.Reflection.Assembly.GetAssembly(typeof(QS.HistoryLog.HistoryMain)),
System.Reflection.Assembly.GetAssembly(typeof(QS.Project.HibernateMapping.TypeOfEntityMap)),
System.Reflection.Assembly.GetAssembly(typeof(QS.Project.Domain.UserBase)),
System.Reflection.Assembly.GetAssembly(typeof(QS.Attachments.HibernateMapping.AttachmentMap))
});
QS.HistoryLog.HistoryMain.Enable();
using (var unitOfWork = UnitOfWorkFactory.CreateWithoutRoot("Email prepare worker"))
{
_instanceId = Convert.ToInt32(unitOfWork.Session
.CreateSQLQuery("SELECT GET_CURRENT_DATABASE_ID()")
.List <object>()
.FirstOrDefault());
}
}
public void ConfigureOrm()
{
logger.Debug("Конфигурация ORM...");
//Увеличиваем таймаут если нужно
var dbConnectionStringBuilder = new DbConnectionStringBuilder {
ConnectionString = QSMain.ConnectionString
};
if (dbConnectionStringBuilder.TryGetValue("ConnectionTimeout", out var timeoutAsObject) &&
timeoutAsObject is string timeoutAsString
)
{
if (Int32.TryParse(timeoutAsString, out int timeout) && timeout != connectionTimeoutSeconds)
{
dbConnectionStringBuilder["ConnectionTimeout"] = connectionTimeoutSeconds;
QSMain.ConnectionString = dbConnectionStringBuilder.ConnectionString;
}
}
else
{
dbConnectionStringBuilder.Add("ConnectionTimeout", connectionTimeoutSeconds);
QSMain.ConnectionString = dbConnectionStringBuilder.ConnectionString;
}
var dbConfig = FluentNHibernate.Cfg.Db.MySQLConfiguration.Standard
.Dialect <MySQL57SpatialExtendedDialect>()
.ConnectionString(QSMain.ConnectionString)
.AdoNetBatchSize(100)
.Driver <LoggedMySqlClientDriver>();
// Настройка ORM
OrmConfig.ConfigureOrm(
dbConfig,
new[] {
System.Reflection.Assembly.GetAssembly(typeof(QS.Project.HibernateMapping.UserBaseMap)),
System.Reflection.Assembly.GetAssembly(typeof(HibernateMapping.OrganizationMap)),
System.Reflection.Assembly.GetAssembly(typeof(QS.Project.HibernateMapping.TypeOfEntityMap)),
System.Reflection.Assembly.GetAssembly(typeof(Bank)),
System.Reflection.Assembly.GetAssembly(typeof(HistoryMain)),
System.Reflection.Assembly.GetAssembly(typeof(QS.Attachments.Domain.Attachment)),
System.Reflection.Assembly.GetAssembly(typeof(QS.Report.Domain.UserPrintSettings))
},
cnf => {
cnf.DataBaseIntegration(
dbi => {
dbi.BatchSize = 100;
dbi.Batcher <MySqlClientBatchingBatcherFactory>();
}
);
}
);
logger.Debug("OK");
}
public EmailStatusUpdateWorker(ILogger <EmailStatusUpdateWorker> logger, IConfiguration configuration, IModel channel, IEmailRepository emailRepository)
{
if (configuration is null)
{
throw new ArgumentNullException(nameof(configuration));
}
_logger = logger ?? throw new ArgumentNullException(nameof(logger));
_channel = channel ?? throw new ArgumentNullException(nameof(channel));
_emailRepository = emailRepository ?? throw new ArgumentNullException(nameof(emailRepository));
_storedEmailStatusUpdatingQueueId = configuration.GetSection(_queuesConfigurationSection)
.GetValue <string>(_emailStatusUpdateQueueParameter);
_channel.QueueDeclare(_storedEmailStatusUpdatingQueueId, true, false, false, null);
_consumer = new AsyncEventingBasicConsumer(_channel);
_consumer.Received += MessageRecieved;
try
{
var conStrBuilder = new MySqlConnectionStringBuilder();
var databaseSection = configuration.GetSection("Database");
conStrBuilder.Server = databaseSection.GetValue("Host", "localhost");
conStrBuilder.Port = databaseSection.GetValue <uint>("Port", 3306);
conStrBuilder.UserID = databaseSection.GetValue("Username", "");
conStrBuilder.Password = databaseSection.GetValue("Password", "");
conStrBuilder.Database = databaseSection.GetValue("DatabaseName", "");
conStrBuilder.SslMode = MySqlSslMode.None;
QSMain.ConnectionString = conStrBuilder.GetConnectionString(true);
var db_config = FluentNHibernate.Cfg.Db.MySQLConfiguration.Standard
.Dialect <NHibernate.Spatial.Dialect.MySQL57SpatialDialect>()
.ConnectionString(QSMain.ConnectionString);
OrmConfig.ConfigureOrm(db_config,
new System.Reflection.Assembly[] {
System.Reflection.Assembly.GetAssembly(typeof(Vodovoz.HibernateMapping.OrganizationMap)),
System.Reflection.Assembly.GetAssembly(typeof(QS.Banks.Domain.Bank)),
System.Reflection.Assembly.GetAssembly(typeof(QS.HistoryLog.HistoryMain)),
System.Reflection.Assembly.GetAssembly(typeof(QS.Project.HibernateMapping.TypeOfEntityMap)),
System.Reflection.Assembly.GetAssembly(typeof(QS.Project.Domain.UserBase)),
System.Reflection.Assembly.GetAssembly(typeof(QS.Attachments.HibernateMapping.AttachmentMap))
});
QS.HistoryLog.HistoryMain.Enable();
}
catch (Exception ex)
{
_logger.LogCritical(ex, "Ошибка чтения конфигурационного файла.");
return;
}
}
private void CreateBaseConfig()
{
_logger.LogInformation("Настройка параметров Nhibernate...");
var conStrBuilder = new MySqlConnectionStringBuilder();
var domainDBConfig = Configuration.GetSection("DomainDB");
conStrBuilder.Server = domainDBConfig.GetValue <string>("Server");
conStrBuilder.Port = domainDBConfig.GetValue <uint>("Port");
conStrBuilder.Database = domainDBConfig.GetValue <string>("Database");
conStrBuilder.UserID = domainDBConfig.GetValue <string>("UserID");
conStrBuilder.Password = domainDBConfig.GetValue <string>("Password");
conStrBuilder.SslMode = MySqlSslMode.None;
var connectionString = conStrBuilder.GetConnectionString(true);
var db_config = FluentNHibernate.Cfg.Db.MySQLConfiguration.Standard
.Dialect <MySQL57SpatialExtendedDialect>()
.ConnectionString(connectionString)
.AdoNetBatchSize(100);
// Настройка ORM
OrmConfig.ConfigureOrm(
db_config,
new System.Reflection.Assembly[]
{
System.Reflection.Assembly.GetAssembly(typeof(QS.Project.HibernateMapping.UserBaseMap)),
System.Reflection.Assembly.GetAssembly(typeof(QS.Project.HibernateMapping.TypeOfEntityMap)),
System.Reflection.Assembly.GetAssembly(typeof(Vodovoz.HibernateMapping.OrganizationMap)),
System.Reflection.Assembly.GetAssembly(typeof(Bank)),
System.Reflection.Assembly.GetAssembly(typeof(HistoryMain)),
System.Reflection.Assembly.GetAssembly(typeof(Attachment))
}
);
var serviceUserId = 0;
using (var unitOfWork = UnitOfWorkFactory.CreateWithoutRoot("Получение пользователя"))
{
serviceUserId = unitOfWork.Session.Query <Vodovoz.Domain.Employees.User>()
.Where(u => u.Login == domainDBConfig.GetValue <string>("UserID"))
.Select(u => u.Id)
.FirstOrDefault();
}
QS.Project.Repositories.UserRepository.GetCurrentUserId = () => serviceUserId;
HistoryMain.Enable();
}
/// <summary>
/// Полная инициализация всего необходимого для тестирования в Nh
/// </summary>
public void InitialiseNHibernate(params Assembly[] assemblies)
{
if (configuration != null)
{
return;
}
var db_config = FluentNHibernate.Cfg.Db.MonoSqliteConfiguration.Standard.InMemory();
OrmConfig.ConfigureOrm(db_config, assemblies);
configuration = OrmConfig.NhConfig;
inMemoryDBTestSessionProvider = new InMemoryDBTestSessionProvider(configuration);
UnitOfWorkFactory = new DefaultUnitOfWorkFactory(inMemoryDBTestSessionProvider);
}
public void ConfigureBindings()
{
logger.Info("Настройка биндинга компонентов диалога стажера");
//Основные
dataentryLastName.Binding.AddBinding(Entity, e => e.LastName, w => w.Text).InitializeFromSource();
dataentryName.Binding.AddBinding(Entity, e => e.Name, w => w.Text).InitializeFromSource();
dataentryPatronymic.Binding.AddBinding(Entity, e => e.Patronymic, w => w.Text).InitializeFromSource();
entryAddressCurrent.Binding.AddBinding(Entity, e => e.AddressCurrent, w => w.Text).InitializeFromSource();
entryAddressRegistration.Binding.AddBinding(Entity, e => e.AddressRegistration, w => w.Text).InitializeFromSource();
entryInn.Binding.AddBinding(Entity, e => e.INN, w => w.Text).InitializeFromSource();
dataentryDrivingNumber.MaxLength = 20;
dataentryDrivingNumber.Binding.AddBinding(Entity, e => e.DrivingLicense, w => w.Text).InitializeFromSource();
referenceNationality.SubjectType = typeof(Nationality);
referenceNationality.Binding.AddBinding(Entity, e => e.Nationality, w => w.Subject).InitializeFromSource();
referenceCitizenship.SubjectType = typeof(Citizenship);
referenceCitizenship.Binding.AddBinding(Entity, e => e.Citizenship, w => w.Subject).InitializeFromSource();
photoviewEmployee.Binding.AddBinding(Entity, e => e.Photo, w => w.ImageFile).InitializeFromSource();
photoviewEmployee.GetSaveFileName = () => Entity.FullName;
phonesView.UoW = UoWGeneric;
checkbuttonRussianCitizen.Binding.AddBinding(Entity, e => e.IsRussianCitizen, w => w.Active).InitializeFromSource();
if (Entity.Phones == null)
{
Entity.Phones = new List <Vodovoz.Domain.Contacts.Phone>();
}
phonesView.Phones = Entity.Phones;
ytreeviewEmployeeDocument.ColumnsConfig = FluentColumnsConfig <EmployeeDocument> .Create()
.AddColumn("Документ").AddTextRenderer(x => x.Document.GetEnumTitle())
.AddColumn("Доп. название").AddTextRenderer(x => x.Name)
.Finish();
ytreeviewEmployeeDocument.SetItemsSource(Entity.ObservableDocuments);
//Реквизиты
accountsView.ParentReference = new ParentReferenceGeneric <Trainee, Account>(UoWGeneric, o => o.Accounts);
accountsView.SetTitle("Банковские счета стажера");
//Файлы
attachmentFiles.AttachToTable = OrmConfig.GetDBTableName(typeof(Trainee));
if (Entity.Id != 0)
{
attachmentFiles.ItemId = Entity.Id;
attachmentFiles.UpdateFileList();
}
logger.Info("Ok");
}
//todo:XML config
//public static Field GeField(string config)
//{
// var document = new XmlDocument();
// document.Load(config);
// var load = document.DocumentElement.FirstChild as XmlElement;
// var accessorName = load.GetElementsByTagName("DBType")[0].InnerText;
// #region 加载类
// var dryClasses = new ConcurrentDictionary<string, ClassDefine>();
// var relations = document.DocumentElement.LastChild as XmlElement;
// var loadAssembly = Assembly.Load(relations.GetAttribute("assembly"));
// var xnamespace = relations.GetAttribute("namespace");
// var classelements = relations.ChildNodes;
// #region 遍历基本属性
// foreach (XmlElement ele in classelements) //基本属性
// {
// var classdefine = new ClassDefine
// {
// Name = ele.GetAttribute("name"),
// Table = ele.GetAttribute("table")
// };
// classdefine.ClassType = loadAssembly.GetType(xnamespace + "." + classdefine.Name);
// var properties = ele.GetElementsByTagName("property");
// foreach (XmlElement property in properties)
// {
// var pe = new BasePropertyElement { Column = property.GetAttribute("column") };
// var propertyname = property.GetAttribute("name");
// classdefine.AllProperties.Add(propertyname, pe);
// }
// dryClasses.TryAdd(classdefine.Name, classdefine);
// }
// #endregion
// #region 建立联系
// foreach (XmlElement ele in classelements)
// {
// string propertyName;
// var define = dryClasses[ele.GetAttribute("name")];
// var otos = ele.GetElementsByTagName("one-to-one");
// foreach (XmlElement element in otos)
// {
// var oo = new OnetoOne
// {
// Column = element.GetAttribute("refercolumn"),
// IsNeedUpdate = !bool.Parse(element.GetAttribute("twoway"))
// };
// var property = element.GetAttribute("class");
// oo.ReferClass = dryClasses[property];
// propertyName = element.GetAttribute("name");
// define.AllProperties.Add(propertyName, oo);
// }
// var mtms = ele.GetElementsByTagName("many-to-many");
// foreach (XmlElement element in mtms)
// {
// var mm = new ManytoMany
// {
// Column = element.GetAttribute("key"),
// ReferColumn = element.GetAttribute("column"),
// Table = element.GetAttribute("table"),
// ReferClass = dryClasses[element.GetAttribute("class")],
// IsNeedUpdate = !bool.Parse(element.GetAttribute("twoway"))
// };
// propertyName = element.GetAttribute("name");
// define.AllProperties.Add(propertyName, mm);
// }
// var otms = ele.GetElementsByTagName("one-to-many");
// foreach (XmlElement element in otms)
// {
// var om = new OnetoMany
// {
// ReferColumn = element.GetAttribute("column"),
// ReferClass = dryClasses[element.GetAttribute("class")],
// IsNeedUpdate = !bool.Parse(element.GetAttribute("twoway"))
// };
// propertyName = element.GetAttribute("name");
// define.AllProperties.Add(propertyName, om);
// }
// var mtos = ele.GetElementsByTagName("many-to-one");
// foreach (XmlElement element in mtos)
// {
// var mo = new ManytoOne
// {
// Column = element.GetAttribute("column"),
// ReferClass = dryClasses[element.GetAttribute("class")],
// };
// propertyName = element.GetAttribute("name");
// define.AllProperties.Add(propertyName, mo);
// }
// var fos = ele.GetElementsByTagName("foreign-one");
// foreach (XmlElement element in fos)
// {
// var fto = new ForeignOne
// {
// Column = element.GetAttribute("column"),
// ReferClass = dryClasses[element.GetAttribute("class")],
// };
// propertyName = element.GetAttribute("name");
// define.AllProperties.Add(propertyName, fto);
// }
// }
// #endregion
// foreach (var dryClassesValue in dryClasses.Values)
// {
// foreach (var basePropertyElement in dryClassesValue.AllProperties)
// {
// basePropertyElement.Value.PropertyInfo =
// dryClassesValue.ClassType.GetProperty(basePropertyElement.Key);
// }
// }
// #endregion
// //创建访问类
// var accessor = CreateAccessor(accessorName);
// accessor.ClassDefines = dryClasses.ToConcurrencyDictionary(kv => kv.Value.ClassType, kv => kv.Value);
// accessor.ConnectionString =
// $"Data Source={load.GetElementsByTagName("Instance")[0].InnerText};AttachDbFilename=" +
// $"{AppDomain.CurrentDomain.BaseDirectory + load.GetElementsByTagName("Path")[0].InnerText};" +
// $"Integrated Security=True;Connect Timeout=30;User Instance=True";
// //accessor.EmptyId = bool.Parse(load.GetElementsByTagName("EmptyID")[0].InnerText);
// //accessor.DefaultId = int.Parse(load.GetElementsByTagName("DefaultID")[0].InnerText);
// var dispatcher = new AccessorDispatcher { Accessor = accessor };
// accessor.Dispatcher = dispatcher;
// var field = new Field
// {
// Accessor = accessor,
// Dispatcher = dispatcher
// };
// return field;
//}
/// <summary>
/// 通过配置文件获取访问域
/// </summary>
/// <param name="register"></param>
public static Field OpenField(OrmConfig register)
{
if (register.ConnectionStringBuilder == null)
{
throw new NullReferenceException("Connectionstring is null!");
}
if (register.IsLinked && string.IsNullOrEmpty(register.LinkedIdName))
{
throw new ArgumentNullException("LinkedIdName is null!");
}
if (register.AccessorType == default(AccessorType))
{
throw new ArgumentNullException("AccessorType is null!");
}
if (register.Logger == null)
{
throw new NullReferenceException("Log is null!");
}
if (register.Function.HasFlag(DecoratorFunction.PropertyChangedNotify))
{
//todo:?
}
var accessor = CreateAccessor(register.AccessorType);
accessor.Config = register;
if (accessor.IsLinked)
{
foreach (var define in register.ClassDefines.Values)
{
define.IdPropertyInfo = define.ClassType.GetProperty(register.LinkedIdName);
}
}
var field = new Field
{
Accessor = accessor,
};
return(field);
}
string ValueDisplay(string value)
{
var claz = OrmConfig.FindMappingByShortClassName(Entity.EntityClassName);
var property = GetPropertyOrNull(claz, Path);
if (property != null)
{
if (property.Type is NHibernate.Type.BooleanType)
{
return(BooleanDisplay(value));
}
if (property.Type is NHibernate.Type.EnumStringType)
{
return(EnumDisplay(value, property));
}
}
return(value);
}
public void ConfigureBindings()
{
logger.Info("Настройка биндинга компонентов диалога стажера");
//Основные
dataentryLastName.Binding.AddBinding(Entity, e => e.LastName, w => w.Text).InitializeFromSource();
dataentryName.Binding.AddBinding(Entity, e => e.Name, w => w.Text).InitializeFromSource();
dataentryPatronymic.Binding.AddBinding(Entity, e => e.Patronymic, w => w.Text).InitializeFromSource();
dataentryPassportSeria.MaxLength = 30;
dataentryPassportSeria.Binding.AddBinding(Entity, e => e.PassportSeria, w => w.Text).InitializeFromSource();
dataentryPassportNumber.MaxLength = 30;
dataentryPassportNumber.Binding.AddBinding(Entity, e => e.PassportNumber, w => w.Text).InitializeFromSource();
ytextviewPassportIssuedOrg.Binding.AddBinding(Entity, e => e.PassportIssuedOrg, w => w.Buffer.Text).InitializeFromSource();
ydatePassportIssuedDate.Binding.AddBinding(Entity, e => e.PassportIssuedDate, w => w.DateOrNull).InitializeFromSource();
entryAddressCurrent.Binding.AddBinding(Entity, e => e.AddressCurrent, w => w.Text).InitializeFromSource();
entryAddressRegistration.Binding.AddBinding(Entity, e => e.AddressRegistration, w => w.Text).InitializeFromSource();
entryInn.Binding.AddBinding(Entity, e => e.INN, w => w.Text).InitializeFromSource();
dataentryDrivingNumber.MaxLength = 20;
dataentryDrivingNumber.Binding.AddBinding(Entity, e => e.DrivingNumber, w => w.Text).InitializeFromSource();
referenceNationality.SubjectType = typeof(Nationality);
referenceNationality.Binding.AddBinding(Entity, e => e.Nationality, w => w.Subject).InitializeFromSource();
photoviewEmployee.Binding.AddBinding(Entity, e => e.Photo, w => w.ImageFile).InitializeFromSource();
photoviewEmployee.GetSaveFileName = () => Entity.FullName;
phonesView.UoW = UoWGeneric;
if (Entity.Phones == null)
{
Entity.Phones = new List <Phone>();
}
phonesView.Phones = Entity.Phones;
//Реквизиты
accountsView.ParentReference = new ParentReferenceGeneric <Trainee, Account>(UoWGeneric, o => o.Accounts);
accountsView.SetTitle("Банковские счета стажера");
//Файлы
attachmentFiles.AttachToTable = OrmConfig.GetDBTableName(typeof(Trainee));
if (Entity.Id != 0)
{
attachmentFiles.ItemId = Entity.Id;
attachmentFiles.UpdateFileList();
}
logger.Info("Ok");
}
static void CreateBaseConfig()
{
logger.Info("Настройка параметров базы...");
// Настройка ORM
var db = FluentNHibernate.Cfg.Db.MySQLConfiguration.Standard
.ConnectionString(QSMain.ConnectionString)
.ShowSql()
.FormatSql();
OrmConfig.ConfigureOrm(db, new System.Reflection.Assembly[] {
System.Reflection.Assembly.GetAssembly(typeof(MainClass)),
System.Reflection.Assembly.GetAssembly(typeof(UserBase)),
});
OrmMain.AddObjectDescription <CarBrand>().DefaultTableView().SearchColumn("Наименование", i => i.Name).OrderAsc(i => i.Name).End();
OrmMain.AddObjectDescription <CarModel>().Dialog <CarModelDlg>();
OrmMain.AddObjectDescription <StoreItem>().Dialog <StoreItemDlg>();
JournalsColumnsConfigs.RegisterColumns();
}
static void CreateBaseConfig()
{
logger.Info("Настройка параметров базы...");
// Настройка ORM
var db = FluentNHibernate.Cfg.Db.MySQLConfiguration.Standard
.Dialect <MySQL57ExtendedDialect>()
.ConnectionString(QSProjectsLib.QSMain.ConnectionString)
.AdoNetBatchSize(100)
.ShowSql()
.FormatSql();
OrmConfig.ConfigureOrm(db, new System.Reflection.Assembly[] {
System.Reflection.Assembly.GetAssembly(typeof(MainClass)),
System.Reflection.Assembly.GetAssembly(typeof(MeasurementUnits)),
System.Reflection.Assembly.GetAssembly(typeof(UserBase)),
System.Reflection.Assembly.GetAssembly(typeof(HistoryMain)),
});
#if DEBUG
NLog.LogManager.Configuration.RemoveRuleByName("HideNhibernate");
#endif
//Настраиваем классы сущностей
OrmMain.AddObjectDescription(MeasurementUnitsOrmMapping.GetOrmMapping());
//Спецодежда
OrmMain.AddObjectDescription <RegulationDoc>().Dialog <RegulationDocDlg>().DefaultTableView().SearchColumn("Документ", i => i.Title).OrderAsc(i => i.Name).End();
//Общее
OrmMain.AddObjectDescription <UserBase>().DefaultTableView().Column("Имя", e => e.Name).End();
OrmMain.AddObjectDescription <UserSettings>();
//Склад
OrmMain.AddObjectDescription <Income>().Dialog <Dialogs.Stock.IncomeDocDlg>();
NotifyConfiguration.Enable();
BuisnessLogicGlobalEventHandler.Init(new GtkQuestionDialogsInteractive());
JournalsColumnsConfigs.RegisterColumns();
}
private void ConfigureDlg()
{
if (Entity.Id == 0)
{
Entity.OrganisationForSalary = commonOrganisationProvider.GetCommonOrganisation(UoW);
}
canManageDriversAndForwarders = ServicesConfig.CommonServices.CurrentPermissionService.ValidatePresetPermission("can_manage_drivers_and_forwarders");
canManageOfficeWorkers = ServicesConfig.CommonServices.CurrentPermissionService.ValidatePresetPermission("can_manage_office_workers");
canEditOrganisationForSalary = ServicesConfig.CommonServices.CurrentPermissionService.ValidatePresetPermission("can_edit_organisation_for_salary");
ConfigureCategory();
ConfigureSubdivision();
OnRussianCitizenToggled(null, EventArgs.Empty);
dataentryDrivingNumber.MaxLength = 20;
dataentryDrivingNumber.Binding.AddBinding(Entity, e => e.DrivingLicense, w => w.Text).InitializeFromSource();
UoWGeneric.Root.PropertyChanged += OnPropertyChanged;
notebookMain.Page = 0;
notebookMain.ShowTabs = false;
GenderComboBox.ItemsEnum = typeof(Gender);
GenderComboBox.Binding.AddBinding(Entity, e => e.Gender, w => w.SelectedItemOrNull).InitializeFromSource();
subdivisionService = SubdivisionParametersProvider.Instance;
yenumcomboStatus.ItemsEnum = typeof(EmployeeStatus);
yenumcomboStatus.Binding.AddBinding(Entity, e => e.Status, w => w.SelectedItem).InitializeFromSource();
chkDriverForOneDay.Binding.AddBinding(Entity, e => e.IsDriverForOneDay, w => w.Active).InitializeFromSource();
cmbDriverOf.ItemsEnum = typeof(CarTypeOfUse);
cmbDriverOf.Binding.AddBinding(Entity, e => e.DriverOf, w => w.SelectedItemOrNull).InitializeFromSource();
dataentryLastName.Binding.AddBinding(Entity, e => e.LastName, w => w.Text).InitializeFromSource();
dataentryName.Binding.AddBinding(Entity, e => e.Name, w => w.Text).InitializeFromSource();
dataentryPatronymic.Binding.AddBinding(Entity, e => e.Patronymic, w => w.Text).InitializeFromSource();
dataentryInnerPhone.Binding.AddBinding(Entity, e => e.InnerPhone, w => w.Text, new Gamma.Binding.Converters.NumbersToStringConverter()).InitializeFromSource();
entryAddressCurrent.Binding.AddBinding(Entity, e => e.AddressCurrent, w => w.Text).InitializeFromSource();
entryAddressRegistration.Binding.AddBinding(Entity, e => e.AddressRegistration, w => w.Text).InitializeFromSource();
entryInn.Binding.AddBinding(Entity, e => e.INN, w => w.Text).InitializeFromSource();
dataentryAndroidLogin.Binding.AddBinding(Entity, e => e.AndroidLogin, w => w.Text).InitializeFromSource();
dataentryAndroidPassword.Binding.AddBinding(Entity, e => e.AndroidPassword, w => w.Text).InitializeFromSource();
var filterDefaultForwarder = new EmployeeFilterViewModel();
filterDefaultForwarder.SetAndRefilterAtOnce(
x => x.Category = EmployeeCategory.forwarder,
x => x.Status = EmployeeStatus.IsWorking
);
repEntDefaultForwarder.RepresentationModel = new EmployeesVM(filterDefaultForwarder);
repEntDefaultForwarder.Binding.AddBinding(Entity, e => e.DefaultForwarder, w => w.Subject).InitializeFromSource();
referenceNationality.SubjectType = typeof(Nationality);
referenceNationality.Binding.AddBinding(Entity, e => e.Nationality, w => w.Subject).InitializeFromSource();
referenceCitizenship.SubjectType = typeof(Citizenship);
referenceCitizenship.Binding.AddBinding(Entity, e => e.Citizenship, w => w.Subject).InitializeFromSource();
referenceUser.SubjectType = typeof(User);
referenceUser.CanEditReference = false;
referenceUser.Binding.AddBinding(Entity, e => e.User, w => w.Subject).InitializeFromSource();
referenceUser.Sensitive = ServicesConfig.CommonServices.CurrentPermissionService.ValidatePresetPermission("can_manage_users");
yenumcombobox13.ItemsEnum = typeof(RegistrationType);
yenumcombobox13.Binding.AddBinding(Entity, e => e.Registration, w => w.SelectedItemOrNull).InitializeFromSource();
comboDriverType.ItemsEnum = typeof(DriverType);
comboDriverType.Binding.AddBinding(Entity, e => e.DriverType, w => w.SelectedItemOrNull).InitializeFromSource();
ydatepicker1.Binding.AddBinding(Entity, e => e.BirthdayDate, w => w.DateOrNull).InitializeFromSource();
dateFired.Binding.AddBinding(Entity, e => e.DateFired, w => w.DateOrNull).InitializeFromSource();
dateHired.Binding.AddBinding(Entity, e => e.DateHired, w => w.DateOrNull).InitializeFromSource();
dateCalculated.Binding.AddBinding(Entity, e => e.DateCalculated, w => w.DateOrNull).InitializeFromSource();
photoviewEmployee.Binding.AddBinding(Entity, e => e.Photo, w => w.ImageFile).InitializeFromSource();
photoviewEmployee.GetSaveFileName = () => Entity.FullName;
attachmentFiles.AttachToTable = OrmConfig.GetDBTableName(typeof(Employee));
if (Entity.Id != 0)
{
attachmentFiles.ItemId = UoWGeneric.Root.Id;
attachmentFiles.UpdateFileList();
}
phonesView.UoW = UoWGeneric;
if (UoWGeneric.Root.Phones == null)
{
UoWGeneric.Root.Phones = new List <Phone>();
}
phonesView.Phones = UoWGeneric.Root.Phones;
accountsView.ParentReference = new ParentReferenceGeneric <Employee, Account>(UoWGeneric, o => o.Accounts);
accountsView.SetTitle("Банковские счета сотрудника");
ydateFirstWorkDay.Binding.AddBinding(Entity, e => e.FirstWorkDay, w => w.DateOrNull).InitializeFromSource();
yspinTripsPriority.Binding.AddBinding(Entity, e => e.TripPriority, w => w.ValueAsShort).InitializeFromSource();
yspinDriverSpeed.Binding.AddBinding(Entity, e => e.DriverSpeed, w => w.Value, new MultiplierToPercentConverter()).InitializeFromSource();
minAddressesSpin.Binding.AddBinding(Entity, e => e.MinRouteAddresses, w => w.ValueAsInt).InitializeFromSource();
maxAddressesSpin.Binding.AddBinding(Entity, e => e.MaxRouteAddresses, w => w.ValueAsInt).InitializeFromSource();
checkbuttonRussianCitizen.Binding.AddBinding(Entity, e => e.IsRussianCitizen, w => w.Active).InitializeFromSource();
checkVisitingMaster.Binding.AddBinding(Entity, e => e.VisitingMaster, w => w.Active).InitializeFromSource();
checkChainStoreDriver.Binding.AddBinding(Entity, e => e.IsChainStoreDriver, w => w.Active).InitializeFromSource();
ylblUserLogin.TooltipText = "При сохранении сотрудника создаёт нового пользователя с введённым логином и отправляет сотруднику SMS с сгенерированным паролем";
yentryUserLogin.Binding.AddBinding(Entity, e => e.LoginForNewUser, w => w.Text);
yentryUserLogin.Sensitive = CanCreateNewUser;
specialListCmbOrganisation.ItemsList = UoW.GetAll <Organization>();
specialListCmbOrganisation.Binding.AddBinding(Entity, e => e.OrganisationForSalary, w => w.SelectedItem).InitializeFromSource();
specialListCmbOrganisation.Sensitive = canEditOrganisationForSalary;
ConfigureWorkSchedules();
ConfigureDistrictPriorities();
ytreeviewEmployeeDocument.ColumnsConfig = FluentColumnsConfig <EmployeeDocument> .Create()
.AddColumn("Документ").AddTextRenderer(x => x.Document.GetEnumTitle())
.AddColumn("Доп. название").AddTextRenderer(x => x.Name)
.Finish();
ytreeviewEmployeeDocument.SetItemsSource(Entity.ObservableDocuments);
ytreeviewEmployeeContract.ColumnsConfig = FluentColumnsConfig <EmployeeContract> .Create()
.AddColumn("Договор").AddTextRenderer(x => x.EmployeeContractTemplate.TemplateType.GetEnumTitle())
.AddColumn("Название").AddTextRenderer(x => x.Name)
.AddColumn("Дата начала").AddTextRenderer(x => x.FirstDay.ToString("dd/MM/yyyy"))
.AddColumn("Дата конца").AddTextRenderer(x => x.LastDay.ToString("dd/MM/yyyy"))
.Finish();
ytreeviewEmployeeContract.SetItemsSource(Entity.ObservableContracts);
wageParametersView.ViewModel = new EmployeeWageParametersViewModel
(
Entity,
this,
UoW,
new HierarchicalPresetPermissionValidator(EmployeeSingletonRepository.GetInstance(), new PermissionRepository()),
UserSingletonRepository.GetInstance(),
ServicesConfig.CommonServices,
NavigationManagerProvider.NavigationManager
);
logger.Info("Ok");
}
public static void Main(string[] args)
{
AppDomain.CurrentDomain.UnhandledException += AppDomain_CurrentDomain_UnhandledException;
IConfig driverServiceConfig;
IConfig firebaseConfig;
try {
IniConfigSource driverConfFile = new IniConfigSource(driverConfigFile);
driverConfFile.Reload();
driverServiceConfig = driverConfFile.Configs["Service"];
firebaseConfig = driverConfFile.Configs["Firebase"];
IConfig mysqlConfig = driverConfFile.Configs["Mysql"];
mysqlServerHostName = mysqlConfig.GetString("mysql_server_host_name");
mysqlServerPort = mysqlConfig.GetString("mysql_server_port", "3306");
mysqlUser = mysqlConfig.GetString("mysql_user");
mysqlPassword = mysqlConfig.GetString("mysql_password");
mysqlDatabase = mysqlConfig.GetString("mysql_database");
}
catch (Exception ex) {
logger.Fatal(ex, "Ошибка чтения конфигурационного файла.");
return;
}
try {
var conStrBuilder = new MySqlConnectionStringBuilder();
conStrBuilder.Server = mysqlServerHostName;
conStrBuilder.Port = UInt32.Parse(mysqlServerPort);
conStrBuilder.Database = mysqlDatabase;
conStrBuilder.UserID = mysqlUser;
conStrBuilder.Password = mysqlPassword;
conStrBuilder.SslMode = MySqlSslMode.None;
QSMain.ConnectionString = conStrBuilder.GetConnectionString(true);
var db_config = FluentNHibernate.Cfg.Db.MySQLConfiguration.Standard
.Dialect <NHibernate.Spatial.Dialect.MySQL57SpatialDialect>()
.ConnectionString(QSMain.ConnectionString);
OrmConfig.ConfigureOrm(db_config,
new System.Reflection.Assembly[] {
System.Reflection.Assembly.GetAssembly(typeof(QS.Banks.Domain.Bank)),
System.Reflection.Assembly.GetAssembly(typeof(Vodovoz.HibernateMapping.OrganizationMap)),
System.Reflection.Assembly.GetAssembly(typeof(QS.HistoryLog.HistoryMain)),
System.Reflection.Assembly.GetAssembly(typeof(QS.Project.Domain.UserBase))
});
MainSupport.LoadBaseParameters();
QS.HistoryLog.HistoryMain.Enable();
}
catch (Exception ex) {
logger.Fatal(ex, "Ошибка в настройке подключения к БД.");
}
try {
DriverServiceStarter.StartService(driverServiceConfig, firebaseConfig, new BaseParametersProvider());
UnixSignal[] signals =
{
new UnixSignal(Signum.SIGINT),
new UnixSignal(Signum.SIGHUP),
new UnixSignal(Signum.SIGTERM)
};
UnixSignal.WaitAny(signals);
}
catch (Exception e) {
logger.Fatal(e);
}
finally {
if (Environment.OSVersion.Platform == PlatformID.Unix)
{
Thread.CurrentThread.Abort();
}
Environment.Exit(0);
}
}
public static void Main(string[] args)
{
AppDomain.CurrentDomain.UnhandledException += AppDomain_CurrentDomain_UnhandledException;
AppDomain.CurrentDomain.ProcessExit += CurrentDomain_ProcessExit;
try {
IniConfigSource configFile = new IniConfigSource(ConfigFile);
configFile.Reload();
IConfig config = configFile.Configs ["General"];
server = config.GetString("server");
port = config.GetString("port", "3306");
user = config.GetString("user");
pass = config.GetString("password");
db = config.GetString("database");
firebaseServerApiToken = config.GetString("server_api_token");
firebaseSenderId = config.GetString("firebase_sender");
servicePort = config.GetString("service_port");
serviceHostName = config.GetString("service_host_name");
OsmService.ConfigureService(configFile);
} catch (Exception ex) {
logger.Fatal(ex, "Ошибка чтения конфигурационного файла.");
return;
}
WebServiceHost OsmHost = new WebServiceHost(typeof(OsmService));
logger.Info(String.Format("Создаем и запускаем службы..."));
try {
var conStrBuilder = new MySqlConnectionStringBuilder();
conStrBuilder.Server = server;
conStrBuilder.Port = UInt32.Parse(port);
conStrBuilder.Database = db;
conStrBuilder.UserID = user;
conStrBuilder.Password = pass;
conStrBuilder.SslMode = MySqlSslMode.None;
QSMain.ConnectionString = conStrBuilder.GetConnectionString(true);
var db_config = FluentNHibernate.Cfg.Db.MySQLConfiguration.Standard
.Dialect <NHibernate.Spatial.Dialect.MySQL57SpatialDialect>()
.ConnectionString(QSMain.ConnectionString);
OrmConfig.ConfigureOrm(db_config,
new System.Reflection.Assembly[] {
System.Reflection.Assembly.GetAssembly(typeof(Vodovoz.HibernateMapping.OrganizationMap)),
System.Reflection.Assembly.GetAssembly(typeof(QSBanks.QSBanksMain)),
System.Reflection.Assembly.GetAssembly(typeof(QSContacts.QSContactsMain)),
System.Reflection.Assembly.GetAssembly(typeof(EmailService.Email))
});
MainSupport.LoadBaseParameters();
FCMHelper.Configure(firebaseServerApiToken, firebaseSenderId);
ServiceHost ChatHost = new ServiceHost(typeof(ChatService));
ServiceHost AndroidDriverHost = new ServiceHost(typeof(AndroidDriverService));
ServiceHost EmailSendingHost = new ServiceHost(typeof(EmailService.EmailService));
WebServiceHost MailjetEventsHost = new WebServiceHost(typeof(EmailService.EmailService));
WebServiceHost MobileHost = new WebServiceHost(typeof(MobileService));
ChatHost.AddServiceEndpoint(
typeof(IChatService),
new BasicHttpBinding(),
String.Format("http://{0}:{1}/ChatService", serviceHostName, servicePort)
);
AndroidDriverHost.AddServiceEndpoint(
typeof(IAndroidDriverService),
new BasicHttpBinding(),
String.Format("http://{0}:{1}/AndroidDriverService", serviceHostName, servicePort)
);
EmailSendingHost.AddServiceEndpoint(
typeof(IEmailService),
new BasicHttpBinding(),
String.Format("http://{0}:{1}/EmailService", serviceHostName, servicePort)
);
MailjetEventsHost.AddServiceEndpoint(
typeof(IMailjetEventService),
new WebHttpBinding(),
String.Format("http://{0}:{1}/Mailjet", serviceHostName, servicePort)
);
MobileService.BaseUrl = String.Format("http://{0}:{1}/Mobile", serviceHostName, servicePort);
MobileHost.AddServiceEndpoint(
typeof(IMobileService),
new WebHttpBinding(),
MobileService.BaseUrl
);
OsmWorker.ServiceHost = serviceHostName;
OsmWorker.ServicePort = Int32.Parse(servicePort);
OsmHost.AddServiceEndpoint(typeof(IOsmService), new WebHttpBinding(), OsmWorker.ServiceAddress);
//FIXME Тут добавлен без дебага, потому что без него не работает отдача изображений в потоке. Метод Stream GetImage(string filename)
// Просто не смог быстро разобраться. А конкретнее нужна строка reply = TraceMessage (reply.CreateBufferedCopy (int.MaxValue), Action.Send);
// видимо она как то обрабатывает сообщение.
MobileHost.Description.Behaviors.Add(new PreFilter());
#if DEBUG
ChatHost.Description.Behaviors.Add(new PreFilter());
AndroidDriverHost.Description.Behaviors.Add(new PreFilter());
EmailSendingHost.Description.Behaviors.Add(new PreFilter());
MailjetEventsHost.Description.Behaviors.Add(new PreFilter());
OsmHost.Description.Behaviors.Add(new PreFilter());
#endif
ChatHost.Open();
AndroidDriverHost.Open();
EmailSendingHost.Open();
MailjetEventsHost.Open();
MobileHost.Open();
OsmHost.Open();
//Запускаем таймеры рутины
OrderRoutineTimer = new System.Timers.Timer(120000); //2 минуты
OrderRoutineTimer.Elapsed += OrderRoutineTimer_Elapsed;
OrderRoutineTimer.Start();
TrackRoutineTimer = new System.Timers.Timer(30000); //30 секунд
TrackRoutineTimer.Elapsed += TrackRoutineTimer_Elapsed;
TrackRoutineTimer.Start();
logger.Info("Server started.");
UnixSignal[] signals =
{
new UnixSignal(Signum.SIGINT),
new UnixSignal(Signum.SIGHUP),
new UnixSignal(Signum.SIGTERM)
};
UnixSignal.WaitAny(signals);
} catch (Exception e) {
logger.Fatal(e);
} finally {
if (OsmHost.State == CommunicationState.Opened)
{
OsmHost.Close();
}
if (Environment.OSVersion.Platform == PlatformID.Unix)
{
Thread.CurrentThread.Abort();
}
Environment.Exit(0);
}
}
public static void Main(string[] args)
{
AppDomain.CurrentDomain.UnhandledException += AppDomain_CurrentDomain_UnhandledException;
try {
IniConfigSource confFile = new IniConfigSource(configFile);
confFile.Reload();
IConfig serviceConfig = confFile.Configs["Service"];
serviceHostName = serviceConfig.GetString("service_host_name");
servicePort = serviceConfig.GetString("service_port");
IConfig osrmConfig = confFile.Configs["OsrmService"];
serverUrl = osrmConfig.GetString("server_url");
IConfig mysqlConfig = confFile.Configs["Mysql"];
mysqlServerHostName = mysqlConfig.GetString("mysql_server_host_name");
mysqlServerPort = mysqlConfig.GetString("mysql_server_port", "3306");
mysqlUser = mysqlConfig.GetString("mysql_user");
mysqlPassword = mysqlConfig.GetString("mysql_password");
mysqlDatabase = mysqlConfig.GetString("mysql_database");
}
catch (Exception ex) {
logger.Fatal(ex, "Ошибка чтения конфигурационного файла.");
return;
}
logger.Info(String.Format("Запуск службы правил доставки"));
try {
var conStrBuilder = new MySqlConnectionStringBuilder();
conStrBuilder.Server = mysqlServerHostName;
conStrBuilder.Port = UInt32.Parse(mysqlServerPort);
conStrBuilder.Database = mysqlDatabase;
conStrBuilder.UserID = mysqlUser;
conStrBuilder.Password = mysqlPassword;
conStrBuilder.SslMode = MySqlSslMode.None;
QSMain.ConnectionString = conStrBuilder.GetConnectionString(true);
var db_config = FluentNHibernate.Cfg.Db.MySQLConfiguration.Standard
.Dialect <NHibernate.Spatial.Dialect.MySQL57SpatialDialect>()
.ConnectionString(QSMain.ConnectionString);
OrmConfig.ConfigureOrm(db_config,
new System.Reflection.Assembly[] {
System.Reflection.Assembly.GetAssembly(typeof(Vodovoz.HibernateMapping.OrganizationMap)),
System.Reflection.Assembly.GetAssembly(typeof(Bank)),
System.Reflection.Assembly.GetAssembly(typeof(QS.Project.Domain.UserBase))
});
OsrmMain.ServerUrl = serverUrl;
IDeliveryRepository deliveryRepository = new DeliveryRepository();
DeliveryRulesInstanceProvider deliveryRulesInstanceProvider = new DeliveryRulesInstanceProvider(deliveryRepository);
ServiceHost deliveryRulesHost = new DeliveryRulesServiceHost(deliveryRulesInstanceProvider);
ServiceEndpoint webEndPoint = deliveryRulesHost.AddServiceEndpoint(
typeof(IDeliveryRulesService),
new WebHttpBinding(),
$"http://{serviceHostName}:{servicePort}/DeliveryRules"
);
WebHttpBehavior httpBehavior = new WebHttpBehavior();
webEndPoint.Behaviors.Add(httpBehavior);
#if DEBUG
deliveryRulesHost.Description.Behaviors.Add(new PreFilter());
#endif
deliveryRulesHost.Open();
logger.Info("Server started.");
UnixSignal[] signals =
{
new UnixSignal(Signum.SIGINT),
new UnixSignal(Signum.SIGHUP),
new UnixSignal(Signum.SIGTERM)
};
UnixSignal.WaitAny(signals);
}
catch (Exception e) {
logger.Fatal(e);
}
finally {
if (Environment.OSVersion.Platform == PlatformID.Unix)
{
Thread.CurrentThread.Abort();
}
Environment.Exit(0);
}
}
static void CreateBaseConfig()
{
logger.Info("Настройка параметров базы...");
//Увеличиваем таймоут
QSMain.ConnectionString += ";ConnectionTimeout=120";
var db_config = FluentNHibernate.Cfg.Db.MySQLConfiguration.Standard
.Dialect <MySQL57SpatialExtendedDialect>()
.ConnectionString(QSMain.ConnectionString)
.AdoNetBatchSize(100)
.Driver <LoggedMySqlClientDriver>();
// Настройка ORM
OrmConfig.ConfigureOrm(
db_config,
new System.Reflection.Assembly[] {
System.Reflection.Assembly.GetAssembly(typeof(QS.Project.HibernateMapping.UserBaseMap)),
System.Reflection.Assembly.GetAssembly(typeof(HibernateMapping.OrganizationMap)),
System.Reflection.Assembly.GetAssembly(typeof(Bank)),
System.Reflection.Assembly.GetAssembly(typeof(HistoryMain)),
},
(cnf) => {
cnf.DataBaseIntegration(
dbi => {
dbi.BatchSize = 100;
dbi.Batcher <MySqlClientBatchingBatcherFactory>();
}
);
}
);
#region Dialogs mapping
OrmMain.ClassMappingList = new List <IOrmObjectMapping> {
//Простые справочники
OrmObjectMapping <CullingCategory> .Create().DefaultTableView().SearchColumn("Название", x => x.Name).End(),
OrmObjectMapping <Nationality> .Create().DefaultTableView().SearchColumn("Название", x => x.Name).End(),
OrmObjectMapping <Citizenship> .Create().DefaultTableView().SearchColumn("Название", x => x.Name).End(),
OrmObjectMapping <Manufacturer> .Create().DefaultTableView().SearchColumn("Название", x => x.Name).End(),
OrmObjectMapping <EquipmentColors> .Create().DefaultTableView().SearchColumn("Название", x => x.Name).End(),
OrmObjectMapping <User> .Create().DefaultTableView().SearchColumn("Название", x => x.Name).End(),
OrmObjectMapping <UserSettings> .Create().Dialog <UserSettingsView>(),
OrmObjectMapping <FuelType> .Create().Dialog <FuelTypeDlg>().DefaultTableView().SearchColumn("Название", x => x.Name).SearchColumn("Стоимость", x => x.Cost.ToString()).End(),
OrmObjectMapping <MovementWagon> .Create().Dialog <MovementWagonViewModel>().DefaultTableView().SearchColumn("Название", x => x.Name).End(),
//Остальные справочники
OrmObjectMapping <CarProxyDocument> .Create().Dialog <CarProxyDlg>(),
OrmObjectMapping <M2ProxyDocument> .Create().Dialog <M2ProxyDlg>(),
OrmObjectMapping <ProductGroup> .Create().Dialog <ProductGroupDlg>(),
OrmObjectMapping <CommentTemplate> .Create().Dialog <CommentTemplateDlg>().DefaultTableView().SearchColumn("Шаблон комментария", x => x.Comment).End(),
OrmObjectMapping <FineTemplate> .Create().Dialog <FineTemplateDlg>().DefaultTableView().SearchColumn("Шаблон комментария", x => x.Reason).End(),
OrmObjectMapping <PremiumTemplate> .Create().Dialog <PremiumTemplateDlg>().DefaultTableView().SearchColumn("Шаблон комментария", x => x.Reason).End(),
OrmObjectMapping <MeasurementUnits> .Create().Dialog <MeasurementUnitsDlg>().DefaultTableView().SearchColumn("ОКЕИ", x => x.OKEI).SearchColumn("Название", x => x.Name).Column("Точность", x => x.Digits.ToString()).End(),
OrmObjectMapping <Contact> .Create().Dialog <ContactDlg>()
.DefaultTableView().SearchColumn("Фамилия", x => x.Surname).SearchColumn("Имя", x => x.Name).SearchColumn("Отчество", x => x.Patronymic).End(),
OrmObjectMapping <Order> .Create().Dialog <OrderDlg>().PopupMenu(OrderPopupMenu.GetPopupMenu),
OrmObjectMapping <UndeliveredOrder> .Create().Dialog <UndeliveredOrderDlg>(),
OrmObjectMapping <Organization> .Create().Dialog <OrganizationDlg>().DefaultTableView().Column("Код", x => x.Id.ToString()).SearchColumn("Название", x => x.Name).End(),
OrmObjectMapping <DeliverySchedule> .Create().Dialog <DeliveryScheduleDlg>().DefaultTableView().SearchColumn("Название", x => x.Name).SearchColumn("Время доставки", x => x.DeliveryTime).End(),
OrmObjectMapping <ProductSpecification> .Create().Dialog <ProductSpecificationDlg>().DefaultTableView().SearchColumn("Код", x => x.Id.ToString()).SearchColumn("Название", x => x.Name).End(),
OrmObjectMapping <EquipmentType> .Create().Dialog <EquipmentTypeDlg>().DefaultTableView().Column("Название", equipmentType => equipmentType.Name).End(),
//Связанное с клиентом
OrmObjectMapping <Proxy> .Create().Dialog <ProxyDlg>()
.DefaultTableView().SearchColumn("Номер", x => x.Number).SearchColumn("С", x => x.StartDate.ToShortDateString()).SearchColumn("По", x => x.ExpirationDate.ToShortDateString()).End(),
OrmObjectMapping <DeliveryPoint> .Create().Dialog <DeliveryPointDlg>().DefaultTableView().SearchColumn("ID", x => x.Id.ToString()).Column("Адрес", x => x.Title).End(),
OrmObjectMapping <PaidRentPackage> .Create().Dialog <PaidRentPackageDlg>()
.DefaultTableView().SearchColumn("Название", x => x.Name).Column("Тип оборудования", x => x.EquipmentType.Name).SearchColumn("Цена в сутки", x => CurrencyWorks.GetShortCurrencyString(x.PriceDaily)).SearchColumn("Цена в месяц", x => CurrencyWorks.GetShortCurrencyString(x.PriceMonthly)).End(),
OrmObjectMapping <FreeRentPackage> .Create().Dialog <FreeRentPackageDlg>().DefaultTableView().SearchColumn("Название", x => x.Name).Column("Тип оборудования", x => x.EquipmentType.Name).OrderAsc(x => x.Name).End(),
OrmObjectMapping <Counterparty> .Create().Dialog <CounterpartyDlg>().DefaultTableView().SearchColumn("Название", x => x.FullName).End(),
OrmObjectMapping <Tag> .Create().Dialog <TagDlg>().DefaultTableView().SearchColumn("Название", x => x.Name).End(),
OrmObjectMapping <CounterpartyContract> .Create().Dialog <CounterpartyContractDlg>(),
OrmObjectMapping <DocTemplate> .Create().Dialog <DocTemplateDlg>().DefaultTableView().SearchColumn("Название", x => x.Name).Column("Тип", x => x.TemplateType.GetEnumTitle()).End(),
OrmObjectMapping <TransferOperationDocument> .Create().Dialog <TransferOperationDocumentDlg>(),
//Справочники с фильтрами
OrmObjectMapping <Equipment> .Create().Dialog <EquipmentDlg>().JournalFilter <EquipmentFilter>()
.DefaultTableView().Column("Код", x => x.Id.ToString()).SearchColumn("Номенклатура", x => x.NomenclatureName).Column("Тип", x => x.Nomenclature.Type.Name).SearchColumn("Серийный номер", x => x.Serial).Column("Дата последней обработки", x => x.LastServiceDate.ToShortDateString()).End(),
//Логисткика
OrmObjectMapping <RouteList> .Create().Dialog <RouteListCreateDlg>()
.DefaultTableView().SearchColumn("Номер", x => x.Id.ToString()).Column("Дата", x => x.Date.ToShortDateString()).Column("Статус", x => x.Status.GetEnumTitle()).SearchColumn("Водитель", x => String.Format("{0} - {1}", x.Driver.FullName, x.Car.Title)).End(),
OrmObjectMapping <RouteColumn> .Create().DefaultTableView().Column("Код", x => x.Id.ToString()).SearchColumn("Название", x => x.Name).End(),
OrmObjectMapping <DeliveryShift> .Create().Dialog <DeliveryShiftDlg>().DefaultTableView().SearchColumn("Название", x => x.Name).SearchColumn("Диапазон времени", x => x.DeliveryTime).End(),
OrmObjectMapping <DeliveryDaySchedule> .Create().Dialog <DeliveryDayScheduleDlg>().DefaultTableView().SearchColumn("Название", x => x.Name).End(),
//Сервис
OrmObjectMapping <ServiceClaim> .Create().Dialog <ServiceClaimDlg>().DefaultTableView().Column("Номер", x => x.Id.ToString()).Column("Тип", x => x.ServiceClaimType.GetEnumTitle()).Column("Оборудование", x => x.Equipment.Title).Column("Подмена", x => x.ReplacementEquipment != null ? "Да" : "Нет").Column("Точка доставки", x => x.DeliveryPoint.Title).End(),
//Касса
OrmObjectMapping <Income> .Create().Dialog <CashIncomeDlg> (),
OrmObjectMapping <ExpenseCategory> .Create().Dialog <ExpenseCategoryViewModel>().DefaultTableView().Column("Код", x => x.Id.ToString()).SearchColumn("Название", e => e.Name).Column("Тип документа", e => e.ExpenseDocumentType.GetEnumTitle()).TreeConfig(new RecursiveTreeConfig <ExpenseCategory>(x => x.Parent, x => x.Childs)).End(),
OrmObjectMapping <Expense> .Create().Dialog <CashExpenseDlg> (),
OrmObjectMapping <AdvanceReport> .Create().Dialog <AdvanceReportDlg> (),
OrmObjectMapping <Fine> .Create().Dialog <FineDlg> (),
OrmObjectMapping <Premium> .Create().Dialog <PremiumDlg> (),
OrmObjectMapping <IncomeCashTransferDocument> .Create().Dialog <IncomeCashTransferDlg>(),
OrmObjectMapping <CommonCashTransferDocument> .Create().Dialog <CommonCashTransferDlg>(),
//Банкинг
OrmObjectMapping <AccountIncome> .Create(),
OrmObjectMapping <AccountExpense> .Create(),
//Склад
OrmObjectMapping <Warehouse> .Create().Dialog <WarehouseDlg>().DefaultTableView().Column("Название", w => w.Name).Column("В архиве", w => w.IsArchive ? "Да":"").End(),
OrmObjectMapping <RegradingOfGoodsTemplate> .Create().Dialog <RegradingOfGoodsTemplateDlg>().DefaultTableView().Column("Название", w => w.Name).End()
};
#region Складские документы
OrmMain.AddObjectDescription <IncomingWater>().Dialog <IncomingWaterDlg>();
OrmMain.AddObjectDescription <WriteoffDocument>().Dialog <WriteoffDocumentDlg>();
OrmMain.AddObjectDescription <InventoryDocument>().Dialog <InventoryDocumentDlg>();
OrmMain.AddObjectDescription <ShiftChangeWarehouseDocument>().Dialog <ShiftChangeWarehouseDocumentDlg>();
OrmMain.AddObjectDescription <RegradingOfGoodsDocument>().Dialog <RegradingOfGoodsDocumentDlg>();
OrmMain.AddObjectDescription <SelfDeliveryDocument>().Dialog <SelfDeliveryDocumentDlg>();
OrmMain.AddObjectDescription <CarLoadDocument>().Dialog <CarLoadDocumentDlg>();
OrmMain.AddObjectDescription <CarUnloadDocument>().Dialog <CarUnloadDocumentDlg>();
#endregion
#region Goods
OrmMain.AddObjectDescription <Nomenclature>().Dialog <NomenclatureDlg>().JournalFilter <NomenclatureFilter>().
DefaultTableView()
.SearchColumn("Код", x => x.Id.ToString())
.SearchColumn("Название", x => x.Name)
.Column("Тип", x => x.CategoryString)
.SearchColumn("Номер в ИМ", x => x.OnlineStoreExternalId)
.End();
OrmMain.AddObjectDescription <Folder1c>().Dialog <Folder1cDlg>()
.DefaultTableView()
.SearchColumn("Код 1С", x => x.Code1c)
.SearchColumn("Название", x => x.Name)
.TreeConfig(new RecursiveTreeConfig <Folder1c>(x => x.Parent, x => x.Childs)).End();
#endregion
#region Простые справочники
OrmMain.AddObjectDescription <DiscountReason>()
.DefaultTableView()
.SearchColumn("Название", x => x.Name)
.End();
OrmMain.AddObjectDescription <GeographicGroup>()
.Dialog <GeographicGroupDlg>()
.DefaultTableView()
.SearchColumn("Название", x => x.Name)
.Column("Код", x => x.Id.ToString())
.End();
OrmMain.AddObjectDescription <TariffZone>()
.DefaultTableView()
.SearchColumn("Номер", x => x.Id.ToString())
.SearchColumn("Название", x => x.Name)
.End();
OrmMain.AddObjectDescription <NonReturnReason>()
.DefaultTableView()
.SearchColumn("Код", x => x.Id.ToString())
.SearchColumn("Название", x => x.Name)
.End();
OrmMain.AddObjectDescription <PaymentFrom>()
.DefaultTableView()
.SearchColumn("Код", x => x.Id.ToString())
.SearchColumn("Название", x => x.Name)
.End();
OrmMain.AddObjectDescription <Post>()
.DefaultTableView()
.SearchColumn("Код", x => x.Id.ToString())
.SearchColumn("Название", x => x.Name)
.End();
#endregion
#region неПростые справочники
OrmMain.AddObjectDescription <Subdivision>().Dialog <SubdivisionDlg>().DefaultTableView().SearchColumn("Название", x => x.Name).Column("Руководитель", x => x.Chief == null ? "" : x.Chief.ShortName).SearchColumn("Номер", x => x.Id.ToString()).TreeConfig(new RecursiveTreeConfig <Subdivision>(x => x.ParentSubdivision, x => x.ChildSubdivisions)).End();
OrmMain.AddObjectDescription <TypeOfEntity>()
.Dialog <TypeOfEntityDlg>()
.DefaultTableView()
.SearchColumn("Тип документа", x => TypeOfEntityRepository.GetEntityNameByString(x.Type))
.SearchColumn("Название документа", x => x.CustomName)
.SearchColumn("Код", x => x.Id.ToString())
.Column("Активно", x => !x.IsActive ? "нет" : String.Empty)
.SearchColumn("Имя класса", x => x.Type)
.OrderAsc(x => x.CustomName)
.End();
OrmMain.AddObjectDescription <Employee>().Dialog <EmployeeDlg>().DefaultTableView()
.Column("Код", x => x.Id.ToString())
.SearchColumn("Ф.И.О.", x => x.FullName)
.Column("Категория", x => x.Category.GetEnumTitle())
.OrderAsc(x => x.LastName).OrderAsc(x => x.Name).OrderAsc(x => x.Patronymic)
.End();
OrmMain.AddObjectDescription <Trainee>().Dialog <TraineeDlg>().DefaultTableView()
.Column("Код", x => x.Id.ToString())
.SearchColumn("Ф.И.О.", x => x.FullName)
.OrderAsc(x => x.LastName).OrderAsc(x => x.Name).OrderAsc(x => x.Patronymic)
.End();
OrmMain.AddObjectDescription <DeliveryPriceRule>().Dialog <DeliveryPriceRuleDlg>().DefaultTableView()
.Column("< 19л б.", x => x.Water19LCount.ToString())
.Column("< 6л б.", x => x.Water6LCount)
.Column("< 1,5л б.", x => x.Water1500mlCount)
.Column("< 0,6л б.", x => x.Water600mlCount)
.Column("Минимальная сумма заказа", x => x.OrderMinSumEShopGoods.ToString())
.SearchColumn("Описание правила", x => x.Title)
.End();
OrmMain.AddObjectDescription <Car>().Dialog <CarsDlg>().DefaultTableView()
.SearchColumn("Код", x => x.Id.ToString())
.SearchColumn("Модель а/м", x => x.Model)
.SearchColumn("Гос. номер", x => x.RegistrationNumber)
.SearchColumn("Водитель", x => x.Driver != null ? x.Driver.FullName : string.Empty)
.End();
OrmMain.AddObjectDescription <Certificate>().Dialog <CertificateDlg>().DefaultTableView()
.SearchColumn("Имя", x => x.Name)
.Column("Тип", x => x.TypeOfCertificate.GetEnumTitle())
.SearchColumn("Номер", x => x.Id.ToString())
.SearchColumn("Начало срока", x => x.StartDate.HasValue ? x.StartDate.Value.ToString("dd.MM.yyyy") : "Ошибка!")
.SearchColumn("Окончание срока", x => x.ExpirationDate.HasValue ? x.ExpirationDate.Value.ToString("dd.MM.yyyy") : "Бессрочно")
.Column("Архивный?", x => x.IsArchive ? "Да" : string.Empty)
.OrderAsc(x => x.IsArchive)
.OrderAsc(x => x.Id)
.End();
OrmMain.AddObjectDescription <StoredImageResource>().Dialog <ImageLoaderDlg>().DefaultTableView()
.SearchColumn("Номер", x => x.Id.ToString())
.SearchColumn("Название", x => x.Name)
.End();
OrmMain.AddObjectDescription <DeliveryPointCategory>().Dialog <DeliveryPointCategoryDlg>().DefaultTableView()
.SearchColumn("Код", x => x.Id.ToString())
.SearchColumn("Название", x => x.Name)
.Column("В архиве?", x => x.IsArchive ? "Да" : "Нет")
.OrderAsc(x => x.Name)
.End();
OrmMain.AddObjectDescription <CounterpartyActivityKind>().Dialog <CounterpartyActivityKindDlg>().DefaultTableView()
.SearchColumn("Код", x => x.Id.ToString())
.SearchColumn("Название", x => x.Name)
.End();
#endregion
OrmMain.ClassMappingList.AddRange(QSBanks.QSBanksMain.GetModuleMaping());
#endregion
HistoryMain.Enable();
TemplatePrinter.InitPrinter();
ImagePrinter.InitPrinter();
//Настройка ParentReference
ParentReferenceConfig.AddActions(new ParentReferenceActions <Organization, Account> {
AddNewChild = (o, a) => o.AddAccount(a)
});
ParentReferenceConfig.AddActions(new ParentReferenceActions <Counterparty, Account> {
AddNewChild = (c, a) => c.AddAccount(a)
});
ParentReferenceConfig.AddActions(new ParentReferenceActions <Employee, Account> {
AddNewChild = (c, a) => c.AddAccount(a)
});
ParentReferenceConfig.AddActions(new ParentReferenceActions <Trainee, Account> {
AddNewChild = (c, a) => c.AddAccount(a)
});
}
public static void Main(string[] args)
{
AppDomain.CurrentDomain.UnhandledException += AppDomain_CurrentDomain_UnhandledException;
AppDomain.CurrentDomain.ProcessExit += CurrentDomain_ProcessExit;
try {
var builder = new ConfigurationBuilder()
.AddIniFile(configFile, optional: false);
var configuration = builder.Build();
var serviceSection = configuration.GetSection("Service");
serviceHostName = serviceSection["service_host_name"];
servicePort = serviceSection["service_port"];
serviceWebPort = serviceSection["service_web_port"];
var mysqlSection = configuration.GetSection("Mysql");
mysqlServerHostName = mysqlSection["mysql_server_host_name"];
mysqlServerPort = mysqlSection["mysql_server_port"];
mysqlUser = mysqlSection["mysql_user"];
mysqlPassword = mysqlSection["mysql_password"];
mysqlDatabase = mysqlSection["mysql_database"];
}
catch (Exception ex) {
logger.Fatal(ex, "Ошибка чтения конфигурационного файла.");
return;
}
logger.Info("Запуск службы отправки электронной почты");
try {
var conStrBuilder = new MySqlConnectionStringBuilder();
conStrBuilder.Server = mysqlServerHostName;
conStrBuilder.Port = uint.Parse(mysqlServerPort);
conStrBuilder.Database = mysqlDatabase;
conStrBuilder.UserID = mysqlUser;
conStrBuilder.Password = mysqlPassword;
conStrBuilder.SslMode = MySqlSslMode.None;
QSMain.ConnectionString = conStrBuilder.GetConnectionString(true);
var db_config = FluentNHibernate.Cfg.Db.MySQLConfiguration.Standard
.Dialect <NHibernate.Spatial.Dialect.MySQL57SpatialDialect>()
.ConnectionString(QSMain.ConnectionString);
OrmConfig.ConfigureOrm(db_config,
new System.Reflection.Assembly[] {
System.Reflection.Assembly.GetAssembly(typeof(Vodovoz.HibernateMapping.OrganizationMap)),
System.Reflection.Assembly.GetAssembly(typeof(QS.Banks.Domain.Bank)),
System.Reflection.Assembly.GetAssembly(typeof(EmailService.OrderEmail)),
System.Reflection.Assembly.GetAssembly(typeof(QS.HistoryLog.HistoryMain)),
System.Reflection.Assembly.GetAssembly(typeof(QS.Project.Domain.UserBase))
});
QS.HistoryLog.HistoryMain.Enable();
EmailInstanceProvider emailInstanceProvider =
new EmailInstanceProvider(new BaseParametersProvider(new ParametersProvider()));
ServiceHost EmailSendingHost = new EmailServiceHost(emailInstanceProvider);
ServiceHost MailjetEventsHost = new EmailServiceHost(emailInstanceProvider);
ServiceEndpoint webEndPoint = EmailSendingHost.AddServiceEndpoint(
typeof(IEmailServiceWeb),
new WebHttpBinding(),
String.Format("http://{0}:{1}/EmailServiceWeb", serviceHostName, serviceWebPort)
);
WebHttpBehavior httpBehavior = new WebHttpBehavior();
webEndPoint.Behaviors.Add(httpBehavior);
EmailSendingHost.AddServiceEndpoint(
typeof(IEmailService),
new BasicHttpBinding(),
String.Format("http://{0}:{1}/EmailService", serviceHostName, servicePort)
);
var mailjetEndPoint = MailjetEventsHost.AddServiceEndpoint(
typeof(IMailjetEventService),
new WebHttpBinding(),
String.Format("http://{0}:{1}/Mailjet", serviceHostName, servicePort)
);
WebHttpBehavior mailjetHttpBehavior = new WebHttpBehavior();
mailjetEndPoint.Behaviors.Add(httpBehavior);
#if DEBUG
EmailSendingHost.Description.Behaviors.Add(new PreFilter());
MailjetEventsHost.Description.Behaviors.Add(new PreFilter());
#endif
EmailSendingHost.Open();
MailjetEventsHost.Open();
logger.Info("Server started.");
if (Environment.OSVersion.Platform == PlatformID.Unix)
{
UnixSignal[] signals =
{
new UnixSignal(Signum.SIGINT),
new UnixSignal(Signum.SIGHUP),
new UnixSignal(Signum.SIGTERM)
};
UnixSignal.WaitAny(signals);
}
else
{
Console.ReadLine();
}
}
catch (Exception e) {
logger.Fatal(e);
}
finally {
if (Environment.OSVersion.Platform == PlatformID.Unix)
{
Thread.CurrentThread.Abort();
}
Environment.Exit(0);
}
}
static void CreateBaseConfig()
{
logger.Info("Настройка параметров базы...");
//Увеличиваем таймоут
QSMain.ConnectionString += ";ConnectionTimeout=120";
var db_config = FluentNHibernate.Cfg.Db.MySQLConfiguration.Standard
.Dialect <NHibernate.Spatial.Dialect.MySQL57SpatialDialect>()
.ConnectionString(QSMain.ConnectionString)
.AdoNetBatchSize(100)
.ShowSql()
.FormatSql();
// Настройка ORM
OrmConfig.ConfigureOrm(db_config, new System.Reflection.Assembly[] {
System.Reflection.Assembly.GetAssembly(typeof(QS.Project.HibernateMapping.UserBaseMap)),
System.Reflection.Assembly.GetAssembly(typeof(Vodovoz.HibernateMapping.OrganizationMap)),
System.Reflection.Assembly.GetAssembly(typeof(QSBanks.QSBanksMain)),
System.Reflection.Assembly.GetAssembly(typeof(QSContacts.QSContactsMain)),
System.Reflection.Assembly.GetAssembly(typeof(QS.HistoryLog.HistoryMain)),
},
(cnf) => cnf.DataBaseIntegration(
dbi => { dbi.BatchSize = 100; dbi.Batcher <MySqlClientBatchingBatcherFactory>(); }
));
#region Dialogs mapping
OrmMain.ClassMappingList = new List <IOrmObjectMapping> {
//Простые справочники
OrmObjectMapping <CullingCategory> .Create().DefaultTableView().SearchColumn("Название", x => x.Name).End(),
OrmObjectMapping <Nationality> .Create().DefaultTableView().SearchColumn("Название", x => x.Name).End(),
OrmObjectMapping <Manufacturer> .Create().DefaultTableView().SearchColumn("Название", x => x.Name).End(),
OrmObjectMapping <EquipmentColors> .Create().DefaultTableView().SearchColumn("Название", x => x.Name).End(),
OrmObjectMapping <User> .Create().DefaultTableView().SearchColumn("Название", x => x.Name).End(),
OrmObjectMapping <UserSettings> .Create().Dialog <UserSettingsDlg>(),
OrmObjectMapping <FuelType> .Create().Dialog <FuelTypeDlg>().DefaultTableView().SearchColumn("Название", x => x.Name).SearchColumn("Стоимость", x => x.Cost.ToString()).End(),
OrmObjectMapping <MovementWagon> .Create().DefaultTableView().SearchColumn("Название", x => x.Name).End(),
//Остальные справочники
//OrmObjectMapping<CarProxyDocument>.Create().Dialog<ProxyDocumentDlg>().DefaultTableView().SearchColumn("Водитель", x => x.Driver != null ? x.Driver.Title : "").End(),
OrmObjectMapping <CarProxyDocument> .Create().Dialog <CarProxyDlg>(),
OrmObjectMapping <M2ProxyDocument> .Create().Dialog <M2ProxyDlg>(),
OrmObjectMapping <CommentTemplate> .Create().Dialog <CommentTemplateDlg>().DefaultTableView().SearchColumn("Шаблон комментария", x => x.Comment).End(),
OrmObjectMapping <FineTemplate> .Create().Dialog <FineTemplateDlg>().DefaultTableView().SearchColumn("Шаблон комментария", x => x.Reason).End(),
OrmObjectMapping <PremiumTemplate> .Create().Dialog <PremiumTemplateDlg>().DefaultTableView().SearchColumn("Шаблон комментария", x => x.Reason).End(),
OrmObjectMapping <MeasurementUnits> .Create().Dialog <MeasurementUnitsDlg>().DefaultTableView().SearchColumn("ОКЕИ", x => x.OKEI).SearchColumn("Название", x => x.Name).Column("Точность", x => x.Digits.ToString()).End(),
OrmObjectMapping <Contact> .Create().Dialog <ContactDlg>()
.DefaultTableView().SearchColumn("Фамилия", x => x.Surname).SearchColumn("Имя", x => x.Name).SearchColumn("Отчество", x => x.Patronymic).End(),
OrmObjectMapping <Car> .Create().Dialog <CarsDlg>()
.DefaultTableView().SearchColumn("Модель а/м", x => x.Model).SearchColumn("Гос. номер", x => x.RegistrationNumber).SearchColumn("Водитель", x => x.Driver != null ? x.Driver.FullName : String.Empty).End(),
OrmObjectMapping <Order> .Create().Dialog <OrderDlg>().PopupMenu(OrderPopupMenu.GetPopupMenu),
OrmObjectMapping <UndeliveredOrder> .Create().Dialog <UndeliveredOrderDlg>(),
OrmObjectMapping <Organization> .Create().Dialog <OrganizationDlg>().DefaultTableView().Column("Код", x => x.Id.ToString()).SearchColumn("Название", x => x.Name).End(),
OrmObjectMapping <DeliverySchedule> .Create().Dialog <DeliveryScheduleDlg>().DefaultTableView().SearchColumn("Название", x => x.Name).SearchColumn("Время доставки", x => x.DeliveryTime).End(),
OrmObjectMapping <ProductSpecification> .Create().Dialog <ProductSpecificationDlg>().DefaultTableView().SearchColumn("Код", x => x.Id.ToString()).SearchColumn("Название", x => x.Name).End(),
OrmObjectMapping <EquipmentType> .Create().Dialog <EquipmentTypeDlg>().DefaultTableView().Column("Название", equipmentType => equipmentType.Name).End(),
//Связанное с клиентом
OrmObjectMapping <Proxy> .Create().Dialog <ProxyDlg>()
.DefaultTableView().SearchColumn("Номер", x => x.Number).SearchColumn("С", x => x.StartDate.ToShortDateString()).SearchColumn("По", x => x.ExpirationDate.ToShortDateString()).End(),
OrmObjectMapping <DeliveryPoint> .Create().Dialog <DeliveryPointDlg>().DefaultTableView().SearchColumn("ID", x => x.Id.ToString()).Column("Адрес", x => x.Title).End(),
OrmObjectMapping <PaidRentPackage> .Create().Dialog <PaidRentPackageDlg>()
.DefaultTableView().SearchColumn("Название", x => x.Name).Column("Тип оборудования", x => x.EquipmentType.Name).SearchColumn("Цена в сутки", x => CurrencyWorks.GetShortCurrencyString(x.PriceDaily)).SearchColumn("Цена в месяц", x => CurrencyWorks.GetShortCurrencyString(x.PriceMonthly)).End(),
OrmObjectMapping <FreeRentPackage> .Create().Dialog <FreeRentPackageDlg>().DefaultTableView().SearchColumn("Название", x => x.Name).Column("Тип оборудования", x => x.EquipmentType.Name).OrderAsc(x => x.Name).End(),
OrmObjectMapping <FreeRentAgreement> .Create().Dialog <FreeRentAgreementDlg>(),
OrmObjectMapping <DailyRentAgreement> .Create().Dialog <DailyRentAgreementDlg>(),
OrmObjectMapping <NonfreeRentAgreement> .Create().Dialog <NonFreeRentAgreementDlg>(),
OrmObjectMapping <SalesEquipmentAgreement> .Create().Dialog <EquipSalesAgreementDlg>(),
OrmObjectMapping <WaterSalesAgreement> .Create().Dialog <WaterAgreementDlg>(),
OrmObjectMapping <RepairAgreement> .Create().Dialog <RepairAgreementDlg>(),
OrmObjectMapping <Counterparty> .Create().Dialog <CounterpartyDlg>().DefaultTableView().SearchColumn("Название", x => x.FullName).End(),
OrmObjectMapping <Tag> .Create().Dialog <TagDlg>().DefaultTableView().SearchColumn("Название", x => x.Name).End(),
OrmObjectMapping <ClientCameFrom> .Create().Dialog <ClientCameFromDlg>().DefaultTableView().SearchColumn("Название", x => x.Name).End(),
OrmObjectMapping <CounterpartyContract> .Create().Dialog <CounterpartyContractDlg>(),
OrmObjectMapping <DocTemplate> .Create().Dialog <DocTemplateDlg>().DefaultTableView().SearchColumn("Название", x => x.Name).Column("Тип", x => x.TemplateType.GetEnumTitle()).End(),
OrmObjectMapping <Residue> .Create().Dialog <ResidueDlg>(),
OrmObjectMapping <TransferOperationDocument> .Create().Dialog <TransferOperationDocumentDlg>(),
//Справочники с фильтрами
OrmObjectMapping <Equipment> .Create().Dialog <EquipmentDlg>().JournalFilter <EquipmentFilter>()
.DefaultTableView().Column("Код", x => x.Id.ToString()).SearchColumn("Номенклатура", x => x.NomenclatureName).Column("Тип", x => x.Nomenclature.Type.Name).SearchColumn("Серийный номер", x => x.Serial).Column("Дата последней обработки", x => x.LastServiceDate.ToShortDateString()).End(),
//Логисткика
OrmObjectMapping <RouteList> .Create().Dialog <RouteListCreateDlg>()
.DefaultTableView().SearchColumn("Номер", x => x.Id.ToString()).Column("Дата", x => x.Date.ToShortDateString()).Column("Статус", x => x.Status.GetEnumTitle()).SearchColumn("Водитель", x => String.Format("{0} - {1}", x.Driver.FullName, x.Car.Title)).End(),
OrmObjectMapping <RouteColumn> .Create().DefaultTableView().Column("Код", x => x.Id.ToString()).SearchColumn("Название", x => x.Name).End(),
OrmObjectMapping <DeliveryShift> .Create().Dialog <DeliveryShiftDlg>().DefaultTableView().SearchColumn("Название", x => x.Name).SearchColumn("Диапазон времени", x => x.DeliveryTime).End(),
OrmObjectMapping <DeliveryDaySchedule> .Create().Dialog <DeliveryDayScheduleDlg>().DefaultTableView().SearchColumn("Название", x => x.Name).End(),
OrmObjectMapping <LogisticsArea> .Create().Dialog <LogisticsAreaDlg>().DefaultTableView().SearchColumn("Название", x => x.Name).Column("Город", x => x.IsCity ? "Да" : "Нет").End(),
//Сервис
OrmObjectMapping <ServiceClaim> .Create().Dialog <ServiceClaimDlg>().DefaultTableView().Column("Номер", x => x.Id.ToString()).Column("Тип", x => x.ServiceClaimType.GetEnumTitle()).Column("Оборудование", x => x.Equipment.Title).Column("Подмена", x => x.ReplacementEquipment != null ? "Да" : "Нет").Column("Точка доставки", x => x.DeliveryPoint.Title).End(),
//Касса
OrmObjectMapping <IncomeCategory> .Create().EditPermision("money_manage_cash").DefaultTableView().Column("Код", x => x.Id.ToString()).Column("Название", e => e.Name).End(),
OrmObjectMapping <ExpenseCategory> .Create().Dialog <CashExpenseCategoryDlg>().EditPermision("money_manage_cash").DefaultTableView().Column("Код", x => x.Id.ToString()).SearchColumn("Название", e => e.Name).TreeConfig(new RecursiveTreeConfig <ExpenseCategory>(x => x.Parent, x => x.Childs)).End(),
OrmObjectMapping <Income> .Create().Dialog <CashIncomeDlg> (),
OrmObjectMapping <Expense> .Create().Dialog <CashExpenseDlg> (),
OrmObjectMapping <AdvanceReport> .Create().Dialog <AdvanceReportDlg> (),
OrmObjectMapping <Fine> .Create().Dialog <FineDlg> (),
OrmObjectMapping <Premium> .Create().Dialog <PremiumDlg> (),
//Банкинг
OrmObjectMapping <AccountIncome> .Create(),
OrmObjectMapping <AccountExpense> .Create(),
//Склад
OrmObjectMapping <Warehouse> .Create().Dialog <WarehouseDlg>().DefaultTableView().Column("Название", w => w.Name).Column("В архиве", w => w.IsArchive ? "Да":"").End(),
OrmObjectMapping <RegradingOfGoodsTemplate> .Create().Dialog <RegradingOfGoodsTemplateDlg>().DefaultTableView().Column("Название", w => w.Name).End()
};
#region Складские документы
OrmMain.AddObjectDescription <IncomingInvoice>().Dialog <IncomingInvoiceDlg>();
OrmMain.AddObjectDescription <IncomingWater>().Dialog <IncomingWaterDlg>();
OrmMain.AddObjectDescription <MovementDocument>().Dialog <MovementDocumentDlg>();
OrmMain.AddObjectDescription <WriteoffDocument>().Dialog <WriteoffDocumentDlg>();
OrmMain.AddObjectDescription <InventoryDocument>().Dialog <InventoryDocumentDlg>();
OrmMain.AddObjectDescription <ShiftChangeWarehouseDocument>().Dialog <ShiftChangeWarehouseDocumentDlg>();
OrmMain.AddObjectDescription <RegradingOfGoodsDocument>().Dialog <RegradingOfGoodsDocumentDlg>();
OrmMain.AddObjectDescription <SelfDeliveryDocument>().Dialog <SelfDeliveryDocumentDlg>();
OrmMain.AddObjectDescription <CarLoadDocument>().Dialog <CarLoadDocumentDlg>();
OrmMain.AddObjectDescription <CarUnloadDocument>().Dialog <CarUnloadDocumentDlg>();
#endregion
#region Goods
OrmMain.AddObjectDescription <Nomenclature>().Dialog <NomenclatureDlg>().JournalFilter <NomenclatureFilter>().DefaultTableView().SearchColumn("Код", x => x.Id.ToString()).SearchColumn("Название", x => x.Name).Column("Тип", x => x.CategoryString).End();
OrmMain.AddObjectDescription <Folder1c>().Dialog <Folder1cDlg>().DefaultTableView().SearchColumn("Код 1С", x => x.Code1c).SearchColumn("Название", x => x.Name).TreeConfig(new RecursiveTreeConfig <Folder1c>(x => x.Parent, x => x.Childs)).End();
OrmMain.AddObjectDescription <ProductGroup>().Dialog <ProductGroupDlg>().EditPermision("can_edit_online_store").DefaultTableView().SearchColumn("Код", x => x.Id.ToString()).SearchColumn("Название", x => x.Name).TreeConfig(new RecursiveTreeConfig <ProductGroup>(x => x.Parent, x => x.Childs)).End();
#endregion
OrmMain.AddObjectDescription <DiscountReason>().DefaultTableView().SearchColumn("Название", x => x.Name).End();
# region Простые справочники
public static void Main(string[] args)
{
AppDomain.CurrentDomain.UnhandledException += AppDomain_CurrentDomain_UnhandledException;
logger.Info("Чтение конфигурационного файла...");
IConfig serviceConfig;
IConfig kassaConfig;
IConfig[] cashboxesConfig;
try {
XmlConfigSource confFile = new XmlConfigSource(configFile);
confFile.Reload();
serviceConfig = confFile.Configs["Service"];
kassaConfig = confFile.Configs["ModulKassa"];
cashboxesConfig = new[] {
confFile.Configs["RetailPointSosnovcev"],
confFile.Configs["RetailPointVodovozSouth"],
confFile.Configs["RetailPointVodovozNorth"]
};
IConfig mysqlConfig = confFile.Configs["Mysql"];
mysqlServerHostName = mysqlConfig.GetString("mysql_server_host_name");
mysqlServerPort = mysqlConfig.GetString("mysql_server_port", "3306");
mysqlUser = mysqlConfig.GetString("mysql_user");
mysqlPassword = mysqlConfig.GetString("mysql_password");
mysqlDatabase = mysqlConfig.GetString("mysql_database");
}
catch (Exception ex) {
logger.Fatal(ex, "Ошибка чтения конфигурационного файла.");
return;
}
logger.Info("Настройка подключения к БД...");
try {
var conStrBuilder = new MySqlConnectionStringBuilder {
Server = mysqlServerHostName,
Port = UInt32.Parse(mysqlServerPort),
Database = mysqlDatabase,
UserID = mysqlUser,
Password = mysqlPassword,
SslMode = MySqlSslMode.None
};
var dbConfig = FluentNHibernate.Cfg.Db.MySQLConfiguration.Standard
.ConnectionString(conStrBuilder.GetConnectionString(true));
OrmConfig.ConfigureOrm(
dbConfig,
new[] {
System.Reflection.Assembly.GetAssembly(typeof(QS.Banks.Domain.Bank)),
System.Reflection.Assembly.GetAssembly(typeof(Vodovoz.HibernateMapping.OrganizationMap)),
System.Reflection.Assembly.GetAssembly(typeof(QS.HistoryLog.HistoryMain)),
System.Reflection.Assembly.GetAssembly(typeof(QS.Project.Domain.UserBase))
}
);
QS.HistoryLog.HistoryMain.Enable();
}
catch (Exception ex) {
logger.Fatal(ex, "Ошибка в настройке подключения к БД.");
return;
}
try {
ReceiptServiceStarter.StartService(serviceConfig, kassaConfig, cashboxesConfig);
if (Environment.OSVersion.Platform == PlatformID.Unix)
{
UnixSignal[] signals =
{
new UnixSignal(Signum.SIGINT),
new UnixSignal(Signum.SIGHUP),
new UnixSignal(Signum.SIGTERM)
};
UnixSignal.WaitAny(signals);
}
else
{
Console.ReadLine();
}
}
catch (Exception e) {
logger.Fatal(e);
}
finally {
if (Environment.OSVersion.Platform == PlatformID.Unix)
{
Thread.CurrentThread.Abort();
}
Environment.Exit(0);
}
}
private void ConfigureDlg()
{
notebook1.Page = 0;
notebook1.ShowTabs = false;
dataentryModel.Binding.AddBinding(Entity, e => e.Model, w => w.Text).InitializeFromSource();
dataentryRegNumber.Binding.AddBinding(Entity, e => e.RegistrationNumber, w => w.Text).InitializeFromSource();
comboTypeOfUse.ItemsEnum = typeof(CarTypeOfUse);
comboTypeOfUse.Binding.AddBinding(Entity, e => e.TypeOfUse, w => w.SelectedItemOrNull).InitializeFromSource();
comboDriverCarKind.ItemsList = UoW.GetAll <DriverCarKind>();
comboDriverCarKind.Binding.AddBinding(Entity, e => e.DriverCarKind, w => w.SelectedItem).InitializeFromSource();
yentryVIN.Binding.AddBinding(Entity, e => e.VIN, w => w.Text).InitializeFromSource();
yentryManufactureYear.Binding.AddBinding(Entity, e => e.ManufactureYear, w => w.Text).InitializeFromSource();
yentryMotorNumber.Binding.AddBinding(Entity, e => e.MotorNumber, w => w.Text).InitializeFromSource();
yentryChassisNumber.Binding.AddBinding(Entity, e => e.ChassisNumber, w => w.Text).InitializeFromSource();
yentryCarcaseNumber.Binding.AddBinding(Entity, e => e.Carcase, w => w.Text).InitializeFromSource();
yentryColor.Binding.AddBinding(Entity, e => e.Color, w => w.Text).InitializeFromSource();
yentryDocSeries.Binding.AddBinding(Entity, e => e.DocSeries, w => w.Text).InitializeFromSource();
yentryDocNumber.Binding.AddBinding(Entity, e => e.DocNumber, w => w.Text).InitializeFromSource();
yentryDocIssuedOrg.Binding.AddBinding(Entity, e => e.DocIssuedOrg, w => w.Text).InitializeFromSource();
ydatepickerDocIssuedDate.Binding.AddBinding(Entity, e => e.DocIssuedDate, w => w.DateOrNull).InitializeFromSource();
yentryFuelCardNumber.Binding.AddBinding(Entity, e => e.FuelCardNumber, w => w.Text).InitializeFromSource();
yentryFuelCardNumber.Binding.AddFuncBinding(Entity, e => e.CanEditFuelCardNumber, w => w.Sensitive).InitializeFromSource();
yentryPTSNum.Binding.AddBinding(Entity, e => e.DocPTSNumber, w => w.Text).InitializeFromSource();
yentryPTSSeries.Binding.AddBinding(Entity, e => e.DocPTSSeries, w => w.Text).InitializeFromSource();
var filter = new EmployeeFilterViewModel();
filter.SetAndRefilterAtOnce(
x => x.RestrictCategory = EmployeeCategory.driver,
x => x.Status = EmployeeStatus.IsWorking
);
dataentryreferenceDriver.RepresentationModel = new EmployeesVM(filter);
dataentryreferenceDriver.Binding.AddBinding(Entity, e => e.Driver, w => w.Subject).InitializeFromSource();
dataentryFuelType.SubjectType = typeof(FuelType);
dataentryFuelType.Binding.AddBinding(Entity, e => e.FuelType, w => w.Subject).InitializeFromSource();
radiobuttonMain.Active = true;
dataspinbutton1.Binding.AddBinding(Entity, e => e.FuelConsumption, w => w.Value).InitializeFromSource();
maxWeightSpin.Binding.AddBinding(Entity, e => e.MaxWeight, w => w.ValueAsInt).InitializeFromSource();
maxVolumeSpin.Binding.AddBinding(Entity, e => e.MaxVolume, w => w.Value).InitializeFromSource();
minBottlesSpin.Binding.AddBinding(Entity, e => e.MinBottles, w => w.ValueAsInt).InitializeFromSource();
maxBottlesSpin.Binding.AddBinding(Entity, e => e.MaxBottles, w => w.ValueAsInt).InitializeFromSource();
minBottlesFromAddressSpin.Binding.AddBinding(Entity, e => e.MinBottlesFromAddress, w => w.ValueAsInt).InitializeFromSource();
maxBottlesFromAddressSpin.Binding.AddBinding(Entity, e => e.MaxBottlesFromAddress, w => w.ValueAsInt).InitializeFromSource();
photoviewCar.Binding.AddBinding(Entity, e => e.Photo, w => w.ImageFile).InitializeFromSource();
photoviewCar.GetSaveFileName = () => String.Format("{0}({1})", Entity.Model, Entity.RegistrationNumber);
carRepository = new CarRepository();
checkIsRaskat.Active = Entity.IsRaskat;
Entity.PropertyChanged += (s, e) => {
if (e.PropertyName == nameof(Entity.IsRaskat) && checkIsRaskat.Active != Entity.IsRaskat)
{
checkIsRaskat.Active = Entity.IsRaskat;
}
};
checkIsRaskat.Toggled += (s, e) => {
if (!carRepository.IsInAnyRouteList(UoW, Entity))
{
Entity.IsRaskat = checkIsRaskat.Active;
}
else if (checkIsRaskat.Active != Entity.IsRaskat)
{
checkIsRaskat.Active = Entity.IsRaskat;
MessageDialogHelper.RunWarningDialog("На данном автомобиле есть МЛ, смена типа невозможна");
}
};
checkIsArchive.Binding.AddBinding(Entity, e => e.IsArchive, w => w.Active).InitializeFromSource();
attachmentFiles.AttachToTable = OrmConfig.GetDBTableName(typeof(Car));
if (!UoWGeneric.IsNew)
{
attachmentFiles.ItemId = UoWGeneric.Root.Id;
attachmentFiles.UpdateFileList();
}
OnDataentryreferenceDriverChanged(null, null);
textDriverInfo.Selectable = true;
int currentUserId = ServicesConfig.CommonServices.UserService.CurrentUserId;
bool canChangeVolumeWeightConsumption = ServicesConfig.CommonServices.PermissionService.ValidateUserPresetPermission("can_change_cars_volume_weight_consumption", currentUserId) || Entity.Id == 0 || !Entity.IsCompanyCar;
bool canChangeBottlesFromAddress = ServicesConfig.CommonServices.PermissionService.ValidateUserPresetPermission("can_change_cars_bottles_from_address", currentUserId);
dataspinbutton1.Sensitive = canChangeVolumeWeightConsumption;
maxVolumeSpin.Sensitive = canChangeVolumeWeightConsumption;
maxWeightSpin.Sensitive = canChangeVolumeWeightConsumption;
checkIsRaskat.Sensitive = CarTypeIsEditable() || ServicesConfig.CommonServices.CurrentPermissionService.ValidatePresetPermission("can_change_car_is_raskat");
comboTypeOfUse.Sensitive = CarTypeIsEditable();
minBottlesFromAddressSpin.Sensitive = canChangeBottlesFromAddress;
maxBottlesFromAddressSpin.Sensitive = canChangeBottlesFromAddress;
yTreeGeographicGroups.Selection.Mode = Gtk.SelectionMode.Single;
yTreeGeographicGroups.ColumnsConfig = FluentColumnsConfig <GeographicGroup> .Create()
.AddColumn("Название").AddTextRenderer(x => x.Name)
.Finish();
yTreeGeographicGroups.ItemsDataSource = Entity.ObservableGeographicGroups;
UpdateSensitivity();
}
public static void Main(string[] args)
{
AppDomain.CurrentDomain.UnhandledException += AppDomain_CurrentDomain_UnhandledException;
IConfiguration configuration;
try
{
var builder = new ConfigurationBuilder()
.AddIniFile(configFile, optional: false);
configuration = builder.Build();
var serviceSection = configuration.GetSection("Service");
serviceHostName = serviceSection["service_host_name"];
servicePort = serviceSection["service_port"];
serviceWebPort = serviceSection["service_web_port"];
var bitrixSection = configuration.GetSection("Bitrix");
baseAddress = bitrixSection["base_address"];
var mysqlSection = configuration.GetSection("Mysql");
mysqlServerHostName = mysqlSection["mysql_server_host_name"];
mysqlServerPort = mysqlSection["mysql_server_port"];
mysqlUser = mysqlSection["mysql_user"];
mysqlPassword = mysqlSection["mysql_password"];
mysqlDatabase = mysqlSection["mysql_database"];
}
catch (Exception ex) {
logger.Fatal(ex, "Ошибка чтения конфигурационного файла.");
return;
}
logger.Info("Запуск службы оплаты заказов по sms...");
try {
var conStrBuilder = new MySqlConnectionStringBuilder
{
Server = mysqlServerHostName,
Port = UInt32.Parse(mysqlServerPort),
Database = mysqlDatabase,
UserID = mysqlUser,
Password = mysqlPassword,
SslMode = MySqlSslMode.None,
ConnectionTimeout = 30
};
QSMain.ConnectionString = conStrBuilder.GetConnectionString(true);
var dbConfig = FluentNHibernate.Cfg.Db.MySQLConfiguration.Standard
.Dialect <NHibernate.Spatial.Dialect.MySQL57SpatialDialect>()
.ConnectionString(QSMain.ConnectionString);
OrmConfig.ConfigureOrm(dbConfig,
new[]
{
System.Reflection.Assembly.GetAssembly(typeof(Vodovoz.HibernateMapping.OrganizationMap)),
System.Reflection.Assembly.GetAssembly(typeof(QS.Banks.Domain.Bank)),
System.Reflection.Assembly.GetAssembly(typeof(QS.HistoryLog.HistoryMain)),
System.Reflection.Assembly.GetAssembly(typeof(QS.Project.Domain.UserBase)),
System.Reflection.Assembly.GetAssembly(typeof(QS.Project.HibernateMapping.TypeOfEntityMap)),
System.Reflection.Assembly.GetAssembly(typeof(QS.Attachments.Domain.Attachment))
});
QS.HistoryLog.HistoryMain.Enable();
var driverApiSection = configuration.GetSection("DriverAPI");
var driverApiHelperConfiguration = new DriverApiHelperConfiguration
{
ApiBase = new Uri(driverApiSection["ApiBase"]),
NotifyOfSmsPaymentStatusChangedURI = driverApiSection["NotifyOfSmsPaymentStatusChangedURI"],
NotifyOfFastDeliveryOrderAddedURI = driverApiSection["NotifyOfFastDeliveryOrderAddedURI"]
};
ISmsPaymentStatusNotificationReciever smsPaymentStatusNotificationReciever =
new DriverAPIHelper(driverApiHelperConfiguration);
var paymentSender = new BitrixPaymentController(baseAddress);
var smsPaymentFileCache = new SmsPaymentFileCache("/tmp/VodovozSmsPaymentServiceTemp.txt");
SmsPaymentServiceInstanceProvider smsPaymentServiceInstanceProvider = new SmsPaymentServiceInstanceProvider(
paymentSender,
smsPaymentStatusNotificationReciever,
new OrderParametersProvider(new ParametersProvider()),
smsPaymentFileCache,
new SmsPaymentDTOFactory(new OrderOrganizationProviderFactory().CreateOrderOrganizationProvider()),
new SmsPaymentValidator(new OrganizationParametersProvider(new ParametersProvider()))
);
ServiceHost smsPaymentServiceHost = new SmsPaymentServiceHost(smsPaymentServiceInstanceProvider);
ServiceEndpoint webEndPoint = smsPaymentServiceHost.AddServiceEndpoint(
typeof(ISmsPaymentService),
new WebHttpBinding(),
$"http://{serviceHostName}:{serviceWebPort}/SmsPaymentWebService"
);
WebHttpBehavior httpBehavior = new WebHttpBehavior();
webEndPoint.Behaviors.Add(httpBehavior);
smsPaymentServiceHost.AddServiceEndpoint(
typeof(ISmsPaymentService),
new BasicHttpBinding(),
$"http://{serviceHostName}:{servicePort}/SmsPaymentService"
);
smsPaymentServiceHost.Description.Behaviors.Add(new PreFilter());
smsPaymentServiceHost.Open();
logger.Info("Server started.");
var serviceInstance = smsPaymentServiceInstanceProvider.GetInstance(null) as ISmsPaymentService;
serviceInstance?.SynchronizePaymentStatuses();
var unsavedPaymentsWorker = new CachePaymentsWorker(smsPaymentFileCache, serviceInstance);
var overduePaymentsWorker = new OverduePaymentsWorker();
unsavedPaymentsWorker.Start();
overduePaymentsWorker.Start();
if (Environment.OSVersion.Platform == PlatformID.Unix)
{
UnixSignal[] signals =
{
new UnixSignal(Signum.SIGINT),
new UnixSignal(Signum.SIGHUP),
new UnixSignal(Signum.SIGTERM)
};
UnixSignal.WaitAny(signals);
}
else
{
Console.ReadLine();
}
}
catch (Exception e) {
logger.Fatal(e);
}
finally {
if (Environment.OSVersion.Platform == PlatformID.Unix)
{
Thread.CurrentThread.Abort();
}
Environment.Exit(0);
}
}
public static void Main(string[] args)
{
AppDomain.CurrentDomain.UnhandledException += AppDomain_CurrentDomain_UnhandledException;
try {
IniConfigSource confFile = new IniConfigSource(configFile);
confFile.Reload();
IConfig serviceConfig = confFile.Configs["Service"];
serviceHostName = serviceConfig.GetString("service_host_name");
servicePort = serviceConfig.GetString("service_port");
serviceWebPort = serviceConfig.GetString("service_web_port");
driverServiceHostName = serviceConfig.GetString("driver_service_host_name");
driverServicePort = serviceConfig.GetString("driver_service_port");
IConfig bitrixConfig = confFile.Configs["Bitrix"];
baseAddress = bitrixConfig.GetString("base_address");
IConfig mysqlConfig = confFile.Configs["Mysql"];
mysqlServerHostName = mysqlConfig.GetString("mysql_server_host_name");
mysqlServerPort = mysqlConfig.GetString("mysql_server_port", "3306");
mysqlUser = mysqlConfig.GetString("mysql_user");
mysqlPassword = mysqlConfig.GetString("mysql_password");
mysqlDatabase = mysqlConfig.GetString("mysql_database");
}
catch (Exception ex) {
logger.Fatal(ex, "Ошибка чтения конфигурационного файла.");
return;
}
logger.Info("Запуск службы оплаты заказов по sms");
try {
var conStrBuilder = new MySqlConnectionStringBuilder
{
Server = mysqlServerHostName,
Port = UInt32.Parse(mysqlServerPort),
Database = mysqlDatabase,
UserID = mysqlUser,
Password = mysqlPassword,
SslMode = MySqlSslMode.None
};
QSMain.ConnectionString = conStrBuilder.GetConnectionString(true);
var dbConfig = FluentNHibernate.Cfg.Db.MySQLConfiguration.Standard
.Dialect <NHibernate.Spatial.Dialect.MySQL57SpatialDialect>()
.ConnectionString(QSMain.ConnectionString);
OrmConfig.ConfigureOrm(dbConfig,
new[] {
System.Reflection.Assembly.GetAssembly(typeof(Vodovoz.HibernateMapping.OrganizationMap)),
System.Reflection.Assembly.GetAssembly(typeof(QS.Banks.Domain.Bank)),
System.Reflection.Assembly.GetAssembly(typeof(QS.HistoryLog.HistoryMain)),
System.Reflection.Assembly.GetAssembly(typeof(QS.Project.Domain.UserBase))
});
MainSupport.LoadBaseParameters();
QS.HistoryLog.HistoryMain.Enable();
ChannelFactory <IAndroidDriverService> channelFactory = new ChannelFactory <IAndroidDriverService>(
new BasicHttpBinding(),
string.Format("http://{0}:{1}/AndroidDriverService", driverServiceHostName, driverServicePort)
);
IDriverPaymentService driverPaymentService = new DriverPaymentService(channelFactory);
var paymentSender = new BitrixPaymentWorker(baseAddress);
SmsPaymentServiceInstanceProvider smsPaymentServiceInstanceProvider = new SmsPaymentServiceInstanceProvider(paymentSender, driverPaymentService);
ServiceHost smsPaymentServiceHost = new SmsPaymentServiceHost(smsPaymentServiceInstanceProvider);
ServiceEndpoint webEndPoint = smsPaymentServiceHost.AddServiceEndpoint(
typeof(ISmsPaymentService),
new WebHttpBinding(),
$"http://{serviceHostName}:{serviceWebPort}/SmsPaymentWebService"
);
WebHttpBehavior httpBehavior = new WebHttpBehavior();
webEndPoint.Behaviors.Add(httpBehavior);
smsPaymentServiceHost.AddServiceEndpoint(
typeof(ISmsPaymentService),
new BasicHttpBinding(),
$"http://{serviceHostName}:{servicePort}/SmsPaymentService"
);
smsPaymentServiceHost.Description.Behaviors.Add(new PreFilter());
smsPaymentServiceHost.Open();
logger.Info("Server started.");
(smsPaymentServiceInstanceProvider.GetInstance(null) as ISmsPaymentService)?.SynchronizePaymentStatuses();
UnixSignal[] signals =
{
new UnixSignal(Signum.SIGINT),
new UnixSignal(Signum.SIGHUP),
new UnixSignal(Signum.SIGTERM)
};
UnixSignal.WaitAny(signals);
}
catch (Exception e) {
logger.Fatal(e);
}
finally {
if (Environment.OSVersion.Platform == PlatformID.Unix)
{
Thread.CurrentThread.Abort();
}
Environment.Exit(0);
}
}
public static void Main(string[] args)
{
AppDomain.CurrentDomain.UnhandledException += CurrentDomain_UnhandledException;;
AppDomain.CurrentDomain.ProcessExit += CurrentDomain_ProcessExit;
SmsRuConfiguration smsRuConfig;
try {
var builder = new ConfigurationBuilder()
.AddIniFile(configFile, optional: false);
var configuration = builder.Build();
var serviceSection = configuration.GetSection("Service");
serviceHostName = serviceSection["service_host_name"];
servicePort = serviceSection["service_port"];
var mysqlSection = configuration.GetSection("Mysql");
mysqlServerHostName = mysqlSection["mysql_server_host_name"];
mysqlServerPort = mysqlSection["mysql_server_port"];
mysqlUser = mysqlSection["mysql_user"];
mysqlPassword = mysqlSection["mysql_password"];
mysqlDatabase = mysqlSection["mysql_database"];
var smsRuSection = configuration.GetSection("SmsRu");
smsRuConfig =
new SmsRuConfiguration(
smsRuSection["login"],
smsRuSection["password"],
smsRuSection["appId"],
smsRuSection["partnerId"],
smsRuSection["email"],
smsRuSection["smsNumberFrom"],
smsRuSection["smtpLogin"],
smsRuSection["smtpPassword"],
smsRuSection["smtpServer"],
int.Parse(smsRuSection["smtpPort"]),
bool.Parse(smsRuSection["smtpUseSSL"]),
bool.Parse(smsRuSection["translit"]),
bool.Parse(smsRuSection["test"])
);
}
catch (Exception ex) {
logger.Fatal(ex, "Ошибка чтения конфигурационного файла.");
return;
}
try {
var conStrBuilder = new MySqlConnectionStringBuilder();
conStrBuilder.Server = mysqlServerHostName;
conStrBuilder.Port = uint.Parse(mysqlServerPort);
conStrBuilder.Database = mysqlDatabase;
conStrBuilder.UserID = mysqlUser;
conStrBuilder.Password = mysqlPassword;
conStrBuilder.SslMode = MySqlSslMode.None;
QSMain.ConnectionString = conStrBuilder.GetConnectionString(true);
var db_config = FluentNHibernate.Cfg.Db.MySQLConfiguration.Standard
.Dialect <NHibernate.Spatial.Dialect.MySQL57SpatialDialect>()
.ConnectionString(QSMain.ConnectionString);
OrmConfig.ConfigureOrm(db_config,
new System.Reflection.Assembly[] {
System.Reflection.Assembly.GetAssembly(typeof(Vodovoz.HibernateMapping.OrganizationMap)),
System.Reflection.Assembly.GetAssembly(typeof(QS.Banks.Domain.Bank)),
System.Reflection.Assembly.GetAssembly(typeof(QS.HistoryLog.HistoryMain)),
System.Reflection.Assembly.GetAssembly(typeof(QS.Project.Domain.UserBase))
});
MainSupport.LoadBaseParameters();
QS.HistoryLog.HistoryMain.Enable();
ISmsNotificationRepository smsNotificationRepository = new SmsNotificationRepository();
SmsRuSendController smsSender = new SmsRuSendController(smsRuConfig);
newClientInformer = new NewClientSmsInformer(smsSender, smsNotificationRepository);
newClientInformer.Start();
BaseParametersProvider parametersProvider = new BaseParametersProvider();
LowBalanceNotifier lowBalanceNotifier = new LowBalanceNotifier(smsSender, smsSender, parametersProvider);
lowBalanceNotifier.Start();
SmsInformerInstanceProvider serviceStatusInstanceProvider = new SmsInformerInstanceProvider(
smsNotificationRepository,
new BaseParametersProvider()
);
WebServiceHost smsInformerStatus = new SmsInformerServiceHost(serviceStatusInstanceProvider);
smsInformerStatus.AddServiceEndpoint(
typeof(ISmsInformerService),
new WebHttpBinding(),
String.Format("http://{0}:{1}/SmsInformer", serviceHostName, servicePort)
);
smsInformerStatus.Open();
logger.Info("Запущена служба мониторинга отправки смс уведомлений");
UnixSignal[] signals =
{
new UnixSignal(Signum.SIGINT),
new UnixSignal(Signum.SIGHUP),
new UnixSignal(Signum.SIGTERM)
};
UnixSignal.WaitAny(signals);
}
catch (Exception ex) {
logger.Fatal(ex);
}
finally {
if (Environment.OSVersion.Platform == PlatformID.Unix)
{
Thread.CurrentThread.Abort();
}
Environment.Exit(0);
}
}
public static void Main(string[] args)
{
AppDomain.CurrentDomain.UnhandledException += AppDomain_CurrentDomain_UnhandledException;
logger.Info("Чтение конфигурационного файла...");
const string configValueNotFoundString = "Не удалось прочитать значение параметра \"{0}\" из файла конфигурации";
try
{
var builder = new ConfigurationBuilder()
.AddJsonFile(configFile, false);
var configuration = builder.Build();
var serviceConfig = configuration.GetSection("Service");
serviceHostName = serviceConfig["service_host_name"]
?? throw new ConfigurationErrorsException(string.Format(configValueNotFoundString, "service_host_name"));
servicePort = serviceConfig["service_port"]
?? throw new ConfigurationErrorsException(string.Format(configValueNotFoundString, "service_port"));
var modulKassaConfig = configuration.GetSection("ModulKassa");
modulKassaBaseAddress = modulKassaConfig["base_address"]
?? throw new ConfigurationErrorsException(string.Format(configValueNotFoundString, "base_address"));
var mysqlConfig = configuration.GetSection("MySql");
mysqlServerHostName = mysqlConfig["mysql_server_host_name"]
?? throw new ConfigurationErrorsException(string.Format(configValueNotFoundString, "mysql_server_host_name"));
mysqlServerPort = mysqlConfig["mysql_server_port"]
?? throw new ConfigurationErrorsException(string.Format(configValueNotFoundString, "mysql_server_port"));
mysqlUser = mysqlConfig["mysql_user"]
?? throw new ConfigurationErrorsException(string.Format(configValueNotFoundString, "mysql_user"));
mysqlPassword = mysqlConfig["mysql_password"]
?? throw new ConfigurationErrorsException(string.Format(configValueNotFoundString, "mysql_password"));
mysqlDatabase = mysqlConfig["mysql_database"]
?? throw new ConfigurationErrorsException(string.Format(configValueNotFoundString, "mysql_database"));
cashboxes = new List <CashBox>();
var cashboxesConfig = configuration.GetSection("Cashboxes")?.GetChildren()
?? throw new ConfigurationErrorsException(string.Format(configValueNotFoundString, "Cashboxes"));
foreach (var cashboxConfig in cashboxesConfig)
{
string stringId = cashboxConfig["id"];
if (string.IsNullOrWhiteSpace(stringId) || !int.TryParse(stringId, out int id))
{
throw new ConfigurationErrorsException(string.Format(configValueNotFoundString, "id"));
}
string stringUserName = cashboxConfig["user_name"];
if (string.IsNullOrWhiteSpace(stringUserName) || !Guid.TryParse(stringUserName, out Guid userName))
{
throw new ConfigurationErrorsException(string.Format(configValueNotFoundString, "user_name"));
}
var cashBox = new CashBox
{
Id = id,
UserName = userName,
RetailPointName = cashboxConfig["retail_point_name"]
?? throw new ConfigurationErrorsException(string.Format(configValueNotFoundString, "retail_point_name")),
Password = cashboxConfig["password"]
?? throw new ConfigurationErrorsException(string.Format(configValueNotFoundString, "password")),
};
cashboxes.Add(cashBox);
}
if (!cashboxes.Any())
{
throw new ConfigurationErrorsException(
$"В конфигурационном файле не найдено данных ни для одной кассы ({nameof(CashBox)})");
}
}
catch (Exception ex) {
logger.Fatal(ex, "Ошибка чтения конфигурационного файла.");
return;
}
logger.Info("Настройка подключения к БД...");
try {
var conStrBuilder = new MySqlConnectionStringBuilder {
Server = mysqlServerHostName,
Port = UInt32.Parse(mysqlServerPort),
Database = mysqlDatabase,
UserID = mysqlUser,
Password = mysqlPassword,
SslMode = MySqlSslMode.None
};
var dbConfig = FluentNHibernate.Cfg.Db.MySQLConfiguration.Standard
.ConnectionString(conStrBuilder.GetConnectionString(true));
OrmConfig.ConfigureOrm(
dbConfig,
new[]
{
System.Reflection.Assembly.GetAssembly(typeof(QS.Banks.Domain.Bank)),
System.Reflection.Assembly.GetAssembly(typeof(Vodovoz.HibernateMapping.OrganizationMap)),
System.Reflection.Assembly.GetAssembly(typeof(QS.HistoryLog.HistoryMain)),
System.Reflection.Assembly.GetAssembly(typeof(QS.Project.Domain.UserBase)),
System.Reflection.Assembly.GetAssembly(typeof(QS.Project.HibernateMapping.TypeOfEntityMap)),
System.Reflection.Assembly.GetAssembly(typeof(QS.Attachments.Domain.Attachment))
}
);
QS.HistoryLog.HistoryMain.Enable();
}
catch (Exception ex) {
logger.Fatal(ex, "Ошибка в настройке подключения к БД.");
return;
}
try {
ReceiptServiceStarter.StartService(serviceHostName, servicePort, modulKassaBaseAddress, cashboxes);
if (Environment.OSVersion.Platform == PlatformID.Unix)
{
UnixSignal[] signals =
{
new UnixSignal(Signum.SIGINT),
new UnixSignal(Signum.SIGHUP),
new UnixSignal(Signum.SIGTERM)
};
UnixSignal.WaitAny(signals);
}
else
{
Console.ReadLine();
}
}
catch (Exception e) {
logger.Fatal(e);
}
finally {
if (Environment.OSVersion.Platform == PlatformID.Unix)
{
Thread.CurrentThread.Abort();
}
Environment.Exit(0);
}
}
