private void btnAdd_Click(object sender, EventArgs e) { if (cmbCampos.SelectedIndex >= 0) { DataRowView row = (DataRowView)cmbCampos.SelectedItem; string tipo = row["X3_TIPO"].ToString().ToUpper(); string len = row["X3_TAMANHO"].ToString(); string obj = FormatScreen.getObjectFromSigaType(tipo).GetType().ToString(); REPORT.Params.ParamsVo parm = new REPORT.Params.ParamsVo(); parm.MAINID = this.MAIN.ID; parm.TAMANHO = int.Parse(len); parm.TABELA = this.MAIN.TABLE; parm.CAMPO = this.cmbCampos.SelectedValue.ToString(); parm.FORMATO = tipo; parm.OBJETO = obj; this.MAIN.THISTABLE.PARAMS.Add(parm); dados.Rows.Add(0 //id , this.MAIN.ID //id da ligação , len //tamanho de digitação , this.MAIN.TABLE //nome da tabela , this.cmbCampos.SelectedValue.ToString() //campo , tipo //formato , obj //objeto ); } }
private void initializer(REPORT.Report.ReportVo report, Table main, string table) { InitializeComponent(); this.MAINREPORT = report; //if(this.MAINREPORT!=null) // this.REPORTID = this.MAINREPORT.ID; this.main = main; this.TABLE = table; /// LIMPANDO AS ABAS this.tpFieldsReturn.Controls.Clear(); this.linksPainel.Controls.Clear(); this.tpGourp.Controls.Clear(); this.tpFilter.Controls.Clear(); this.tpOrder.Controls.Clear(); this.tpParms.Controls.Clear(); /// INICIALIZANDO OBJETOS //this.CHILDREN = new List<Table>(); this.FIELDS = new Fields(this); this.FILTERS = new Filters(this); this.ORDERBY = new OrderBy(this); this.PARAMS = new Params(this); /// ADCIONANDO OBJETOS NAS ABAS FormatScreen.AddControl(tpFieldsReturn, this.FIELDS); //FormatScreen.AddControl(tpGourp , this.GROUPBY); FormatScreen.AddControl(tpFilter, this.FILTERS); FormatScreen.AddControl(tpOrder, this.ORDERBY); FormatScreen.AddControl(tpParms, this.PARAMS); DataTable dtRelType = new DataTable(); string typeDisplay = "display"; string typeValue = "value"; cbRelatedType.DisplayMember = typeDisplay; cbRelatedType.ValueMember = typeValue; dtRelType.Columns.Add(typeDisplay); dtRelType.Columns.Add(typeValue); dtRelType.Rows.Add("AMBAS AS TABELAS ", " INNER JOIN "); dtRelType.Rows.Add("SOMENTE NA RELACIONADA", " LEFT JOIN "); dtRelType.Rows.Add("SOMENTE NESTA ", " RIGHT JOIN "); cbRelatedType.DataSource = dtRelType.DefaultView; /* * cbRelatedTable.DisplayMember = SXManager.TableDisplayMember; * cbRelatedTable.ValueMember = SXManager.TableValueMember; * //*/ // ------------------------------- dataRelatedTable = new DataTable(); dataRelatedTable.Columns.Add("display"); dataRelatedTable.Columns.Add("value"); cbRelatedTable.DisplayMember = "display"; cbRelatedTable.ValueMember = "value"; cbRelatedTable.DataSource = dataRelatedTable.DefaultView; }
public void AddChildTable(Table child) { this.CHILDREN.Add(child); //this.RELATEDTABLES.Add(child.TABLE); FormatScreen.AddControl(linksPainel, child, true, 3, false, false); //foreach(Table tab in this.CHILDREN) // tab.popRelatedtables(dataRelatedChild); }
private void linksPainel_AjustControls() { List <Control> controls = new List <Control>(); foreach (Control c in linksPainel.Controls) { controls.Add(c); //(c as Table).THISTABLE.INDEX = linksPainel.Controls.IndexOf(c); } FormatScreen.Ajust2EqualsWidthControls(controls.ToArray(), linksPainel.Width, false); }
private void popScreenFromRecursiveTables() { panelParams.Controls.Clear(); REPORT.Table.TableVo tabela = new REPORT.Table.TableVo(); new REPORT.Table.TableDao().load(tabela, this.RELATORIO.ID, 0); DataTable tabelas = new REPORT.Params.ParamsDao().getRecursiveTables(tabela, "userParms_" + sigaSession.LoggedUser.ID, tabela.ID); if (tabelas.DefaultView.Count == 0) { btnExec_Click(null, null); destroy = true; } foreach (DataRow row in tabelas.Rows) { string tagFormat = "@$TAB$@.$CAMPO$ ?? '@?@'"; string controle = (string)row["formato"]; string strNomeCampo = new SigaObjects .SXManager(sigaSession.EMPRESAS[0].CODIGO) .getFields((string)row["tabela"], SigaObjects.SXManager.FieldValueMember + " = '" + (string)row["campo"] + "'" , null) .Rows[0][SigaObjects.SXManager.FieldDisplayMember].ToString(); // // CONTROLE DE Control cDE = FormatScreen.getObjectFromSigaType(controle); string lblDE = strNomeCampo + "\t\t Entre \t\t"; cDE.Tag = tagFormat .Replace("$TAB$", (string)row["tabela"]) .Replace("$CAMPO$", (string)row["campo"]) .Replace("??", ">="); FormatScreen.AddControl(panelParams, new Label(lblDE), true, 3, false, false); FormatScreen.AddControl(panelParams, cDE, true, 3, false, false); // // CONTROLE ATE Control cATE = FormatScreen.getObjectFromSigaType(controle); string lblATE = string.Format("{0,50}", "e"); cATE.Tag = tagFormat .Replace("$TAB$", (string)row["tabela"]) .Replace("$CAMPO$", (string)row["campo"]) .Replace("??", "<="); //FormatScreen.AddControl(panelParams, new Label(lblATE),true, 4, false, false); FormatScreen.AddControl(panelParams, cATE, true, 3, false, false); } }
private void CadContasAPagar_VisibleChanged(object sender, EventArgs e) { FormatScreen.setIcon(this); popScreen(); if (this.readOnly || conta.STATUS == 1 || conta.STATUS == 4) { FormatScreen.lockControls(this, typeof(TextBox), typeof(Button), typeof(DateTimePicker), typeof(NumericUpDown)); } FormatScreen.addEventTag(this, "*"); FormatScreen.addEventTag(this, FormatScreen.TIPOS.MOEDA, "$"); }
private void cbFields_SelectedIndexChanged(object sender, EventArgs e) { if (cbFields.SelectedIndex >= 0) { DataRow row = (cbFields.DataSource as DataView).Table.Rows[cbFields.SelectedIndex]; int left = txtFilter.Left; int top = txtFilter.Top; panel1.Controls.Remove(txtFilter); txtFilter = FormatScreen.getObjectFromSigaType((string)row["X3_TIPO"]); txtFilter.Update(); txtFilter.Left = left; txtFilter.Top = top; panel1.Controls.Add(txtFilter); } }
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; } }
private void btnOk_Click(object sender, EventArgs e) { string erro = FormatScreen.ValidateTextControls(this, typeof(TextBox)); if (erro.Length > 0) { MessageBox.Show(erro, "ERRO DE PREENCHIMENTO"); } else { conta.EMPRESA = empresa.CODIGO; conta.FILIAL = empresa.CODIGO_FILIAL; conta.PREFIXO = txtPREFIXO.Text; conta.NUMTITULO = txtNUMTITULO.Text; conta.PARCELA = txtPARCELA.Text; conta.NATUREZA = txtNATUREZA.Text; conta.FORNECEDOR = txtFORNECEDOR.Text; conta.LOJA = txtLOJA.Text; conta.EMISSAO = dtpEMISSAO.Value; conta.VENCIMENTO = dtpVENCIMENTO.Value; conta.VALOR = decimal.Parse(txtVALOR.Text, CultureInfo.InvariantCulture); conta.ISS = decimal.Parse(txtISS.Text, CultureInfo.InvariantCulture); conta.IRRF = decimal.Parse(txtIRRF.Text, CultureInfo.InvariantCulture); conta.HISTORICO = txtHISTORICO.Text.Trim(); conta.INSS = decimal.Parse(txtINSS.Text, CultureInfo.InvariantCulture); conta.COFINS = decimal.Parse(txtCOFINS.Text, CultureInfo.InvariantCulture); conta.PISPASEP = decimal.Parse(txtPISPASEP.Text, CultureInfo.InvariantCulture); conta.CSLL = decimal.Parse(txtCSLL.Text, CultureInfo.InvariantCulture); conta.STATUS = 2; conta.ObsSolicitante = txtOBS_SOL.Text.Trim(); conta.USERID = sigaSession.LoggedUser.ID; try { new ContasAPagarDAO().save(conta); MessageBox.Show("Cadastro feito com sucesso."); } catch (Exception EX) { MessageBox.Show(EX.Message); return; } string subject = "CONTAS A PAGAR / " + lblEmpresaFilial.Text + " / " + DateTime.Now.ToString("dddd dd/MM/yyyy hh:mm:ss"); StringBuilder bodyMail = new StringBuilder(subject); bodyMail.AppendLine(); bodyMail.AppendLine("EMPRESA / FILIAL\t\t: " + lblEmpresaFilial.Text); bodyMail.AppendLine("Prefixo - Numero do Titulo\t\t: " + conta.PREFIXO + " - " + conta.NUMTITULO); bodyMail.AppendLine("Parcela / Natureza\t\t: " + conta.PARCELA + " - " + conta.NATUREZA); bodyMail.AppendLine("Fornecedor / Loja : " + conta.FORNECEDOR + " - " + txtNOMEFORNECEDOR.Text + " / " + conta.LOJA); bodyMail.AppendLine(String.Format("{0,-11} : {1,-10}", "Emissao", conta.EMISSAO.ToString("dd/MM/yyyy"))); bodyMail.AppendLine(String.Format("{0,-11} : {1,-10}", "Vencimento", conta.VENCIMENTO.ToString("dd/MM/yyyy"))); bodyMail.AppendLine(String.Format("{0,-11} : {1, 10}", "Valor", conta.VALOR.ToString("C", new CultureInfo("pt-BR")))); bodyMail.AppendLine(String.Format("{0,-11} : {1,-10}", "Historico", conta.HISTORICO)); bodyMail.AppendLine(String.Format("{0,-11} : {1, 10}", "ISS", conta.ISS.ToString("C", new CultureInfo("pt-BR")))); bodyMail.AppendLine(String.Format("{0,-11} : {1, 10}", "IRFF", conta.IRRF.ToString("C", new CultureInfo("pt-BR")))); bodyMail.AppendLine(String.Format("{0,-11} : {1, 10}", "INSS", conta.INSS.ToString("C", new CultureInfo("pt-BR")))); bodyMail.AppendLine(String.Format("{0,-11} : {1, 10}", "COFINS", conta.COFINS.ToString("C", new CultureInfo("pt-BR")))); bodyMail.AppendLine(String.Format("{0,-11} : {1, 10}", "PIS/PASEP", conta.PISPASEP.ToString("C", new CultureInfo("pt-BR")))); bodyMail.AppendLine(String.Format("{0,-11} : {1, 10}", "CSLL", conta.CSLL.ToString("C", new CultureInfo("pt-BR")))); bodyMail.AppendLine(); bodyMail.AppendLine("------------------------------"); bodyMail.AppendLine("Obs Solicitante : " + sigaSession.LoggedUser.NAME); bodyMail.AppendLine(conta.ObsSolicitante); bodyMail.AppendLine("------------------------------"); bodyMail.AppendLine(); bodyMail.AppendLine("Obs Aprovador:"); bodyMail.AppendLine(conta.ObsAprovador); SigaObjects.Session.SysUsers.SysUserVo mailSender = new SigaObjects.Session.SysUsers.SysUserVo(); new SigaObjects.Session.SysUsers.SysUserDao().load(mailSender, "admin"); try { new Carralero.Net.Email(mailSender.MAILADDRESS , subject , bodyMail , mailSender.MAILADDRESS , mailSender.MAILUSER , mailSender.MAILPASSWD , mailSender.MAILSERVER , mailSender.MAILDOOR).Enviar(); MessageBox.Show("Email Enviado com sucesso!"); this.Form.Close(); } catch (Exception EX) { MessageBox.Show(Carralero.ExceptionControler.getStrException(EX)); } //this.Form.Close(); } }