protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
if (ProducerSelect.SelectedValue == "" || ModelSelect.SelectedValue != "")
{
return;
}
else
{
selectedProducer = ProducerSelect.SelectedValue;
var prod = Producers.Where(x => x.Name == selectedProducer).First();
ModelSelect.DataSource = prod.Models;
ModelSelect.DataTextField = "Name";
ModelSelect.DataValueField = "Name";
ModelSelect.DataBind();
ModelSelect.Items.Insert(0, new ListItem("", ""));
}
}
else
{
ProducerSelect.DataSource = Producers;
ProducerSelect.DataTextField = "Name";
ProducerSelect.DataValueField = "Name";
ProducerSelect.DataBind();
ProducerSelect.Items.Insert(0, new ListItem("", ""));
ExtraSelect.DataSource = Extras;
ExtraSelect.DataTextField = "Name";
ExtraSelect.DataValueField = "Name";
ExtraSelect.DataBind();
}
}
/// <summary>
/// Генерация Выписки в docx
/// </summary>
/// <param name="model">Модель для генерации выписки</param>
/// <returns></returns>
public async Task <Stream> GenerateStatement(ModelSelect model)
{
return(await Task.Factory.StartNew(() =>
{
try
{
SerializeJson serializeJson = new SerializeJson();
model = (ModelSelect)typeof(SqlSelect).GetMethod("ParameterSelect")?.Invoke(new SqlSelect(), new object[] { model });
var type = Type.GetType($"{model.ParameterProcedureWeb.ModelClassFind}, EfDatabaseAutomation");
model = (ModelSelect)typeof(SqlSelect).GetMethod("ResultSelectProcedureString")?.MakeGenericMethod(type).Invoke(new SqlSelect(), new object[] { model });
EfDatabaseAutomation.Automation.BaseLogica.SqlSelect.XsdDTOSheme.Statement statement = (EfDatabaseAutomation.Automation.BaseLogica.SqlSelect.XsdDTOSheme.Statement)serializeJson.JsonDeserializeObjectClass <EfDatabaseAutomation.Automation.BaseLogica.SqlSelect.XsdDTOSheme.Statement>(model.ResultSelectProcedureWeb);
if (statement != null)
{
ReportStatement reportStatement = new ReportStatement();
reportStatement.CreateDocument(_parameterConfig.PathSaveTemplate, statement);
return reportStatement.FileArray();
}
}
catch (Exception ex)
{
Loggers.Log4NetLogger.Error(ex);
}
return null;
}));
}
/// <summary>
/// Модель отчета из БД которая отправится в Open Xml
/// </summary>
/// <param name="report">Параметры отчета Report</param>
/// <returns></returns>
public void ReportInvoice(ref EfDatabaseInvoice.Report report)
{
try
{
ModelSelect model = new ModelSelect {
LogicaSelect = SqlSelectModel(report.ParamRequest.IdSelect)
};
report.Main.Formed = Inventory.Database.SqlQuery <Formed>(model.LogicaSelect.SelectUser,
new SqlParameter(model.LogicaSelect.SelectedParametr.Split(',')[0], 1),
new SqlParameter(model.LogicaSelect.SelectedParametr.Split(',')[1], report.ParamRequest.IdOut),
new SqlParameter(model.LogicaSelect.SelectedParametr.Split(',')[2], report.ParamRequest.IdUsers)).ToList()[0];
report.Main.Received = Inventory.Database.SqlQuery <Received>(model.LogicaSelect.SelectUser,
new SqlParameter(model.LogicaSelect.SelectedParametr.Split(',')[0], 2),
new SqlParameter(model.LogicaSelect.SelectedParametr.Split(',')[1], report.ParamRequest.IdOut),
new SqlParameter(model.LogicaSelect.SelectedParametr.Split(',')[2], report.ParamRequest.IdUsers)).ToList()[0];
report.Body = Inventory.Database.SqlQuery <Body>(model.LogicaSelect.SelectUser,
new SqlParameter(model.LogicaSelect.SelectedParametr.Split(',')[0], 3),
new SqlParameter(model.LogicaSelect.SelectedParametr.Split(',')[1], report.ParamRequest.IdOut),
new SqlParameter(model.LogicaSelect.SelectedParametr.Split(',')[2], report.ParamRequest.IdUsers)).ToArray();
report.Main.Organization = Inventory.Database.SqlQuery <EfDatabaseInvoice.Organization>(model.LogicaSelect.SelectUser,
new SqlParameter(model.LogicaSelect.SelectedParametr.Split(',')[0], 4),
new SqlParameter(model.LogicaSelect.SelectedParametr.Split(',')[1], report.ParamRequest.IdOut),
new SqlParameter(model.LogicaSelect.SelectedParametr.Split(',')[2], report.ParamRequest.IdUsers)).ToList()[0];
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
/// <summary>
/// Поиск по группе абонентов
/// </summary>
/// <param name="idDepNumber">Номер департамента</param>
/// <param name="nameGroup">Наименование группы</param>
/// <returns></returns>
public UserLotus FindUserGroup(int?idDepNumber = null, string nameGroup = null)
{
try
{
UserLotus userLotus = new UserLotus();
ModelSelect model = new ModelSelect {
LogicaSelect = SqlSelectModel(26)
};
if (idDepNumber != null)
{
userLotus.User = Inventory.Database.SqlQuery <EfDatabaseXsdLotusUser.User>(model.LogicaSelect.SelectUser,
new SqlParameter(model.LogicaSelect.SelectedParametr.Split(',')[0], idDepNumber),
new SqlParameter(model.LogicaSelect.SelectedParametr.Split(',')[1], DBNull.Value)).ToArray();
}
else
{
userLotus.User = Inventory.Database.SqlQuery <EfDatabaseXsdLotusUser.User>(model.LogicaSelect.SelectUser,
new SqlParameter(model.LogicaSelect.SelectedParametr.Split(',')[0], DBNull.Value),
new SqlParameter(model.LogicaSelect.SelectedParametr.Split(',')[1], nameGroup)).ToArray();
}
return(userLotus);
}
catch (Exception e)
{
Loggers.Log4NetLogger.Error(e);
}
return(null);
}
private void butUpdateItem_Click(object sender, EventArgs e)
{
try
{
if (rowIndex != -1)
{
dgListItem.Rows[rowIndex].Cells["FileType"].Value = cbbLoaiFile.Text;
dgListItem.Rows[rowIndex].Cells["IndexTypeSelect"].Value = indexCbbFileTypeSelect;
if (indexCbbFileTypeSelect == 0)
{
ModelSelect modelSelect = (ModelSelect)cbbIntConfig.SelectedItem;
dgListItem.Rows[rowIndex].Cells["ValueFile"].Value = modelSelect.Text;
dgListItem.Rows[rowIndex].Cells["IdObj"].Value = modelSelect.Value;
}
else
{
ModelSelect modelSelect = (ModelSelect)cbbSound.SelectedItem;
dgListItem.Rows[rowIndex].Cells["ValueFile"].Value = modelSelect.Text;
dgListItem.Rows[rowIndex].Cells["IdObj"].Value = modelSelect.Value;
}
dgListItem.Rows[rowIndex].Cells["ThuTuDoc"].Value = txtThuTuDoc.Text;
dgListItem.Rows[rowIndex].Cells["IsActiveOfDetail"].Value = chkIsActiveOfDetail.Checked;
}
}
catch (Exception ex)
{
MessageBox.Show("Lỗi: " + ex.Message);
}
}
/// <summary>
/// Выгрузка выписки для формирования файла выписки
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public void ResultStatement(ModelSelect model)
{
var result = Automation.Database.SqlQuery <HeadingStatement>(model.ParameterProcedureWeb.SelectUser,
new SqlParameter(model.ParameterProcedureWeb.ParameterProcedure.Split(',')[0], model.ParametrsSelect.IdCodeProcedure),
new SqlParameter(model.ParameterProcedureWeb.ParameterProcedure.Split(',')[1], string.IsNullOrWhiteSpace(model.ParametrsSelect.Inn) ? (object)DBNull.Value : model.ParametrsSelect.Inn),
new SqlParameter(model.ParameterProcedureWeb.ParameterProcedure.Split(',')[2], model.ParametrsSelect.RegNumber)).ToList();
//return result;
}
private void butChoose_Click(object sender, EventArgs e)
{
try
{
ModelSelect modelSelect = (ModelSelect)cbbSoundInt.SelectedItem;
txtFormula.Text += "(" + modelSelect.Code.Trim() + ")";
}
catch (Exception ex)
{
MessageBox.Show("Lỗi: " + ex.Message);
}
}
/// <summary>
/// Выгрузка ролей пользователя
/// </summary>
/// <param name="idUser">УН пользователя</param>
/// <returns></returns>
public RuleUsers[] AllRuleUser(int idUser)
{
SelectSql sql = new SelectSql();
ModelSelect model = new ModelSelect {
LogicaSelect = sql.SqlSelectModel(34)
};
sql.Dispose();
var ruleAndUser = Inventory.Database.SqlQuery <RuleUsers>(model.LogicaSelect.SelectUser,
new SqlParameter(model.LogicaSelect.SelectedParametr.Split(',')[0], idUser)).ToArray();
return(ruleAndUser);
}
private void butAddItem_Click(object sender, EventArgs e)
{
try
{
DataGridViewRow drow = new DataGridViewRow();
DataGridViewCell cell = new DataGridViewTextBoxCell();
cell.Value = cbbLoaiFile.SelectedIndex;
drow.Cells.Add(cell);
cell = new DataGridViewTextBoxCell();
cell.Value = cbbLoaiFile.Text;
drow.Cells.Add(cell);
ModelSelect modelSelect = null;
if (indexCbbFileTypeSelect == 0)
{
modelSelect = (ModelSelect)cbbIntConfig.SelectedItem;
}
else
{
modelSelect = (ModelSelect)cbbSound.SelectedItem;
}
if (modelSelect != null)
{
cell = new DataGridViewTextBoxCell();
cell.Value = modelSelect.Value;
drow.Cells.Add(cell);
cell = new DataGridViewTextBoxCell();
cell.Value = modelSelect.Text;
drow.Cells.Add(cell);
}
int thuThuDoc = 1;
int.TryParse(txtThuTuDoc.Text, out thuThuDoc);
cell = new DataGridViewTextBoxCell();
cell.Value = thuThuDoc.ToString();
drow.Cells.Add(cell);
cell = new DataGridViewTextBoxCell();
cell.Value = chkIsActiveOfDetail.Checked.ToString();
drow.Cells.Add(cell);
dgListItem.Rows.Add(drow);
}
catch (Exception ex)
{
MessageBox.Show("Lỗi: " + ex.Message);
}
}
/// <summary>
/// Генерация модели с параметрами для пользовательских выборок
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public ModelSelect SqlSelect(ModelSelect model)
{
try
{
model.LogicaSelect = SqlSelectModel(model.ParametrsSelect.Id);
model.Parametrs = Inventory.Database.SqlQuery <Parametrs>(model.LogicaSelect.SelectedParametr).ToArray();
return(model);
}
catch (Exception e)
{
Loggers.Log4NetLogger.Error(e);
return(null);
}
}
/// <summary>
/// Генерация модели с параметрами для пользовательских выборок
/// </summary>
/// <param name="model">Модель</param>
/// <returns></returns>
public ModelSelect SelectSql(ModelSelect model)
{
try
{
model.LogicsSelectAutomation = SqlSelectModel(model.ParametrsSelect.Id);
model.InfoViewAutomation = Automation.Database.SqlQuery <InfoViewAutomation> (model.LogicsSelectAutomation.SelectedParametr).ToArray();
return(model);
}
catch (Exception e)
{
Loggers.Log4NetLogger.Error(e);
return(null);
}
}
/// <summary>
/// Запрос параметров для раз кладки и дальнейшей выборки Предпроверка генерация динамических таблиц
/// </summary>
/// <param name="model">Модель параметров с сайта</param>
/// <returns></returns>
public ModelSelect ParameterSelect(ModelSelect model)
{
try
{
model.ParameterProcedureWeb = SqlSelectParameterProcedureWeb(model.ParametrsSelect.Id);
model.InfoViewAutomation = Automation.Database.SqlQuery <InfoViewAutomation>(model.ParameterProcedureWeb.SelectParameterTable).ToArray();
return(model);
}
catch (Exception e)
{
Loggers.Log4NetLogger.Error(e);
return(null);
}
}
/// <summary>
/// Актуализация пользователей модели
/// </summary>
/// <param name="isActualizationUser">xml в виде string с актуальными пользователями</param>
/// <returns></returns>
public string ActualUserModel(string isActualizationUser)
{
try
{
ModelSelect model = new ModelSelect {
LogicaSelect = SqlSelectModel(5)
};
Inventory.Database.ExecuteSqlCommand(model.LogicaSelect.SelectUser,
new SqlParameter(model.LogicaSelect.SelectedParametr, isActualizationUser));
return("Актуализация произошла успешно!!!");
}
catch (Exception exception)
{
Loggers.Log4NetLogger.Error(exception);
return("Во время актуализации произошла ошибка смотрите Log.txt");
}
}
/// <summary>
/// Получение данных для личного кабинета пользователя инвенторизации
/// </summary>
/// <param name="idUser">Ун пользователя</param>
/// <returns></returns>
public string AllTechicsLkInventory(int idUser)
{
SerializeJson json = new SerializeJson();
SelectSql sql = new SelectSql();
ModelSelect model = new ModelSelect {
LogicaSelect = sql.SqlSelectModel(33)
};
var idDepartment = Inventory.Database.SqlQuery <int>(model.LogicaSelect.SelectUser,
new SqlParameter(model.LogicaSelect.SelectedParametr.Split(',')[0], idUser)).FirstOrDefault();
sql.Dispose();
if (idDepartment != 0)
{
return(json.JsonLibaryIgnoreDate(Inventory.AllTechnics.Where(x => x.IdOtdel == idDepartment)));
}
return(json.JsonLibaryIgnoreDate(Inventory.AllTechnics.Where(x => x.IdUser == idUser)));
}
/// <summary>
/// Возврат дополнительных атрибутов моделей АКСИОК
/// </summary>
/// <param name="idModel">Ун интересуем ого объекта</param>
/// <returns></returns>
public ModelAksiok.DtoAksiok.ValueCharacteristicJson SelectModelCharacteristicJson(int idModel)
{
try
{
ModelSelect selectModel = new ModelSelect {
LogicaSelect = SqlSelectModel(56)
};
return(Inventory.Database.SqlQuery <ModelAksiok.DtoAksiok.ValueCharacteristicJson>(
selectModel.LogicaSelect.SelectUser,
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[0], idModel))
.FirstOrDefault());
}
catch (Exception e)
{
Loggers.Log4NetLogger.Error(e);
}
return(null);
}
/// <summary>
/// Генерация акта по модели параметров
/// </summary>
/// <param name="modelParameterAct">Параметры акта списания техники</param>
/// <returns></returns>
public Act[] GenerateParameterAct(ModelSelect modelParameterAct)
{
var modelParameter = Inventory.Acts.Where(act => act.IdClasification == modelParameterAct.ParametrsAct.IdClasificationAct).ToArray();
foreach (var act in modelParameter)
{
if (act.ParameterAct.IsExistParameterReplace)
{
act.ParameterAct.Parameter = Inventory.Database.SqlQuery <string>(act.ParameterAct.SelectParameter,
new SqlParameter("Id", modelParameterAct.ParametrsAct.IdModelTemplate)).FirstOrDefault();
}
else
{
act.ParameterAct.Parameter = Inventory.Database.SqlQuery <string>(act.ParameterAct.SelectParameter).FirstOrDefault();
}
}
return(modelParameter);
}
/// <summary>
/// Снятие статуса по технике
/// </summary>
/// <param name="technic">Техника</param>
/// <returns></returns>
public string CheckStatus(AllTechnic technic)
{
try
{
ModelSelect model = new ModelSelect {
LogicaSelect = SqlSelectModel(32)
};
Inventory.Database.ExecuteSqlCommand(model.LogicaSelect.SelectUser,
new SqlParameter(model.LogicaSelect.SelectedParametr.Split(',')[0], technic.Id),
new SqlParameter(model.LogicaSelect.SelectedParametr.Split(',')[1], technic.Item));
return("Статус снят!!!");
}
catch (Exception exception)
{
Loggers.Log4NetLogger.Error(exception);
return("Во время снятия статуса произошла ошибка смотрите Log.txt");
}
}
/// <summary>
/// Выбираем людей подписантов табельных номеров
/// </summary>
/// <param name="model">Модель табеля</param>
/// <returns></returns>
public void SelectCardModelLeader(ref ReportCardModel model)
{
try
{
ModelSelect selectModel = new ModelSelect {
LogicaSelect = SqlSelectModel(48)
};
if (model.SettingParameters.IdDepartment != 0)
{
model.SettingParameters.TabelNumber = Inventory.Database.SqlQuery <string>(selectModel.LogicaSelect.SelectUser,
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[0], 5),
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[1], DBNull.Value),
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[2], model.SettingParameters.Mouth.NumberMouth),
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[3], model.SettingParameters.IdDepartment)).FirstOrDefault();
}
model.SettingParameters.LeaderN = Inventory.Database.SqlQuery <LeaderN>(selectModel.LogicaSelect.SelectUser,
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[0], 1),
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[1], DBNull.Value),
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[2], model.SettingParameters.Mouth.NumberMouth),
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[3], DBNull.Value)).FirstOrDefault();
model.SettingParameters.LeaderD = Inventory.Database.SqlQuery <LeaderD>(selectModel.LogicaSelect.SelectUser,
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[0], 2),
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[1], model.SettingParameters.TabelNumber),
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[2], model.SettingParameters.Mouth.NumberMouth),
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[3],
model.SettingParameters.IdDepartment != 0 ?
(IConvertible)model.SettingParameters.IdDepartment
: DBNull.Value)).FirstOrDefault();
model.SettingParameters.LeaderKadr = Inventory.Database.SqlQuery <LeaderKadr>(selectModel.LogicaSelect.SelectUser,
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[0], 3),
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[1], DBNull.Value),
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[2], model.SettingParameters.Mouth.NumberMouth),
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[3], DBNull.Value)).FirstOrDefault();
model.SettingParameters.Holidays = Inventory.Database.SqlQuery <Holidays>(selectModel.LogicaSelect.SelectUser,
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[0], 4),
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[1], DBNull.Value),
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[2], model.SettingParameters.Mouth.NumberMouth),
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[3], DBNull.Value)).ToArray();
}
catch (Exception e)
{
Loggers.Log4NetLogger.Error(e);
}
}
public void TestProcedure()
{
ModelSelect model = new ModelSelect()
{
ParametrsSelect = new ParametrsSelect()
{
Id = 1, IdCodeProcedure = 1, Inn = "7727280875", RegNumber = 0
}
};
model = (ModelSelect)typeof(SqlSelect).GetMethod("ParameterSelect")?.Invoke(new SqlSelect(), new object[] { model });
Assembly db = typeof(DataBaseUlSelect).Assembly;
if (model != null)
{
var type = db.GetType($"EfDatabaseAutomation.Automation.BaseLogica.SqlSelect.XsdDTOSheme.{model.ParameterProcedureWeb.ModelClassFind}");
model = (ModelSelect)typeof(SqlSelect).GetMethod("ResultSelectProcedure")?.MakeGenericMethod(type).Invoke(new SqlSelect(), new object[] { model });
}
}
/// <summary>
/// Проверка модели на действия с ней Редактирование или Добавление
/// </summary>
/// <param name="aksiokAddAndEdit">Транспортная модель с параметрами</param>
/// <returns></returns>
public AksiokAddAndEdit ModelValidation(AksiokAddAndEdit aksiokAddAndEdit)
{
try
{
ModelSelect selectModel = new ModelSelect {
LogicaSelect = SqlSelectModel(57)
};
var idFullCategoria = new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[3], aksiokAddAndEdit.ParametersModel.IdFullCategoria)
{
Direction = ParameterDirection.Output, SqlDbType = SqlDbType.Int
};
var codeError = new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[4], aksiokAddAndEdit.ParametersModel.CodeError)
{
Direction = ParameterDirection.Output, SqlDbType = SqlDbType.Int
};
var errorServer = new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[5], aksiokAddAndEdit.ParametersModel.ErrorServer)
{
Direction = ParameterDirection.Output, Size = 512, SqlDbType = SqlDbType.VarChar
};
Inventory.Database.ExecuteSqlCommand(selectModel.LogicaSelect.SelectUser,
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[0],
aksiokAddAndEdit.ParametersModel.ModelRequest),
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[1],
aksiokAddAndEdit.ParametersModel.SerNumber),
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[2],
aksiokAddAndEdit.ParametersModel.InventoryNum),
idFullCategoria, codeError, errorServer
);
aksiokAddAndEdit.ParametersModel.IdFullCategoria = (int?)idFullCategoria.Value;
aksiokAddAndEdit.ParametersModel.CodeError = (int)codeError.Value;
aksiokAddAndEdit.ParametersModel.ErrorServer = (string)errorServer.Value;
return(aksiokAddAndEdit);
}
//В случае исключения
catch (Exception e)
{
Loggers.Log4NetLogger.Error(e);
aksiokAddAndEdit.ParametersModel.CodeError = 404;
aksiokAddAndEdit.ParametersModel.ErrorServer = e.Message;
}
return(aksiokAddAndEdit);
}
/// <summary>
/// Запрос по процедурам лежащим в них выборок Предпроверка генерация динамических таблиц (сама таблица)
/// </summary>
/// <param name="model">С запроса</param>
/// <returns></returns>
public ModelSelect ResultSelectProcedure <T>(ModelSelect model)
{
try
{
SerializeJson serializeJson = new SerializeJson();
var result = Automation.Database.SqlQuery <T>(model.ParameterProcedureWeb.SelectUser,
new SqlParameter(model.ParameterProcedureWeb.ParameterProcedure.Split(',')[0], model.ParametrsSelect.IdCodeProcedure),
new SqlParameter(model.ParameterProcedureWeb.ParameterProcedure.Split(',')[1], string.IsNullOrWhiteSpace(model.ParametrsSelect.Inn) ? (object)DBNull.Value : model.ParametrsSelect.Inn),
new SqlParameter(model.ParameterProcedureWeb.ParameterProcedure.Split(',')[2], model.ParametrsSelect.RegNumber)).ToList();
dynamic expand = new ExpandoObject();
AddProperty(expand, model.ParameterProcedureWeb.ModelClassFind, result);
model.ResultSelectProcedureWeb = serializeJson.JsonLibrary(expand);
return(model);
}
catch (Exception e)
{
Loggers.Log4NetLogger.Error(e);
return(null);
}
}
/// <summary>
/// Выполнение процедуры возвращающая xml файл для разбора на web UI
/// </summary>
/// <param name="model">Модель выборки</param>
/// <returns></returns>
public ModelSelect ResultSelectProcedureString <T>(ModelSelect model)
{
try
{
var xml = new XmlReadOrWrite();
SerializeJson serializeJson = new SerializeJson();
var result = Automation.Database.SqlQuery <string>(model.ParameterProcedureWeb.SelectUser,
new SqlParameter(model.ParameterProcedureWeb.ParameterProcedure.Split(',')[0], model.ParametrsSelect.IdCodeProcedure),
new SqlParameter(model.ParameterProcedureWeb.ParameterProcedure.Split(',')[1], string.IsNullOrWhiteSpace(model.ParametrsSelect.Inn) ? (object)DBNull.Value : model.ParametrsSelect.Inn),
new SqlParameter(model.ParameterProcedureWeb.ParameterProcedure.Split(',')[2], model.ParametrsSelect.RegNumber)).ToArray();
var resultServer = (T)xml.ReadXmlText(string.Join("", result), typeof(T));
model.ResultSelectProcedureWeb = serializeJson.JsonLibrary(resultServer);
return(model);
}
catch (Exception e)
{
Loggers.Log4NetLogger.Error(e);
return(null);
}
}
/// <summary>
/// Журнал назначений АИС 3
/// </summary>
/// <param name="year">Год назначения</param>
/// <param name="idOtdel">УН отдела</param>\
/// <param name="isAllJournal">Параметр журнала</param>
public AllJournal SelectJournalAis3(int year, int idOtdel, bool isAllJournal)
{
try
{
AllJournal journal = new AllJournal();
ModelSelect model = new ModelSelect {
LogicaSelect = SqlSelectModel(47)
};
journal.JournalAis3 = Inventory.Database.SqlQuery <Journal.JournalAis3>(model.LogicaSelect.SelectUser,
new SqlParameter(model.LogicaSelect.SelectedParametr.Split(',')[0], year),
new SqlParameter(model.LogicaSelect.SelectedParametr.Split(',')[1], idOtdel),
new SqlParameter(model.LogicaSelect.SelectedParametr.Split(',')[2], isAllJournal)).ToArray();
return(journal);
}
catch (Exception e)
{
Loggers.Log4NetLogger.Error(e);
}
return(null);
}
/// <summary>
/// Актуализация Ip Адресов в БД
/// </summary>
/// <returns></returns>
public string ActualIp()
{
try
{
ModelSelect model = new ModelSelect {
LogicaSelect = SqlSelectModel(19)
};
var resultCommands = new SqlParameter(model.LogicaSelect.SelectedParametr.Split(',')[0], DBNull.Value)
{
Direction = ParameterDirection.Output, Size = 8000
};
Inventory.Database.ExecuteSqlCommand(model.LogicaSelect.SelectUser, resultCommands);
return((string)resultCommands.Value);
}
catch (Exception exception)
{
Loggers.Log4NetLogger.Error(exception);
return(exception.Message);
}
}
/// <summary>
/// Динамическое создание моделей для сайта (Пред проверка)
/// </summary>
/// <param name="model">Модель параметров заступление с сайта</param>
/// <returns></returns>
public async Task <ModelSelect> ResultSelectProcedure(ModelSelect model)
{
return(await Task.Factory.StartNew(() =>
{
model = (ModelSelect)typeof(SqlSelect).GetMethod("ParameterSelect")
?.Invoke(new SqlSelect(), new object[] { model });
if (model != null)
{
var type = Type.GetType($"{model.ParameterProcedureWeb.ModelClassFind}, EfDatabaseAutomation");
if (model.ParametrsSelect.Id == 12)
{
return (ModelSelect)typeof(SqlSelect).GetMethod("ResultSelectProcedureString")
?.MakeGenericMethod(type).Invoke(new SqlSelect(), new object[] { model });
}
return (ModelSelect)typeof(SqlSelect).GetMethod("ResultSelectProcedure")?.MakeGenericMethod(type)
.Invoke(new SqlSelect(), new object[] { model });
}
return model;
}));
}
void Start()
{
mTrackableBehaviour = GetComponent <TrackableBehaviour>();
if (mTrackableBehaviour)
{
mTrackableBehaviour.RegisterTrackableEventHandler(this);
}
simpleCloud = GameObject.FindGameObjectWithTag("cloudrec").GetComponent <SimpleCloudHandler>();
phoneButton = GetComponentInChildren <PhoneButton>();
gotolink = GetComponentInChildren <GoToLink>();
infoMarker = GetComponentInChildren <ModelSelect>();
infoPanel = GetComponentInChildren <InfoPanel>();
phonePanel = phoneButton.gameObject;
linkPanel = gotolink.gameObject;
infoButton = infoMarker.gameObject;
phonePanel.SetActive(false);
linkPanel.SetActive(false);
infoButton.SetActive(false);
}
/// <summary>
/// Генерация для служебных записок модель
/// </summary>
/// <param name="memoReport">Модель для служебных записок</param>
public void SelectMemoReport(ref ModelMemoReport memoReport)
{
try
{
ModelSelect selectModel = new ModelSelect {
LogicaSelect = SqlSelectModel(49)
};
memoReport.UserDepartment = Inventory.Database.SqlQuery <UserDepartment>(selectModel.LogicaSelect.SelectUser,
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[0], 1),
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[1], memoReport.SelectParameterDocument.IdUser),
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[2], DBNull.Value),
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[3], DBNull.Value)).FirstOrDefault();
memoReport.Executor = Inventory.Database.SqlQuery <Executor>(selectModel.LogicaSelect.SelectUser,
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[0], 2),
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[1], memoReport.SelectParameterDocument.IdUser),
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[2], memoReport.SelectParameterDocument.TabelNumber),
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[3], DBNull.Value)).FirstOrDefault();
memoReport.BossDepartment = Inventory.Database.SqlQuery <BossDepartment>(selectModel.LogicaSelect.SelectUser,
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[0], 3),
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[1], memoReport.SelectParameterDocument.IdUser),
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[2], memoReport.SelectParameterDocument.TabelNumber),
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[3], DBNull.Value)).FirstOrDefault();
memoReport.BossAgreed = Inventory.Database.SqlQuery <BossAgreed>(selectModel.LogicaSelect.SelectUser,
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[0], 4),
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[1], memoReport.SelectParameterDocument.IdUser),
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[2], memoReport.SelectParameterDocument.TabelNumber),
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[3], memoReport.SelectParameterDocument.TypeDocument)).FirstOrDefault();
memoReport.LeaderOrganization = Inventory.Database.SqlQuery <LeaderOrganization>(selectModel.LogicaSelect.SelectUser,
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[0], 5),
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[1], memoReport.SelectParameterDocument.IdUser),
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[2], DBNull.Value),
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[3], DBNull.Value)).FirstOrDefault();
}
catch (Exception e)
{
Loggers.Log4NetLogger.Error(e);
}
}
/// <summary>
/// Запрос на лиц кто согласовывает надо добавлять в xml
/// </summary>
/// <param name="template">Шаблон возврата</param>
public ModelSelect SendersUsers(ref RuleTemplate template)
{
try
{
ModelSelect model = new ModelSelect {
LogicaSelect = SqlSelectModel(13)
};
template.SenderUsers.Security = Inventory.Database.SqlQuery <Security>(model.LogicaSelect.SelectUser, new SqlParameter(model.LogicaSelect.SelectedParametr.Split(',')[0], 3),
new SqlParameter(model.LogicaSelect.SelectedParametr.Split(',')[1], "Отдел безопасности"),
new SqlParameter(model.LogicaSelect.SelectedParametr.Split(',')[2], DBNull.Value)).FirstOrDefault();
template.SenderUsers.ItOtdel = Inventory.Database.SqlQuery <ItOtdel>(model.LogicaSelect.SelectUser, new SqlParameter(model.LogicaSelect.SelectedParametr.Split(',')[0], 4),
new SqlParameter(model.LogicaSelect.SelectedParametr.Split(',')[1], "Отдел информатизации"),
new SqlParameter(model.LogicaSelect.SelectedParametr.Split(',')[2], DBNull.Value)).FirstOrDefault();
template.SenderUsers.SenderRukovodstvo = Inventory.Database.SqlQuery <SenderRukovodstvo>(model.LogicaSelect.SelectUser, new SqlParameter(model.LogicaSelect.SelectedParametr.Split(',')[0], 5),
new SqlParameter(model.LogicaSelect.SelectedParametr.Split(',')[1], "Руководство"),
new SqlParameter(model.LogicaSelect.SelectedParametr.Split(',')[2], DBNull.Value)).FirstOrDefault();
return(model);
}
catch (Exception e)
{
Loggers.Log4NetLogger.Error(e);
}
return(null);
}
/// <summary>
/// Генерация выборки на клиенте
/// </summary>
/// <param name="model">Модель</param>
/// <returns></returns>
public async Task <ModelSelect> GenerateSqlSelect(ModelSelect model)
{
var select = new SqlSelect();
return(await Task.Factory.StartNew(() => select.SelectSql(model)));
}
/// <summary>
/// Вытягивание данных на отдел и пользователей
/// </summary>
/// <param name="template">Шаблон раскладки</param>
/// <param name="userRule">Данные ролей из АИС 3</param>
/// <param name="sqlSelect">Запрос к БД для выборки данных</param>
public void UserRuleModel(ref RuleTemplate template, UserRules userRule, ModelSelect sqlSelect)
{
var groupElement = userRule.User.Where(x => x.Number != "Скрипт").Select(x => new
{ x.Dates,
x.Number,
Otdel = x.Otdel.Replace("№ ", "№") }).GroupBy(x => new { x.Dates, x.Number, x.Otdel }).Select(x => new { x.Key.Number, x.Key.Dates, x.Key.Otdel }).ToList();
int i = 0;
foreach (var gr in groupElement)
{
if (template.Otdel == null)
{
template.Otdel = new Otdel[groupElement.Count];
}
template.Otdel[i] = Inventory.Database.SqlQuery <Otdel>(
sqlSelect.LogicaSelect.SelectUser,
new SqlParameter(sqlSelect.LogicaSelect.SelectedParametr.Split(',')[0], 1),
new SqlParameter(sqlSelect.LogicaSelect.SelectedParametr.Split(',')[1],
gr.Otdel.Replace("№ ", "№")),
new SqlParameter(sqlSelect.LogicaSelect.SelectedParametr.Split(',')[2],
gr.Number)).FirstOrDefault() ??
new Otdel()
{
Number = gr.Number, NameOtdel = "Ошибка в наименование отдела Кадры,AD,АИС3",
RnameOtdel = "Ошибка в наименование отдела Кадры,AD,АИС3",
SmallName = "Отсутствует", NamePosition = "Отсутствует"
};
template.Otdel[i].Dates = gr.Dates;
var user = userRule.User.Where(userRole => (userRole.Dates == gr.Dates) && (userRole.Number == gr.Number) && (userRole.Otdel.Replace("№ ", "№") == gr.Otdel)).Select(u => new
{
u.Dates,
u.Fio,
u.SysName,
u.Dolj,
Otdel = u.Otdel.Replace("№ ", "№"),
u.Number
}).Distinct().ToList();
int j = 0;
foreach (var userRole in user)
{
var roleAll = userRule.User.Where(u =>
u.Dates == userRole.Dates && u.Dolj == userRole.Dolj && u.Otdel.Replace("№ ", "№") == userRole.Otdel &&
u.Fio == userRole.Fio && u.SysName == userRole.SysName && u.Number == userRole.Number).
Select(x => x.Rule).Aggregate((element, next) => element.Concat(next).ToArray());
if (template.Otdel[i].Users == null)
{
template.Otdel[i].Users = new LibaryXMLAutoModelXmlAuto.OtdelRuleUsers.Users[user.Count];
}
template.Otdel[i].Users[j] = Inventory.Database.SqlQuery <LibaryXMLAutoModelXmlAuto.OtdelRuleUsers.Users>(sqlSelect.LogicaSelect.SelectUser, new SqlParameter(sqlSelect.LogicaSelect.SelectedParametr.Split(',')[0], 2),
new SqlParameter(sqlSelect.LogicaSelect.SelectedParametr.Split(',')[1], userRole.SysName.Split('@')[0]),
new SqlParameter(sqlSelect.LogicaSelect.SelectedParametr.Split(',')[2], DBNull.Value)).FirstOrDefault() ??
new LibaryXMLAutoModelXmlAuto.OtdelRuleUsers.Users()
{
Name = userRole.Fio, NamePosition = userRole.Dolj, IpAdress = null,
Tabel = $"regions\\{userRole.SysName.Split('@')[0]}", NumberKabinet = null,
RuleTemplate = null
};
template.Otdel[i].Users[j].RuleTemplate = roleAll.Select(elem => $"{elem.Types}: {elem.Name}").Aggregate(
(element, next) => element + (string.IsNullOrWhiteSpace(element) ? string.Empty : ", ") + next);
template.Otdel[i].Users[j].Pushed = roleAll[0].Pushed;
j++;
}
i++;
}
}
