protected override void OnStartup(StartupEventArgs e)
{
Properties.Settings App = new Properties.Settings();
// провереям подключение к WebService
var client = new EDIWebServiceSoapClient("EDIWebServiceSoap");
string result = client.Relationships(App.LoginWebService, App.PasswordWebService, 1000).Res;
client.Close();
if (!String.IsNullOrEmpty(SoapRequest.ResultWebRequest(result)))
{
MessageBox.Show(SoapRequest.ResultWebRequest(result), "Подключения к WebService", MessageBoxButton.OK, MessageBoxImage.Error);
SettingWebSerice settingForm = new SettingWebSerice();
settingForm.ShowDialog();
// перезагружаем приложение
System.Diagnostics.Process.Start(Application.ResourceAssembly.Location);
Application.Current.Shutdown();
}
// проверяем подключения к бд
if (!StatusApp.CheckConnection())
{
MessageBox.Show("Нет соединение с базой данных , проверьте параметры подключения или обратитесь к системному администратору ", "Cоединение с базой данных", MessageBoxButton.OK, MessageBoxImage.Hand);
ConnectionDataBase.ChangeConnect();
}
}
public async Task <IActionResult> Log(LogAddressModel model)
{
var appid = _tokenManager.ValidateAccessToken(model.AccessToken);
var appLocal = await _dbContext.StatusApps.SingleOrDefaultAsync(t => t.AppId == appid);
if (appLocal == null)
{
appLocal = new StatusApp
{
AppId = appid
};
_dbContext.StatusApps.Add(appLocal);
await _dbContext.SaveChangesAsync();
}
var newEvent = new ErrorLog
{
AppId = appid,
Message = model.Message,
StackTrace = model.StackTrace,
EventLevel = model.EventLevel
};
_dbContext.ErrorLogs.Add(newEvent);
await _dbContext.SaveChangesAsync();
return(this.Protocol(ErrorType.Success, $"Successfully logged your event."));
}
public async Task <IActionResult> View(ViewAddressModel model)
{
var appid = _tokenManager.ValidateAccessToken(model.AccessToken);
var appLocal = await _dbContext.StatusApps.SingleOrDefaultAsync(t => t.AppId == appid);
if (appLocal == null)
{
appLocal = new StatusApp
{
AppId = appid
};
_dbContext.StatusApps.Add(appLocal);
await _dbContext.SaveChangesAsync();
}
var logs = await _dbContext
.ErrorLogs
.Where(t => t.AppId == appid)
.ToListAsync();
var viewModel = new ViewLogViewModel
{
AppId = appLocal.AppId,
Logs = logs,
Code = ErrorType.Success,
Message = "Successfully get your logs!"
};
return(Json(viewModel));
}
public override void Novo()
{
txtCodigo.txtValor.ReadOnly = false;
try
{
_statusApp = new StatusApp();
var model = _statusApp.Novo(Funcoes.IdUsuario);
Funcoes.VerificarMensagem(model.Mensagem);
base.Novo();
Tela.LimparTela(tbPrincipal);
Tela.LimparTela(grNotificacao);
txtCodigo.txtValor.Text = model.Codigo.ToString("0000");
txtCodigo.txtValor.ReadOnly = false;
rbChamado.Checked = true;
chkAtivo.Checked = true;
txtCodigo.txtValor.Focus();
_Id = 0;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// Обновляет статус принтера
/// </summary>
private void dispatcherTimerStatusPrinter(object sender, EventArgs e)
{
if (StatusApp.PrinterStatusBool())
{
lblStatus.Content = "Online";
EllipseStatus.Fill = Brushes.GreenYellow;
}
else
{
lblStatus.Content = "Offline";
EllipseStatus.Fill = Brushes.OrangeRed;
}
}
private void FiltrarDados(string texto, EnStatus enStatus)
{
string sCampo = Grade.BuscarCampo(ref dgvDados, cbCampos.Text);
_statusApp = new StatusApp();
string ativo = cboAtivo.Text;
if (sCampo == "NomePrograma")
{
sCampo = "Sta_Programa";
}
_listaConsulta = _statusApp.Filtrar(sCampo, texto, enStatus, ativo.Substring(0, 1)).ToList();
dgvDados.DataSource = _listaConsulta;
}
protected override void OnStartup(StartupEventArgs e)
{
// проверяем статус принтера
if (!StatusApp.PrinterStatusBool())
{
ConfigTxt config = new ConfigTxt();
Log.Write("Status printer " + config.PrintName + " : Offline\n");
MessageBox.Show("Нет подключения к принтеру " + config.PrintName + " или нет драйвера .Установите в Меню/Настройки программы принтер !!!", "", MessageBoxButton.OK, MessageBoxImage.Error);
}
// проверяем наличие файла шрифта штрихкода
StatusApp.FontBarcod();
// проверяем подключения к бд
if (!StatusApp.CheckConnection())
{
MessageBox.Show("Нет соединение с базой данных , проверьте сетевое подключение или обратитесь к системному администратору ", "", MessageBoxButton.OK, MessageBoxImage.Hand);
ConnectionStringDataBase.ChangeConnect();
}
}
public override void Editar()
{
try
{
_statusApp = new StatusApp();
var model = _statusApp.Editar(Grade.RetornarId(ref dgvDados, "Sta_Id"), Funcoes.IdUsuario, EnStatus.Todos);
btnSalvar.Enabled = Funcoes.PermitirEditar(model.Mensagem);
base.Editar();
Tela.LimparTela(tbPrincipal);
txtCodigo.txtValor.Text = model.Codigo.ToString("0000");
txtNome.Text = model.Nome;
txtConceito.Text = model.Conceito;
chkAtivo.Checked = model.Ativo;
rbChamado.Checked = (model.Programa == 1);
rbVisita.Checked = (model.Programa == 2);
rbSolicitacao.Checked = (model.Programa == 3);
rbVersao.Checked = (model.Programa == 4);
rbQualidade.Checked = (model.Programa == 5);
rbBaseConh.Checked = (model.Programa == 6);
rbAtividade.Checked = (model.Programa == 7);
rbAgendamento.Checked = (model.Programa == 8);
rbRecado.Checked = (model.Programa == 10);
chkNotCliente.Checked = model.NotificarCliente;
chkNotConsultor.Checked = model.NotificarConsultor;
chkNotRevenda.Checked = model.NotificarRevenda;
chkNotSupervisor.Checked = model.NotificarSupervisor;
txtNome.Focus();
txtCodigo.txtValor.ReadOnly = true;
_Id = model.Id;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public override void Excluir()
{
base.Excluir();
if (Funcoes.Confirmar("Confirmar Exclusão?"))
{
try
{
_statusApp = new StatusApp();
int id = Grade.RetornarId(ref dgvDados, "Sta_Id");
var model = _statusApp.Excluir(id, Funcoes.IdUsuario);
Funcoes.VerificarMensagem(model.Mensagem);
_listaConsulta.Remove(_listaConsulta.First(x => x.Id == id));
dgvDados.DataSource = _listaConsulta.ToArray();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
public async Task <IActionResult> View(ViewAddressModel model)
{
var appid = await _tokenManager.ValidateAccessToken(model.AccessToken);
var appLocal = await _dbContext.StatusApps.SingleOrDefaultAsync(t => t.AppId == appid);
if (appLocal == null)
{
appLocal = new StatusApp
{
AppId = appid
};
_dbContext.StatusApps.Add(appLocal);
await _dbContext.SaveChangesAsync();
}
var logs = (await _dbContext
.ErrorLogs
.Where(t => t.AppId == appid)
.ToListAsync())
.GroupBy(t => t.Message)
.Select(t => new LogCollection
{
Message = t.Key,
First = t.OrderByDescending(p => p.LogTime).FirstOrDefault(),
Count = t.Count()
})
.ToList();
var viewModel = new ViewLogViewModel
{
AppId = appLocal.AppId,
Logs = logs,
Code = ErrorType.Success,
Message = "Successfully get your logs!"
};
return(Json(viewModel));
}
public override void Salvar()
{
try
{
_statusApp = new StatusApp();
var status = new StatusViewModel();
status.Id = _Id;
status.Ativo = chkAtivo.Checked;
status.Codigo = Funcoes.StrToInt(txtCodigo.txtValor.Text);
status.Nome = txtNome.Text;
status.Conceito = txtConceito.Text;
if (rbChamado.Checked)
{
status.Programa = 1;
}
else if (rbVisita.Checked)
{
status.Programa = 2;
}
else if (rbSolicitacao.Checked)
{
status.Programa = 3;
}
else if (rbVersao.Checked)
{
status.Programa = 4;
}
else if (rbQualidade.Checked)
{
status.Programa = 5;
}
else if (rbBaseConh.Checked)
{
status.Programa = 6;
}
else if (rbAtividade.Checked)
{
status.Programa = 7;
}
else if (rbAgendamento.Checked)
{
status.Programa = 8;
}
else if (rbRecado.Checked)
{
status.Programa = 10;
}
status.NotificarCliente = chkNotCliente.Checked;
status.NotificarConsultor = chkNotConsultor.Checked;
status.NotificarRevenda = chkNotRevenda.Checked;
status.NotificarSupervisor = chkNotSupervisor.Checked;
var model = _statusApp.Salvar(status);
Funcoes.VerificarMensagem(model.Mensagem);
_listaConsulta = _statusApp.Filtrar("Sta_Id", model.Id.ToString(), _enStatus, "T", false).ToList();
dgvDados.DataSource = _listaConsulta;
base.Salvar();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public ConsultaStatus()
{
_statusApp = new StatusApp();
}
/// <summary>
/// Опрашивает бд и печатает ценники и устанавливает flag 1
/// </summary>
private void PrintAllPriceList()
{
PriceListCash.Properties.Settings App1 = new PriceListCash.Properties.Settings();
if (StatusApp.PrinterStatusBool()) // если подключен принтер , то печатаем
{
DataTable dtQuery = CRUD.SelectToDateTable(" exec [cash_Ценники Вывод всех ценников]");
if (dtQuery.Rows.Count > 0)
{
string defaultPrinterName = MyPrintersOptions.GetDefaultPrinterName();
foreach (DataRow myDataRow in dtQuery.Rows)
{
for (int i = 0; i < Convert.ToInt32(myDataRow["Количество"]); i++)
{
PriceList barcodeDetails = new PriceList();
DataTable dtPriceList = barcodeDetails._PriceList;
DataRow drow = dtPriceList.NewRow();
drow["Name"] = myDataRow["Наименование"].ToString();
drow["EI"] = myDataRow["ЕИ"].ToString();
drow["Barcode"] = myDataRow["BarCode"].ToString();
drow["Barcode_"] = "*";
drow["Barcode_"] += myDataRow["КодРегистра"].ToString();
drow["Barcode_"] += "*";
var Price = Convert.ToDouble(myDataRow["Цена"]);
var IntegerPartPrice = Convert.ToInt32(Math.Truncate(Price)); // Целая часть цены
var FractionalPart = Convert.ToInt32((Price - IntegerPartPrice) * 100); // Дробная часть
drow["IntegerPartPrice"] = IntegerPartPrice.ToString();
drow["FractionalPartPrice"] = ((FractionalPart < 10) ? ("0" + FractionalPart.ToString()) : FractionalPart.ToString());
drow["Code"] = myDataRow["КодРегистра"].ToString();
drow["TimeStamp"] = myDataRow["timestamp"].ToString();
drow["HostName"] = myDataRow["HostName"].ToString();
dtPriceList.Rows.Add(drow);
if (Convert.ToInt32(App1.ВидЦенника) == 0)
{
using (CrystalReportMida Report = new CrystalReportMida())
{
Report.Database.Tables["PriceList"].SetDataSource((DataTable)dtPriceList);
MyPrintersOptions.SetDefaultPrinter(config.PrintName);
Report.PrintOptions.PrinterName = config.PrintName;
Report.PrintToPrinter(1, false, 0, 0); // печать без предосмотра
}
}
else
{
using (CrystalReportGippo Report = new CrystalReportGippo())
{
Report.Database.Tables["PriceList"].SetDataSource((DataTable)dtPriceList);
MyPrintersOptions.SetDefaultPrinter(config.PrintName);
Report.PrintOptions.PrinterName = config.PrintName;
Report.PrintToPrinter(1, false, 0, 0); // печать без предосмотра
}
}
}
CRUD.QuerySQL("UPDATE [cash_Ценники] SET [fPrint] = 1 WHERE rowguid = '" + myDataRow["rowguid"].ToString() + "'");
}
MyPrintersOptions.SetDefaultPrinter(defaultPrinterName);
}
}
else
{
Log.Write("Status printer " + config.PrintName + " : Offline\n");
MessageBox.Show("Нет подключения к принтеру " + config.PrintName + " или нет драйвера . Установите по умолчанию принтер " + config.PrintName + " !!!", "", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
