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));
}