public void LOAD(List <REPORT.Fields.FieldsVo> checkFields) { this.MAIN.THISTABLE.FIELDS = checkFields; try { if (this.MAIN.TABLE != null) { // POPULA CAMPOS DA TABELA SELECIONADA DataTable dtFields = new SXManager(sigaSession.EMPRESAS[0].CODIGO).getFields(this.MAIN.TABLE); foreach (DataRow drv in dtFields.Rows) { dgvFields.Rows.Add(); REPORT.Fields.FieldsVo field = this.existInFields(checkFields, drv[SXManager.FieldValueMember].ToString()); int indice = dgvFields.Rows.Count - 1; bool isMark = field != null; dgvFields.Rows[indice].Cells[0].Value = isMark; dgvFields.Rows[indice].Cells[1].Value = (string)drv[SXManager.FieldValueMember]; dgvFields.Rows[indice].Cells[2].Value = (string)drv[SXManager.FieldDisplayMember]; dgvFields.Rows[indice].Cells[3].Value = (isMark) ? field.GROUPING : ""; dgvFields.Rows[indice].Cells[4].Value = (isMark) ? getDisplayCombo(field.GROUPING) : ""; } } } catch (Exception e) { new ERROR(Carralero.ExceptionControler.getFullException(e)).SHOW(); } }
private void marcarCampo(int row, int col) { if (dgvFields.Rows[row].Cells[0].Value.ToString() != "True") { DataGridViewRow dgvRow = dgvFields.Rows[row]; REPORT.Fields.FieldsVo field = new REPORT.Fields.FieldsVo(); field.CODIGO = (string)dgvRow.Cells[1].Value; field.GROUPING = (string)dgvRow.Cells[3].Value; field.MAINID = this.MAIN.ID; this.MAIN.THISTABLE.AddField(field); /// Verifica se existe grupo /// se existir verifica o select do campo. string query = this.main.QUERY.ToString(); int haveOrder = query.IndexOf("ORDER BY"); string tab_camp = new SXManager(sigaSession.EMPRESAS[0].CODIGO).getTabela(this.main.TABLE)["X2_ARQUIVO"].ToString() + "." + dgvRow.Cells[1].Value.ToString(); if (haveOrder > 0) { int haveField = query.IndexOf(tab_camp, haveOrder); if (haveField > 0) { this.main.SAVE(); REPORT.OrderBy.OrderByDao orders = new SigaObjects.Reports.OrderBy.OrderByDao(); tab_camp = " valuemember = '" + tab_camp + "'"; orders.delete(this.main.ID, tab_camp); this.main.LOAD(this.main.THISTABLE); MessageBox.Show("A Ordenação com este campo foi excluída."); } } } else { //this.MAIN.THISTABLE.RemoveField( int idx = this.MAIN.THISTABLE.FindField((string)dgvFields.Rows[row].Cells[1].Value); if (idx >= 0) { this.MAIN.THISTABLE.FIELDS.RemoveAt(idx); } } }
public void SAVE( ) { //this.DELETE(); //* List <REPORT.Fields.FieldsVo> fields = new List <REPORT.Fields.FieldsVo>(); foreach (DataGridViewRow drv in dgvFields.Rows) { if (drv.Cells[0].Value.ToString() == true.ToString()) { REPORT.Fields.FieldsVo field = new REPORT.Fields.FieldsVo(); field.MAINID = this.MAIN.ID; field.CODIGO = (string)drv.Cells[1].Value; field.GROUPING = (string)drv.Cells[3].Value; fields.Add(field); } } //*/ new REPORT.Fields.FieldsDao().save(fields);//this.MAIN.THISTABLE.FIELDS); }