private void txtFORNECEDOR_TextChanged(object sender, EventArgs e) { DataRowView table = new SigaObjects.SXManager(empresa.CODIGO).getTabela("SA2"); StringBuilder sQuery = new StringBuilder(); if (table != null) { sQuery.AppendLine("SELECT A2_COD, A2_LOJA, A2_NOME"); sQuery.AppendLine(" FROM " + table["X2_ARQUIVO"].ToString()); sQuery.AppendLine(" WHERE A2_COD = '" + txtFORNECEDOR.Text.Trim() + "'"); if (table["X2_MODO"].ToString() == "E") { sQuery.AppendLine(" AND A2_FILIAL = '" + empresa.CODIGO_FILIAL + "'"); } } if (sQuery.Length > 0) { DataTable fornece = new SigaObjects.DataMaster().SelectDataTable(sQuery); if (fornece.DefaultView.Count > 0) { txtNOMEFORNECEDOR.Text = fornece.DefaultView[0]["A2_NOME"].ToString().Trim(); txtLOJA.Text = fornece.DefaultView[0]["A2_LOJA"].ToString().Trim(); } else { MessageBox.Show("Fornecedor inexistente. cod:" + txtFORNECEDOR.Text.Trim()); } } }
private void btnBuscaNatureza_Click(object sender, EventArgs e) { DataRowView table = new SigaObjects.SXManager(empresa.CODIGO).getTabela("SED"); StringBuilder sQuery = new StringBuilder(); if (table != null) { sQuery.AppendLine("SELECT ED_CODIGO , ED_DESCRIC, ED_CALCIRF, ED_CALCISS"); sQuery.AppendLine(" , ED_CALCINS, ED_CALCCSL, ED_CALCCOF, ED_CALCPIS"); sQuery.AppendLine(" FROM " + table["X2_ARQUIVO"].ToString()); if (table["X2_MODO"].ToString() == "E") { sQuery.AppendLine(" WHERE ED_FILIAL = '" + empresa.CODIGO_FILIAL + "'"); } sQuery.AppendLine(" ORDER BY ED_DESCRIC"); } if (sQuery.Length > 0) { DataTable fornece = new SigaObjects.DataMaster().SelectDataTable(sQuery); new gridWindow(fornece, txtNATUREZA, "ED_CODIGO").showWindow(this.Form, true, 50); } }
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 btnExec_Click(object sender, EventArgs e) { try { SigaObjects.SXManager sxm = new SigaObjects.SXManager(sigaSession.EMPRESAS[0].CODIGO); sxm.ToDatabase = txtToDatabase.Text.Trim(); sxm.ToFields = txtToFields.Text.Trim(); sxm.ToTable = txtToTable.Text.Trim(); sxm.UseProvider = txtProvider.Text.Trim(); sxm.UseDriver = txtDriver.Text.Trim(); sxm.InDirectory = txtDirectory.Text.Trim(); sxm.SourceType = txtSourceType.Text.Trim(); sxm.FromFields = txtFromFields.Text.Trim(); sxm.FromFile = txtFromFile.Text.Trim(); DataTable dtSxm = (DataTable)sxm.Import(); string strError = ""; for (int i = 0; i < dtSxm.GetErrors().Length; i++) { strError += dtSxm.GetErrors().GetValue(i).ToString(); } if (strError.Length > 0) { MessageBox.Show(strError); } else { MessageBox.Show(sxm.ToTable + " add com sucesso!"); } } catch (Exception err) { StringBuilder sError = new StringBuilder(); sError.AppendLine("< ERRO >"); sError.AppendLine("Message: " + err.Message); sError.AppendLine("Source : " + err.Source); sError.AppendLine("Target : " + err.TargetSite); sError.AppendLine("StackTrace:\n" + err.StackTrace); //MessageBox.Show(sError.ToString(), "ERRO"); MessageBox.Show(Carralero.ExceptionControler.getStrException(err), "ERROR"); } }
private void btnBuscaFornece_Click(object sender, EventArgs e) { DataRowView table = new SigaObjects.SXManager(empresa.CODIGO).getTabela("SA2"); StringBuilder sQuery = new StringBuilder(); if (table != null) { sQuery.AppendLine("SELECT A2_COD, A2_LOJA, A2_NOME"); sQuery.AppendLine(" FROM " + table["X2_ARQUIVO"].ToString()); if (table["X2_MODO"].ToString() == "E") { sQuery.AppendLine(" WHERE A2_FILIAL = '" + empresa.CODIGO_FILIAL + "'"); } sQuery.AppendLine(" ORDER BY A2_NOME"); } if (sQuery.Length > 0) { DataTable fornece = new SigaObjects.DataMaster().SelectDataTable(sQuery); new gridWindow(fornece, txtFORNECEDOR, "A2_COD").showWindow(this.Form, true, 50); } }