private void OnSalvar(string formUID)
{
using (var formCOM = new FormCOM(formUID))
{
var form = formCOM.Form;
try
{
form.Freeze(true);
using (var dbdtsCOM = new DBDatasourceCOM(form, mainDbDataSource))
{
var dbdts = dbdtsCOM.Dbdts;
var mtx = GetMatrix(form, _matriz.ItemUID);
Salvar(form, dbdts, mtx);
Program.CarregarPeneirasVindoDaConfiguracao();
}
}
catch (Exception e)
{
Dialogs.PopupError("Erro interno. Erro ao salvar dados.\nErro: " + e.Message);
Global.Company.EndTransaction(SAPbobsCOM.BoWfTransOpt.wf_RollBack);
}
finally
{
form.Freeze(false);
}
}
}
public override void OnAfterFormVisible(string FormUID, ref ItemEvent pVal, out bool BubbleEvent)
{
BubbleEvent = true;
using (var formCOM = new FormCOM(FormUID))
{
var form = formCOM.Form;
try
{
form.Freeze(true);
_matriz._certificado.Popular(form, _matriz.ItemUID);
CarregarDadosMatriz(form, _fatherFormUID, _matriz.ItemUID, mainDbDataSource);
using (var fatherFormCOM = new FormCOM(_fatherFormUID))
{
var statusContratoPai = formPai.GetStatusPersistent(fatherFormCOM.Form);
form.Items.Item("1").Enabled = UsuarioPermitido() && formPai.ContratoPodeSerAlterado(statusContratoPai);
}
}
catch (Exception e)
{
Dialogs.PopupError("Erro interno. Erro ao desenhar o form.\nErro: " + e.Message);
}
finally
{
form.Freeze(false);
}
}
}
public override void OnAfterItemPressed(string FormUID, ref ItemEvent pVal, out bool BubbleEvent)
{
BubbleEvent = true;
if (pVal.ItemUID == _botaoCopiar.ItemUID)
{
using (var formCOM = new FormCOM(FormUID))
{
var form = formCOM.Form;
var mtx = GetMatrix(form, _matrizDocumentos.ItemUID);
int row = mtx.GetNextSelectedRow();
if (row > 0)
{
var objBase = GetObjetoDeContrato(form);
var codigoDocSelecionado = mtx.GetCellSpecific(_matrizDocumentos.Codigo.ItemUID, row).Value;
var formBase = objBase.Form.Abrir(codigoDocSelecionado);
Dialogs.Info("Buscando informações...");
objBase.Form.CopiarPara(formBase);
form.Close();
}
else
{
Dialogs.PopupError("Selecione uma linha da matriz para escolher um documento base.");
}
}
}
}
public override void OnBeforeItemPressed(string FormUID, ref ItemEvent pVal, out bool BubbleEvent)
{
BubbleEvent = true;
if (pVal.ItemUID == "1")
{
using (var formCOM = new FormCOM(FormUID))
{
var form = formCOM.Form;
var mtxCorretor = ((Matrix)form.Items.Item(_corretores.ItemUID).Specific);
var mtxResponsaveis = ((Matrix)form.Items.Item(_responsaveis.ItemUID).Specific);
mtxCorretor.FlushToDataSource();
mtxResponsaveis.FlushToDataSource();
using (var dbdtsCorretorCOM = new DBDatasourceCOM(form, corretorDbDataSource))
using (var dbdtsResponsavelCOM = new DBDatasourceCOM(form, responsavelDbDataSource))
{
var dbdtsCorretor = dbdtsCorretorCOM.Dbdts;
var dbdtsResponsavel = dbdtsResponsavelCOM.Dbdts;
if (!MatrizEstaValida(form, dbdtsCorretor, _corretores) || !MatrizEstaValida(form, dbdtsResponsavel, _responsaveis))
{
BubbleEvent = false;
}
}
}
}
}
//Обработчик события: нажатие кнопки "Подключение"
private void buttonConnect_Click(object sender, EventArgs e)
{
chart1.Series.Clear();
FormCOM FC = new FormCOM();
FC.ShowDialog(this);
}
public override void OnAfterFormVisible(string FormUID, ref ItemEvent pVal, out bool BubbleEvent)
{
BubbleEvent = true;
var numContratoFinal = string.Empty;
using (var formFatherCOM = new FormCOM(_fatherFormUID))
{
var formFather = formFatherCOM.Form;
var dbdtsFather = GetDBDatasource(formFather, formFather.DataSources.DBDataSources.Item(0).TableName);
numContratoFinal = dbdtsFather.GetValue("U_DocNumCF", 0).Trim();
}
using (var formCOM = new FormCOM(FormUID))
{
var form = formCOM.Form;
if (!string.IsNullOrEmpty(numContratoFinal))
{
_numeroContratoFinal.SetValorUserDataSource(form, numContratoFinal);
var mtx = GetMatrix(form, _matrizDocumentos.ItemUID);
_matrizDocumentos.Bind(mtx);
AtualizarMatriz(form);
}
else
{
Dialogs.PopupError("Erro interno. Não foi encontrado o código do contrato final. Este form será fechado.");
}
}
}
private void OnRemoverLinha(string FormUID)
{
using (var formCOM = new FormCOM(FormUID))
{
var form = formCOM.Form;
_matriz.RemoverLinha(form);
}
}
private void OnAdicionarLinha(string FormUID)
{
using (var formCOM = new FormCOM(FormUID))
{
var form = formCOM.Form;
_matriz.AdicionarLinha(form);
}
}
public override void OnAfterFormVisible(string FormUID, ref ItemEvent pVal, out bool BubbleEvent)
{
BubbleEvent = true;
using (var formCOM = new FormCOM(FormUID))
{
var form = formCOM.Form;
_OnAdicionarNovo(form);
}
}
public override void OnBeforeComboSelect(string FormUID, ref ItemEvent pVal, out bool BubbleEvent)
{
if (pVal.ItemUID == _botaoComboCopiar.ItemUID)
{
BubbleEvent = false;
using (var formCOM = new FormCOM(FormUID))
{
var form = formCOM.Form;
if (form.Mode == BoFormMode.fm_OK_MODE)
{
using (var dbdtsCOM = new DBDatasourceCOM(form, MainDbDataSource))
{
var dbdts = dbdtsCOM.Dbdts;
var fornecedor = _codigoPN.GetValorDBDatasource <string>(dbdts);
var numContratoFinal = _numeroDoContrato.GetValorDBDatasource <string>(dbdts);
var transportadora = _transportadora.GetValorDBDatasource <string>(dbdts);
var codigoItem = _codigoItem.GetValorDBDatasource <string>(dbdts);
var deposito = _deposito.GetValorDBDatasource <string>(dbdts);
var utilizacao = _utilizacao.GetValorDBDatasource <string>(dbdts);
var safra = _safra.GetValorDBDatasource <string>(dbdts);
var embalagem = _embalagem.GetValorDBDatasource <string>(dbdts);
var quantidade = _saldoDePeso.GetValorDBDatasource <double>(dbdts);
var filial = GetFilial(_deposito.GetValorDBDatasource <string>(dbdts));
var precoUnitario = _valorFaturado.GetValorDBDatasource <double>(dbdts);
var objPedidoCompra = new FormPedidoCompra();
var formPedidoCompra = objPedidoCompra.Abrir();
objPedidoCompra.PreencherPedido(formPedidoCompra, new PedidoCompraParams()
{
NumContratoFinal = numContratoFinal,
Fornecedor = fornecedor,
Item = codigoItem,
Utilizacao = utilizacao,
Transportadora = transportadora,
Embalagem = embalagem,
Deposito = deposito,
Quantidade = quantidade,
PrecoUnitario = precoUnitario,
Filial = filial
});
}
}
else
{
Dialogs.PopupError("Salve o Contrato antes de criar um novo Documento.");
}
}
}
else
{
base.OnAfterComboSelect(FormUID, ref pVal, out BubbleEvent);
}
}
public override void OnBeforeFormLoad(string FormUID, ref ItemEvent pVal, out bool BubbleEvent)
{
BubbleEvent = true;
using (var formCOM = new FormCOM(FormUID))
{
var form = formCOM.Form;
CriarEDesenharCampos(form);
CriarEDesenharCampoEmbalagem(form);
}
}
private void OnBotaoRemoverClick(ItemEvent pVal)
{
using (var formCOM = new FormCOM(pVal.FormUID))
{
var form = formCOM.Form;
using (var dbdtsCOM = new DBDatasourceCOM(form, mainDbDataSource))
{
var dbdts = dbdtsCOM.Dbdts;
_matriz.RemoverLinhaSelecionada(form, dbdts);
}
}
}
private void OnRemoverResponsavelClick(ItemEvent pVal)
{
using (var formCOM = new FormCOM(pVal.FormUID))
{
var form = formCOM.Form;
using (var dbdtsCOM = new DBDatasourceCOM(form, responsavelDbDataSource))
{
var dbdts = dbdtsCOM.Dbdts;
_responsaveis.RemoverLinhaSelecionada(form, dbdts);
}
}
}
private void OnRemoverCorretorClick(ItemEvent pVal)
{
using (var formCOM = new FormCOM(pVal.FormUID))
{
var form = formCOM.Form;
using (var dbdtsCOM = new DBDatasourceCOM(form, corretorDbDataSource))
{
var dbdts = dbdtsCOM.Dbdts;
_corretores.RemoverLinhaSelecionada(form, dbdts);
}
}
}
public override void OnAfterFormDataLoad(ref BusinessObjectInfo BusinessObjectInfo, out bool BubbleEvent)
{
BubbleEvent = true;
base.OnAfterFormDataLoad(ref BusinessObjectInfo, out BubbleEvent);
using (var formCOM = new FormCOM(BusinessObjectInfo.FormUID))
{
var form = formCOM.Form;
AtualizarMatriz(form);
}
}
public override void OnBeforeFormDataUpdate(ref BusinessObjectInfo BusinessObjectInfo, out bool BubbleEvent)
{
BubbleEvent = true;
using (var formCOM = new FormCOM(BusinessObjectInfo.FormUID))
{
var form = formCOM.Form;
using (var dbdtsCOM = new DBDatasourceCOM(form, mainDbDataSource))
{
var dbdts = dbdtsCOM.Dbdts;
BubbleEvent = CamposFormEstaoPreenchidos(form, dbdts);
}
}
}
public override void OnAfterFormVisible(string FormUID, ref ItemEvent pVal, out bool BubbleEvent)
{
BubbleEvent = true;
using (var formCOM = new FormCOM(FormUID))
{
var form = formCOM.Form;
var mtx = GetMatrix(form, _matriz.ItemUID);
using (var dbdtsCOM = new DBDatasourceCOM(form, mainDbDataSource))
{
var dbdts = dbdtsCOM.Dbdts;
PreencherDadosMatriz(form, mtx, dbdts);
}
}
}
public override void OnAfterFormVisible(string FormUID, ref ItemEvent pVal, out bool BubbleEvent)
{
BubbleEvent = true;
using (var formCOM = new FormCOM(FormUID))
{
var form = formCOM.Form;
try
{
form.Freeze(true);
DesabilitarMenuAdicionarNovo(form);
DesabilitarMenuPesquisar(form);
_corretores.CriarColunaSumAuto(form, _corretores._comissao.ItemUID);
_responsaveis.CriarColunaSumAuto(form, _responsaveis._comissao.ItemUID);
CarregarDadosMatriz(form, _fatherFormUID, _corretores.ItemUID, corretorDbDataSource);
CarregarDadosMatriz(form, _fatherFormUID, _responsaveis.ItemUID, responsavelDbDataSource);
var mtxCorretores = ((Matrix)form.Items.Item(_corretores.ItemUID).Specific);
var mtxResponsaveis = ((Matrix)form.Items.Item(_responsaveis.ItemUID).Specific);
ClicarParaCalcularOsTotalizadores(mtxCorretores, _corretores._comissao.ItemUID);
ClicarParaCalcularOsTotalizadores(mtxResponsaveis, _responsaveis._comissao.ItemUID);
_corretores._participante.Popular(mtxCorretores);
_responsaveis._participante.Popular(mtxResponsaveis);
using (var fatherFormCOM = new FormCOM(_fatherFormUID))
{
var statusContratoPai = formPai.GetStatusPersistent(fatherFormCOM.Form);
form.Items.Item("1").Enabled = UsuarioPermitido() && formPai.ContratoPodeSerAlterado(statusContratoPai);
}
}
catch (Exception e)
{
Dialogs.PopupError("Erro interno. Erro ao desenhar o form.\nErro: " + e.Message);
}
finally
{
form.Freeze(false);
}
}
}
public override void OnBeforeFormDataAdd(ref BusinessObjectInfo BusinessObjectInfo, out bool BubbleEvent)
{
BubbleEvent = true;
using (var formCOM = new FormCOM(BusinessObjectInfo.FormUID))
{
var form = formCOM.Form;
using (var dbdtsCOM = new DBDatasourceCOM(form, mainDbDataSource))
{
var dbdts = dbdtsCOM.Dbdts;
string nextCode = GetNextCode(mainDbDataSource);
dbdts.SetValue(_codigo.ItemUID, 0, nextCode);
BubbleEvent = CamposFormEstaoPreenchidos(form, dbdts);
}
}
}
public override void OnAfterFormDataAdd(ref BusinessObjectInfo BusinessObjectInfo, out bool BubbleEvent)
{
base.OnAfterFormDataAdd(ref BusinessObjectInfo, out BubbleEvent);
using (var formCOM = new FormCOM(BusinessObjectInfo.FormUID))
{
var form = formCOM.Form;
using (var dbdtsCOM = new DBDatasourceCOM(form, MainDbDataSource))
{
var dbdts = dbdtsCOM.Dbdts;
if (BusinessObjectInfo.ActionSuccess)
{
_adicionou = true;
AtualizarSaldoPreContrato(dbdts);
}
}
}
}
public override void OnBeforeItemPressed(string FormUID, ref ItemEvent pVal, out bool BubbleEvent)
{
base.OnAfterItemPressed(FormUID, ref pVal, out BubbleEvent);
if (pVal.ItemUID == "B_DocNumCF")
{
using (var formCOM = new FormCOM(FormUID))
{
var form = formCOM.Form;
using (var dbdtsCOM = new DBDatasourceCOM(form, mainDbDataSource))
{
BubbleEvent = false;
var dbdts = dbdtsCOM.Dbdts;
var codigo = dbdts.GetValue("U_DocNumCF", 0).Trim();
FormContratoFinal.AbrirNoRegistro(codigo);
}
}
}
}
public override void OnAfterFormLoad(string FormUID, ref ItemEvent pVal, out bool BubbleEvent)
{
base.OnAfterFormLoad(FormUID, ref pVal, out BubbleEvent);
using (var formCOM = new FormCOM(FormUID))
{
var form = formCOM.Form;
using (var dbdtsCOM = new DBDatasourceCOM(form, mainDbDataSource))
{
var dbdts = dbdtsCOM.Dbdts;
var cardcode = dbdts.GetValue("CardCode", 0).Trim();
if (!string.IsNullOrEmpty(cardcode) && form.Mode == BoFormMode.fm_ADD_MODE)
{
AtualizarCampoFalandoQueVeioDeContrato(form);
Dialogs.Success("Ok.");
}
}
}
}
public override void OnAfterFormVisible(string FormUID, ref ItemEvent pVal, out bool BubbleEvent)
{
BubbleEvent = true;
using (var formCOM = new FormCOM(FormUID))
{
var form = formCOM.Form;
try
{
form.Freeze(true);
_matriz.CriarColunaSumAuto(form, _matriz._percentual.ItemUID);
_matriz.CriarColunaSumAuto(form, _matriz._diferencial.ItemUID);
CarregarDadosMatriz(form, _fatherFormUID, _matriz.ItemUID, mainDbDataSource);
var mtx = ((Matrix)form.Items.Item(_matriz.ItemUID).Specific);
ClicarParaCalcularOsTotalizadores(mtx);
form.Items.Item("1").Enabled = UsuarioPermitido();
using (var fatherFormCOM = new FormCOM(_fatherFormUID))
{
var fatherForm = fatherFormCOM.Form;
using (var dbdtsCOM = new DBDatasourceCOM(fatherForm, fatherFormMainDbDataSource))
{
var fatherDbdts = dbdtsCOM.Dbdts;
var itemcodeBase = fatherDbdts.GetValue("U_ItemCode", 0).Trim();
ConditionsParaItens(form, itemcodeBase);
}
}
}
catch (Exception e)
{
Dialogs.PopupError("Erro interno. Erro ao desenhar o form.\nErro: " + e.Message);
}
finally
{
form.Freeze(false);
}
}
}
public override void OnAfterItemPressed(string FormUID, ref ItemEvent pVal, out bool BubbleEvent)
{
BubbleEvent = true;
if (pVal.ItemUID == "1")
{
using (var formCOM = new FormCOM(FormUID))
{
var form = formCOM.Form;
if (form.Mode == BoFormMode.fm_ADD_MODE && _adicionou)
{
_adicionou = false;
form.Close();
}
}
}
else
{
base.OnAfterItemPressed(FormUID, ref pVal, out BubbleEvent);
}
}
public override void OnBeforeFormLoad(string FormUID, ref ItemEvent pVal, out bool BubbleEvent)
{
BubbleEvent = true;
using (var formCOM = new FormCOM(FormUID))
{
var form = formCOM.Form;
var itemRefUID = "18";
var itemRef = form.Items.Item(itemRefUID);
var itemLabelRefUID = "8";
var itemLabelRef = form.Items.Item(itemLabelRefUID);
var comboGrupoAprovador = form.Items.Add(_grupoAprovador.ItemUID, BoFormItemTypes.it_COMBO_BOX);
comboGrupoAprovador.FromPane = 0;
comboGrupoAprovador.ToPane = 0;
int comboTop = itemRef.Top + 122;
comboGrupoAprovador.Top = comboTop;
comboGrupoAprovador.Left = itemRef.Left;
comboGrupoAprovador.Width = itemRef.Width;
comboGrupoAprovador.DisplayDesc = true;
((ComboBox)comboGrupoAprovador.Specific).DataBind.SetBound(true, mainDbDataSource, _grupoAprovador.Datasource);
var labelGrupoAprovador = form.Items.Add(_labelGrupoAprovador.ItemUID, BoFormItemTypes.it_STATIC);
labelGrupoAprovador.FromPane = 0;
labelGrupoAprovador.ToPane = 0;
labelGrupoAprovador.Top = comboTop;
labelGrupoAprovador.Left = itemLabelRef.Left;
labelGrupoAprovador.Width = itemLabelRef.Width;
labelGrupoAprovador.LinkTo = comboGrupoAprovador.UniqueID;
((StaticText)labelGrupoAprovador.Specific).Caption = "Grupo Aprovador";
}
}
public override void OnAfterComboSelect(string FormUID, ref ItemEvent pVal, out bool BubbleEvent)
{
BubbleEvent = true;
using (var formCOM = new FormCOM(FormUID))
{
var form = formCOM.Form;
var matrix = GetMatrix(form, pVal.ItemUID);
matrix.FlushToDataSource();
var dbdtsName = string.Empty;
Matriz matriz = null;
if (pVal.ItemUID == _corretores.ItemUID)
{
dbdtsName = corretorDbDataSource;
matriz = _corretores;
}
else if (pVal.ItemUID == _responsaveis.ItemUID)
{
dbdtsName = responsavelDbDataSource;
matriz = _responsaveis;
}
var row = pVal.Row - 1;
using (var dbdtsCOM = new DBDatasourceCOM(form, dbdtsName))
{
var dbdts = dbdtsCOM.Dbdts;
var participante = matriz._participante.GetValorDBDatasource <string>(dbdts, row);
if (!String.IsNullOrEmpty(participante))
{
matriz._comissao.GetValorDBDatasource <int>(dbdts);
var comissao = GetComissaoPadrao(participante);
matriz._comissao.SetValorDBDatasource(dbdts, comissao, row);
matrix.LoadFromDataSourceEx();
}
}
}
}
public override void OnAfterFormVisible(string FormUID, ref ItemEvent pVal, out bool BubbleEvent)
{
BubbleEvent = true;
using (var formCOM = new FormCOM(FormUID))
{
var form = formCOM.Form;
var mtx = GetMatrix(form, _matriz.ItemUID);
_matriz._utilizacao.Popular(mtx);
using (var dbdtsCOM = new DBDatasourceCOM(form, mainDbDataSource))
{
var dbdts = dbdtsCOM.Dbdts;
dbdts.Clear();
using (var recordset = new RecordSet())
{
var rs = recordset.DoQuery($"SELECT U_Usage FROM [{mainDbDataSource}] ORDER BY CONVERT(INT,Code)");
if (rs.RecordCount > 0)
{
while (!rs.EoF)
{
var utilizacao = rs.Fields.Item(_matriz._utilizacao.Datasource).Value;
dbdts.InsertRecord(dbdts.Size);
dbdts.SetValue(_matriz._utilizacao.Datasource, dbdts.Size - 1, utilizacao);
rs.MoveNext();
}
mtx.LoadFromDataSourceEx();
}
else
{
_matriz.AdicionarLinha(form);
}
}
}
}
}
public override void OnBeforeItemPressed(string FormUID, ref ItemEvent pVal, out bool BubbleEvent)
{
BubbleEvent = true;
if (pVal.ItemUID == "1")
{
using (var formCOM = new FormCOM(FormUID))
{
var form = formCOM.Form;
var mtx = ((Matrix)form.Items.Item(_matriz.ItemUID).Specific);
mtx.FlushToDataSource();
using (var dbdtsCOM = new DBDatasourceCOM(form, mainDbDataSource))
{
var dbdts = dbdtsCOM.Dbdts;
if (!CamposMatrizEstaoValidos(form, dbdts, _matriz))
{
BubbleEvent = false;
}
}
}
}
}
public override void OnAfterItemPressed(string FormUID, ref ItemEvent pVal, out bool BubbleEvent)
{
BubbleEvent = true;
if (pVal.ItemUID == _botaoAdicionar.ItemUID)
{
using (var formCOM = new FormCOM(FormUID))
{
var form = formCOM.Form;
if (form.Mode == BoFormMode.fm_OK_MODE)
{
FormContratoFinal.AbrirCriandoNovoRegistro(FormUID);
}
else
{
Dialogs.PopupError("Salve o Contrato antes de criar um novo Contrato Final.");
}
}
}
else
{
base.OnAfterItemPressed(FormUID, ref pVal, out BubbleEvent);
}
}
private void buttonConnect_Click(object sender, EventArgs e)
{
FormCOM FC = new FormCOM();
FC.ShowDialog(this);
}
