Example #1
0
        private void frmNDoc_Load(object sender, EventArgs e)
        {
            using (DAOContext con = new DAOContext(AccessConstring.SettingConString))
            {
                con.OpenConnection();

                int ret = 0;

                SettingsSingleton.getValue(SettingsSingleton.KeyNDocTop, out ret);
                if (ret > 0)
                {
                    this.Top = ret;
                }

                SettingsSingleton.getValue(SettingsSingleton.KeyNDocLeft, out ret);
                if (ret > 0)
                {
                    this.Left = ret;
                }

                SettingsSingleton.getValue(SettingsSingleton.KeyNDocWidth, out ret);
                if (ret > 0)
                {
                    this.Width = ret;
                }

                SettingsSingleton.getValue(SettingsSingleton.KeyNDocHeight, out ret);
                if (ret > 0)
                {
                    this.Height = ret;
                }

                con.CloseConnection();
            }
        }
Example #2
0
        public AccessFuncs()
        {
            DataTable tbl = null;
            using (DAOContext con = new DAOContext(AccessConstring.FuncsConString))
            {
                con.OpenConnection();
                funcsDAO dao = new funcsDAO(con);

                tbl = dao.selectAll();

                foreach (DataRow row in tbl.Rows)
                {
                    string funcname = row["funcname"].ToString();
                    string stringfuncname = row["stringfuncname"].ToString();

                    DataTable argsTbl = dao.selectArgs(funcname);
                    List<string> argTypes = new List<string>();
                    foreach (DataRow arow in argsTbl.Rows)
                    {
                        argTypes.Add(arow["argtype"].ToString());
                    }

                    if (!AccessFuncs.FuncsData.ContainsKey(funcname))
                    {
                        AccessFuncs.FuncsData.Add(funcname, new FuncData(funcname, stringfuncname, argTypes));
                    }
                }

                con.CloseConnection();
            }
        }
        public SeqAccessTableNode(string tableName)
        {
            using (DAOContext con = new DAOContext(AccessConstring.conString))
            {
                con.OpenConnection();

                tableDAO dao = new tableDAO(con, tableName);
                this.table = dao.selectAll();

                con.CloseConnection();
            }
        }
Example #4
0
        private void frmNDoc_FormClosing(object sender, FormClosingEventArgs e)
        {
            using (DAOContext con = new DAOContext(AccessConstring.SettingConString))
            {
                con.OpenConnection();

                SettingsSingleton.setValue(SettingsSingleton.KeyNDocTop, this.Top);
                SettingsSingleton.setValue(SettingsSingleton.KeyNDocLeft, this.Left);
                SettingsSingleton.setValue(SettingsSingleton.KeyNDocWidth, this.Width);
                SettingsSingleton.setValue(SettingsSingleton.KeyNDocHeight, this.Height);

                con.CloseConnection();
            }
        }
        public RandomAccessTableNode(string tableName)
        {
            using (DAOContext con = new DAOContext(AccessConstring.conString))
            {
                con.OpenConnection();

                tableDAO dao = new tableDAO(con, tableName);
                this.table = dao.selectAll();

                con.CloseConnection();
            }

            this.max = this.table.Rows.Count;

            int seed = Environment.TickCount;
            this.objRandom = new Random(seed);
        }
Example #6
0
        private void Form1_FormClosing(object sender, FormClosingEventArgs e)
        {
            this.cmbReflectTarget.Save();
            this.cmbPrefix.Save();

            using (DAOContext con = new DAOContext(AccessConstring.SettingConString))
            {
                con.OpenConnection();

                SettingsSingleton.setValue(SettingsSingleton.KeyMainFormTop, this.Top);
                SettingsSingleton.setValue(SettingsSingleton.KeyMainFormLeft, this.Left);
                SettingsSingleton.setValue(SettingsSingleton.KeyMainFormWidth, this.Width);
                SettingsSingleton.setValue(SettingsSingleton.KeyMainFormHeight, this.Height);

                con.CloseConnection();
            }
        }
