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