public void Load(FiltersVo filter, int mainId) { List <FiltersVo> filters = new List <FiltersVo>(); filters.Add(filter); Load(filters, mainId, "id = " + filter.ID); }
public int update(FiltersVo filter) { this.QUERY = new StringBuilder(); this.addInQuery(fromDatabase); this.addInQuery("UPDATE filters"); this.addInQuery(" SET tabela = '" + filter.TABELA + "'"); this.addInQuery(" ,campo = '" + filter.CAMPO + "'"); this.addInQuery(" ,filtro = '" + filter.FILTRO + "'"); this.addInQuery(" ,tipofiltro = '" + filter.TIPOFILTRO + "'"); this.addInQuery(" WHERE id = " + filter.ID); return(getData().DefaultView.Count); }
public int save(FiltersVo filter) { int iRet = 0; if (filter.ID == 0) { iRet = insert(filter); } else { iRet = update(filter); } return(iRet); }
public int insert(FiltersVo filter) { this.QUERY = new StringBuilder(); this.addInQuery(fromDatabase); this.addInQuery("INSERT INTO filters (mainId, tabela, campo, filtro, tipofiltro)"); this.QUERY.Append("VALUES ("); this.QUERY.Append("" + filter.MAINID + ","); this.QUERY.Append("'" + filter.TABELA + "',"); this.QUERY.Append("'" + filter.CAMPO + "',"); this.QUERY.Append("'" + filter.FILTRO + "',"); this.QUERY.Append("'" + filter.TIPOFILTRO + "'"); this.addInQuery(")"); return(getData().DefaultView.Count); }
public void Load(List <FiltersVo> filters, int mainId, string filtro) { DataTable table = select(mainId, filtro, false); for (int i = 0; i < table.DefaultView.Count; i++) { FiltersVo filter = new FiltersVo(); filter.MAINID = mainId; filter.ID = (int)table.DefaultView[i]["id"]; filter.TABELA = (string)table.DefaultView[i]["tabela"]; filter.TIPOFILTRO = (string)table.DefaultView[i]["tipofiltro"]; filter.FILTRO = (string)table.DefaultView[i]["filtro"]; filter.CAMPO = (string)table.DefaultView[i]["campo"]; filters.Add(filter); } }
public int delete(FiltersVo filter) { return(delete(filter.MAINID, "id = " + filter.ID)); }