Example #7
0
 private void btnOk_Click(object sender, EventArgs e)
 {
     if (string.IsNullOrEmpty(this.tbxNDocComnment.Text))
     {
         MessageBox.Show("テキストボックスが空です。");
         return;
     }
     if (string.IsNullOrEmpty(lblTargetName.Text))
     {
         MessageBox.Show("ターゲットが空です。");
         return;
     }
     using (DAOContext con = new DAOContext(AccessConstring.jpDBConString))
     {
         con.OpenConnection();
         SettingsSingleton.setValue(con, this.NDocHeader + this.lblTargetName.Text, this.tbxNDocComnment.Text);
         con.CloseConnection();
     }
     this.Close();
 }
        public static string getStringValue(string headerText, string strgKey)
        {
            string strgValue = "";

            //DBから読み込む
            using (DAOContext con = new DAOContext(AccessConstring.SettingConString))
            {
                con.OpenConnection();
                MyDummySQLSettingsDAO dao = new MyDummySQLSettingsDAO(con);

                dao.selectSetting(headerText, strgKey, out strgValue);

                con.CloseConnection();

            }
            return strgValue;
        }
        public static IList<string> getHeaderTexts()
        {
            List<string> headertexts = new List<string>();
            DataTable tbl = null;
            //DBから読み込む
            using (DAOContext con = new DAOContext(AccessConstring.SettingConString))
            {
                con.OpenConnection();
                MyDummySQLSettingsDAO dao = new MyDummySQLSettingsDAO(con);

                tbl = dao.selectHeaders();

                con.CloseConnection();
            }

            if (tbl != null)
            {
                foreach (DataRow row in tbl.Rows)
                {
                    headertexts.Add(row["HEADERTEXT"].ToString());
                }
            }
            return headertexts;
        }
 public static void deleteSettings(string headerText, string strgKey)
 {
     using (DAOContext con = new DAOContext(AccessConstring.SettingConString))
     {
         con.OpenConnection();
         MyDummySQLSettingsDAO dao = new MyDummySQLSettingsDAO(con);
         dao.deleteSettings(headerText, strgKey);
         con.CloseConnection();
     }
 }
        public static void setStringValus(string headerText, string strgKey, IList<string> strgs)
        {
            int no = 1;
            using (DAOContext con = new DAOContext(AccessConstring.SettingConString))
            {
                con.OpenConnection();
                MyDummySQLSettingsDAO dao = new MyDummySQLSettingsDAO(con);

                dao.deleteSettings(headerText, strgKey);

                foreach (string strg in strgs)
                {
                    dao.insertNew(headerText, strgKey, no, strg);
                    no++;
                }

                con.CloseConnection();
            }
        }
 public static bool isExistsHeader(string headerText)
 {
     bool ret = false;
     using (DAOContext con = new DAOContext(AccessConstring.SettingConString))
     {
         con.OpenConnection();
         MyDummySQLSettingsDAO dao = new MyDummySQLSettingsDAO(con);
         ret = dao.isExistsHeader(headerText);
         con.CloseConnection();
     }
     return ret;
 }
Example #13
0
        private void Form1_Load(object sender, EventArgs e)
        {
            this.cmbReflectTarget.Load();
            this.cmbPrefix.SaveFilename = "prefix.txt";
            this.cmbPrefix.Load();

            this.cmbPublicElse.SelectedIndex = 0;

            object selected = new NameSpaceItem(ReflectOtherAssembly.NameSpaceEnum.WindowsForms, "System.Windows.Forms");

            this.cmbNameSpace.Items.Add(new NameSpaceItem(ReflectOtherAssembly.NameSpaceEnum.System, "System"));
            this.cmbNameSpace.Items.Add(new NameSpaceItem(ReflectOtherAssembly.NameSpaceEnum.Generic, "System.Collections.Generic"));
            this.cmbNameSpace.Items.Add(selected);
            this.cmbNameSpace.SelectedItem = selected;

            this.tbxJpLineOfListBox.ParentListView = this.listJpArgsInfo;

            this.cmbExportMethod.Text = "TSV";



            // Menu

            /*
             * //Copy
             * MenuItem mNdoc = new MenuItem();
             * mNdoc.Text = "NDocコメント";
             * mNdoc.Click += this.ShowNDocCommentDialog;
             * //this.cMenu.Items.Add(mNdoc);
             * this.tbxJpMethodName.ContextMenu = new ContextMenu();
             * this.tbxJpMethodName.ContextMenu.MenuItems.Add(mNdoc);
             */
            this.AddMenusToControl(this.tbxJpMethodName);
            this.AddMenusToControl(this.tbxJpReturnType);
            this.AddMenusToControl(this.listJpArgsInfo);


            // SIZE
            using (DAOContext con = new DAOContext(AccessConstring.SettingConString))
            {
                con.OpenConnection();

                int ret = 0;

                SettingsSingleton.getValue(SettingsSingleton.KeyMainFormTop, out ret);
                if (ret > 0)
                {
                    this.Top = ret;
                }

                SettingsSingleton.getValue(SettingsSingleton.KeyMainFormLeft, out ret);
                if (ret > 0)
                {
                    this.Left = ret;
                }

                SettingsSingleton.getValue(SettingsSingleton.KeyMainFormWidth, out ret);
                if (ret > 0)
                {
                    this.Width = ret;
                }

                SettingsSingleton.getValue(SettingsSingleton.KeyMainFormHeight, out ret);
                if (ret > 0)
                {
                    this.Height = ret;
                }

                con.CloseConnection();
            }
        }
