public void load(ReportGroupVo reportgroup, string filtro)
{
DataTable table = select(reportgroup.DESCRICAO, filtro, false);
if (table.DefaultView.Count > 0)
{
reportgroup.ID = (int)table.DefaultView[0]["id"];
reportgroup.DESCRICAO = (string)table.DefaultView[0]["descricao"];
}
}
public int update(ReportGroupVo reportgroup)
{
this.QUERY = new StringBuilder(fromDatabase);
this.QUERY.AppendLine("UPDATE reportgroup");
this.QUERY.AppendLine(" SET");
this.QUERY.AppendLine("descricao = '" + reportgroup.DESCRICAO + "'");
this.QUERY.AppendLine(" WHERE id = " + reportgroup.ID);
return(getData().DefaultView.Count);
}
public int insert(ReportGroupVo reportgroup)
{
this.QUERY = new StringBuilder(fromDatabase);
this.QUERY.Append("INSERT INTO reportgroup");
this.QUERY.AppendLine("(descricao)");
this.QUERY.Append("VALUES(");
this.QUERY.Append("'" + reportgroup.DESCRICAO + "'");
this.QUERY.AppendLine(")");
return(getData().DefaultView.Count);
}
public int save(ReportGroupVo reportgroup)
{
if (reportgroup.ID == 0)
{
int i = insert(reportgroup);
this.load(reportgroup);
return(i);
}
else
{
return(update(reportgroup));
}
}
public int delete(ReportGroupVo reportgroup)
{
return(delete(reportgroup.ID, null));
}
public void load(ReportGroupVo reportgroup)
{
load(reportgroup, null);
}
