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("加载完成"); }