private void populaConta(ContasAPagarVO conta, DataTable table, int i) { conta.ID = (int)table.DefaultView[i]["id"]; conta.EMPRESA = (string)table.DefaultView[i]["EMPRESA"]; conta.FILIAL = (string)table.DefaultView[i]["FILIAL"]; conta.PREFIXO = (string)table.DefaultView[i]["PREFIXO"]; conta.NUMTITULO = (string)table.DefaultView[i]["NUMTITULO"]; conta.PARCELA = (string)table.DefaultView[i]["PARCELA"]; conta.NATUREZA = (string)table.DefaultView[i]["NATUREZA"]; conta.FORNECEDOR = (string)table.DefaultView[i]["FORNECEDOR"]; conta.LOJA = (string)table.DefaultView[i]["LOJA"]; conta.EMISSAOstr = (string)table.DefaultView[i]["EMISSAO"]; conta.VENCIMENTOstr = (string)table.DefaultView[i]["VENCIMENTO"]; conta.VALOR = (decimal)table.DefaultView[i]["VALOR"]; conta.ISS = (decimal)table.DefaultView[i]["ISS"]; conta.IRRF = (decimal)table.DefaultView[i]["IRRF"]; conta.HISTORICO = (string)table.DefaultView[i]["HISTORICO"]; conta.INSS = (decimal)table.DefaultView[i]["INSS"]; conta.COFINS = (decimal)table.DefaultView[i]["COFINS"]; conta.PISPASEP = (decimal)table.DefaultView[i]["PISPASEP"]; conta.CSLL = (decimal)table.DefaultView[i]["CSLL"]; conta.ObsSolicitante = (string)table.DefaultView[i]["OBS_SOL"]; conta.ObsAprovador = (string)table.DefaultView[i]["OBS_APR"]; conta.STATUS = (int)table.DefaultView[i]["STATUS"]; conta.USERID = (int)table.DefaultView[i]["USERID"]; }
private int update(ContasAPagarVO conta) { this.QUERY = new StringBuilder(); this.QUERY.AppendLine("UPDATE CONTASPG "); this.QUERY.AppendLine(" SET EMPRESA = '" + conta.EMPRESA + "'"); this.QUERY.AppendLine(" , FILIAL = '" + conta.FILIAL + "'"); this.QUERY.AppendLine(" , PREFIXO = '" + conta.PREFIXO + "'"); this.QUERY.AppendLine(" , NUMTITULO = '" + conta.NUMTITULO + "'"); this.QUERY.AppendLine(" , PARCELA = '" + conta.PARCELA + "'"); this.QUERY.AppendLine(" , NATUREZA = '" + conta.NATUREZA + "'"); this.QUERY.AppendLine(" , FORNECEDOR = '" + conta.FORNECEDOR + "'"); this.QUERY.AppendLine(" , LOJA = '" + conta.LOJA + "'"); this.QUERY.AppendLine(" , EMISSAO = '" + conta.EMISSAOstr + "'"); this.QUERY.AppendLine(" , VENCIMENTO = '" + conta.VENCIMENTOstr + "'"); this.QUERY.AppendLine(" , VALOR = '" + conta.VALOR.ToString("0.00", CultureInfo.InvariantCulture) + "'"); this.QUERY.AppendLine(" , ISS = '" + conta.ISS.ToString("0.00", CultureInfo.InvariantCulture) + "'"); this.QUERY.AppendLine(" , IRRF = '" + conta.IRRF.ToString("0.00", CultureInfo.InvariantCulture) + "'"); this.QUERY.AppendLine(" , HISTORICO = '" + conta.HISTORICO + "'"); this.QUERY.AppendLine(" , INSS = '" + conta.INSS.ToString("0.00", CultureInfo.InvariantCulture) + "'"); this.QUERY.AppendLine(" , COFINS = '" + conta.COFINS.ToString("0.00", CultureInfo.InvariantCulture) + "'"); this.QUERY.AppendLine(" , PISPASEP = '" + conta.PISPASEP.ToString("0.00", CultureInfo.InvariantCulture) + "'"); this.QUERY.AppendLine(" , CSLL = '" + conta.CSLL.ToString("0.00", CultureInfo.InvariantCulture) + "'"); this.QUERY.AppendLine(" , OBS_SOL = '" + conta.ObsSolicitante + "'"); this.QUERY.AppendLine(" , OBS_APR = '" + conta.ObsAprovador + "'"); this.QUERY.AppendLine(" , STATUS = " + conta.STATUS + " "); this.QUERY.AppendLine(" WHERE id = " + conta.ID); return(getData().DefaultView.Count); }
public void load(ContasAPagarVO conta, string filtro) { DataTable table = select(filtro, null, true); if (table.DefaultView.Count > 0) { populaConta(conta, table, 0); } }
public void load(ContasAPagarVO conta, string empresa, string filial, string numtitulo) { StringBuilder filtro = new StringBuilder(); filtro.AppendLine(" EMPRESA = '" + empresa + "'"); filtro.AppendLine(" AND FILIAL = '" + filial + "'"); filtro.AppendLine(" AND NUMTITULO = '" + numtitulo + "'"); load(conta, filtro.ToString()); }
public int save(ContasAPagarVO conta) { if (conta.ID == 0) { return(insert(conta)); } else { return(update(conta)); } }
public void load(List <ContasAPagarVO> contas, string filtro, string orderby, bool firstOnly) { contas = new List <ContasAPagarVO>(); DataTable table = select(filtro, orderby, firstOnly); for (int i = 0; i < table.DefaultView.Count; i++) { ContasAPagarVO conta = new ContasAPagarVO(); populaConta(conta, table, i); contas.Add(conta); } }
private int insert(ContasAPagarVO conta) { this.QUERY = new StringBuilder(); this.QUERY.AppendLine("INSERT INTO CONTASPG"); this.QUERY.AppendLine("( EMPRESA, FILIAL , PREFIXO , NUMTITULO, PARCELA, NATUREZA, FORNECEDOR "); this.QUERY.AppendLine(", LOJA , EMISSAO, VENCIMENTO, VALOR , ISS , IRRF , HISTORICO "); this.QUERY.AppendLine(", INSS , COFINS , PISPASEP , CSLL , OBS_SOL, OBS_APR , STATUS , USERID)"); this.QUERY.AppendLine("VALUES("); this.QUERY.Append("'" + conta.EMPRESA + "', "); this.QUERY.Append("'" + conta.FILIAL + "', "); this.QUERY.Append("'" + conta.PREFIXO + "', "); this.QUERY.Append("'" + conta.NUMTITULO + "', "); this.QUERY.Append("'" + conta.PARCELA + "', "); this.QUERY.Append("'" + conta.NATUREZA + "', "); this.QUERY.Append("'" + conta.FORNECEDOR + "', "); this.QUERY.AppendLine("'" + conta.LOJA + "', "); this.QUERY.Append("'" + conta.EMISSAOstr + "', "); this.QUERY.Append("'" + conta.VENCIMENTOstr + "', "); this.QUERY.Append("'" + conta.VALOR.ToString("0.00", CultureInfo.InvariantCulture) + "', "); this.QUERY.Append("'" + conta.ISS.ToString("0.00", CultureInfo.InvariantCulture) + "', "); this.QUERY.Append("'" + conta.IRRF.ToString("0.00", CultureInfo.InvariantCulture) + "', "); this.QUERY.Append("'" + conta.HISTORICO + "', "); this.QUERY.AppendLine("'" + conta.INSS.ToString("0.00", CultureInfo.InvariantCulture) + "', "); this.QUERY.Append("'" + conta.COFINS.ToString("0.00", CultureInfo.InvariantCulture) + "', "); this.QUERY.Append("'" + conta.PISPASEP.ToString("0.00", CultureInfo.InvariantCulture) + "', "); this.QUERY.Append("'" + conta.CSLL.ToString("0.00", CultureInfo.InvariantCulture) + "', "); this.QUERY.Append("'" + conta.ObsSolicitante + "', "); this.QUERY.Append("'" + conta.ObsAprovador + "', "); this.QUERY.Append("'" + conta.STATUS + "', "); this.QUERY.Append("'" + conta.USERID + "' "); this.QUERY.Append(")"); return(getData().DefaultView.Count); }
public ContasAPagarDAO(ContasAPagarVO conta) { throw new Exception("método não implementado."); }
public int delete(ContasAPagarVO conta) { return(delete(conta.EMPRESA, null, "id = " + conta.ID)); }