private void loadFields_Click(object sender, EventArgs e)
{
try
{
if (!Check())
{
return;
}
if (!Check())
{
return;
}
this.dataGridView1.Rows.Clear();
DataTable dtTableMetaList = SAPFunction.DDIF_FIELDINFO_GET(_systemName, _tableName);
// ReadTableFieldCollection co = dt.Fields;
for (int i = 0; i < dtTableMetaList.Rows.Count; i++)
{
this.dataGridView1.Rows.Add(new object[] { false, dtTableMetaList.Rows[i]["FIELDNAME"], dtTableMetaList.Rows[i]["SCRTEXT_M"] });
}
dataGridView1.AutoResizeColumns();
// saveContext();
}
catch (Exception ee)
{
MessageBox.Show(ee.Message);
}
}
/// <summary>
/// 从SAP系统中加载表或结构的定义。
///
/// </summary>
void loadTableMetaData()
{
String sysName = _systemName.ToUpper().Trim();
DtMetaList = SAPFunction.DDIF_FIELDINFO_GET(sysName, _tableName);
DeleteRows(ref DtMetaList);
DeleteColumn(ref DtMetaList);
if (EventTableReadMeta != null)
{
EventTableReadMeta(this);
}
//MessageBox.Show("加载完成");
}
private void btnLoadFields2_Click(object sender, EventArgs e)
{
if (!Check())
{
return;
}
this.dataGridView2.Rows.Clear();
DataTable dtColumns = SAPFunction.DDIF_FIELDINFO_GET(_systemName, "DFIES");
for (int i = 0; i < dtColumns.Rows.Count; i++)
{
this.dataGridView2.Rows.Add(new object[] { false, dtColumns.Rows[i]["FIELDNAME"], dtColumns.Rows[i]["SCRTEXT_M"] });
}
dataGridView2.AutoResizeColumns();
SetDefaultOptions();
}
/// <summary>
/// 从SAP系统中加载表或结构的定义。
///
/// </summary>
void loadTableMetaData()
{
String sysName = _systemName.ToUpper().Trim();
DtMetaList = SAPFunction.DDIF_FIELDINFO_GET(sysName, _tableName);
DeleteRows(ref DtMetaList);
DeleteColumn(ref DtMetaList);
eventGetTableInfo(this);
////在当前激活的工作表上存放数据
//ws = Globals.Factory.GetVstoObject(Globals.ThisAddIn.Application.ActiveWorkbook.ActiveSheet);
//ListObject ls = null;
//if (!ws.Controls.Contains(_tableName))
//{
// int count = ws.ListObjects.Count;
// for (int i = 1; i < count + 1; i++)
// {
// if (ws.ListObjects[i].Name == _tableName)
// {
// ws.ListObjects[i].Delete();
// // ws.Controls.Remove(_tableName);
// }
// }
// ls = ws.Controls.AddListObject(ws.Range["A4"], _tableName);
//}
//else
//{
// ls = (ListObject)ws.Controls[_tableName];
//}
// ls.SetDataBinding(dtMetaList);
// ws.Rows[1].Clear();
// DataTable dtColumnName = SAPFunction.DDIF_FIELDINFO_GET(sysName, "DFIES");
// int j = 0;
// for (int i = 0; i < dtColumnName.Rows.Count; i++)
// {
// if (TitleList.Count>0)
// {
// if (TitleList.Contains(dtColumnName.Rows[i]["FIELDNAME"].ToString()))
// {
// ws.Cells.set_Item(4, j + 1, dtColumnName.Rows[i]["SCRTEXT_L"].ToString().Trim());
// j += 1;
// }
// }
// else
// {
// ws.Cells.set_Item(4, i + 1, dtColumnName.Rows[i]["SCRTEXT_L"].ToString().Trim());
// }
// }
////清空两行抬头，并重新设置。
//ws.Columns.AutoFit();
//ws.Columns.ShrinkToFit = true;
////saveContext();
//ws = Globals.Factory.GetVstoObject(Globals.ThisAddIn.Application.ActiveWorkbook.ActiveSheet);
//ws.Name = _tableName;
MessageBox.Show("加载完成");
}
