Ejemplo n.º 1
0
        public static DataSet From(ConnectionInfo pInfo, string pSelectQuery, DataFieldCollection pConditionalParameters)
        {
            DataBase lDB;
            Transaction lTransaction = null;
            DataSet lReturn = new DataSet();

            try
            {

                lDB = Instance.CreateDatabase(pInfo);

                lTransaction = new Transaction(lDB);

                lReturn = From(lTransaction, pSelectQuery, pConditionalParameters);

                lTransaction.Commit();
            }
            catch (Exception lException)
            {

                if (lTransaction != null)
                    lTransaction.Rollback();

                throw lException;
            }

            return lReturn;
        }
        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);
            }
        }
Ejemplo n.º 3
0
        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 btnSim_Click(object sender, EventArgs e)
    {
        DataFieldCollection lFields = new DataFieldCollection();
        OperationResult lreturn = new OperationResult();

        try
        {
            lFields.Add(DEFENSORITINERANCIAQD._DEF_ID, ddlDefensores.SelectedValue);
            lFields.Add(DEFENSORITINERANCIAQD._DEFI_DISPOSICAO, rblItinerancia.SelectedValue);
            lFields.Add(DEFENSORITINERANCIAQD._DEFI_USUARIOS, Session["_SessionUser"].ToString());
            lFields.Add(DEFENSORITINERANCIAQD._DEFI_REGDATE, DateTime.Now);
            lFields.Add(DEFENSORITINERANCIAQD._DEFI_STATUS, "A");

            lreturn = DEFENSORITINERANCIADo.Insert(lFields, LocalInstance.ConnectionInfo);

            if (!lreturn.IsValid)
            {
                Exception exc = new Exception(lreturn.OperationException.Message.ToString());
                throw exc;
            }
            else
            {
                MessageBox1.wuc_ShowMessage("Registro efetuado com sucesso!", 1);
                LoadDefensor();
            }

        }
        catch (Exception err)
        {
            (new UnknownException(err)).TratarExcecao(true);
        }
    }
Ejemplo n.º 6
0
        public void Insert(DataFieldCollection dfc)
        {
            InsertHandle handle = new InsertHandle(ModelName);

            handle.Ctx.Row = dfc;
            handle.Execute();
        }
Ejemplo n.º 7
0
 public static void UpdateRow(DataRow row, DataFieldCollection fields)
 {
     foreach (DataColumn dc in row.Table.Columns)
     {
         DataField field = fields.IndexOf(dc.ColumnName);
         row[dc] = field != null && field.Value != null ? field.Value : DBNull.Value;
     }
 }
Ejemplo n.º 8
0
        public void Update(DataFieldCollection dfc, Criteria ct)
        {
            UpdateHandle handle = new UpdateHandle(ModelName);

            handle.Ctx.Row          = dfc;
            handle.ConditonCriteria = ct;
            handle.Execute();
        }
Ejemplo n.º 9
0
        public BaseRowAdapter(TableName tname, Locator locator)
        {
            this.columns = new ColumnAdapterCollection();
            this.fields = new DataFieldCollection();

            this.tableName = tname;
            this.locator = locator;
        }
        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);
            }
        }
Ejemplo n.º 11
0
        public TableAdapter(DataTable dataTable, TableName tableName, Locator locator)
        {
            this.dataTable = dataTable;
            this.tableName = tableName;
            this.locator = locator;

            this.columns = new ColumnAdapterCollection();
            this.fields = new DataFieldCollection();
        }
Ejemplo n.º 12
0
         public static OperationResult Update(DataFieldCollection pValues, ConnectionInfo pInfo) {
             OperationResult lReturn = null;                         
                                                                     
             if (pInfo.BridgeMode == (int)BridgeMode.Internal){                                                       
				lReturn = PORT_BANNERDo.Update(pValues, pInfo);
             }
             else{
                 // Chamada do WebServices     
             }                                                       
                                                                     
             return lReturn;                                         
         }                                                           
        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);
            }
        }
