public SCMContratoBE SelectID(SCMContratoBE obj) { SCMContratoBE contrato = new SCMContratoDao().Select <SCMContratoBE>(obj).FirstOrDefault <SCMContratoBE>(); contrato.Cliente = new GlobaisClienteBLL().SelectID(new GlobaisClienteBE { cli_id = contrato.cli_id }); return(contrato); }
public List <NTNotasEmitidasBE> CarregaNotasEmitidas(NTNotasBE obj, string tipoSelect = "Emitidas") { List <NTNotasEmitidasBE> result = new List <NTNotasEmitidasBE>(); GlobaisClienteDao cliente = new GlobaisClienteDao(); SCMContratoDao contrato = new SCMContratoDao(); SqlDataReader dr = new BaseDados().RetornaDataReader(this.procedure, tipoSelect, this.conectionString, obj); if (dr.HasRows) { while (dr.Read()) { NTNotasEmitidasBE item = new NTNotasEmitidasBE(); item.not_id = DBNull.Value.Equals(dr["not_id"]) ? 0 : Convert.ToInt32(dr["not_id"]); item.log_id = DBNull.Value.Equals(dr["log_id"]) ? 0 : Convert.ToInt32(dr["log_id"]); //item.user_id = DBNull.Value.Equals(dr["user_id"]) ? 0 : Convert.ToInt32(dr["user_id"]); item.log_cadastro = Convert.ToDateTime(dr["log_cadastro"]); item.log_alteracao = DBNull.Value.Equals(dr["log_alteracao"]) ? default(DateTime) : Convert.ToDateTime(dr["log_alteracao"]); item.log_exclusao = DBNull.Value.Equals(dr["log_exclusao"]) ? default(DateTime) : Convert.ToDateTime(dr["log_exclusao"]); item.log_ativo = DBNull.Value.Equals(dr["log_ativo"]) ? false : Convert.ToBoolean(dr["log_ativo"]); item.not_numero = DBNull.Value.Equals(dr["not_numero"]) ? 0 : Convert.ToInt32(dr["not_numero"]); item.cli_id = DBNull.Value.Equals(dr["cli_id"]) ? 0 : Convert.ToInt32(dr["cli_id"]); item.cont_id = DBNull.Value.Equals(dr["cont_id"]) ? 0 : Convert.ToInt32(dr["cont_id"]); item.conf_id = DBNull.Value.Equals(dr["conf_id"]) ? 0 : Convert.ToInt32(dr["conf_id"]); item.not_tipoReceita = dr["not_tipoReceita"].ToString(); item.not_codReceita = dr["not_codReceita"].ToString(); item.not_dtEmissao = DBNull.Value.Equals(dr["not_dtEmissao"]) ? default(DateTime) : Convert.ToDateTime(dr["not_dtEmissao"]); item.not_dtVencimento = DBNull.Value.Equals(dr["not_dtVencimento"]) ? default(DateTime) : Convert.ToDateTime(dr["not_dtVencimento"]); item.not_pis = DBNull.Value.Equals(dr["not_pis"]) ? 0 : Convert.ToDecimal(dr["not_pis"]); item.not_confins = DBNull.Value.Equals(dr["not_confins"]) ? 0 : Convert.ToDecimal(dr["not_confins"]); item.not_cssl = DBNull.Value.Equals(dr["not_cssl"]) ? 0 : Convert.ToDecimal(dr["not_cssl"]); item.not_irrf = DBNull.Value.Equals(dr["not_irrf"]) ? 0 : Convert.ToDecimal(dr["not_irrf"]); item.not_totalbruto = DBNull.Value.Equals(dr["not_totalbruto"]) ? 0 : Convert.ToDecimal(dr["not_totalbruto"]); item.not_totalliquido = DBNull.Value.Equals(dr["not_totalliquido"]) ? 0 : Convert.ToDecimal(dr["not_totalliquido"]); item.not_preenchida = DBNull.Value.Equals(dr["not_preenchida"]) ? 0 : Convert.ToInt32(dr["not_preenchida"]); item.not_emitida = DBNull.Value.Equals(dr["not_emitida"]) ? false : Convert.ToBoolean(dr["not_emitida"]); item.not_situacao = dr["not_situacao"].ToString(); item.not_chave = dr["not_chave"].ToString(); //Lote item.Lote = new NTLoteBE(); item.Lote.lote_serie = dr["lote_serie"].ToString(); item.Lote.lote_modulo = dr["lote_modulo"].ToString(); item.Lote.lote_emissao = DBNull.Value.Equals(dr["lote_emissao"]) ? default(DateTime) : Convert.ToDateTime(dr["lote_emissao"]); //Retorno item.res_id = DBNull.Value.Equals(dr["res_id"]) ? 0 : Convert.ToInt32(dr["res_id"]); item.res_numeroNota = DBNull.Value.Equals(dr["res_numeroNota"]) ? 0 : Convert.ToInt32(dr["res_numeroNota"]); item.res_codigoVerificacao = DBNull.Value.Equals(dr["res_codigoVerificacao"]) ? 0 : Convert.ToInt32(dr["res_codigoVerificacao"]); item.res_dataEmissao = dr["res_dataEmissao"].ToString(); item.Cliente = cliente.CarregaClienteCompleto(new GlobaisClienteBE { cli_id = item.cli_id }).FirstOrDefault <GlobaisClienteBE>(); item.Contrato = contrato.SelectId <SCMContratoBE>(new SCMContratoBE { cont_id = item.cont_id }); result.Add(item); } dr.Close(); } dr.Close(); return(result); }