Пример #1
0
        public static int AttachDataBase(this ServerForm main, CoreConfig config)
        {
            List <string> dbs = config.DataBases;

            if (dbs != null)
            {
                MSSqlHelper sql = new MSSqlHelper(config.ConnectionString);
                if (sql.Open())
                {
                    int i = 0;
                    foreach (string db in dbs)
                    {
                        string file = PathHelper.Combine(config.DatabasePath, db + ".mdf");
                        try
                        {
                            if (!sql.Exist(db))
                            {
                                sql.AttachDataBase(db, file);
                                i++;
                            }
                        }
                        catch (Exception e)
                        {
                            main.Error(R.TipServerDbAttachFail + "\n" + file + "\n" + e.Message);
                            break;
                        }
                    }
                    return(i);
                }
            }
            return(0);
        }
Пример #2
0
        public static int AttachDataBase(this MainForm main, CoreConfig config)
        {
            List <string> dbs = config.DataBases;

            if (dbs != null)
            {
                MSSqlHelper sql = new MSSqlHelper(config.ConnectionString);
                if (sql.Open())
                {
                    int i = 0;
                    foreach (string db in dbs)
                    {
                        string file = PathHelper.Combine(config.DatabasePath, db + ".mdf");
                        try
                        {
                            if (sql.Exist(db))
                            {
#if DEBUG
                                main.Warnning("数据库已经存在:" + db);
#endif
                            }
                            else
                            {
                                sql.AttachDataBase(db, file);
                                i++;
                            }
                        }
                        catch (Exception e)
                        {
#if DEBUG
                            main.Error("分离失败\n" + e);
#else
                            main.Error("附加失败\n" + file + "\n" + e.Message);
#endif
                            break;
                        }
                    }
                    return(i);
                }
            }
            return(0);
        }