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