public void PegaDadosRamo(String pApelido, String pXml) { // Conexao Conn = new Conexao(pXml); String Qry = "EXEC crtotramo " + Srelib.QStr(pApelido); DS = new DataSet(); SqlCommand Command = new SqlCommand(Qry, DM.ConexaoSessao); Command.CommandTimeout = 99999; SqlDataAdapter DA = new SqlDataAdapter(); DA.TableMappings.Add("Table", "CRTOTCED1"); DA.SelectCommand = Command; DA.Fill(DS); DataTable DT; DT = DS.Tables["CRTOTCED1"]; DataRow DR = DT.Rows[0]; op1 = Srelib.PadData(Convert.ToString(DR["op1"])); op2 = Srelib.PadData(Convert.ToString(DR["op2"])); op3 = Convert.ToString(DR["op3"]); op4 = Srelib.PadDouble(Convert.ToString(DR["op4"])); r1 = Srelib.PadDouble(Convert.ToString(DR["r1"])); r2 = Srelib.PadDouble(Convert.ToString(DR["r2"])); r3 = Srelib.PadDouble(Convert.ToString(DR["r3"])); s4 = Srelib.PadDouble(Convert.ToString(DR["s4"])); // Conn.SqlConn.Close(); DS.Dispose(); }
public void PegaDadosDoCedente(String wcedente) { String sql = @"Select cnpj, apelido, nome, endereco, bairro, cidade, uf, cep, fone, contato, gerente, ramo, grupo, isnull(l_acum,0.00) l_acum, isnull(l_acumch,0.00) l_acumch, isnull(l_acumdp,0.00) l_acumdp, isnull(l_sac,0.00) l_sac, isnull(l_sacch,0.00) l_sacch, isnull(l_sacdp,0.00) l_sacdp, dlimite, isnull(l_valor,0.00) l_valor, isnull(l_titulos,0.00) l_titulos, vencimento, isnull(l_nconf,0.00) l_nconf, isnull(limitech,0.00) limitech, isnull(pconfir,0.00) pconfir, isnull(cnpjmin,0.00) cnpjmin, isnull(prazomin,0) prazomin, isnull(prazomax,0) prazomax, isnull(tdesc,0.00) tdesc, isnull(txserv,0.00) txserv from cedente where apelido=@cedente"; SqlParameter[] parametros = { new SqlParameter("@cedente", wcedente) }; DataSet Ds = SreDblib.GetDsCp(sql, parametros); // dados apelido = ""; cnpjformatado = ""; cnpj = ""; raiz_cnpj = ""; grupo = ""; gerente = ""; ramo = ""; razaosocial = ""; endereco = ""; bairro = ""; cidade = ""; uf = ""; cep = ""; fones = ""; contatos = ""; l_acum = "0.00"; l_acumch = "0.00"; l_acumdp = "0.00"; l_sac = "0.00"; l_sacch = "0.00"; l_sacdp = "0.00"; fixacao = ""; l_valor = "0.00"; l_titulos = "0"; vencimento = ""; l_nconf = "0.00"; limitech = "0.00"; pconfir = "0.00"; cnpjmin = "0.00"; prazomin = "0"; prazomax = "0"; tdesc = "0.00"; txserv = "0.00"; if (Ds.Tables.Count > 0) { apelido = Ds.Tables[0].Rows[0]["apelido"].ToString(); cnpj = Ds.Tables[0].Rows[0]["cnpj"].ToString(); raiz_cnpj = cnpj; if (cnpj.Trim().Length == 14) { raiz_cnpj = raiz_cnpj.Substring(0, 8); } cnpjformatado = Srelib.FormataCPFCNPJ(cnpj); razaosocial = Ds.Tables[0].Rows[0]["nome"].ToString(); endereco = Ds.Tables[0].Rows[0]["endereco"].ToString(); bairro = Ds.Tables[0].Rows[0]["bairro"].ToString(); cidade = Ds.Tables[0].Rows[0]["cidade"].ToString(); uf = Ds.Tables[0].Rows[0]["uf"].ToString(); cep = Ds.Tables[0].Rows[0]["cep"].ToString(); fones = Ds.Tables[0].Rows[0]["fone"].ToString(); contatos = Ds.Tables[0].Rows[0]["contato"].ToString(); gerente = Ds.Tables[0].Rows[0]["gerente"].ToString(); ramo = Ds.Tables[0].Rows[0]["ramo"].ToString(); grupo = Ds.Tables[0].Rows[0]["grupo"].ToString(); l_titulos = Ds.Tables[0].Rows[0]["l_titulos"].ToString(); l_valor = Srelib.PadDouble(Ds.Tables[0].Rows[0]["l_valor"].ToString()); l_acum = Srelib.PadDouble(Ds.Tables[0].Rows[0]["l_acum"].ToString()); l_acumdp = Srelib.PadDouble(Ds.Tables[0].Rows[0]["l_acumdp"].ToString()); l_acumch = Srelib.PadDouble(Ds.Tables[0].Rows[0]["l_acumch"].ToString()); l_sac = Srelib.PadDouble(Ds.Tables[0].Rows[0]["l_sac"].ToString()); l_sacdp = Srelib.PadDouble(Ds.Tables[0].Rows[0]["l_sacdp"].ToString()); l_sacch = Srelib.PadDouble(Ds.Tables[0].Rows[0]["l_sacch"].ToString()); vencimento = Srelib.PadData(Ds.Tables[0].Rows[0]["vencimento"].ToString()); l_nconf = Srelib.PadDouble(Ds.Tables[0].Rows[0]["l_nconf"].ToString()); limitech = Srelib.PadDouble(Ds.Tables[0].Rows[0]["limitech"].ToString()); pconfir = Srelib.PadDouble(Ds.Tables[0].Rows[0]["pconfir"].ToString()); cnpjmin = Srelib.PadDouble(Ds.Tables[0].Rows[0]["cnpjmin"].ToString()); prazomin = Ds.Tables[0].Rows[0]["prazomin"].ToString(); prazomax = Ds.Tables[0].Rows[0]["prazomax"].ToString(); fixacao = Srelib.PadData(Ds.Tables[0].Rows[0]["dlimite"].ToString()); tdesc = Srelib.PadDouble(Ds.Tables[0].Rows[0]["tdesc"].ToString()); txserv = Srelib.PadDouble(Ds.Tables[0].Rows[0]["txserv"].ToString()); } }