private static LIS_ORDEMSERVICOSFECHEntity FillEntityObject(ref FbDataReader DataReader)
{
LIS_ORDEMSERVICOSFECHEntity entity = new LIS_ORDEMSERVICOSFECHEntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.IDORDEMSERVICO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDORDEMSERVICO"));
entity.DATAEMISSAO = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("DATAEMISSAO"));
entity.VALORORCAMENTO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORORCAMENTO"));
entity.PRAZOENTREGA = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("PRAZOENTREGA"));
entity.IDSTATUS = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDSTATUS"));
entity.NOMESTATUS = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMESTATUS"));
entity.IDFUNCIONARIO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDFUNCIONARIO"));
entity.NOMEFUNCIONARIO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMEFUNCIONARIO"));
entity.OBSERVACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("OBSERVACAO"));
entity.TOTALITEMSERVICO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("TOTALITEMSERVICO"));
entity.TOTALITEMPECA = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("TOTALITEMPECA"));
entity.MAOOBRA = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("MAOOBRA"));
entity.OUTROVALOR = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("OUTROVALOR"));
entity.TOTALFECHOS = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("TOTALFECHOS"));
entity.GARANTIAVECTO = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("GARANTIAVECTO"));
entity.IDFORMAPAGAMENTO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDFORMAPAGAMENTO"));
entity.NOMEFORMAPAGTO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMEFORMAPAGTO"));
entity.IDCLIENTE = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDCLIENTE"));
entity.NOMECLIENTE = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMECLIENTE"));
entity.CONTATO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CONTATO"));
entity.VALORPAGO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORPAGO"));
entity.VALORDEVEDOR = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORDEVEDOR"));
entity.FLAGORCAMENTO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("FLAGORCAMENTO"));
entity.PORCCOMISSAO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("PORCCOMISSAO"));
entity.VLCOMISSAO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VLCOMISSAO"));
entity.PLACA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("PLACA"));
entity.PROBLEMAINFORMADO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("PROBLEMAINFORMADO"));
entity.PROBLEMACONSTATADO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("PROBLEMACONSTATADO"));
entity.SERVICOEXECUTADO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("SERVICOEXECUTADO"));
entity.EQUIPAMENTO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("EQUIPAMENTO"));
entity.MODELO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("MODELO"));
entity.MARCA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("MARCA"));
entity.ACESSORIOS = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("ACESSORIOS"));
return(entity);
}
private void btnConsultar_Click(object sender, EventArgs e)
{
try
{
RowRelatorio.Clear();
RowRelatorio.Add(new RowsFiltro("DATAEMISSAO", "System.DateTime", ">=", Util.ConverStringDateSearch(mkDtInicial.Text)));
RowRelatorio.Add(new RowsFiltro("DATAEMISSAO", "System.DateTime", "<=", Util.ConverStringDateSearch(mkdatafinal.Text)));
if (rdOrcamento.Checked)
{
RowRelatorio.Add(new RowsFiltro("FLAGORCAMENTO", "System.String", "=", "S"));
}
else if (rdVenda.Checked)
{
RowRelatorio.Add(new RowsFiltro("FLAGORCAMENTO", "System.String", "=", "N"));
}
LIS_ORDEMSERVICOSFECHColl.Clear();
LIS_ORDEMSERVICOSFECHColl = LIS_ORDEMSERVICOSFECHP.ReadCollectionByParameter(RowRelatorio, "DATAEMISSAO DESC");
//Colocando somatorio no final da lista
LIS_ORDEMSERVICOSFECHEntity LIS_ORDEMSERVICOSFECHTy = new LIS_ORDEMSERVICOSFECHEntity();
LIS_ORDEMSERVICOSFECHTy.TOTALFECHOS = SumTotalPesquisa("TOTALFECHOS");
LIS_ORDEMSERVICOSFECHColl.Add(LIS_ORDEMSERVICOSFECHTy);
lblTotalRegistros.Text = "Total de Registros: " + (LIS_ORDEMSERVICOSFECHColl.Count - 1).ToString();
DataGridRelaPedido.AutoGenerateColumns = false;
DataGridRelaPedido.DataSource = LIS_ORDEMSERVICOSFECHColl;
AddGridFormaPagto();
}
catch (Exception ex)
{
MessageBox.Show("Erro técnico: " + ex.Message);
}
}
