コード例 #1
0
ファイル: Class1.cs プロジェクト: uvbs/FullSource
        public void ExportActivityDailyQuest(string strClient, SqlConnection Conn)
        {
            //ActivityInfo.txt
            string    sql1          = "select [ClassID],[ActivityID],[ClassName],[Title],[Content],[Link] from tbl_Guide_ActivityInfo where [ClassID] > -1 and [ActivityID] > -1 order by [ClassID],[ActivityID]";
            DataTable dt1           = RHelper.GetDataTableWithSqlProxy("tbl_Guide_ActivityInfo", sql1, Conn);
            string    content1      = TableToString(dt1);
            int       FirstReturn1  = content1.IndexOf("\r\n");
            string    stringBefore1 = content1.Substring(0, FirstReturn1 + 2);
            string    stringAfter1  = content1.Substring(FirstReturn1 + 2);
            string    stringMiddle1 = "0\t0\t\t\t\t\r\n";

            content1 = stringBefore1 + stringMiddle1 + stringAfter1;
            string out1 = string.Format("{0}/ui/scheme/case/cyclopaedia/ActivityInfo.txt", strClient);

            FileFolderHelper.StringToFile(content1, out1);

            //DailyQuestInfo.txt
            string    sql2          = "select [TypeID],[QuestID],[TypeName],[Content],[Link] from tbl_Guide_DailyQuestInfo where [TypeID] > -1 and [QuestID] > -1 order by [TypeID],[QuestID]";
            DataTable dt2           = RHelper.GetDataTableWithSqlProxy("tbl_Guide_DailyQuestInfo", sql2, Conn);
            string    content2      = TableToString(dt2);
            int       FirstReturn2  = content2.IndexOf("\r\n");
            string    stringBefore2 = content2.Substring(0, FirstReturn2 + 2);
            string    stringAfter2  = content2.Substring(FirstReturn2 + 2);
            string    stringMiddle2 = "0\t0\t\t\t\r\n";

            content2 = stringBefore2 + stringMiddle2 + stringAfter2;
            string out2 = string.Format("{0}/ui/scheme/case/cyclopaedia/DailyQuestInfo.txt", strClient);

            FileFolderHelper.StringToFile(content2, out2);
        }
コード例 #2
0
ファイル: Class1.cs プロジェクト: uvbs/FullSource
        public void ExportJx3Library(string strClient, SqlConnection Conn)
        {
            // JX3Library.txt
            string    sql1 = "select [ClassID],[SubClassID],[ID],[ClassName],[SubClassName],[Title],[Content],[Link] from tbl_Guide_JX3Library order by [ClassID],[SubClassID],[ID]";
            DataTable t1   = RHelper.GetDataTableWithSqlProxy("tbl_Guide_JX3Library", sql1, Conn);

            foreach (DataRow row in t1.Rows)
            {
                string content = row["Content"].ToString();
                int    nIndexP = 0;
                int    nIndexE = 0;

                nIndexP = content.IndexOf("\"");
                if (nIndexP == -1)
                {
                    continue;
                }
                nIndexE = content.IndexOf("\"", nIndexP + 1);

                string newContext = content.Substring(nIndexP + 1, nIndexE - nIndexP - 1).TrimEnd(new char[] { ' ', '\n' });
                newContext = newContext.Replace(" ", "  ");

                row["Content"] = content.Substring(0, nIndexP + 1) + newContext + content.Substring(nIndexE, content.Length - nIndexE);
            }
            string content1     = TableToString(t1);
            int    FirstReturn  = content1.IndexOf("\r\n");
            string stringBefore = content1.Substring(0, FirstReturn + 2);
            string stringAfter  = content1.Substring(FirstReturn + 2);
            string stringMiddle = "0\t0\t0\t\t\t\t\t\r\n";

            content1 = stringBefore + stringMiddle + stringAfter;
            string out1 = string.Format("{0}/ui/scheme/case/cyclopaedia/JX3Library.txt", strClient);

            FileFolderHelper.StringToFile(content1, out1);
        }
コード例 #3
0
ファイル: Class1.cs プロジェクト: uvbs/FullSource
        public void ExportFile(string strClient, SqlConnection Conn)
        {
            // CareerEvent.txt
            string    sql1     = "select [Level],[Name],[Title],[Introduction],[MapID1],[MapID2],[MapID3],[MapID4],[MapID5],[Tab0],[Tab1],[Tab2],[Tab3],[Tab4],[Tab5],[Tab6],[Tab7] from tbl_Guide_CareerEvent where [level]>0 or ([level]=0 and [tabid]=0) order by [level]";
            DataTable t1       = RHelper.GetDataTableWithSqlProxy("tbl_Guide_CareerEvent", sql1, Conn);
            string    content1 = TableToString(t1);
            string    out1     = string.Format("{0}/ui/scheme/case/cyclopaedia/CareerEvent.txt", strClient);

            FileFolderHelper.StringToFile(content1, out1);

            // CareerTab.txt
            string    sql2     = "select [TabID],[Name],[Title],[Image1],[Note1],[Image2],[Note2],[Image3],[Note3],[Description] from tbl_Guide_CareerEvent where [TabID]>=0 order by [tabid]";
            DataTable t2       = RHelper.GetDataTableWithSqlProxy("tbl_Guide_CareerEvent", sql2, Conn);
            string    content2 = TableToString(t2);
            string    out2     = string.Format("{0}/ui/scheme/case/cyclopaedia/CareerTab.txt", strClient);

            FileFolderHelper.StringToFile(content2, out2);
        }
コード例 #4
0
ファイル: Class1.cs プロジェクト: uvbs/FullSource
        public void ExportDungeon(string strClient, SqlConnection Conn)
        {
            //DungeonClass.txt
            string    sql1     = "select [ClassID],[ClassName],[Content],[Link] from tbl_Guide_Dungeon where [ClassID] > -1 and [MapID] = 0 order by [ClassID]";
            DataTable dt1      = RHelper.GetDataTableWithSqlProxy("tbl_Guide_ActivityInfo", sql1, Conn);
            string    content1 = TableToString(dt1);
            string    out1     = string.Format("{0}/ui/scheme/case/cyclopaedia/DungeonClass.txt", strClient);

            FileFolderHelper.StringToFile(content1, out1);

            //DungeonInfo.txt
            string    sql2          = "select [MapID],[ClassID],[MinLevel],[MaxLevel],[FitLevel],[EnterWay],[BossInfo],[Introduction] from tbl_Guide_Dungeon where [MapID] > 0 order by [MapID],[ClassID]";
            DataTable dt2           = RHelper.GetDataTableWithSqlProxy("tbl_Guide_Dungeon", sql2, Conn);
            string    content2      = TableToString(dt2);
            int       FirstReturn2  = content2.IndexOf("\r\n");
            string    stringBefore2 = content2.Substring(0, FirstReturn2 + 2);
            string    stringAfter2  = content2.Substring(FirstReturn2 + 2);
            string    stringMiddle2 = "0\t0\t0\t0\t0\t\t\t\r\n";

            content2 = stringBefore2 + stringMiddle2 + stringAfter2;
            string out2 = string.Format("{0}/ui/scheme/case/cyclopaedia/ActivityInfo.txt", strClient);

            FileFolderHelper.StringToFile(content2, out2);
        }