public void load(ReportVo report, int idreportgroup, string filtro) { string strFiltro = ""; strFiltro += (idreportgroup > 0) ? " idReportGroup = " + idreportgroup : " idReportGroup != 0"; strFiltro += (filtro != null) ? " AND " + filtro : filtro; load(report, strFiltro); }
public void load(ReportVo report, string reportName, string filtro) { string strFiltro = ""; strFiltro += (reportName != null) ? " nome = '" + reportName + "'" : ""; strFiltro += (filtro != null) ? " AND " + filtro : filtro; load(report, strFiltro); }
public int update(ReportVo report) { this.QUERY = new StringBuilder(fromDatabase); this.QUERY.AppendLine("UPDATE report"); this.QUERY.AppendLine(" SET idReportGroup = " + report.IDREPORTGROUP); this.QUERY.AppendLine(" , nome = '" + report.NOME + "'"); this.QUERY.AppendLine(" , username = '******'"); this.QUERY.AppendLine(" , filial = '" + report.FILIAL + "'"); this.QUERY.AppendLine(" , empresa = '" + report.EMPRESA + "'"); this.QUERY.AppendLine(" WHERE id = " + report.ID); return(getData().DefaultView.Count); }
public void load(ReportVo report, string filtro) { DataTable table = select(filtro, false); if (table.DefaultView.Count > 0) { report.IDREPORTGROUP = (int)table.DefaultView[0]["idReportGroup"]; report.ID = (int)table.DefaultView[0]["id"]; report.EMPRESA = (string)table.DefaultView[0]["empresa"]; report.NOME = (string)table.DefaultView[0]["nome"]; report.USERNAME = (string)table.DefaultView[0]["username"]; report.FILIAL = (string)table.DefaultView[0]["filial"]; } }
public int insert(ReportVo report) { this.QUERY = new StringBuilder(fromDatabase); this.QUERY.Append("INSERT INTO report"); this.QUERY.AppendLine("(idReportGroup, nome, username, filial, empresa)"); this.QUERY.Append("VALUES("); this.QUERY.Append("" + report.IDREPORTGROUP + ","); this.QUERY.Append("'" + report.NOME + "',"); this.QUERY.Append("'" + report.USERNAME + "',"); this.QUERY.Append("'" + report.FILIAL + "',"); this.QUERY.Append("'" + report.EMPRESA + "'"); this.QUERY.AppendLine(")"); return(getData().DefaultView.Count); }
public int save(ReportVo report) { if (report.ID == 0) { int i = insert(report); this.load(report); report.TABLE.REPORT = report; new Table.TableDao().save(report.TABLE); return(i); } else { return(update(report)); } }
public void load(List <ReportVo> reports, int idreportgroup, string filtro) { DataTable table = select(idreportgroup, filtro, false); for (int i = 0; i < table.DefaultView.Count; i++) { ReportVo report = new ReportVo(); report.IDREPORTGROUP = idreportgroup; report.ID = (int)table.DefaultView[i]["id"]; report.EMPRESA = (string)table.DefaultView[i]["empresa"]; report.NOME = (string)table.DefaultView[i]["nome"]; report.USERNAME = (string)table.DefaultView[i]["username"]; report.FILIAL = (string)table.DefaultView[i]["filial"]; reports.Add(report); } }
public void load(ReportVo report, int idreportgroup) { load(report, idreportgroup, " nome = '" + report.NOME + "'"); }
public void load(ReportVo report) { load(report, report.IDREPORTGROUP); }
public DataTable select(int idreportgroup, ReportVo report) { return(this.select(idreportgroup, " nome = '" + report.NOME + "'")); }
public int delete(ReportVo report) { return(delete(report.IDREPORTGROUP, "id = " + report.ID)); }
private void menu_Click(object objSource, ToolBarItemEventArgs objArgs) { Control inControl = this.Parent; SxMakeRelatory rel; REPORT.ReportVo report; string relname = ""; switch (objArgs.ToolBarButton.Name.ToLower()) { case "tbbadd": #region ADD this.Parent.Controls.Clear(); rel = new SxMakeRelatory(); rel.Dock = DockStyle.Fill; FormatScreen.AddControl(inControl, rel, true, 1, true, false); rel.btnAddNew_Click(null, null); #endregion break; case "tbbver": #region VER if (dgvReports.SelectedRows.Count > 0) { DataRow row = (DataRow)(dgvReports.DataSource as DataView).Table.Rows[dgvReports.SelectedRows[0].Index]; /* * Report cReport = new Report(); * cReport.LOAD((string)row["nome"], false); * * gridWindow grid = new gridWindow(cReport.TABLE.QUERY.ToString(), null); * grid.SetGridHeader(cReport.TABLE.FIELDS.TOGRID); * grid.showWindow(); * //*/ ControlsConfig.formShow(new ViewReport(int.Parse(row["id"].ToString())), this.Form, ControlsConfig.showType.Dialog, null, true); } #endregion break; case "tbbedit": #region EDIT if (dgvReports.SelectedRows.Count > 0) { this.Parent.Controls.Clear(); DataRow row = (DataRow)(dgvReports.DataSource as DataView).Table.Rows[dgvReports.SelectedRows[0].Index]; rel = new SxMakeRelatory(); rel.Dock = DockStyle.Fill; FormatScreen.AddControl(inControl, rel, true, 1, true, false); relname = (string)row["nome"]; rel.btnAbrir_Click(new Label(relname), null); } #endregion break; case "tbbdel": #region DEL if (dgvReports.SelectedRows.Count > 0) { DataRow row = (DataRow)(dgvReports.DataSource as DataView).Table.Rows[dgvReports.SelectedRows[0].Index]; report = new REPORT.ReportVo(); report.ID = int.Parse(row["id"].ToString()); report.IDREPORTGROUP = int.Parse(row["idreportgroup"].ToString()); SigaObjects.Reports.Table.TableVo maintable = new SigaObjects.Reports.Table.TableVo(); new SigaObjects.Reports.Table.TableDao().load(maintable, report.ID, 0); new SigaObjects.Reports.Report.ReportDao().DeleteRecursiveTables(maintable.ID); new SigaObjects.Reports.Report.ReportDao().delete(report); } #endregion break; case "tbbexcel": #region EXCEL FormatScreen.showNotImplemented(); #endregion break; case "tbbpdf": #region PDF FormatScreen.showNotImplemented(); #endregion break; default: break; } }