public static DataSet getData()
        {
            ExcelExtension.GetValues egv = new ExcelExtension.GetValues();
            DataSet ds = egv.getValuesFromExcel();

            return(ds);
        }
예제 #2
0
        private void Form1_Load(object sender, EventArgs e)
        {
            ExcelExtension.GetValues egv = new ExcelExtension.GetValues();
            Cg1.clsDb cd      = new Cg1.clsDb();
            string    textout = "";
            DataSet   ds      = egv.getValuesFromExcel();

            if (ds == null)
            {
                return;
            }
            foreach (DataTable dt in ds.Tables)
            {
                textout = textout + "\n" + (new clsDb()).gencreate(dt);
            }
            Clipboard.SetText(textout);
        }
        public override void Execute()
        {
            ExcelExtension.GetValues egv = new ExcelExtension.GetValues();
            //Cg1.clsDb cd = new Cg1.clsDb();
            string  textout = "";
            DataSet ds      = egv.getValuesFromExcelExpand();

            if (ds == null)
            {
                return;
            }
            foreach (DataTable dt in ds.Tables)
            {
                textout = textout + "\n" + (new clsDb()).gencreate(dt);
            }
            Clipboard.SetText(textout);
        }
예제 #4
0
        public override void Execute()
        {
            ExcelExtension.GetValues egv = new ExcelExtension.GetValues();
            //Cg1.clsDb cd = new Cg1.clsDb();
            string  textout = "";
            DataSet ds      = egv.getValuesFromExcelExpand();

            if (ds == null)
            {
                return;
            }
            string mainmenu = Properties.Settings.Default.MnuGenMainMenuName;
            bool   fromList = Properties.Settings.Default.MnuGenFromList;

            foreach (DataTable dt in ds.Tables)
            {
                textout = textout + "\n" + (new clsMenuDeclare(mainmenu, fromList)).gencreate(dt);
                textout = textout + "\n" + (new clsMenuDesigner(mainmenu, fromList)).gencreate(dt);
                textout = textout + "\n" + (new clsMenuDesign(mainmenu, fromList)).gencreate(dt);
                textout = textout + "\n" + (new clsMenuCall(mainmenu, fromList)).gencreate(dt);
            }
            Clipboard.SetText(textout);
        }