private void btnConnect_Click(object sender, RoutedEventArgs e)
{
if (System.IO.Directory.Exists(cmbDBPath.Text))
{
if (!cmbDBPath.Items.Contains(cmbDBPath.Text))
{
cmbDBPath.Items.Add(cmbDBPath.Text);
SiaqodbConfigurator.EncryptedDatabase = false;
Sqo.Siaqodb siaqodbConfig = new Sqo.Siaqodb(AppDomain.CurrentDomain.BaseDirectory);
siaqodbConfig.StoreObject(new ConnectionItem(cmbDBPath.Text));
siaqodbConfig.Close();
EncryptionSettings.SetEncryptionSettings();//set back settings
}
siaqodb = Sqo.Internal._bs._b(cmbDBPath.Text);
siaqodbList = siaqodb.GetAllTypes();
treeView1.Items.Clear();
ContextMenu cm = new ContextMenu();
MenuItem mitem = new MenuItem();
mitem.Header = "Load objects";
cm.Items.Add(mitem);
mitem.Click += new RoutedEventHandler(mitem_Click);
foreach (Sqo.MetaType mt in siaqodbList)
{
Sqo.Internal._bs._sdbfn(siaqodb, mt, mt.FileName);
ImageTreeViewItem nodeType = new ImageTreeViewItem();
nodeType.Tag = mt;
nodeType.Text = mt.Name;
nodeType.SelectedImage = ImageTreeViewItem.Createimage(@"pack://*****:*****@"pack://application:,,/Resources/pubclass.gif");
nodeType.ContextMenu = cm;
treeView1.Items.Add(nodeType);
foreach (Sqo.MetaField mf in mt.Fields)
{
ImageTreeViewItem nodeField = new ImageTreeViewItem();
//nodeField.Header = mf.Name + "(" + mf.FieldType.ToString() + ")";
if (mf.FieldType != null)
{
nodeField.Text = mf.Name + "(" + mf.FieldType.ToString() + ")";
}
else
{
nodeField.Text = mf.Name + "(ComplexType)";
}
nodeField.SelectedImage = ImageTreeViewItem.Createimage(@"pack://*****:*****@"pack://application:,,/Resources/pubfield.gif");
nodeField.ContextMenu = null;
nodeType.Items.Add(nodeField);
}
}
btnDBInfo.IsEnabled = true;
}
else
{
MessageBox.Show("Select a valid folder path!");
}
}
public List <ImageTreeViewItem> GetSlidesItem()
{
var listitm = new List <ImageTreeViewItem>();
foreach (ppt.Slide slide in GetSlides())
{
ImageTreeViewItem itm = new ImageTreeViewItem();
itm.Image = GetResourceImage("Component Icon/SlideIcon_s.png");
itm.Header = $"Slide{slide.SlideNumber} (슬라이드)";
itm.Tag = slide;
listitm.Add(itm);
}
return(listitm);
}
public List <ImageTreeViewItem> GetShapeItem(List <ppt.Shape> shapelist, bool GetAllGroupItem)
{
BitmapImage shapeimage = GetResourceImage("Component Icon/ShapeIcon_s.png");
var itm = new List <ImageTreeViewItem>();
foreach (ppt.Shape shape in shapelist)
{
var shapeitm = new ImageTreeViewItem(GetResourceIcon(shape.Type),
shape.Name + " " + MsoShapeTypeToString(shape.Type),
new ShapeData(false, ShapeToCustomShapeData(((ppt.Slide)(shape.Parent)).SlideIndex, shape)));
if (shape.Type == MsoShapeType.msoGroup)
{
foreach (ImageTreeViewItem inneritm in GetShapeItem(GroupShapesToShapes(shape.GroupItems), GetAllGroupItem))
{
shapeitm.Items.Add(inneritm);
}
}
itm.Add(shapeitm);
}
return(itm);
}
private void PptComponent_SelectedItemChanged(object sender, RoutedPropertyChangedEventArgs <object> e)
{
if (e.NewValue.GetType() == typeof(ImageTreeViewItem))
{
ImageTreeViewItem itm = (ImageTreeViewItem)e.NewValue;
iItemData itmdata = itm.data;
ImageButton[] ableAddBtns, unableAddBtns;
ableAddBtns = new ImageButton[] { };
unableAddBtns = new ImageButton[] { AddEnumBtn, AddFuncBtn, AddSubBtn, AddTypeBtn, EventMouseOverBtn, EventMouseClickBtn };
if (itmdata != null)
{
switch (itmdata.type)
{
case itemDataType.ShapeData:
// 쉐이프 선택
ShapeData shapedata = (ShapeData)itmdata;
ppt.Shape shape = CustomShapeDataToShape(shapedata.Item, pc.PowerPointPresentation);
ableAddBtns = new ImageButton[] { AddEnumBtn, AddFuncBtn, AddSubBtn, AddTypeBtn, EventMouseOverBtn, EventMouseClickBtn };
unableAddBtns = new ImageButton[] { };
//ppGrid.SelectedObject = shape;
break;
case itemDataType.SlideData:
// 슬라이드 선택
SlideData slidedata = (SlideData)itmdata;
ableAddBtns = new ImageButton[] { AddEnumBtn, AddFuncBtn, AddSubBtn, AddTypeBtn };
unableAddBtns = new ImageButton[] { EventMouseOverBtn, EventMouseClickBtn };
if (slidedata.IsLoaded)
{
break;
}
pb.Value = 0;
pb.Minimum = 0; pb.Maximum = pc.PowerPointPresentation.Slides[slidedata.SlideIndex].Shapes.Count;
Thread thr = new Thread(() =>
{
foreach (ppt.Shape shpe in pc.PowerPointPresentation.Slides[slidedata.SlideIndex].Shapes)
{
Application.Current.Dispatcher.Invoke(DispatcherPriority.Background,
new Action(delegate
{
pptComponent.IsEnabled = false;
var inneritm = new ImageTreeViewItem(GetResourceIcon(shpe.Type),
shpe.Name + " " + MsoShapeTypeToString(shpe.Type),
new ShapeData(false, ShapeToCustomShapeData(slidedata.SlideIndex, shpe)));
if (shpe.Type == Microsoft.Office.Core.MsoShapeType.msoGroup)
{
foreach (var childitem in pc.GetShapeItem(GroupShapesToShapes(shpe.GroupItems), true))
{
inneritm.Items.Add(childitem);
}
}
pb.Value++;
InfoTB.Text = $"슬라이드의 도형 정보를 읽어오는 중입니다. ({pb.Value}/{pb.Maximum})";
itm.Items.Add(inneritm);
}));
}
Dispatcher.Invoke(new Action(() => {
InfoTB.Text = $"슬라이드{slidedata.SlideIndex}의 {pb.Maximum}개의 도형 정보를 모두 읽어왔습니다. ";
itmdata.IsLoaded = true; pptComponent.IsEnabled = true;
pptComponent.Focus();
}));
});
thr.SetApartmentState(ApartmentState.STA);
thr.Start();
break;
default:
MessageBox.Show(itmdata.GetType().ToString());
break;
}
}
foreach (ImageButton btn in ableAddBtns)
{
btn.IsEnabled = true;
}
foreach (ImageButton btn in unableAddBtns)
{
btn.IsEnabled = false;
}
}
}
private void button_Click(object sender, RoutedEventArgs e)
{
//int enumdata = 1;
//string str = "abcdef";
//bool Bool = false;
//pg.AddEnumItem("Enum1", ref enumdata, typeof(tester));
//pg.AddEnumItem("Enum2", ref enumdata, typeof(tester));
//pg.AddStrItem("Str1", ref str);
//pg.AddBoolItem("Bool1", ref Bool);
//MethodInfo[] mis = typeof(ppt.Shape).GetMethods();
//foreach(MethodInfo mi in mis)
//{
// MessageBox.Show(mi.Name);
//}
//typeof(ppt.Shape).GetProperties();
//return;
var pptItem = new ImageTreeViewItem(GetResourceImage("Component Icon/ppticon_s.png"), "Presentation (프레젠테이션)");
ImageTreeViewItem slideItem;
//F:\장유탁 파일\PowerPoint Game\Buster Wars\Buster Wars Final Edition.pptx
string location = $@"{Environment.GetFolderPath(Environment.SpecialFolder.DesktopDirectory)}\Icon.pptm"; //U. Buster Wars 1.5.0.pptx
InfoTB.Text = $"'{location}'프레젠테이션을 읽어오고 있습니다";
Application.Current.Dispatcher.Invoke(DispatcherPriority.Background,
new Action(delegate { pc = new PresentationConnector(location, false, true);
VBProjectConnector vc = new VBProjectConnector(pc.VBProject); }));
this.Title = location + " - PowerVBA";
//pc = new PresentationConnector(Environment.GetFolderPath(Environment.SpecialFolder.DesktopDirectory) + "\\Icon.pptx", false, false);
ImageTreeViewItem SlidesItem = null;
thr = new Thread(() =>
{
Stopwatch sw = new Stopwatch();
sw.Start();
//Environment.GetFolderPath(Environment.SpecialFolder.DesktopDirectory) + "\\Icon.pptx"
//pc = new PresentationConnector(@"F:\장유탁 파일\Github Project\PowerVBA\PowerVBA\Icon.pptx",false,false);
//VBProjectConnector vbprojConn = new VBProjectConnector(pc.PowerPointPresentation.VBProject);
ppt.Slides slides = pc.PowerPointPresentation.Slides;
int SlideNum = slides.Count;
Dispatcher.Invoke(new Action(() =>
{
pb.Maximum = SlideNum;
SlidesItem = new ImageTreeViewItem(GetResourceImage("Component Icon/slideicon_s.png"), "Slides (슬라이드 목록)");
this.IsEnabled = false;
}));
foreach (ppt.Slide slide in pc.PowerPointPresentation.Slides)
{
Dispatcher.Invoke(new Action(() => {
pb.Value++;
InfoTB.Text = $"슬라이드 정보를 읽어오는 중입니다. ({pb.Value}/{SlideNum})";
var sd = new SlideData(false, slide.SlideNumber);
slidedatas.Add(sd);
var shapeItem = new ImageTreeViewItem(GetResourceImage("Component Icon/shapeicon_s.png"), "Shapes (도형 목록)", sd);
slideItem = new ImageTreeViewItem(GetResourceImage("Component Icon/slideicon_s.png"), "Slide" + slide.SlideNumber + " (슬라이드)");
slideItem.Items.Add(shapeItem);
SlidesItem.Items.Add(slideItem);
this.IsEnabled = true;
}));
}
Dispatcher.Invoke(new Action(() => {
pptComponent.Items.Add(pptItem);
pptItem.Items.Add(SlidesItem);
}));
});
thr.SetApartmentState(ApartmentState.STA);
thr.Start();
}