Ejemplo n.º 14
0
    private void InterfaceLocalidade()
    {
        try
        {
            DataFieldCollection lFields = new DataFieldCollection();
            OperationResult lReturn = new OperationResult();

            LoginUserDo oUsuario = (LoginUserDo)Session["UsuarioAtual"];

            if (hfNucLoc.Value == "")
            {
                lFields.Add(NucleoxLocalidadeQD._NUC_ID,        hfNucId.Value);
                lFields.Add(NucleoxLocalidadeQD._CID_ID,        ddlLocalidade.SelectedValue);
                lFields.Add(NucleoxLocalidadeQD._BRR_ID,        "0");
                lFields.Add(NucleoxLocalidadeQD._NUCLOC_REGDATE, DateTime.Now);
                lFields.Add(NucleoxLocalidadeQD._NUCLOC_REGUSER, oUsuario.LoginName);
                lFields.Add(NucleoxLocalidadeQD._NUCLOC_STATUS, "A");

                lReturn = NucleoxLocalidadeDo.Insert(lFields, LocalInstance.ConnectionInfo);
            }
            else
            {
                lFields.Add(NucleoxLocalidadeQD._NUCLOC_ID,     hfNucLoc.Value);
                lFields.Add(NucleoxLocalidadeQD._NUC_ID,        hfNucId.Value);
                lFields.Add(NucleoxLocalidadeQD._CID_ID,        ddlLocalidade.SelectedValue);
                lFields.Add(NucleoxLocalidadeQD._NUCLOC_REGDATE, DateTime.Now);
                lFields.Add(NucleoxLocalidadeQD._NUCLOC_REGUSER, oUsuario.LoginName);
                lFields.Add(NucleoxLocalidadeQD._NUCLOC_STATUS, "A");

                lReturn = NucleoxLocalidadeDo.Update(lFields, LocalInstance.ConnectionInfo);
            }

            if (!lReturn.IsValid)
            {
                Exception err = new Exception(lReturn.OperationException.Message.ToString());
                exibirMensagem("Erro", err.Message, "erro");
            }
            else
            {
                Response.Redirect("GerNucleo.aspx?r=OK&n=" + hfNucId.Value + "");
            }
        }
        catch (Exception err)
        {
            exibirMensagem("Erro", err.Message, "erro");
        }
    }
        public static OperationResult Insert(                                                           
             DataFieldCollection pValues,                            
             ConnectionInfo pInfo                                    
         )
        {
            OperationResult lReturn = null;

             if (pInfo.BridgeMode == (int)BridgeMode.Internal)
             {
                 lReturn = DESCCONTROLEINTERNODo.Insert(pValues, pInfo);
             }
             else
             {
                 // Chamada do WebServices
             }

             return lReturn;
        }
        public static OperationResult Insert(                                                           
             DataFieldCollection pValues,                            
             ConnectionInfo pInfo                                    
         )
        {
            OperationResult lReturn = null;

             if (pInfo.BridgeMode == (int)BridgeMode.Internal)
             {
                 lReturn = Biblioteca_itememprestimoDo.Insert(pValues, pInfo);
             }
             else
             {
                 // Chamada do WebServices
             }

             return lReturn;
        }
