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