protected void btnDevolver_Click(object sender, EventArgs e) { DataFieldCollection lFields = new DataFieldCollection(); OperationResult lReturn = new OperationResult(); hidRetornarSetor.Value = "true"; try { string lTramitacaoAnterior = string.Empty; lFields.Add(TRAMITACAOQD._TRA_ID, hidTRA_ID.Value); lFields.Add(TRAMITACAOQD._TRA_REGDATE, DateTime.Now); lFields.Add(TRAMITACAOQD._TRA_REGUSER, Session["_SessionUser"].ToString()); lFields.Add(TRAMITACAOQD._TRA_STATUS, "A"); lFields.Add(TRAMITACAOQD._SPED_ID, "5"); lFields.Add(TRAMITACAOQD._TRA_OBSERVACAO, txtObservacaoTeste.Text); lReturn = TRAMITACAOTo.Update(lFields, LocalInstance.ConnectionInfo); exibirMensagem("Mensagem", "Diaria devolvida com sucesso", "ok", "AcompanharPedidoPlanejamento.aspx"); } catch (Exception err) { (new UnknownException(err)).TratarExcecao(false); } }
public static OperationResult Insert(DataFieldCollection pValues, ConnectionInfo pInfo) { Transaction lTransaction; lTransaction = new Transaction(Instance.CreateDatabase(pInfo)); bool lLocalTransaction = (lTransaction != null); InsertCommand lInsert; OperationResult lReturn = new OperationResult(PORT_BANNERQD.TableName, PORT_BANNERQD.TableName); if (!lReturn.HasError){ try{ if (lLocalTransaction){ lReturn.Trace("Transação local, instanciando banco..."); } lInsert = new InsertCommand(PORT_BANNERQD.TableName); lReturn.Trace("Adicionando campos ao objeto de insert"); foreach (DataField lField in pValues.Keys){ lInsert.Fields.Add(lField.Name, pValues[lField], (ItemType)lField.DBType); } decimal lSequence; lSequence = DataBaseSequenceControl.GetNext(pInfo, "BAN_ID"); lInsert.Fields.Add(PORT_BANNERQD._BAN_ID.Name, lSequence, (ItemType)PORT_BANNERQD._BAN_ID.DBType); lReturn.Trace("Executando o Insert"); lInsert.Execute(lTransaction, false); if (!lReturn.HasError){ if (lLocalTransaction){ if (!lReturn.HasError){ lReturn.Trace("Insert finalizado, executando commit"); lTransaction.Commit(); } else{ lTransaction.Rollback(); } } } else{ if (lLocalTransaction) lTransaction.Rollback(); } } catch (Exception ex){ lReturn.OperationException = new SerializableException(ex); if (lLocalTransaction) lTransaction.Rollback(); } } return lReturn; }
private void InterfaceInclude() { try { DataFieldCollection lFields = new DataFieldCollection(); OperationResult lReturn = new OperationResult(); lFields.Add(INTERACAOQD._CHA_ID, txtCHA_ID.Text); lFields.Add(INTERACAOQD._INT_REGDATE, DateTime.Now); lFields.Add(INTERACAOQD._INT_REGUSER, "USER"); lFields.Add(INTERACAOQD._INT_STATUS, "A"); lReturn = INTERACAOTo.Insert(lFields, LocalInstance.ConnectionInfo); if (!lReturn.IsValid) { Exception err = new Exception(lReturn.OperationException.Message.ToString()); throw err; } else { MessageBox1.wuc_ShowMessage("Registro salvo com sucesso.", 1); //LoadGrid(); Clear(); } } catch (WebManagerException e) { e.TratarExcecao(true); } catch (Exception err) { (new UnknownException(err)).TratarExcecao(true); } }
protected void btnIndeferir_Click(object sender, EventArgs e) { DataFieldCollection lFields = new DataFieldCollection(); OperationResult lReturn = new OperationResult(); try { if (btnIndeferir.Text == "INDEFERIR") { txtOBS.Visible = true; btnIndeferir.Text = "CONFIRMAR INDEFERIMENTO"; } else { string lTramitacao = string.Empty; txtOBS.Visible = false; btnIndeferir.Text = "INDEFERIR"; lTramitacao = hidTRA_ID.Value; lFields.Add(TRAMITACAOQD._TRA_ID, lTramitacao); lFields.Add(TRAMITACAOQD._SPED_ID, "4"); lFields.Add(TRAMITACAOQD._TRA_REGDATE, DateTime.Now); lFields.Add(TRAMITACAOQD._TRA_REGUSER, Session["_SessionUser"].ToString()); lFields.Add(TRAMITACAOQD._TRA_STATUS, "A"); lFields.Add(TRAMITACAOQD._TRA_OBSERVACAO, txtOBS.Text); lReturn = TRAMITACAOTo.Update(lFields, LocalInstance.ConnectionInfo); if (!lReturn.IsValid) { Exception ee = new Exception(lReturn.OperationException.Message); throw ee; } btnImprimir.Visible = false; PanelDadosDiaria.Visible = false; //lobao grvDestinacao.Visible = false; grvPROPOSTO.Visible = false; dvPropostos.Visible = false; dvPedidos.Visible = true; dvGPPARAFUNDOS.Visible = false; DivDadosSuprimentoFundos.Visible = false; LoadGridPlanejDeferido(); LoadGridPlanejIndeferido(); LoadGridPlanejTramitando(); LoadTabs(); } } catch (Exception err) { (new UnknownException(err)).TratarExcecao(false); } }
protected void grdMain_RowCommand(object sender, GridViewCommandEventArgs e) { try { if (e.CommandName != "Page") //Paginação { int iIndice = (((GridView)sender).PageIndex * ((GridView)sender).PageSize) + int.Parse(e.CommandArgument.ToString()); if (e.CommandName == "Receber") { DataTable lRelatorios = (DataTable)ViewState["WRK_TABLE"]; if (lRelatorios.Rows.Count > 0) { DataTable lImagem = CORREGEDORIAIMGDo.GetCORREGEDORIAIMGByID(lRelatorios.Rows[iIndice]["CGDR_ID"].DBToDecimal(), LocalInstance.ConnectionInfo); Session["_CGDR_ID_"] = lRelatorios.Rows[iIndice]["CGDR_ID"].DBToDecimal(); ////System.IO.FileStream wFile; ////byte[] byteData = null; ////byteData = (byte[])lImagem.Rows[0][CORREGEDORIAIMGQD._CGDR_IMG.Name]; ////wFile = new FileStream("c:\\" + lRelatorios.Rows[iIndice]["PES_NOME"].ToString() + "_" + lRelatorios.Rows[iIndice][CORREGEDORIAIMGQD._CGDR_NOME.Name].ToString(), FileMode.Append); ////wFile.Write(byteData, 0, byteData.Length); ////wFile.Close(); DataFieldCollection lFields = new DataFieldCollection(); OperationResult lReturn = new OperationResult(); lFields.Add(CORREGEDORIAIMGQD._CGDR_ID, lRelatorios.Rows[iIndice]["CGDR_ID"].DBToDecimal()); lFields.Add(CORREGEDORIAIMGQD._CGDR_SIT, 1); lReturn = CORREGEDORIAIMGDo.Update(lFields, LocalInstance.ConnectionInfo); if (!lReturn.IsValid) { Exception err = new Exception(lReturn.OperationException.Message.ToString()); throw err; } else { LoadGrid(); } } } } } catch (Exception err) { (new UnknownException(err)).TratarExcecao(true); } }
public static decimal GetNext(Transaction pTransaction, string pIDFieldValue) { decimal lID; // Inicializa operação OperationResult lReturn = new OperationResult(QueryDictionaries.SequencesQD.TableName, QueryDictionaries.SequencesQD.TableName); // Recupera Valor SelectCommand lSelectNext; string lSelectQuery = QueryDictionaries.SequencesQD.qSequencesMax; lSelectQuery += String.Format("WHERE {0} = >>{0}", QueryDictionaries.SequencesQD._SEQ_NAME.Name); object lScalarReturn; lSelectNext = new SelectCommand(lSelectQuery); // Passagem dos Valores de Parametros para a Clausula WHERE [comando SELECT] lSelectNext.Fields.Add(QueryDictionaries.SequencesQD._SEQ_NAME.Name, pIDFieldValue, ItemType.String); // Recupera Valor do Select (Seq_Value) lScalarReturn = lSelectNext.ReturnScalar(pTransaction); if (lScalarReturn == null || lScalarReturn == DBNull.Value) lScalarReturn = 1; lID = Convert.ToDecimal(lScalarReturn); // Altera Valor da Sequence UpdateCommand lUpdate; lUpdate = new UpdateCommand(QueryDictionaries.SequencesQD.TableName); // Identificação dos Campos a serem Alterados lUpdate.Fields.Add(QueryDictionaries.SequencesQD._SEQ_VALUE.Name, lID, (ItemType) QueryDictionaries.SequencesQD._SEQ_VALUE.DBType); string lUpdateQuery; lUpdateQuery = String.Format("WHERE {0} = >>{0}", QueryDictionaries.SequencesQD._SEQ_NAME.Name); lUpdate.Condition = lUpdateQuery; // Passagem dos Valores para a Condição Where do Update lUpdate.Conditions.Add(QueryDictionaries.SequencesQD._SEQ_NAME.Name, pIDFieldValue); // Execução do UPDATE lUpdate.Execute(pTransaction); // Retorna novo valor da chave [SEQUENCE VALUE] return lID; }
protected void btnAceitar_Click(object sender, EventArgs e) { DataFieldCollection lFields = new DataFieldCollection(); OperationResult lReturn = new OperationResult(); try { lFields.Add(RELATORIOVIAGEMQD._RELVIA_ID, lobRELVIA_ID); lFields.Add(RELATORIOVIAGEMQD._RELVIA_REGDATE, DateTime.Now); lFields.Add(RELATORIOVIAGEMQD._RELVIA_REGUSER, Session["_SessionUser"].ToString()); lFields.Add(RELATORIOVIAGEMQD._RELVIA_STATUS, "A"); lFields.Add(RELATORIOVIAGEMQD._RELVIA_FINAN, "OK"); lReturn = RELATORIOVIAGEMTo.Update(lFields, LocalInstance.ConnectionInfo); if (!lReturn.IsValid) { Exception ee = new Exception(lReturn.OperationException.Message.ToString()); throw ee; } string jscript = ""; jscript += "window.opener.location.reload('../Aut/Admin/AcompanharPedidofinanceiro.aspx');"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "refreshPageAnterior", jscript, true); ClientScript.RegisterStartupScript(typeof(Page), "closePage", "window.close();", true); } catch (WebManagerException wex) { wex.TratarExcecao(true); } catch (Exception ee) { (new UnknownException(ee)).TratarExcecao(true); } }
private static void ValidateInsert(DataFieldCollection pValues, OperationResult pResult) { GenericDataObject.ValidateConversion(pValues, pResult); }
private static void ValidateUpdate(DataFieldCollection pValues, OperationResult pResult) { GenericDataObject.ValidateRequired(BairroQD._BRR_ID, pValues, pResult); GenericDataObject.ValidateRequired(BairroQD._BRR_REGDATE, pValues, pResult); GenericDataObject.ValidateRequired(BairroQD._BRR_REGUSER, pValues, pResult); GenericDataObject.ValidateRequired(BairroQD._BRR_STATUS , pValues, pResult); }
public static OperationResult Update( DataFieldCollection pValues, List<DataFieldCollection> pListAtuaInc, List<DataFieldCollection> pListAtuaUpd, DataFieldCollection pValuesAtuaExcluir, List<DataFieldCollection> pListPermissao, ConnectionInfo pInfo ) { Transaction pTransaction; pTransaction = new Transaction(Instance.CreateDatabase(pInfo)); bool lLocalTransaction = (pTransaction != null); UpdateCommand lUpdate; OperationResult lReturn = new OperationResult(PessoaFuncaoQD.TableName, PessoaFuncaoQD.TableName); ValidateUpdate(pValues, lReturn); if (lReturn.IsValid) { try { lUpdate = new UpdateCommand(PessoaFuncaoQD.TableName); foreach (DataField lField in pValues.Keys) { if ((lField.Name != PessoaFuncaoQD._PESF_ID.Name)) lUpdate.Fields.Add(lField.Name, pValues[lField], (ItemType)lField.DBType); } string lSql = ""; lSql = String.Format("WHERE {0} = <<{0}", PessoaFuncaoQD._PESF_ID.Name); lUpdate.Condition = lSql; lUpdate.Conditions.Add(PessoaFuncaoQD._PESF_ID.Name, pValues[PessoaFuncaoQD._PESF_ID].DBToDecimal()); lUpdate.Execute(pTransaction); if (!lReturn.HasError) { //Excluir atuação do núcleo alterado if (pValuesAtuaExcluir.Count > 0) { lReturn = AtuacaoDo.UpdateInativo(pValuesAtuaExcluir, pInfo); if (lReturn.HasError) { pTransaction.Rollback(); return lReturn; } } if (pListAtuaInc.Count > 0) { foreach (DataFieldCollection lFields in pListAtuaInc) { lReturn = AtuacaoDo.Insert(lFields, pTransaction, pInfo); if (lReturn.HasError) { pTransaction.Rollback(); return lReturn; } } } if (pListAtuaUpd.Count > 0) { foreach (DataFieldCollection lFields in pListAtuaUpd) { lReturn = AtuacaoDo.Update(lFields, pTransaction, pInfo); if (lReturn.HasError) { pTransaction.Rollback(); return lReturn; } } } if (pListPermissao.Count > 0) { foreach (DataFieldCollection lFields in pListPermissao) { lReturn = SecurityUsersDtDo.Insert(lFields, pTransaction, pInfo); if (lReturn.HasError) { pTransaction.Rollback(); return lReturn; } } } if (!lReturn.HasError) { pTransaction.Commit(); } else { pTransaction.Rollback(); } } else { if (lLocalTransaction) pTransaction.Rollback(); } } catch (Exception ex) { lReturn.OperationException = new SerializableException(ex); if (lLocalTransaction) pTransaction.Rollback(); } } return lReturn; }
private void TramitacaoUpdate(string pOpcao) { DataFieldCollection lFields = new DataFieldCollection(); OperationResult lReturn = new OperationResult(); try { lFields.Add(TRAMITACAOQD._TRA_ID, hidTRA_ID.Value); lFields.Add(TRAMITACAOQD._SPED_ID, pOpcao); lFields.Add(TRAMITACAOQD._TRA_REGDATE, DateTime.Now); lFields.Add(TRAMITACAOQD._TRA_REGUSER, "USER"); lFields.Add(TRAMITACAOQD._TRA_STATUS, "A"); //4 - indeferido if (pOpcao.Equals("4")) { } else if (pOpcao.Equals("3")) // 3 - DEFERIDO { lReturn = TRAMITACAOTo.Update(lFields, LocalInstance.ConnectionInfo); if (!lReturn.IsValid) { Exception e = new Exception(lReturn.OperationException.Message.ToString()); throw e; } else { TramitacaoInclude(); } } } catch (WebManagerException wex) { wex.TratarExcecao(true); } catch (Exception e) { (new UnknownException(e)).TratarExcecao(true); } }
private void InterfaceInclude() { try { LoginUserDo oUsuario = (LoginUserDo)Session["UsuarioAtual"]; string pPath = ""; if (chkTipoCaminho.Checked) pPath = @"~\anexos\File\" + hdPathImgDestaque1.Value.Trim(); else pPath = txtBannerPath.Text; if(validaDados()) { DataFieldCollection lFields = new DataFieldCollection(); OperationResult lReturn = new OperationResult(); lFields.Add(PORT_BANNERQD._BAN_PATH, @"~\banners\" + hdPathImgDestaque.Value.Trim()); lFields.Add(PORT_BANNERQD._BAN_LINK, pPath); lFields.Add(PORT_BANNERQD._BAN_ORDEM, txtBanOrdemDestaque.Text); lFields.Add(PORT_BANNERQD._BAN_REGDATE, DateTime.Now); lFields.Add(PORT_BANNERQD._BAN_REGUSER, oUsuario.LoginName.ToString()); lFields.Add(PORT_BANNERQD._BAN_REGSTATUS, "A"); lReturn = PORT_BANNERDo.Insert(lFields, LocalInstance.ConnectionInfo); if (!lReturn.IsValid) { Exception err = new Exception(lReturn.OperationException.Message.ToString()); exibirMensagem(UpdatePanelPrincipal, "Cadastro de Banner", err.Message, "erro"); } else { if (msg != "") { exibirMensagem(UpdatePanelPrincipal, "Cadastro de Banner", msg, "alerta"); } else { exibirMensagem(UpdatePanelPrincipal, "Cadastro de Banner", "Banner cadastrado com sucesso"); Clear(); } } } } catch (Exception err) { exibirMensagem(UpdatePanelPrincipal, "Cadastro de Banner", err.Message, "erro"); } }
private static void ValidateUpdate(DataFieldCollection pValues, OperationResult pResult) { GenericDataObject.ValidateRequired(NucleoxLocalidadeQD._NUCLOC_ID, pValues, pResult); GenericDataObject.ValidateRequired(NucleoxLocalidadeQD._NUCLOC_REGDATE, pValues, pResult); GenericDataObject.ValidateRequired(NucleoxLocalidadeQD._NUCLOC_REGUSER, pValues, pResult); GenericDataObject.ValidateRequired(NucleoxLocalidadeQD._NUCLOC_STATUS, pValues, pResult); }
private void InterfaceUpdateAnexoSuprimento(decimal pSUPFUNANX_ID) { try { DataFieldCollection lFields = new DataFieldCollection(); OperationResult lReturn = new OperationResult(); lFields.Add(SuprimentoFundo_AnexoQD._SUPFUNANX_ID, pSUPFUNANX_ID); lFields.Add(SuprimentoFundo_AnexoQD._SUPFUNANX_REGDATE, DateTime.Now); lFields.Add(SuprimentoFundo_AnexoQD._SUPFUNANX_REGUSER, Session["_SessionUser"].ToString()); lFields.Add(SuprimentoFundo_AnexoQD._SUPFUNANX_STATUS, "I"); lReturn = SuprimentoFundo_AnexoTo.Update(lFields, LocalInstance.ConnectionInfo); if (!lReturn.IsValid) { Exception err = new Exception(lReturn.OperationException.Message.ToString()); throw err; } else { LoadGridAnexoSuprimento(hidKEY_ID.Value.DBToDecimal()); lblMSG.Text = "Registro Excluído"; lblMSG.Visible = true; } } catch (WebManagerException wex) { wex.TratarExcecao(true); } catch (Exception e) { (new UnknownException(e)).TratarExcecao(true); } }
private void IncludeImagem() { DataFieldCollection lFields = new DataFieldCollection(); OperationResult lReturn = new OperationResult(); byte[] Anexo = new byte[0]; string lTipo = ""; if (hidTipo.Value.Equals("2")) //Diaria { #region Empenho //1 empenho if (btnImgEmpenho.FileName != "") { // lTipo = Path.GetExtension(Path.GetFileName(btnImgEmpenho.FileName)); // Anexo = new byte[0]; // if (lTipo.ToLower() == ".jpg") // { Anexo = carregaAnexoEmpenho(); lFields.Clear(); lFields.Add(Diaria_Proposto_AnexoQD._DIAPRO_ID, hidPESF_ID.Value); lFields.Add(Diaria_Proposto_AnexoQD._DIAPROANX_TIPO, 1); lFields.Add(Diaria_Proposto_AnexoQD._DIAPROANX_IMG, Anexo); lFields.Add(Diaria_Proposto_AnexoQD._DIAPROANX_REGDATE, DateTime.Now); lFields.Add(Diaria_Proposto_AnexoQD._DIAPROANX_REGUSER, Session["_SessionUser"].ToString()); lFields.Add(Diaria_Proposto_AnexoQD._DIAPROANX_STATUS, "A"); lReturn = Diaria_Proposto_AnexoTo.Insert(lFields, LocalInstance.ConnectionInfo); if (!lReturn.IsValid) { Exception err = new Exception(lReturn.OperationException.Message.ToString()); throw err; } // } // else // { // lblMSG.Visible = true; // lblMSG.Text = "Só possível salvar imagens JPG ou JPEG"; // } } #endregion #region LIQUIDAÇÃO //2 LIQUIDAÇÃO if (btnImgLiquidacao.FileName != "") { //lTipo = Path.GetExtension(Path.GetFileName(btnImgLiquidacao.FileName)); //Anexo = new byte[0]; //if (lTipo.ToLower() == ".jpg") //{ Anexo = carregaAnexoLiquidacao(); lFields.Clear(); lFields.Add(Diaria_Proposto_AnexoQD._DIAPRO_ID, hidPESF_ID.Value); lFields.Add(Diaria_Proposto_AnexoQD._DIAPROANX_TIPO, 2); lFields.Add(Diaria_Proposto_AnexoQD._DIAPROANX_IMG, Anexo); lFields.Add(Diaria_Proposto_AnexoQD._DIAPROANX_REGDATE, DateTime.Now); lFields.Add(Diaria_Proposto_AnexoQD._DIAPROANX_REGUSER, Session["_SessionUser"].ToString()); lFields.Add(Diaria_Proposto_AnexoQD._DIAPROANX_STATUS, "A"); lReturn = Diaria_Proposto_AnexoTo.Insert(lFields, LocalInstance.ConnectionInfo); if (!lReturn.IsValid) { Exception err = new Exception(lReturn.OperationException.Message.ToString()); throw err; } //} //else //{ // lblMSG.Visible = true; // lblMSG.Text = "Só possível salvar imagens JPG ou JPEG"; //} } #endregion #region OB //2 OB if (btnImgOb.FileName != "") { //lTipo = Path.GetExtension(Path.GetFileName(btnImgOb.FileName)); //Anexo = new byte[0]; //if (lTipo.ToLower() == ".jpg") //{ Anexo = carregaAnexoOb(); lFields.Clear(); lFields.Add(Diaria_Proposto_AnexoQD._DIAPRO_ID, hidPESF_ID.Value); lFields.Add(Diaria_Proposto_AnexoQD._DIAPROANX_TIPO, 3); lFields.Add(Diaria_Proposto_AnexoQD._DIAPROANX_IMG, Anexo); lFields.Add(Diaria_Proposto_AnexoQD._DIAPROANX_REGDATE, DateTime.Now); lFields.Add(Diaria_Proposto_AnexoQD._DIAPROANX_REGUSER, Session["_SessionUser"].ToString()); lFields.Add(Diaria_Proposto_AnexoQD._DIAPROANX_STATUS, "A"); lReturn = Diaria_Proposto_AnexoTo.Insert(lFields, LocalInstance.ConnectionInfo); if (!lReturn.IsValid) { Exception err = new Exception(lReturn.OperationException.Message.ToString()); throw err; } //} //else //{ // lblMSG.Visible = true; // lblMSG.Text = "Só possível salvar imagens JPG ou JPEG"; //} } #endregion } else { //SUPRIMENTO #region Empenho //1 empenho if (btnImgEmpenho.FileName != "") { //lTipo = Path.GetExtension(Path.GetFileName(btnImgEmpenho.FileName)); //Anexo = new byte[0]; //if (lTipo.ToLower() == ".jpg") //{ Anexo = carregaAnexoEmpenho(); lFields.Clear(); lFields.Add(SuprimentoFundo_AnexoQD._SUPFUN_ID, hidKEY_ID.Value); lFields.Add(SuprimentoFundo_AnexoQD._SUPFUNANX_TIPO, 1); lFields.Add(SuprimentoFundo_AnexoQD._SUPFUNANX_IMG, Anexo); lFields.Add(SuprimentoFundo_AnexoQD._SUPFUNANX_REGDATE, DateTime.Now); lFields.Add(SuprimentoFundo_AnexoQD._SUPFUNANX_REGUSER, Session["_SessionUser"].ToString()); lFields.Add(SuprimentoFundo_AnexoQD._SUPFUNANX_STATUS, "A"); lReturn = SuprimentoFundo_AnexoTo.Insert(lFields, LocalInstance.ConnectionInfo); if (!lReturn.IsValid) { Exception err = new Exception(lReturn.OperationException.Message.ToString()); throw err; } //} //else //{ // lblMSG.Visible = true; // lblMSG.Text = "Só possível salvar imagens JPG ou JPEG"; //} } #endregion #region LIQUIDAÇÃO if (btnImgLiquidacao.FileName != "") { //lTipo = Path.GetExtension(Path.GetFileName(btnImgLiquidacao.FileName)); //Anexo = new byte[0]; //if (lTipo.ToLower() == ".jpg") //{ Anexo = carregaAnexoLiquidacao(); lFields.Clear(); lFields.Add(SuprimentoFundo_AnexoQD._SUPFUN_ID, hidKEY_ID.Value); lFields.Add(SuprimentoFundo_AnexoQD._SUPFUNANX_TIPO, 2); lFields.Add(SuprimentoFundo_AnexoQD._SUPFUNANX_IMG, Anexo); lFields.Add(SuprimentoFundo_AnexoQD._SUPFUNANX_REGDATE, DateTime.Now); lFields.Add(SuprimentoFundo_AnexoQD._SUPFUNANX_REGUSER, Session["_SessionUser"].ToString()); lFields.Add(SuprimentoFundo_AnexoQD._SUPFUNANX_STATUS, "A"); lReturn = SuprimentoFundo_AnexoTo.Insert(lFields, LocalInstance.ConnectionInfo); if (!lReturn.IsValid) { Exception err = new Exception(lReturn.OperationException.Message.ToString()); throw err; } //} //else //{ // lblMSG.Visible = true; // lblMSG.Text = "Só possível salvar imagens JPG ou JPEG"; //} } #endregion #region OB if (btnImgOb.FileName != "") { //lTipo = Path.GetExtension(Path.GetFileName(btnImgOb.FileName)); //Anexo = new byte[0]; //if (lTipo.ToLower() == ".jpg") //{ Anexo = carregaAnexoOb(); lFields.Clear(); lFields.Add(SuprimentoFundo_AnexoQD._SUPFUN_ID, hidKEY_ID.Value); lFields.Add(SuprimentoFundo_AnexoQD._SUPFUNANX_TIPO, 3); lFields.Add(SuprimentoFundo_AnexoQD._SUPFUNANX_IMG, Anexo); lFields.Add(SuprimentoFundo_AnexoQD._SUPFUNANX_REGDATE, DateTime.Now); lFields.Add(SuprimentoFundo_AnexoQD._SUPFUNANX_REGUSER, Session["_SessionUser"].ToString()); lFields.Add(SuprimentoFundo_AnexoQD._SUPFUNANX_STATUS, "A"); lReturn = SuprimentoFundo_AnexoTo.Insert(lFields, LocalInstance.ConnectionInfo); if (!lReturn.IsValid) { Exception err = new Exception(lReturn.OperationException.Message.ToString()); throw err; } //} //else //{ // lblMSG.Visible = true; // lblMSG.Text = "Só possível salvar imagens JPG ou JPEG"; //} } #endregion } }
private void InterfaceUpdate(decimal pNOTFIS_ID, string pStatus) { try { DataFieldCollection lFields = new DataFieldCollection(); OperationResult lReturn = new OperationResult(); lFields.Add(NotaFiscalQD._NOTFIS_ID, pNOTFIS_ID); if (pStatus == "A") { lFields.Add(NotaFiscalQD._NOTFIS_NUMERO, txtNOTFIS_NUMERO.Text); lFields.Add(NotaFiscalQD._NOTFIS_VALOR, txtNOTFIS_VALOR.Text); //lFields.Add(NotaFiscalQD._FIG_ID.Text); //lFields.Add(NotaFiscalQD._PRESNOT_ID , txtPRESNOT_ID.Text); } lFields.Add(NotaFiscalQD._NOTFIS_REGDATE, DateTime.Now); lFields.Add(NotaFiscalQD._NOTFIS_REGUSER, "USER"); lFields.Add(NotaFiscalQD._NOTFIS_STATUS, pStatus); lReturn = NotaFiscalTo.Update(lFields, LocalInstance.ConnectionInfo); if (!lReturn.IsValid) { Exception err = new Exception(lReturn.OperationException.Message.ToString()); throw err; } else { MessageBox1.wuc_ShowMessage("Registro salvo com sucesso.", 1); //Clear(); } } catch (WebManagerException e) { e.TratarExcecao(true); } catch (Exception err) { (new UnknownException(err)).TratarExcecao(true); } }
private void TramitacaoInclude(string pSetorOri, decimal pDoc_id) { DataFieldCollection lFields = new DataFieldCollection(); OperationResult lreturn = new OperationResult(); string lSeqOrg; try { lSeqOrg = SETORTo.GetSEQUENCIAORGANOGRAMA_PRESTACAObySETOR(LocalInstance.ConnectionInfo, "N", pSetorOri); lFields.Add(TRAMITACAOQD._SORG_ID, lSeqOrg); //lFields.Add(TRAMITACAOQD._SET_IDDESTINO, lSetorDest); lFields.Add(TRAMITACAOQD._SPED_ID, 1); lFields.Add(TRAMITACAOQD._DOC_ID, hidDOC_ID.Value); lFields.Add(TRAMITACAOQD._TRA_REGDATE, DateTime.Now); lFields.Add(TRAMITACAOQD._TRA_REGUSER, "USER"); lFields.Add(TRAMITACAOQD._TRA_STATUS, "A"); lreturn = TRAMITACAOTo.Insert(lFields, LocalInstance.ConnectionInfo); if (!lreturn.IsValid) { Exception exc = new Exception(lreturn.OperationException.Message.ToString()); throw exc; } } catch (WebManagerException wex) { wex.TratarExcecao(true); } catch (Exception e) { (new UnknownException(e)).TratarExcecao(true); } }
private bool PropostoUpdate() { if (hidTipo.Value.Equals("2")) //Diaria { try { DataFieldCollection lFields = new DataFieldCollection(); OperationResult lReturn = new OperationResult(); lFields.Add(DIARIA_PROPOSTOQD._DIAPRO_ID, hidPESF_ID.Value); lFields.Add(DIARIA_PROPOSTOQD._DIAPRO_NUMEROEMPENHO, txtEmpenho.Text); lFields.Add(DIARIA_PROPOSTOQD._DIAPRO_LIQUIDACAO, txtLiquidacao.Text); lFields.Add(DIARIA_PROPOSTOQD._DIAPRO_OB, txtOB.Text); lFields.Add(DIARIA_PROPOSTOQD._DIAPRO_PD, txtDOCSAL_SALDO.Text); lFields.Add(DIARIA_PROPOSTOQD._DIAPRO_EVENTO, txtEvento.Text); lFields.Add(DIARIA_PROPOSTOQD._DIAPRO_REGDATE, DateTime.Now); lFields.Add(DIARIA_PROPOSTOQD._DIAPRO_REGUSER, Session["_SessionUser"].ToString()); lFields.Add(DIARIA_PROPOSTOQD._DIAPRO_STATUS, "A"); lReturn = DIARIA_PROPOSTOTo.Update(lFields, LocalInstance.ConnectionInfo); if (!lReturn.IsValid) { Exception err = new Exception(lReturn.OperationException.Message.ToString()); throw err; } else { //InterfaceIncludeDocumentoSaldo(); IncludeImagem(); return true; } } catch (WebManagerException e) { e.TratarExcecao(true); } catch (Exception err) { (new UnknownException(err)).TratarExcecao(true); } } else //suprimento de fundo { try { DataFieldCollection lFields = new DataFieldCollection(); OperationResult lReturn = new OperationResult(); lFields.Add(SUPRIMENTOFUNDOQD._SUPFUN_ID, hidKEY_ID.Value); lFields.Add(SUPRIMENTOFUNDOQD._SUPFUN_NUMEROEMPENHO, txtEmpenho.Text); lFields.Add(SUPRIMENTOFUNDOQD._SUPFUN_LIQUIDACAO, txtLiquidacao.Text); lFields.Add(SUPRIMENTOFUNDOQD._SUPFUN_OB, txtOB.Text); lFields.Add(SUPRIMENTOFUNDOQD._SUPFUN_PD, txtDOCSAL_SALDO.Text); lFields.Add(SUPRIMENTOFUNDOQD._SUPFUN_REGDATE, DateTime.Now); lFields.Add(SUPRIMENTOFUNDOQD._SUPFUN_REGUSER, Session["_SessionUser"].ToString()); lFields.Add(SUPRIMENTOFUNDOQD._SUPFUN_STATUS, "A"); lReturn = SUPRIMENTOFUNDOTo.Update(lFields, LocalInstance.ConnectionInfo); if (!lReturn.IsValid) { Exception err = new Exception(lReturn.OperationException.Message.ToString()); throw err; } else { //InterfaceIncludeDocumentoSaldo(); IncludeImagem(); return true; } } catch (WebManagerException e) { e.TratarExcecao(true); } catch (Exception err) { (new UnknownException(err)).TratarExcecao(true); } } return false; }
private void InterfaceInclude() { try { DataFieldCollection lFields = new DataFieldCollection(); OperationResult lReturn = new OperationResult(); String Aux; Aux = txtDESCCENTES_APRESENTACAO.Text.Replace("size", ""); Aux = txtDESCCENTES_APRESENTACAO.Text.Replace("H1", ""); Aux = txtDESCCENTES_APRESENTACAO.Text.Replace("H2", ""); Aux = txtDESCCENTES_APRESENTACAO.Text.Replace("H3", ""); Aux = txtDESCCENTES_APRESENTACAO.Text.Replace("H4", ""); lFields.Add(DESCCENTROESTUDOQD._DESCCENTES_APRESENTACAO, Aux); Aux = txtDESCCENTES_OBJETIVO.Text.Replace("size", ""); Aux = txtDESCCENTES_OBJETIVO.Text.Replace("H1", ""); Aux = txtDESCCENTES_OBJETIVO.Text.Replace("H2", ""); Aux = txtDESCCENTES_OBJETIVO.Text.Replace("H3", ""); Aux = txtDESCCENTES_OBJETIVO.Text.Replace("H4", ""); lFields.Add(DESCCENTROESTUDOQD._DESCCENTES_OBJETIVO, Aux); Aux = txtDESCCENTES_CONTATO.Text.Replace("size", ""); Aux = txtDESCCENTES_CONTATO.Text.Replace("H1", ""); Aux = txtDESCCENTES_CONTATO.Text.Replace("H2", ""); Aux = txtDESCCENTES_CONTATO.Text.Replace("H3", ""); Aux = txtDESCCENTES_CONTATO.Text.Replace("H4", ""); lFields.Add(DESCCENTROESTUDOQD._DESCCENTES_CONTATO, Aux); lFields.Add(DESCCENTROESTUDOQD._DESCCENTES_REGDATE, DateTime.Now); lFields.Add(DESCCENTROESTUDOQD._DESCCENTES_REGUSER, "USER"); lFields.Add(DESCCENTROESTUDOQD._DESCCENTES_STATUS, "A"); lReturn = DESCCENTROESTUDOTo.Insert(lFields, LocalInstance.ConnectionInfo); if (!lReturn.IsValid) { Exception err = new Exception(lReturn.OperationException.Message.ToString()); throw err; } else { MessageBox1.wuc_ShowMessage("Registro salvo com sucesso.", 1); LoadGrid(); LoadCampos(); } } catch (WebManagerException e) { e.TratarExcecao(true); } catch (Exception err) { (new UnknownException(err)).TratarExcecao(true); } }
private void TramitacaoUpdate() { DataFieldCollection lFields = new DataFieldCollection(); OperationResult lReturn = new OperationResult(); try { lFields.Add(TRAMITACAOQD._TRA_ID, hidTRA_ID.Value); lFields.Add(TRAMITACAOQD._SPED_ID, "3"); lFields.Add(TRAMITACAOQD._TRA_REGDATE, DateTime.Now); lFields.Add(TRAMITACAOQD._TRA_REGUSER, Session["_SessionUser"].ToString()); lFields.Add(TRAMITACAOQD._TRA_STATUS, "A"); lReturn = TRAMITACAOTo.Update(lFields, LocalInstance.ConnectionInfo); if (!lReturn.IsValid) { Exception e = new Exception(lReturn.OperationException.Message.ToString()); throw e; } else { TramitacaoInclude(); } } catch (WebManagerException wex) { wex.TratarExcecao(true); } catch (Exception e) { (new UnknownException(e)).TratarExcecao(true); } }
private void TramitacaoInclude() { DataFieldCollection lFields = new DataFieldCollection(); OperationResult lreturn = new OperationResult(); try { DataTable lTableSetor = SETORTo.GetSEQUENCIAORGANOGRAMAbyTramitacao(LocalInstance.ConnectionInfo, hidTRA_ID.Value); string lProxProx = "", lProxSeqOrg = ""; if (lTableSetor.Rows.Count > 0) { lProxSeqOrg = lTableSetor.Rows[0]["SORG_IDCORRESPONDENTE"].ToString(); lProxProx = lTableSetor.Rows[0]["PROXIMO"].ToString(); } lFields.Add(TRAMITACAOQD._SORG_ID, lProxSeqOrg); if (lProxProx.Length > 0) lFields.Add(TRAMITACAOQD._SPED_ID, 1); else lFields.Add(TRAMITACAOQD._SPED_ID, 3); lFields.Add(TRAMITACAOQD._DOC_ID, hidDOC_ID.Value); lFields.Add(TRAMITACAOQD._TRA_REGDATE, DateTime.Now); lFields.Add(TRAMITACAOQD._TRA_REGUSER, "USER"); lFields.Add(TRAMITACAOQD._TRA_STATUS, "A"); lreturn = TRAMITACAOTo.Insert(lFields, LocalInstance.ConnectionInfo); if (!lreturn.IsValid) { Exception exc = new Exception(lreturn.OperationException.Message.ToString()); throw exc; } } catch (WebManagerException wex) { wex.TratarExcecao(true); } catch (Exception e) { (new UnknownException(e)).TratarExcecao(true); } }
private void InterfaceUpdate(decimal pNATDES_ID,string pStatus) { try { DataFieldCollection lFields = new DataFieldCollection(); OperationResult lReturn = new OperationResult(); lFields.Add(NATUREZADESPESAQD._NATDES_ID , pNATDES_ID); if (pStatus == "A") { lFields.Add(NATUREZADESPESAQD._NATDES_CODIGO , txtNATDES_CODIGO.Text); lFields.Add(NATUREZADESPESAQD._NATDES_DESC , txtNATDES_DESC.Text); } lFields.Add(NATUREZADESPESAQD._NATDES_REGDATE, DateTime.Now); lFields.Add(NATUREZADESPESAQD._NATDES_REGUSER, "USER"); lFields.Add(NATUREZADESPESAQD._NATDES_STATUS, pStatus); lReturn = NATUREZADESPESATo.Update(lFields, LocalInstance.ConnectionInfo); if (!lReturn.IsValid) { Exception err = new Exception(lReturn.OperationException.Message.ToString()); throw err; } else { MessageBox1.wuc_ShowMessage("Registro salvo com sucesso.", 1); LoadGrid(); Clear(); } } catch (WebManagerException e) { e.TratarExcecao(true); } catch (Exception err) { (new UnknownException(err)).TratarExcecao(true); } }
public static OperationResult Insert( DataFieldCollection pValuesPESF, List<DataFieldCollection> pListValuesATUA, DataFieldCollection pValuesSUSR, List<DataFieldCollection> pListValuesPERMISSAO, ConnectionInfo pInfo ) { Transaction lTransaction; lTransaction = new Transaction(Instance.CreateDatabase(pInfo)); bool lLocalTransaction = (lTransaction != null); InsertCommand lInsert; OperationResult lReturn = new OperationResult(PessoaFuncaoQD.TableName, PessoaFuncaoQD.TableName); if (!lReturn.HasError) { try { lInsert = new InsertCommand(PessoaFuncaoQD.TableName); foreach (DataField lField in pValuesPESF.Keys) { lInsert.Fields.Add(lField.Name, pValuesPESF[lField], (ItemType)lField.DBType); } decimal lSequencePESF_ID; lSequencePESF_ID = DataBaseSequenceControl.GetNext(pInfo, "PESF_ID"); lInsert.Fields.Add(PessoaFuncaoQD._PESF_ID.Name, lSequencePESF_ID, (ItemType)PessoaFuncaoQD._PESF_ID.DBType); lReturn.SequenceControl = lSequencePESF_ID; lInsert.Execute(lTransaction); if (!lReturn.HasError) { if (pListValuesATUA.Count > 0) { foreach (DataFieldCollection lFields in pListValuesATUA) { lFields.Add(AtuacaoQD._PESF_ID, lSequencePESF_ID); lReturn = AtuacaoDo.Insert(lFields, lTransaction, pInfo); if (lReturn.HasError) { lTransaction.Rollback(); return lReturn; } } } lReturn = SystemUserDo.Insert(pValuesSUSR, lTransaction, pInfo); if (lReturn.HasError) { lTransaction.Rollback(); return lReturn; } if (pListValuesPERMISSAO.Count > 0) { foreach (DataFieldCollection lFields in pListValuesPERMISSAO) { lFields.Add(SecurityUsersDtQD._SU_ID, lSequencePESF_ID); lReturn = SecurityUsersDtDo.Insert(lFields, lTransaction, pInfo); if (lReturn.HasError) { lTransaction.Rollback(); return lReturn; } } } if (!lReturn.HasError) { lTransaction.Commit(); } else { lTransaction.Rollback(); } } else { if (lLocalTransaction) lTransaction.Rollback(); } } catch (Exception ex) { lReturn.OperationException = new SerializableException(ex); if (lLocalTransaction) lTransaction.Rollback(); } } return lReturn; }
private static void ValidateUpdate(DataFieldCollection pValues, OperationResult pResult) { GenericDataObject.ValidateRequired(EscalaQD._ESC_ID, pValues, pResult); //GenericDataObject.ValidateRequired(EscalaQD._ESC_REGDATE, pValues, pResult); //GenericDataObject.ValidateRequired(EscalaQD._ESC_REGUSER, pValues, pResult); GenericDataObject.ValidateRequired(EscalaQD._ESC_STATUS, pValues, pResult); }
private static void ValidateUpdate(DataFieldCollection pValues, OperationResult pResult) { GenericDataObject.ValidateRequired(PessoaFuncaoQD._PESF_ID, pValues, pResult); GenericDataObject.ValidateRequired(PessoaFuncaoQD._PESF_REGDATE, pValues, pResult); GenericDataObject.ValidateRequired(PessoaFuncaoQD._PESF_REGUSER, pValues, pResult); GenericDataObject.ValidateRequired(PessoaFuncaoQD._PESF_STATUS, pValues, pResult); }
private decimal InterfaceIncludeFigura(byte[] IMG) { decimal ID = 0; try { DataFieldCollection lFields = new DataFieldCollection(); OperationResult lReturn = new OperationResult(); lFields.Add(FIGURASQD._FIG_IMAGEN, IMG); lFields.Add(FIGURASQD._FIG_NOME, "FIGURA"); lFields.Add(FIGURASQD._FIG_FORMATO, ".jpg"); lFields.Add(FIGURASQD._FIG_TAMANHO, IMG); lFields.Add(FIGURASQD._FIG_REGDATE, DateTime.Now); lFields.Add(FIGURASQD._FIG_REGUSER, "USER"); lFields.Add(FIGURASQD._FIG_STATUS, "A"); lReturn = FIGURASTo.Insert(lFields, LocalInstance.ConnectionInfo); if (!lReturn.IsValid) { Exception err = new Exception(lReturn.OperationException.Message.ToString()); throw err; } else { ID = lReturn.SequenceControl; } } catch (WebManagerException e) { e.TratarExcecao(true); } catch (Exception err) { (new UnknownException(err)).TratarExcecao(true); } return ID; }
public static OperationResult Update( DataFieldCollection pValues, ConnectionInfo pInfo ) { Transaction pTransaction; pTransaction = new Transaction(Instance.CreateDatabase(pInfo)); bool lLocalTransaction = (pTransaction != null); UpdateCommand lUpdate; OperationResult lReturn = new OperationResult(PLANOINTERNOQD.TableName, PLANOINTERNOQD.TableName); ValidateUpdate(pValues, lReturn); if (lReturn.IsValid) { try { if (lLocalTransaction) { lReturn.Trace("Transação local, instanciando banco..."); } lUpdate = new UpdateCommand(PLANOINTERNOQD.TableName); lReturn.Trace("Adicionando campos ao objeto de update"); foreach (DataField lField in pValues.Keys) { if ((lField.Name != PLANOINTERNOQD._PLANI_ID.Name)) lUpdate.Fields.Add(lField.Name, pValues[lField], (ItemType)lField.DBType); } string lSql = ""; lSql = String.Format("WHERE {0} = <<{0}", PLANOINTERNOQD._PLANI_ID.Name); lUpdate.Condition = lSql; lUpdate.Conditions.Add(PLANOINTERNOQD._PLANI_ID.Name, pValues[PLANOINTERNOQD._PLANI_ID].DBToDecimal()); lReturn.Trace("Executando o Update"); lUpdate.Execute(pTransaction); if (!lReturn.HasError) { if (lLocalTransaction) { if (!lReturn.HasError) { lReturn.Trace("Update finalizado, executando commit"); pTransaction.Commit(); } else { pTransaction.Rollback(); } } } else { if (lLocalTransaction) pTransaction.Rollback(); } } catch (Exception ex) { lReturn.OperationException = new SerializableException(ex); if (lLocalTransaction) pTransaction.Rollback(); } } return lReturn; }
private void InterfaceIncludeNotaFiscal(decimal notaid) { try { DataTable lTable = (DataTable)ViewState["WRK_TABLE"]; DataFieldCollection lFields = new DataFieldCollection(); OperationResult lReturn = new OperationResult(); CreateTableReceitaDespesa(); DataTable lTableReceitaDespesa = (DataTable)ViewState["WRK_TABLE_RD"]; for (int i = 0; i < lTable.Rows.Count; i++) { lFields.Add(NotaFiscalQD._NOTFIS_NUMERO, lTable.Rows[i][NotaFiscalQD._NOTFIS_NUMERO.Name].ToString()); lFields.Add(NotaFiscalQD._NOTFIS_VALOR, lTable.Rows[i][NotaFiscalQD._NOTFIS_VALOR.Name].ToString()); lFields.Add(NotaFiscalQD._NOTFIS_TIPO, lTable.Rows[i][NotaFiscalQD._NOTFIS_TIPO.Name].DBToDecimal()); decimal fig_id = InterfaceIncludeFigura((byte[])lTable.Rows[i]["FIGURA"]); if (fig_id == 0) { lFields.Clear(); continue; } lFields.Add(NotaFiscalQD._FIG_ID, fig_id); lFields.Add(NotaFiscalQD._PRESNOT_ID, notaid); lFields.Add(NotaFiscalQD._NOTFIS_REGDATE, DateTime.Now); lFields.Add(NotaFiscalQD._NOTFIS_REGUSER, "USER"); lFields.Add(NotaFiscalQD._NOTFIS_STATUS, "A"); lReturn = NotaFiscalTo.Insert(lFields, LocalInstance.ConnectionInfo); if (!lReturn.IsValid) { Exception err = new Exception(lReturn.OperationException.Message.ToString()); throw err; } lFields.Clear(); #region Tabela Relatorio DataRow lRow = lTableReceitaDespesa.NewRow(); int lord = i + 2; lRow["ORD"] = lord.ToString(); lRow[NotaFiscalQD._NOTFIS_DESCRICAO.Name] = lTable.Rows[i][NotaFiscalQD._NOTFIS_DESCRICAO.Name].ToString(); lRow[NotaFiscalQD._NOTFIS_NUMERO.Name] = lTable.Rows[i][NotaFiscalQD._NOTFIS_NUMERO.Name].ToString(); //if (lTable.Rows[i][NotaFiscalQD._NOTFIS_TIPO.Name].DBToDecimal() == (decimal)TipoNotaFiscal.NotaFiscal) // lRow["DEBITO"] = lTable.Rows[i][NotaFiscalQD._NOTFIS_VALOR.Name].DBToDecimal(); //else lRow["CREDITO"] = lTable.Rows[i][NotaFiscalQD._NOTFIS_VALOR.Name].DBToDecimal(); lTableReceitaDespesa.Rows.Add(lRow); #endregion } Session["WRK_PARAMETER_REGUSER"] = hidPES_NOME.Value; Session["WRK_PARAMETER_PORTARIA"] = hidPORT_NUMERO.Value; Session["WRK_TABLE"] = lTableReceitaDespesa; } catch (WebManagerException e) { e.TratarExcecao(true); } catch (Exception err) { (new UnknownException(err)).TratarExcecao(true); } }
private static void ValidateUpdate(DataFieldCollection pValues, OperationResult pResult) { GenericDataObject.ValidateRequired(PLANOINTERNOQD._PLANI_ID, pValues, pResult); GenericDataObject.ValidateRequired(PLANOINTERNOQD._PLANI_REGDATE, pValues, pResult); GenericDataObject.ValidateRequired(PLANOINTERNOQD._PLANI_REGUSER, pValues, pResult); GenericDataObject.ValidateRequired(PLANOINTERNOQD._PLANI_STATUS, pValues, pResult); }
private void InterfaceIncludePrestacaoNotaFiscal() { decimal ID = 0; try { DataFieldCollection lFields = new DataFieldCollection(); OperationResult lReturn = new OperationResult(); lFields.Add(PrestacaoxNotaFiscalQD._PRES_ID, Session["PRES_ID"].ToString()); lFields.Add(PrestacaoxNotaFiscalQD._PRESNOT_DATA, DateTime.Now); lFields.Add(PrestacaoxNotaFiscalQD._PRESNOT_REGDATE, DateTime.Now); lFields.Add(PrestacaoxNotaFiscalQD._PRESNOT_REGUSER, "USER"); lFields.Add(PrestacaoxNotaFiscalQD._PRESNOT_STATUS, "A"); lReturn = PrestacaoxNotaFiscalTo.Insert(lFields, LocalInstance.ConnectionInfo); if (!lReturn.IsValid) { Exception err = new Exception(lReturn.OperationException.Message.ToString()); throw err; } else { ID = lReturn.SequenceControl; InterfaceIncludeNotaFiscal(ID); string lSetorOri = (string)Session["_SessionSetor"]; TramitacaoInclude(lSetorOri, decimal.Parse(hidDOC_ID.Value)); MessageBox1.wuc_ShowMessage("Prestação Realizada com sucesso. Aguarde a proxima janela aparecer com o demonstrativo da receita e da espesa.", "AutDefault.aspx", "Reports/LoadReport.aspx?ReportName=SFReceitaDespesa.rpt", 1); Session["PRES_ID"] = null; Session["DOC_ID"] = null; Session["KEY_ID"] = null; } } catch (WebManagerException e) { e.TratarExcecao(true); } catch (Exception err) { (new UnknownException(err)).TratarExcecao(true); } }