Ejemplo n.º 17
0
        public void Update(Dictionary <string, object> dic, Criteria ct)
        {
            DataFieldCollection dfc = new DataFieldCollection();

            foreach (string key in dic.Keys)
            {
                if (!Columns.Contains(key))
                {
                    throw new ArgumentException("当前模型不包含:" + key + "字段");
                }
                if (Columns[key].Direction == ParameterDirection.ReturnValue)
                {
                    throw new ArgumentException("字段" + key + "为Return类型,不能添加数据");
                }
                dfc.Add(new DataField(Columns[key], dic[key]));
            }
            Update(dfc, ct);
        }
        public static OperationResult Insert(                                                           
             DataFieldCollection pValues,                            
             ConnectionInfo pInfo                                    
         )
        {
            OperationResult lReturn = null;

             if (pInfo.BridgeMode == (int)BridgeMode.Internal)
             {
                 lReturn = PrestacaoFundoFiguraDo.Insert(pValues, pInfo);
             }
             else
             {
                 // Chamada do WebServices
             }

             return lReturn;
        }
        public static OperationResult Insert(                                                           
             DataFieldCollection pValues,                            
             ConnectionInfo pInfo                                    
         )
        {
            OperationResult lReturn = null;

             if (pInfo.BridgeMode == (int)BridgeMode.Internal)
             {
                 lReturn = MODALIDADEXSUPRIMENTOFUNDODo.Insert(pValues, pInfo);
             }
             else
             {
                 // Chamada do WebServices
             }

             return lReturn;
        }
        public static OperationResult Insert(                                                           
             DataFieldCollection pValues,                            
             ConnectionInfo pInfo                                    
         )
        {
            OperationResult lReturn = null;

             if (pInfo.BridgeMode == (int)BridgeMode.Internal)
             {
                 lReturn = BIBLIOTECA_ITEMJRNL_REVISTADo.Insert(pValues, pInfo);
             }
             else
             {
                 // Chamada do WebServices
             }

             return lReturn;
        }
        public static OperationResult Insert(                                                           
             DataFieldCollection pValues,                            
             ConnectionInfo pInfo                                    
         )
        {
            OperationResult lReturn = null;

             if (pInfo.BridgeMode == (int)BridgeMode.Internal)
             {
                 lReturn = SEQUENCIAORGANOGRAMADo.Insert(pValues, pInfo);
             }
             else
             {
                 // Chamada do WebServices
             }

             return lReturn;
        }
        public static OperationResult Insert(                                                           
             DataFieldCollection pValues,                            
             ConnectionInfo pInfo                                    
         )
        {
            OperationResult lReturn = null;

             if (pInfo.BridgeMode == (int)BridgeMode.Internal)
             {
                 lReturn = VALORESMATERIALDETALHAMENTODo.Insert(pValues, pInfo);
             }
             else
             {
                 // Chamada do WebServices
             }

             return lReturn;
        }
 public static void ValidateRequired(DataField pField, DataFieldCollection pValues, OperationResult pOperationResult)
 {
     if (!pValues.ContainsKey(pField))
     {
         pOperationResult.InvalidField(pField.Name, "Required", null);
     }
     else
     {
         if (pValues[pField] == null)
         {
             pOperationResult.InvalidField(pField.Name, "Required", null);
         }
         else
         {
             if (pValues[pField].ToString() == "")
                 pOperationResult.InvalidField(pField.Name, "Required", null);
         }
     }
 }
        public static OperationResult Insert(                         
             string pTipo,                     
             DataFieldCollection pValues,                            
             ConnectionInfo pInfo                                    
         )
        {
            OperationResult lReturn = null;

             if (pInfo.BridgeMode == (int)BridgeMode.Internal)
             {
                 lReturn = DEFDOCUMENTODo.Insert(pTipo,pValues, pInfo);
             }
             else
             {
                 // Chamada do WebServices
             }

             return lReturn;
        }
        public static void ValidateConversion(DataFieldCollection pValues, OperationResult pOperationResult)
        {
            foreach (DataField lField in pValues.Keys)
            {
                switch (lField.DBType)
                {
                    case 0:

                        ValidateDecimal(lField.Name, pValues[lField], pOperationResult);

                        break;

                    case 2:

                        ValidateDate(lField.Name, pValues[lField], pOperationResult);

                        break;
                }
            }
        }
        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);
            }
        }
    protected void btnScpjNovo_Click(object sender, EventArgs e)
    {
        DataFieldCollection lFields = new DataFieldCollection();
        OperationResult lReturn = new OperationResult();

        lFields.Add(LOGDEFNETQD._LOGDEF_PAGINA,     "SCPJ NOVO");
        lFields.Add(LOGDEFNETQD._LOGDEF_USUARIO,    Session["_SessionUser"].ToString());
        lFields.Add(LOGDEFNETQD._LOGDEF_REGDATE,    DateTime.Now);
        lFields.Add(LOGDEFNETQD._LOGDEF_STATUS,     "A");

        lReturn = LOGDEFNETDo.Insert(lFields, LocalInstance.ConnectionInfo);

        if (!lReturn.IsValid)
        {
            Exception err = new Exception(lReturn.OperationException.Message.ToString());
            throw err;
        }
        else
        {
            Response.Redirect(lLinkNovo);
        }
    }