Example #14
0
 public Context()
 {
     dao = new DAOContext(database_user, database_passwd, database_server, database_db);
 }
Example #15
0
 public funcsDAO(DAOContext con)
     : base(con)
 {
 }
        public static IList<string> getStringValues(string headerText, string strgKey)
        {
            List<string> ret = new List<string>();
            DataTable tbl = null;

            //DBから読み込む
            using (DAOContext con = new DAOContext(AccessConstring.SettingConString))
            {
                con.OpenConnection();
                MyDummySQLSettingsDAO dao = new MyDummySQLSettingsDAO(con);

                tbl = dao.selectSettingRows(headerText, strgKey);

                con.CloseConnection();

            }

            if (tbl != null)
            {
                foreach (DataRow row in tbl.Rows)
                {
                    ret.Add(row["TEXTVALUE"].ToString());
                }
            }

            return ret;
        }
        public static void getValue(string headerText, string strgKey, out int intValue)
        {
            intValue = 0;

            //DBから読み込む
            using (DAOContext con = new DAOContext(AccessConstring.SettingConString))
            {
                con.OpenConnection();
                MyDummySQLSettingsDAO dao = new MyDummySQLSettingsDAO(con);

                dao.selectSetting(headerText, strgKey, out intValue);

                con.CloseConnection();

            }
        }
Example #18
0
            public void Execute(string fullsigunature, string funcname, string returnType, string publicOr, string virtualString, List <string> args)
            {
                // prefix
                string prefix = this.ParentForm.cmbPrefix.Text.Trim();

                if (string.IsNullOrEmpty(prefix))
                {
                    prefix = string.Empty;
                }

                using (DAOContext con = new DAOContext(AccessConstring.jpDBConString))
                {
                    con.OpenConnection();

                    // english
                    this.ParentForm.tbxReturnType.Text = returnType;
                    this.ParentForm.tbxMethodName.Text = funcname;
                    this.ParentForm.tbxPublicOr.Text   = publicOr;
                    this.ParentForm.tbxVirtual.Text    = virtualString;

                    this.ParentForm.listArgsInfo.Items.Clear();
                    foreach (string arg in args)
                    {
                        ListViewItem item = new ListViewItem();
                        item.Text = arg;
                        this.ParentForm.listArgsInfo.Items.Add(item);
                    }

                    // Japanese
                    string ret = string.Empty;

                    SettingsSingleton.getValue(con, prefix + returnType, out ret);
                    if (!string.IsNullOrEmpty(ret))
                    {
                        this.ParentForm.tbxJpReturnType.Text = ret;
                    }
                    else
                    {
                        this.ParentForm.tbxJpReturnType.Text = returnType;
                    }

                    SettingsSingleton.getValue(con, prefix + funcname, out ret);
                    if (!string.IsNullOrEmpty(ret))
                    {
                        this.ParentForm.tbxJpMethodName.Text = ret;
                    }
                    else
                    {
                        this.ParentForm.tbxJpMethodName.Text = funcname;
                    }

                    this.ParentForm.tbxJpPublicOr.Text = publicOr;
                    this.ParentForm.tbxJpVirtual.Text  = virtualString;

                    this.ParentForm.listJpArgsInfo.Items.Clear();
                    foreach (string arg in args)
                    {
                        ListViewItem item = new ListViewItem();

                        SettingsSingleton.getValue(con, prefix + arg, out ret);
                        if (!string.IsNullOrEmpty(ret))
                        {
                            item.Text = ret;
                        }
                        else
                        {
                            item.Text = arg;
                        }

                        this.ParentForm.listJpArgsInfo.Items.Add(item);
                    }

                    con.CloseConnection();
                }
            }
 public static void MergeHeader(string headerText)
 {
     using (DAOContext con = new DAOContext(AccessConstring.SettingConString))
     {
         con.OpenConnection();
         MyDummySQLSettingsDAO dao = new MyDummySQLSettingsDAO(con);
         dao.mergeHeader(headerText);
         con.CloseConnection();
     }
 }
