private void barAdd1item_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (treeList1.FocusedNode == null) return; string uid = treeList1.FocusedNode["UID"].ToString(); PspType obj = new PspType(); obj.UID = obj.UID + "|" + ProjectUID ; obj.Contents = bts; obj.ParentID = uid; obj.CreateDate = DateTime.Now; obj.Col1 = progName; FrmPspTypeDialog dlg = new FrmPspTypeDialog(); dlg.Text = progName; dlg.Object = obj; dlg.IsCreate = true; if (dlg.ShowDialog() != DialogResult.OK) { return; } dataTable.Rows.Add(DataConverter.ObjectToRow(obj, dataTable.NewRow())); }
private void barEdititem_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (treeList1.FocusedNode == null) return; string uid = treeList1.FocusedNode["UID"].ToString(); PspType obj = Services.BaseService.GetOneByKey<PspType>(uid); PspType objCopy = new PspType(); DataConverter.CopyTo<PspType>(obj, objCopy); FrmPspTypeDialog dlg = new FrmPspTypeDialog(); dlg.Text = progName; dlg.Object = objCopy; if (dlg.ShowDialog() != DialogResult.OK) { return; } DataConverter.CopyTo<PspType>(objCopy, obj); treeList1.FocusedNode.SetValue("Title", obj.Title); }
private void barAdditem_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { PspType obj = new PspType(); obj.Contents = bts; obj.ParentID = ""; obj.CreateDate = DateTime.Now; obj.Col1 = progName; FrmPspTypeDialog dlg = new FrmPspTypeDialog(); dlg.Text = progName; dlg.Object = obj; dlg.IsCreate = true; if (dlg.ShowDialog() != DialogResult.OK) { return; } string uid = treeList1.FocusedNode["UID"].ToString(); uid1 = uid; PspType obj1 = Services.BaseService.GetOneByKey<PspType>(uid); WaitDialogForm wait = null; try { wait = new WaitDialogForm("", "���ڼ�������, ���Ժ�..."); System.IO.MemoryStream ms = new System.IO.MemoryStream(obj1.Contents); // by1 = obj.Contents; string str = ""; str = filename; string fname = filepath + Guid.NewGuid().ToString() + ".xls"; filename = fname; dsoExcelControl1.saveStreamFile(fname, ms.ToArray()); dsoExcelControl1.FileOpen(fname); // dsoExcelControl1.FileNew(); dsoExcelControl1.AxFramerControl.Titlebar = false; dsoExcelControl1.Onisdispalymenubar(false); dsoExcelControl1.Onisdispalytoolbar(false); if (File.Exists(str)) { File.Delete(str); } // fpSpread1.Open(ms); wait.Close(); //fpSpread1.ActiveSheet.Columns[0, fpSpread1.ActiveSheet.Columns.Count - 1].AllowAutoFilter = true;//��ѯ //fpSpread1.Sheets[0].SetColumnAllowAutoSort(-1, true);//���� } catch { wait.Close(); } dataTable.Rows.Add(DataConverter.ObjectToRow(obj, dataTable.NewRow())); }
private void InitData() { if (!isSelect) { switch (smmprog.ProgId) { case "64c9efcb-e6cc-402f-b2fc-f5f6f7d296f7": progName = "�������Է���"; type = "fhtxfx"; break; case "a50e1781-e470-4721-a6ee-c4b1294d6bd4": progName = "������������"; type = "dwjcsj"; break; case "3630adcc-9d4b-4059-b44e-4f88ccf76b43": progName = "�����滮������"; type = "dwghjc"; break; } } PspType pt = new PspType(); pt.Col1 = progName; ilist = Services.BaseService.GetList("SelectPspTypeList", pt); //ilist = Services.BaseService.GetList<PspType>(); dataTable = DataConverter.ToDataTable(ilist, typeof(PspType)); treeList1.DataSource = dataTable; Econ ed = new Econ(); ed.UID = "yyy"; try { bts = Services.BaseService.GetOneByKey<Econ>(ed).ExcelData; //byte[] bb = null; //bb = Services.BaseService.GetOneByKey<Econ>(ed).ExcelData; } catch { } }
private void barAdd1item_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (treeList1.FocusedNode == null) return; string uid = treeList1.FocusedNode["UID"].ToString(); PspType obj = new PspType(); obj.UID = obj.UID + "|" + ProjectUID; obj.Contents = bts; obj.ParentID = uid; obj.CreateDate = DateTime.Now; obj.Col1 = ProjectUID; FrmPspTypeDialog dlg = new FrmPspTypeDialog(); dlg.Text = progName; dlg.Object = obj; dlg.IsCreate = true; if (dlg.ShowDialog() != DialogResult.OK) { return; } WaitDialogForm wait = null; try { wait = new WaitDialogForm("", "���ڼ�������, ���Ժ�..."); //System.IO.MemoryStream ms = new System.IO.MemoryStream(obj1.Contents); //// by1 = obj.Contents; string str = ""; str = filename; string fname = filepath + Guid.NewGuid().ToString() + ".xls"; filename = fname; dsoExcelControl1.AxFramerControl.Save(fname, false, null, null); //dsoExcelControl1.FileOpen(fname); //dsoExcelControl1.AxFramerControl.Titlebar = false; //dsoExcelControl1.Onisdispalymenubar(false); //dsoExcelControl1.Onisdispalytoolbar(false); wait.Close(); } catch { wait.Close(); } dataTable.Rows.Add(DataConverter.ObjectToRow(obj, dataTable.NewRow())); }