Ejemplo n.º 28
0
    private void InterfaceUpdateSystemUser(decimal pPES_ID, string pStatus)
    {
        try
        {
            DataFieldCollection lFields = new DataFieldCollection();
            OperationResult lReturn = new OperationResult();

            lFields.Add(SystemUserQD._SUSR_ID, decimal.Parse(Session["Susr_Id"].ToString()));

            if (pStatus == "A")
            {
                String lPASS = APB.Framework.Encryption.Crypto.Encode(txtSenha.Text);

                lFields.Add(SystemUserQD._PES_ID,           pPES_ID);
                lFields.Add(SystemUserQD._SUSR_PASSWORD,    lPASS);
            }

            lFields.Add(SystemUserQD._SUSR_REGDATE,         DateTime.Now);
            lFields.Add(SystemUserQD._SUSR_REGUSR,          Session["UsuarioAtual"].ToString());
            lFields.Add(SystemUserQD._SUSR_STATUS,          pStatus);

            lReturn = SystemUserDo.Update(lFields, LocalInstance.ConnectionInfo);

            if (!lReturn.IsValid)
            {
                Exception err = new Exception(lReturn.OperationException.Message.ToString());
                throw err;
            }
            else
            {
                exibirMensagem("Alerta", " Registro salvo com sucesso.", "ok", "MudarSenha.aspx");
            }
        }
        catch (Exception err)
        {
            exibirMensagem( "Erro", err.Message.ToString(), "erro");
        }
    }
Ejemplo n.º 29
0
    private void InterfaceInsert()
    {
        try
        {
            DataFieldCollection lFields = new DataFieldCollection();
            OperationResult lReturn = new OperationResult();

            LoginUserDo oUsuario = (LoginUserDo)Session["UsuarioAtual"];

            lFields.Add(MUNICIPIOQD._CID_ID,        hfMunId.Value);
            lFields.Add(MUNICIPIOQD._MUN_ENDERECO,  txtEndCorreto.Value);
            lFields.Add(MUNICIPIOQD._MUN_LATITUDE,  txtLatitude.Value);
            lFields.Add(MUNICIPIOQD._MUN_LOGINTUDE, txtLongitude.Value);
            lFields.Add(MUNICIPIOQD._MUN_CONTATO,   txtContato.Value);
            lFields.Add(MUNICIPIOQD._MUN_COMPETENCIA, txtCompetencia.Value);
            lFields.Add(MUNICIPIOQD._MUN_REGDATE,   DateTime.Now);
            lFields.Add(MUNICIPIOQD._MUN_USUARIO,   oUsuario.LoginName);
            lFields.Add(MUNICIPIOQD._MUN_STATUS,    "A");

            lReturn = MUNICIPIODo.Insert(lFields, LocalInstance.ConnectionInfo);

            if (!lReturn.IsValid)
            {
                Exception err = new Exception(lReturn.OperationException.Message.ToString());
                exibirMensagem("Erro", err.Message, "erro");
            }
            else
            {
                Response.Redirect("GerNucleo.aspx?r=OK&n=" + hfMunId.Value + "");
            }
        }
        catch (Exception err)
        {
            exibirMensagem("Erro", err.Message, "erro");
        }
    }
 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 static void ValidateInsert(DataFieldCollection pValues, OperationResult pResult)
 {
     GenericDataObject.ValidateConversion(pValues, pResult);
 }
        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 static void ValidateUpdate(DataFieldCollection pValues, OperationResult pResult)
 {
     GenericDataObject.ValidateRequired(AssuntoProcessualQD._ASSPRC_ID, pValues, pResult);
     GenericDataObject.ValidateRequired(AssuntoProcessualQD._ASSPRC_REGDATE, pValues, pResult);
     GenericDataObject.ValidateRequired(AssuntoProcessualQD._ASSPRC_REGUSER, pValues, pResult);
     GenericDataObject.ValidateRequired(AssuntoProcessualQD._ASSPRC_STATUS, 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);
 }