Example #20
0
        public void SaveJpNameToDB()
        {
            //prefix
            string prefix = this.cmbPrefix.Text.Trim();

            if (string.IsNullOrEmpty(prefix))
            {
                prefix = string.Empty;
            }

            // english
            string returnTypeEn    = this.tbxReturnType.Text;
            string funcnameEn      = this.tbxMethodName.Text;
            string publicOrEn      = this.tbxPublicOr.Text;
            string virtualStringEn = this.tbxVirtual.Text;

            List <string> ArgsListEn = new List <string>();//this.ParentForm.listArgsInfo.Items

            foreach (var item in this.listArgsInfo.Items)
            {
                string arg = item.ToString();
                ArgsListEn.Add(arg);

                /*
                 * ListViewItem item = new ListViewItem();
                 * item.Text = arg;
                 * this.ParentForm.listArgsInfo.Items.Add(item);
                 */
            }

            // Japanese
            string returnTypeJp    = this.tbxJpReturnType.Text;
            string funcnameJp      = this.tbxJpMethodName.Text;
            string publicOrJp      = this.tbxJpPublicOr.Text;
            string virtualStringJp = this.tbxJpVirtual.Text;

            //this.ParentForm.listJpArgsInfo.Items;
            List <string> ArgsListJp = new List <string>();

            foreach (var item in this.listJpArgsInfo.Items)
            {
                string arg = item.ToString();
                ArgsListJp.Add(arg);
            }

            // convert and save
            using (DAOContext con = new DAOContext(AccessConstring.jpDBConString))
            {
                con.OpenConnection();

                if (!string.IsNullOrEmpty(returnTypeEn.Trim()) && !string.IsNullOrEmpty(returnTypeJp.Trim()))
                {
                    SettingsSingleton.setValue(con, prefix + returnTypeEn.Trim(), returnTypeJp.Trim());
                }
                if (!string.IsNullOrEmpty(funcnameEn.Trim()) && !string.IsNullOrEmpty(funcnameJp.Trim()))
                {
                    SettingsSingleton.setValue(con, prefix + funcnameEn.Trim(), funcnameJp.Trim());
                }

                int maxArgEn = ArgsListEn.Count;
                int maxArgJp = ArgsListJp.Count;
                int max      = (maxArgEn < maxArgJp) ? maxArgEn : maxArgJp;

                try
                {
                    for (int i = 0; i < max; i++)
                    {
                        if (!string.IsNullOrEmpty(ArgsListEn[i].Trim()) && !string.IsNullOrEmpty(ArgsListJp[i].Trim()))
                        {
                            SettingsSingleton.setValue(con, prefix + ArgsListEn[i].Trim(), ArgsListJp[i].Trim());
                        }
                    }
                }
                catch (Exception excp)
                {
                }

                con.CloseConnection();
            }
        }
 public static void setValue(string headerText, string strgKey, int intValue)
 {
     using (DAOContext con = new DAOContext(AccessConstring.SettingConString))
     {
         con.OpenConnection();
         MyDummySQLSettingsDAO dao = new MyDummySQLSettingsDAO(con);
         dao.mergeSettings(headerText,strgKey, intValue);
         con.CloseConnection();
     }
 }
 public MyDummySQLSettingsDAO(DAOContext con)
     : base(con)
 {
 }
 public AccessSchemaDAO(DAOContext con)
     : base(con)
 {
 }
Example #24
0
 public tableDAO(DAOContext con, string tableName_)
     : base(con)
 {
     this.tableName = tableName_;
 }