static private bool IsNewKanjouKamoku(KaikeiDatabase db1, KaikeiDatabase db2, Row originalRow)
        {
            List <Row> rowList = new List <Row>();

            Row row = originalRow;

            while (row != null)
            {
                rowList.Add(row);
                row = db2.MTKanjouKamoku.GetParentOf(row);
            }

            int parentId = -1;

            for (int i = rowList.Count - 1; i >= 0; i--)
            {
                row = rowList[i];

                string sql = string.Format(
                    "where kamoku = '{0}' and hierarchy = {1} and kamoku_code = '{2}' and parent_id = {3}",
                    row.GetStr("kamoku"),
                    row.GetLong("hierarchy", -1),
                    row.GetStr("kamoku_code"),
                    parentId);
                var selectRows = db1.MTKanjouKamoku.Select(sql);
                if (selectRows.Count() == 0)
                {
                    return(true);
                }
                else if (selectRows.Count() > 1)
                {
                    string buf = "";
                    foreach (var r in rowList)
                    {
                        buf += r.GetStr("kamoku") + "(" + r.GetStr("kamoku_code") + ") - ";
                    }
                    helper.MsgBox.Warn("警告:mt_kanjou_kamoku " + buf + " が二重に登録されています");
                    parentId = selectRows.First().GetId();
                }
                else
                {
                    parentId = selectRows.First().GetId();
                }
            }

            return(false);

            /*string sql = string.Format("where kamoku = '{0}' and hierarchy = {1} and kamoku_code = '{2}'", originalRow.GetStr("kamoku"), originalRow.GetLong("hierarchy", -1), originalRow.GetStr("kamoku_code"));
             * if (db1.MTKanjouKamoku.RowCount(sql) > 0) {
             *  int parentId = (int)originalRow.GetLong("parent_id", -1);
             *  if (parentId == -1) {
             *      return false;
             *  }
             *  Row parentRow = db2.MTKanjouKamoku.GetRowById(parentId);
             *  return IsNewKanjouKamoku(db1, db2, parentRow);
             * }
             * else {
             *  return true;
             * }*/
        }
        static public void MargeKurikoshi(KaikeiDatabase db1, KaikeiDatabase db2)
        {
            foreach (var kurikoshiRow in db2.ZenkiKurikoshiKamokuKubun.Select(""))
            {
                int kamokuKubunId = GetDict(db1, kamokuKubunId2Id, (int)kurikoshiRow.GetLong("kamoku_kubun_id", -1));

                string sql = string.Format(
                    "where kaikei_kubun_id = {0} and nenndo = {1} and kamoku_kubun_id = {2}",
                    (int)kurikoshiRow.GetLong("kaikei_kubun_id", -1),
                    (int)kurikoshiRow.GetLong("nenndo", -1),
                    kamokuKubunId);
                if (db1.ZenkiKurikoshiKamokuKubun.RowCount(sql) == 0)
                {
                    db1.ZenkiKurikoshiKamokuKubun.SetColumnValue(kurikoshiRow, "kamoku_kubun_id", kamokuKubunId);
                    db1.ZenkiKurikoshiKamokuKubun.Insert(kurikoshiRow);
                }
                else
                {
                    var  row   = db1.ZenkiKurikoshiKamokuKubun.GetFirstRow(sql);
                    long value = row.GetLong("zenki_kurikoshi_gaku", 0);
                    value += kurikoshiRow.GetLong("zenki_kurikoshi_gaku", 0);
                    row.Set("zenki_kurikoshi_gaku", value);
                    db1.ZenkiKurikoshiKamokuKubun.Update(row);
                }
            }
        }
        static private void AddKanjouKamoku(KaikeiDatabase db1, KaikeiDatabase db2)
        {
            foreach (Row row in db2.MTKanjouKamoku.Select("order by id"))
            {
                int originalId = row.GetId();
                int parentId   = (int)row.GetLong("parent_id", -1);

                if (IsNewKanjouKamoku(db1, db2, row))
                {
                    if (parentId == -1)
                    {
                    }
                    else if (kanjouKamokuId2Id.ContainsKey(parentId))
                    {
                        row.Set("parent_id", kanjouKamokuId2Id[parentId]);
                    }
                    else
                    {
                        Row parentRow = db1.MTKanjouKamoku.GetRowById(parentId);
                        if (parentRow != null)
                        {
                            parentRow.Set("has_child", 1);
                            db1.MTKanjouKamoku.Update(parentRow);
                        }
                        else
                        {
                            throw new Exception("unknown parent_id");
                        }
                    }

                    foreach (string colName in new string[] { "shikin_kamoku_kubun_id", "jigyou_kamoku_kubun_id", "taisyaku_kamoku_kubun_id" })
                    {
                        int kamokuKubunId = (int)row.GetLong(colName, -1);
                        if (kamokuKubunId == -1)
                        {
                        }
                        else if (kamokuKubunId2Id.ContainsKey(kamokuKubunId))
                        {
                            row.Set(colName, kamokuKubunId2Id[kamokuKubunId]);
                        }
                        else if (db1.MTKamokuKubun.GetRowById(kamokuKubunId) == null)
                        {
                            throw new Exception("unknown " + colName);
                        }
                    }

                    row.RemoveColumn("id");
                    db1.MTKanjouKamoku.Insert(row);

                    int insertedId = db1.MTKanjouKamoku.LastInsertedRow().GetId();
                    kanjouKamokuId2Id[originalId] = insertedId;

                    foreach (string colName in new string[] { "shikin_kamoku_kubun_id", "jigyou_kamoku_kubun_id", "taisyaku_kamoku_kubun_id" })
                    {
                        int kamokuKubunId = (int)row.GetLong(colName, -1);
                        kamokuKubunId2KanjouKamokuId[kamokuKubunId] = insertedId;
                    }
                }
            }
        }
        static private bool IsNewKamokuKubun(KaikeiDatabase db1, KaikeiDatabase db2, Row originalRow)
        {
            List <Row> rowList = new List <Row>();

            Row row = originalRow;

            while (row != null)
            {
                rowList.Add(row);
                if (db2.MTKamokuKubun.HasInvalidParent(row))
                {
                    return(false); // invalidな科目の場合追加しない
                }
                row = db2.MTKamokuKubun.GetParentOf(row);
            }

            int parentId = -1;

            for (int i = rowList.Count - 1; i >= 0; i--)
            {
                row = rowList[i];

                string sql = string.Format(
                    "where name = '{0}' and hierarchy = {1} and parent_id = {2}",
                    row.GetStr("name"), row.GetLong("hierarchy", -1), parentId
                    );
                var selectRows = db1.MTKamokuKubun.Select(sql);
                if (selectRows.Count() == 0)
                {
                    return(true);
                }
                else if (selectRows.Count() > 1)
                {
                    string buf = "";
                    foreach (var r in rowList)
                    {
                        buf += r.GetStr("name") + "(" + r.GetStr("display_order") + ") - ";
                    }
                    helper.MsgBox.Warn("警告:mt_kamoku_kubun " + buf + " が二重に登録されています");
                    parentId = selectRows.First().GetId();
                }
                else
                {
                    parentId = selectRows.First().GetId();
                }
            }

            return(false);
        }
        static public int GetDict(KaikeiDatabase db1, Dictionary <int, int> dict, int id)
        {
            if (dict.ContainsKey(id))
            {
                return(dict[id]);
            }

            Row originalRow = db1.MTKanjouKamoku.GetRowFromCache(id);

            if (originalRow != null)
            {
                return(originalRow.GetId());
            }

            return(-1);
        }
        static public void MargeDenpyou(KaikeiDatabase db1, KaikeiDatabase db2)
        {
            MargeKanjouKamoku(db1, db2);

            Dictionary <int, int> oldId2newId = new Dictionary <int, int>();

            foreach (var denpyouRow in db2.KaikeiDenpyouMeisai.Select(""))
            {
                int oldId = denpyouRow.GetId();

                db1.KaikeiDenpyouMeisai.SetColumnValue(denpyouRow, "karikata_kamoku_id", GetDict(db1, kanjouKamokuId2Id, (int)denpyouRow.GetLong("karikata_kamoku_id", -1)));
                db1.KaikeiDenpyouMeisai.SetColumnValue(denpyouRow, "kashikata_kamoku_id", GetDict(db1, kanjouKamokuId2Id, (int)denpyouRow.GetLong("kashikata_kamoku_id", -1)));
                db1.KaikeiDenpyouMeisai.SetColumnValue(denpyouRow, "karikata_hojo_id", GetDict(db1, kanjouKamokuId2Id, (int)denpyouRow.GetLong("karikata_hojo_id", -1)));
                db1.KaikeiDenpyouMeisai.SetColumnValue(denpyouRow, "kashikata_hojo_id", GetDict(db1, kanjouKamokuId2Id, (int)denpyouRow.GetLong("kashikata_hojo_id", -1)));
                denpyouRow.RemoveColumn("id");
                db1.KaikeiDenpyouMeisai.Insert(denpyouRow);
                int newId = db1.KaikeiDenpyouMeisai.LastInsertedRow().GetId();

                oldId2newId.Add(oldId, newId);
            }

            foreach (var oldId in oldId2newId.Keys)
            {
                int newId = oldId2newId[oldId];

                Row denpyouRow = db1.KaikeiDenpyouMeisai.GetRowById(newId);

                int parenetMeisaiId   = (int)denpyouRow.GetLong("parent_meisai_id", -1);
                int meisaiGroupNextId = (int)denpyouRow.GetLong("meisai_group_next_id", -1);

                if (parenetMeisaiId > 0)
                {
                    denpyouRow.Set("parent_meisai_id", oldId2newId[parenetMeisaiId]);
                }
                if (meisaiGroupNextId > 0)
                {
                    denpyouRow.Set("meisai_group_next_id", oldId2newId[meisaiGroupNextId]);
                }
                if (meisaiGroupNextId > 0 || parenetMeisaiId > 0)
                {
                    db1.KaikeiDenpyouMeisai.Update(denpyouRow);
                }
            }
        }
        static public void MargeKanjouKamoku(KaikeiDatabase db1, KaikeiDatabase db2)
        {
            kamokuKubunId2Id             = new Dictionary <int, int>();
            kanjouKamokuId2Id            = new Dictionary <int, int>();
            kamokuKubunId2KanjouKamokuId = new Dictionary <int, int>();

            AddKamokuKubun(db1, db2);
            AddKanjouKamoku(db1, db2);

            foreach (int kamokuKubunId in kamokuKubunId2Id.Values)
            {
                if (!kamokuKubunId2KanjouKamokuId.ContainsKey(kamokuKubunId))
                {
                    throw new Exception("kamoku_kubun has no kanjou_kamoku : " + kamokuKubunId);
                }
                Row row = db1.MTKamokuKubun.GetRowById(kamokuKubunId);
                row.Set("kanjou_kamoku_id", kamokuKubunId2KanjouKamokuId[kamokuKubunId]);
                db1.MTKamokuKubun.Update(row);
            }
        }
        static private void AddKamokuKubun(KaikeiDatabase db1, KaikeiDatabase db2)
        {
            foreach (Row row in db2.MTKamokuKubun.Select("order by id"))
            {
                int originalId = row.GetId();
                int parentId   = (int)row.GetLong("parent_id", -1);

                if (IsNewKamokuKubun(db1, db2, row))
                {
                    if (parentId == -1)
                    {
                    }
                    else if (kamokuKubunId2Id.ContainsKey(parentId))
                    {
                        row.Set("parent_id", kamokuKubunId2Id[parentId]);
                    }
                    else
                    {
                        Row parentRow = db1.MTKamokuKubun.GetRowById(parentId);
                        if (parentRow != null)
                        {
                            parentRow.Set("has_child", 1);
                            db1.MTKamokuKubun.Update(parentRow);
                        }
                        else
                        {
                            throw new Exception("unknown parent_id");
                        }
                    }

                    row.Set("kanjou_kamoku_id", -2);
                    row.RemoveColumn("id");
                    db1.MTKamokuKubun.Insert(row);
                    kamokuKubunId2Id[originalId] = db1.MTKamokuKubun.LastInsertedRow().GetId();
                }
            }
        }
Exemplo n.º 9
0
 public Context(db.KaikeiDatabase db)
 {
     KaikeiDatabase = db;
 }