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); } }
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); } }
public void Insert(DataFieldCollection dfc) { InsertHandle handle = new InsertHandle(ModelName); handle.Ctx.Row = dfc; handle.Execute(); }
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; } }
public void Update(DataFieldCollection dfc, Criteria ct) { UpdateHandle handle = new UpdateHandle(ModelName); handle.Ctx.Row = dfc; handle.ConditonCriteria = ct; handle.Execute(); }
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); } }
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(); }
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); } }
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; }
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); } }
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"); } }
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); }