private void button1_Click(object sender, EventArgs e) { OpenFileDialog fileDialog = new OpenFileDialog(); fileDialog.Multiselect = true; fileDialog.Title = "请选择文件"; fileDialog.Filter = "所有文件(*.*)|*.*"; if (fileDialog.ShowDialog() == DialogResult.OK) { string file = fileDialog.FileName; if (file.Contains("LoginServer.ini") || file.Contains("loginserver.ini")) { txt_gameVerFile.Text = file; } else { MessageBox.Show("错误的文件,请重新选择!"); txt_gameVerFile.Text = "请选择版本文件!"; return; } } else { return; } //读取版本号到vertxt string CurVer = CIniCtrl.ReadIniData("System", "Version", "", txt_gameVerFile.Text); txt_gameVer.Text = CurVer; //保存次路径到工具配置文件 CIniCtrl.WriteIniData("Config", "gameVersionFile", txt_gameVerFile.Text, serverIni); }
private void load_Soul_Conf() { //读取武魂设置 string LoginServerFile = txt_svrForder.Text + "\\Login\\LoginServer.ini"; if (!File.Exists(LoginServerFile)) { return; } string tmp = ""; tmp = CIniCtrl.ReadIniData("soul", "ticket_weekday", "", LoginServerFile); txt_soulticketwdy.Text = tmp.Split(';')[0].Replace("\t", "").Replace(" ", ""); tmp = CIniCtrl.ReadIniData("soul", "ticket_sell", "", LoginServerFile); txt_soulsellday.Text = tmp.Split(';')[0].Replace("\t", "").Replace(" ", ""); tmp = CIniCtrl.ReadIniData("soul", "battle_weekday", "", LoginServerFile); txt_soulbattlwdy.Text = tmp.Split(';')[0].Replace("\t", "").Replace(" ", ""); tmp = CIniCtrl.ReadIniData("soul", "battle_time", "", LoginServerFile); txt_soulbattltime.Text = tmp.Split(';')[0].Replace("\t", "").Replace(" ", ""); tmp = CIniCtrl.ReadIniData("soul", "battle_period", "", LoginServerFile); txt_soulbattlperiod.Text = tmp.Split(';')[0].Replace("\t", "").Replace(" ", ""); }
public static string CmdGetVersion() { string ErrInfo = ""; try { string versionIni = System.AppDomain.CurrentDomain.BaseDirectory + verIni; //找出传递过来的用户名和密码 string ver = ""; string link = "111"; ver = CIniCtrl.ReadIniData("Config", "loginVersion", "", versionIni); if (File.Exists("D:\\sgserver\\FtpRoot\\Update.zip")) { System.IO.FileInfo f = new FileInfo("D:\\sgserver\\FtpRoot\\Update.zip"); ErrInfo = ver + "版本" + link + "长度" + f.Length.ToString(); } else { ErrInfo = ver + "版本" + link + "长度1"; } LogHelper.WriteLog(System.AppDomain.CurrentDomain.BaseDirectory, ErrInfo, new StackTrace(new StackFrame(true))); } catch (Exception ex) { LogHelper.WriteLog(System.AppDomain.CurrentDomain.BaseDirectory, ex.Message, new StackTrace(new StackFrame(true))); ErrInfo = "error"; } return(ErrInfo); }
private void btn_startQues_Click(object sender, EventArgs e) { if (!m_Active) { MessageBox.Show("软件尚未激活! 请联系软件发布人给予激活!"); return; } m_SGExHandle.LoadLoginServerPtr(""); if (txt_QusbankFile.Text == string.Empty) { MessageBox.Show("请选择题库!"); return; } if (txt_TaskTime.Text == string.Empty || txt_AskNormalInterval.Text == string.Empty || txt_AnswerVtId.Text == string.Empty || txt_AnswerVtName.Text == string.Empty || txt_QuesInterval.Text == string.Empty || txt_MaxQuesNum.Text == string.Empty) { MessageBox.Show("请确保[开始时间][普通题间隔][奖励id][奖励名称][出题总数][问答间隔]均设置成功!"); return; } //构建竞赛奖励字符串 string normalReward = rbx_QANormalDetil.Text; string taskReward = ""; for (int i = 1; i <= 10; i++) { string key = "m_TaskRecharge" + i; string reward = CIniCtrl.ReadIniData("Config", key, "", serverIni); if (reward != string.Empty && reward != "") { taskReward += reward + "&"; } } if (g_StopQues) { g_StopQues = false; btn_startQues.Text = "停止"; m_SleepCount = m_AskNormalInterval = UInt32.Parse(txt_AskNormalInterval.Text); m_AnswerVtId = UInt32.Parse(txt_AnswerVtId.Text); m_AnswerVtName = txt_AnswerVtName.Text; m_SGExHandle.SetConfigPath(txt_gameVerFile.Text); m_SGExHandle.LoadAQBank(txt_QusbankFile.Text); m_SGExHandle.SetQADatVt(txt_svrForder.Text + "\\DataBase\\saves\\players.dat"); m_SGExHandle.SetQAReward((int)m_AnswerVtId, m_AnswerVtName); m_SGExHandle.SetQANormalReward(normalReward); m_SGExHandle.SetQATaskReward(taskReward); m_SGExHandle.SetMaxQuesNum(g_MaxQuesNum); m_SGExHandle.SetNormalInterval((int)m_AskNormalInterval); m_SGExHandle.SetTaskTime(m_TaskDate, m_TaskTime); m_SGExHandle.StartQAThread(); } else { g_StopQues = true; btn_startQues.Text = "开始"; m_SGExHandle.StopQAThread(); } }
private void DoRcgLevelSelectedIndexChanged(string rcgLevel) { string rcgConf = CIniCtrl.ReadIniData(rcgLevel, "rcgConf", "", serverIni); string leftNum = CIniCtrl.ReadIniData(rcgLevel, "leftNum", "", serverIni); string rightNum = CIniCtrl.ReadIniData(rcgLevel, "rightNum", "", serverIni); cbx_rcgConf.Text = rcgConf; cbx_rcgConfNum.Text = rcgConf; txt_betmLeft.Text = leftNum; txt_betmRight.Text = rightNum; }
private void OnHandleRcgConfNum_SelectedIndexChanged(string conf_num) { serverIni = System.AppDomain.CurrentDomain.BaseDirectory + "配置文件.ini"; string id = ""; string name = ""; string num = ""; //读取 id = CIniCtrl.ReadIniData("Recharge", conf_num + "_id1", "", serverIni); name = CIniCtrl.ReadIniData("Recharge", conf_num + "_name1", "", serverIni); num = CIniCtrl.ReadIniData("Recharge", conf_num + "_num1", "", serverIni); //配置内容 txt_confId1.Text = id; txt_confName1.Text = name; txt_confNum1.Text = num; //读取 id = CIniCtrl.ReadIniData("Recharge", conf_num + "_id2", "", serverIni); name = CIniCtrl.ReadIniData("Recharge", conf_num + "_name2", "", serverIni); num = CIniCtrl.ReadIniData("Recharge", conf_num + "_num2", "", serverIni); //配置内容 txt_confId2.Text = id; txt_confName2.Text = name; txt_confNum2.Text = num; //读取 id = CIniCtrl.ReadIniData("Recharge", conf_num + "_id3", "", serverIni); name = CIniCtrl.ReadIniData("Recharge", conf_num + "_name3", "", serverIni); num = CIniCtrl.ReadIniData("Recharge", conf_num + "_num3", "", serverIni); //配置内容 txt_confId3.Text = id; txt_confName3.Text = name; txt_confNum3.Text = num; //读取 id = CIniCtrl.ReadIniData("Recharge", conf_num + "_id4", "", serverIni); name = CIniCtrl.ReadIniData("Recharge", conf_num + "_name4", "", serverIni); num = CIniCtrl.ReadIniData("Recharge", conf_num + "_num4", "", serverIni); //配置内容 txt_confId4.Text = id; txt_confName4.Text = name; txt_confNum4.Text = num; //读取 id = CIniCtrl.ReadIniData("Recharge", conf_num + "_id5", "", serverIni); name = CIniCtrl.ReadIniData("Recharge", conf_num + "_name5", "", serverIni); num = CIniCtrl.ReadIniData("Recharge", conf_num + "_num5", "", serverIni); //配置内容 txt_confId5.Text = id; txt_confName5.Text = name; txt_confNum5.Text = num; }
private void cbx_xbconf_SelectedIndexChanged(object sender, EventArgs e) { clear_xbConfItems(); xbconf_SelectedIndex = cbx_xbconf.SelectedIndex; string xbconfCap = "xbconfCap" + cbx_xbconf.SelectedIndex; string xbconfDesc = "xbconfDesc" + cbx_xbconf.SelectedIndex; txt_xbconfCap.Text = CIniCtrl.ReadIniData("XbConf", xbconfCap, "", serverIni); rbx_confDesc.Text = CIniCtrl.ReadIniData("XbConf", xbconfDesc, "", serverIni); //读取 string tmp = "xbconfItemsId" + cbx_xbconf.SelectedIndex; string ret = CIniCtrl.ReadIniData("XbConf", tmp, "", serverIni); var Ids = ret.Split(','); for (int i = 0; i < Ids.Length; i++) { string ctrlName = "txt_xbId" + (i + 1); Control col = this.groupBox17.Controls.Find(ctrlName, true)[0]; TextBox txt = col as TextBox;//转为TextBox txt.Text = Ids[i]; } tmp = "xbconfItemsName" + cbx_xbconf.SelectedIndex; ret = CIniCtrl.ReadIniData("XbConf", tmp, "", serverIni); var Names = ret.Split(','); for (int i = 0; i < Names.Length; i++) { string ctrlName = "txt_xbName" + (i + 1); Control col = this.groupBox17.Controls.Find(ctrlName, true)[0]; TextBox txt = col as TextBox;//转为TextBox txt.Text = Names[i]; } tmp = "xbconfItemsCount" + cbx_xbconf.SelectedIndex; ret = CIniCtrl.ReadIniData("XbConf", tmp, "", serverIni); var Counts = ret.Split(','); for (int i = 0; i < Counts.Length; i++) { string ctrlName = "txt_xbCount" + (i + 1); Control col = this.groupBox17.Controls.Find(ctrlName, true)[0]; TextBox txt = col as TextBox;//转为TextBox txt.Text = Counts[i]; } tmp = "xbconfDb" + cbx_xbconf.SelectedIndex; ret = CIniCtrl.ReadIniData("XbConf", tmp, "", serverIni); txt_dbSend.Text = ret; }
private void LoadXbMould() { for (int i = 0; i < cbx_xbconf.Items.Count; i++) { string xbconfCap = "xbconfCap" + i; string xbconfDesc = "xbconfDesc" + i; string cap = CIniCtrl.ReadIniData("XbConf", xbconfCap, "", serverIni); if (!string.IsNullOrEmpty(cap) && cap != "") { cbx_xbconf.Items[i] = cap; } } cbx_xbconf.SelectedIndex = 0; xbconf_SelectedIndex = 0; txt_xbconfCap.Text = CIniCtrl.ReadIniData("XbConf", "xbconfCap0", "", serverIni); rbx_confDesc.Text = CIniCtrl.ReadIniData("XbConf", "xbconfDesc0", "", serverIni); }
private void load_Process_Conf() { txt_ps1.Text = CIniCtrl.ReadIniData("Prosess", "ps1", "", serverIni); txt_ps2.Text = CIniCtrl.ReadIniData("Prosess", "ps2", "", serverIni); txt_ps3.Text = CIniCtrl.ReadIniData("Prosess", "ps3", "", serverIni); txt_ps4.Text = CIniCtrl.ReadIniData("Prosess", "ps4", "", serverIni); txt_ps5.Text = CIniCtrl.ReadIniData("Prosess", "ps5", "", serverIni); txt_ps6.Text = CIniCtrl.ReadIniData("Prosess", "ps6", "", serverIni); txt_ps7.Text = CIniCtrl.ReadIniData("Prosess", "ps7", "", serverIni); txt_ps8.Text = CIniCtrl.ReadIniData("Prosess", "ps8", "", serverIni); txt_ps9.Text = CIniCtrl.ReadIniData("Prosess", "ps9", "", serverIni); txt_ps10.Text = CIniCtrl.ReadIniData("Prosess", "ps10", "", serverIni); txt_ps11.Text = CIniCtrl.ReadIniData("Prosess", "ps11", "", serverIni); txt_ps12.Text = CIniCtrl.ReadIniData("Prosess", "ps12", "", serverIni); txt_ps13.Text = CIniCtrl.ReadIniData("Prosess", "ps13", "", serverIni); txt_ps14.Text = CIniCtrl.ReadIniData("Prosess", "ps14", "", serverIni); txt_ps15.Text = CIniCtrl.ReadIniData("Prosess", "ps15", "", serverIni); }
private void load_War_Conf() { //读取国战设置 string LoginServerFile = txt_svrForder.Text + "\\Login\\LoginServer.ini"; if (!File.Exists(LoginServerFile)) { return; } string tmp = ""; tmp = CIniCtrl.ReadIniData("System", "country_war_date", "", LoginServerFile); txt_wardate.Text = tmp.Split(';')[0].Replace("\t", "").Replace(" ", ""); tmp = CIniCtrl.ReadIniData("System", "country_war_time", "", LoginServerFile); txt_wartime.Text = tmp.Split(';')[0].Replace("\t", "").Replace(" ", ""); tmp = CIniCtrl.ReadIniData("System", "country_war_period", "", LoginServerFile); txt_warperiod.Text = tmp.Split(';')[0].Replace("\t", "").Replace(" ", ""); }
private void load_ServerPort_Conf() { //读取 //soldata/Server.ini string ServerFile = txt_svrForder.Text + "\\soldata\\Server.ini"; if (!File.Exists(ServerFile)) { return; } string loginPort = CIniCtrl.ReadIniData("LoginServer", "port", "", ServerFile); txt_loginPort.Text = loginPort; string DBPort = CIniCtrl.ReadIniData("DBServer", "port", "", ServerFile); txt_dbPort.Text = DBPort; string logPort = CIniCtrl.ReadIniData("LogServer", "port", "", ServerFile); txt_logPort.Text = logPort; string accountPort = CIniCtrl.ReadIniData("AccountServer", "port", "", ServerFile); txt_accountPort.Text = accountPort; string VTPort = CIniCtrl.ReadIniData("VTServer", "port", "", ServerFile); txt_VTPort.Text = VTPort; //map //string mapPort = ""; //var list = CIniCtrlComm.ReadValues(ServerFile); //foreach (var item in list) //{ // if (item.Section == "MapServer") // { // mapPort += item.GetComment("port") + ","; // } //} //txt_mapPort.Text = mapPort; string mapPort = ""; FileStream rdfs = new FileStream(ServerFile, FileMode.Open, FileAccess.Read); StreamReader rd = new StreamReader(rdfs, Encoding.ASCII); rd.BaseStream.Seek(0, SeekOrigin.Begin); rd.DiscardBufferedData(); rd.BaseStream.Seek(0, SeekOrigin.Begin); rd.BaseStream.Position = 0; string strLine = ""; strLine = ""; strLine = rd.ReadLine(); string map_session = ""; do { if (strLine.Contains("[MapServer]")) { map_session = "MapServer"; } if (strLine.Contains("port") && map_session == "MapServer") { string map_port = strLine.Split('=')[1]; mapPort += map_port + ","; map_session = ""; } strLine = ""; strLine = rd.ReadLine(); } while (strLine != null); rd.Close(); rdfs.Close(); txt_mapPort.Text = mapPort.Replace(" ", ""); }
private void cbc_QATaskIndex_SelectedIndexChanged(object sender, EventArgs e) { string key = "m_TaskRecharge" + cbc_QATaskIndex.Text; rbx_QATaskDetil.Text = CIniCtrl.ReadIniData("Config", key, "", serverIni); }
private void LoadIniConf() { #region //sgserver信息 string srvAddr = CIniCtrl.ReadIniData("Server", "ServerIP", "", serverIni); if (srvAddr != "") { sql_srvAddr = srvAddr; txt_sqlsvr.Text = sql_srvAddr; } string srvPort = CIniCtrl.ReadIniData("Server", "SqlPort", "", serverIni); if (srvPort == "") { CIniCtrl.WriteIniData("Server", "SqlPort", "1433", serverIni); } else { sql_srvPort = srvPort; txt_sqlPort.Text = sql_srvPort; } string srvUser = CIniCtrl.ReadIniData("Server", "SqlAccount", "", serverIni); if (srvUser != "") { sql_srvUser = srvUser; txt_sqlAcc.Text = sql_srvUser; } string srvPwd = CIniCtrl.ReadIniData("Server", "SqlPasswd", "", serverIni); if (srvPwd != "") { sql_srvPwd = srvPwd; txt_sqlPwd.Text = sql_srvPwd; } string mrgPort = CIniCtrl.ReadIniData("Server", "ListenPort", "", serverIni); if (mrgPort != "") { accMrgPort = mrgPort; txt_accMrgPort.Text = accMrgPort; } string sqlAccount = CIniCtrl.ReadIniData("Server", "AccountName", "", serverIni); if (sqlAccount != "") { sqlAccountName = sqlAccount; txt_sqlAccountName.Text = sqlAccountName; } string sqlSanvt = CIniCtrl.ReadIniData("Server", "SanvtName", "", serverIni); if (sqlSanvt != "") { sqlSanvtName = sqlSanvt; txt_sqlSanvtName.Text = sqlSanvtName; } string sqlLog = CIniCtrl.ReadIniData("Server", "LogName", "", serverIni); if (sqlLog != "") { sqlLogName = sqlLog; txt_sqlLogName.Text = sqlLogName; } #endregion #region //版本管理 string gameVersionFile = CIniCtrl.ReadIniData("Config", "gameVersionFile", "", serverIni); if (gameVersionFile != "") { if (gameVersionFile.Contains("LoginServer.ini") || gameVersionFile.Contains("loginserver.ini")) { txt_gameVerFile.Text = gameVersionFile; //读取版本号到vertxt string CurVer = CIniCtrl.ReadIniData("System", "Version", "", txt_gameVerFile.Text); txt_gameVer.Text = CurVer; m_SGExHandle.SetConfigPath(txt_gameVerFile.Text); } else { txt_gameVerFile.Text = "请选择版本文件!"; } } string loginVersion = CIniCtrl.ReadIniData("Config", "loginVersion", "", serverIni); if (loginVersion != "") { txt_loginVer.Text = loginVersion; } string gameServerFolder = CIniCtrl.ReadIniData("Config", "gameServerFolder", "", serverIni); if (gameServerFolder != "") { txt_svrForder.Text = gameServerFolder; } string gServerIp = CIniCtrl.ReadIniData("Server", "GServerIP", "", serverIni); if (gServerIp != "") { txt_GServerIP.Text = gServerIp; } string gameFreezeFilter = CIniCtrl.ReadIniData("Config", "FreezeFilter", "", serverIni); if (gameFreezeFilter != "") { rtb_FreezeFilter.Text = gameFreezeFilter; m_FreezeFilterList = rtb_FreezeFilter.Text.Split(','); } #endregion #region //外挂检测 string gameAutoFreeze = CIniCtrl.ReadIniData("Config", "AutoFreeze", "", serverIni); if (gameServerFolder != "" && gameAutoFreeze == "Enable") { cbx_AutoFreeze.Checked = true; btn_startListen_Click(null, null); } else { cbx_AutoFreeze.Checked = false; } #endregion #region //在线答题 FillQAItemsView(); rbx_QANormalDetil.Text = CIniCtrl.ReadIniData("Config", "m_NormalRecharge", "", serverIni); rbx_QATaskDetil.Text = CIniCtrl.ReadIniData("Config", "m_TaskRecharge1", "", serverIni); string quesBankFile = CIniCtrl.ReadIniData("Config", "QuesBankFile", "", serverIni); txt_QusbankFile.Text = quesBankFile; txt_TaskDate.Text = CIniCtrl.ReadIniData("Config", "TaskDate", "", serverIni); if (txt_TaskDate.Text != string.Empty) { var dates = txt_TaskDate.Text.Split(','); m_TaskDate.Clear(); foreach (var date in dates) { m_TaskDate.Add(int.Parse(date)); } } txt_TaskTime.Text = CIniCtrl.ReadIniData("Config", "TaskTime", "", serverIni); if (txt_TaskTime.Text != string.Empty) { var times = txt_TaskTime.Text.Split(';'); m_TaskTime.Clear(); foreach (var time in times) { m_TaskTime.Add(time); } } string maxQuesNum = CIniCtrl.ReadIniData("Config", "MaxQuesNum", "", serverIni); if (maxQuesNum != string.Empty) { txt_MaxQuesNum.Text = maxQuesNum; g_MaxQuesNum = int.Parse(maxQuesNum); } string quesInterval = CIniCtrl.ReadIniData("Config", "QuesInterval", "", serverIni); if (quesInterval != string.Empty) { txt_QuesInterval.Text = quesInterval; g_QuesInterval = int.Parse(quesInterval); } string _AskNormalInterval = CIniCtrl.ReadIniData("Config", "m_AskNormalInterval", "", serverIni); if (_AskNormalInterval != string.Empty) { txt_AskNormalInterval.Text = _AskNormalInterval; m_AskNormalInterval = UInt32.Parse(_AskNormalInterval); } string _AnswerVtId = CIniCtrl.ReadIniData("Config", "m_AnswerVtId", "", serverIni); if (_AskNormalInterval != string.Empty) { txt_AnswerVtId.Text = _AnswerVtId; m_AnswerVtId = UInt32.Parse(_AnswerVtId); } string _AnswerVtName = CIniCtrl.ReadIniData("Config", "m_AnswerVtName", "", serverIni); m_AnswerVtName = _AnswerVtName; txt_AnswerVtName.Text = _AnswerVtName; string gameAutoStartQues = CIniCtrl.ReadIniData("Config", "AutoStartQues", "", serverIni); if (gameAutoStartQues != "" && gameAutoStartQues == "Enable") { cbx_AutoStartQues.Checked = true; btn_startQues_Click(null, null); } else { cbx_AutoStartQues.Checked = false; } #endregion #region //加持公告 string _15SrchInterval = CIniCtrl.ReadIniData("Config", "15SrchInterval", "", serverIni); if (_15SrchInterval != string.Empty) { g_15SrchInterval = int.Parse(_15SrchInterval); txt_15srchInterval.Text = _15SrchInterval; } string _15MaxAnn = CIniCtrl.ReadIniData("Config", "15MaxAnn", "", serverIni); if (_15MaxAnn != string.Empty) { g_15MaxAnn = _15MaxAnn; txt_15MaxAnn.Text = _15MaxAnn; } string _AnnItemsFile = CIniCtrl.ReadIniData("Config", "AnnItemsFile", "", serverIni); if (_AnnItemsFile != string.Empty) { txt_AnnItemsFile.Text = _AnnItemsFile; if (File.Exists(txt_AnnItemsFile.Text)) { rbx_DorpTalkItems.Text = File.ReadAllText(txt_AnnItemsFile.Text, Encoding.Default); } } string _15NameFilter = CIniCtrl.ReadIniData("Config", "15NameFilter", "", serverIni); g_15NameFilter = _15NameFilter; rbx_15NameFilter.Text = _15NameFilter; string game15TalkAutoStart = CIniCtrl.ReadIniData("Config", "15TalkAutoStart", "", serverIni); if (game15TalkAutoStart != "" && game15TalkAutoStart == "Enable") { cbx_AutoStart15Talk.Checked = true; btn_15Talk_Click(null, null); } else { cbx_AutoStart15Talk.Checked = false; } #endregion #region //系统公告 string liststring = CIniCtrl.ReadIniData("Config", "WorldWordsList", "", serverIni); if (liststring != string.Empty) { var list = liststring.Split(';'); listBox1.Items.Clear(); foreach (var it in list) { listBox1.Items.Add(it); } listBox1.Update(); } #endregion }
private void btn_rcgInit_Click(object sender, EventArgs e) { if (btn_sql.Text == "连接数据库") { MessageBox.Show("请先连接数据库!"); return; } //加载设定的配置 Recharge_Conf[] conf = new Recharge_Conf[7]; for (int i = 0; i < 7; i++) { string rcgLevel = "档位:" + (i + 1); string rcgConf = CIniCtrl.ReadIniData(rcgLevel, "rcgConf", "", serverIni); string leftNum = CIniCtrl.ReadIniData(rcgLevel, "leftNum", "", serverIni); string rightNum = CIniCtrl.ReadIniData(rcgLevel, "rightNum", "", serverIni); string id = ""; string name = ""; string num = ""; //读取 id = CIniCtrl.ReadIniData("Recharge", rcgConf + "_id1", "", serverIni); name = CIniCtrl.ReadIniData("Recharge", rcgConf + "_name1", "", serverIni); num = CIniCtrl.ReadIniData("Recharge", rcgConf + "_num1", "", serverIni); //配置内容 conf[i].id1 = id == "" ? "0" : id; conf[i].name1 = name == "" ? "空" : name; conf[i].num1 = num == "" ? "0" : num; //读取 id = CIniCtrl.ReadIniData("Recharge", rcgConf + "_id2", "", serverIni); name = CIniCtrl.ReadIniData("Recharge", rcgConf + "_name2", "", serverIni); num = CIniCtrl.ReadIniData("Recharge", rcgConf + "_num2", "", serverIni); //配置内容 conf[i].id2 = id == "" ? "0" : id; conf[i].name2 = name == "" ? "空" : name; conf[i].num2 = num == "" ? "0" : num; //读取 id = CIniCtrl.ReadIniData("Recharge", rcgConf + "_id3", "", serverIni); name = CIniCtrl.ReadIniData("Recharge", rcgConf + "_name3", "", serverIni); num = CIniCtrl.ReadIniData("Recharge", rcgConf + "_num3", "", serverIni); //配置内容 conf[i].id3 = id == "" ? "0" : id; conf[i].name3 = name == "" ? "空" : name; conf[i].num3 = num == "" ? "0" : num; //读取 id = CIniCtrl.ReadIniData("Recharge", rcgConf + "_id4", "", serverIni); name = CIniCtrl.ReadIniData("Recharge", rcgConf + "_name4", "", serverIni); num = CIniCtrl.ReadIniData("Recharge", rcgConf + "_num4", "", serverIni); //配置内容 conf[i].id4 = id == "" ? "0" : id; conf[i].name4 = name == "" ? "空" : name; conf[i].num4 = num == "" ? "0" : num; //读取 id = CIniCtrl.ReadIniData("Recharge", rcgConf + "_id5", "", serverIni); name = CIniCtrl.ReadIniData("Recharge", rcgConf + "_name5", "", serverIni); num = CIniCtrl.ReadIniData("Recharge", rcgConf + "_num5", "", serverIni); //配置内容 conf[i].id5 = id == "" ? "0" : id; conf[i].name5 = name == "" ? "空" : name; conf[i].num5 = num == "" ? "0" : num; leftNum = leftNum == "" ? "0" : leftNum; rightNum = rightNum == "" ? "-1" : rightNum; if (Int32.Parse(leftNum) >= Int32.Parse(rightNum)) { conf[i].leftNum = "0"; conf[i].rightNum = "-1"; } else { conf[i].leftNum = leftNum; conf[i].rightNum = rightNum; } } string cmd = ""; string ret = ""; //删除[recharge_history]表 cmd = @"DROP TABLE recharge_history"; ret = CSGHelper.SqlCommand(cmd); if (ret != "success") { MessageBox.Show("删除[recharge_history]表失败!"); //return; } //删除game_acc 的 Account_Insert触发器 cmd = @"drop trigger Account_Insert "; ret = CSGHelper.SqlCommand(cmd); if (ret != "success") { MessageBox.Show("删除game_acc 的 Account_Insert触发器失败!"); //return; } //创建[recharge_history]表 cmd = @"create table [recharge_history] ( account varchar(21) PRIMARY KEY, point int default 0, time datetime )"; ret = CSGHelper.SqlCommand(cmd); if (ret != "success") { MessageBox.Show("创建[recharge_history]表失败!"); return; } //同步账户名 cmd = @"insert INTO recharge_history(account,point) SELECT account,point FROM game_acc"; ret = CSGHelper.SqlCommand(cmd); if (ret != "success") { MessageBox.Show("同步game_acc账户名和point到recharge_history失败!"); return; } //创建game_acc 的 Account_Insert触发器,game_acc有插入时同样插入信息到recharge_history cmd = @"CREATE TRIGGER Account_Insert ON dbo.game_acc FOR INSERT AS DECLARE @account varchar(21) Select @account=account from inserted insert INTO recharge_history(account,point) values (@account,0)"; ret = CSGHelper.SqlCommand(cmd); if (ret != "success") { MessageBox.Show("创建game_acc 的 Account_Insert触发器失败!"); return; } //创建recharge_history 的 Recharge_Update触发器,充值更新point,触发更新game_acc的point cmd = @"CREATE TRIGGER Recharge_Update ON dbo.recharge_history FOR UPDATE AS DECLARE @account varchar(21) DECLARE @point int DECLARE @old_point int DECLARE @add_point int DECLARE @old_point_acc int DECLARE @new_point_acc int Select @account=account from inserted Select @point=point from inserted SELECT @old_point=point FROM DELETED SET @add_point = @point - @old_point Select @old_point_acc=point from dbo.game_acc where account = @account set @new_point_acc = @old_point_acc + @add_point Update dbo.game_acc set point = @new_point_acc where account = @account DECLARE @cardid varchar(100) DECLARE @dtDate datetime set @dtDate = getdate() SET @cardid = CONVERT(varchar(100), GETDATE(), 21) PRINT @cardid DECLARE @DataID1 int DECLARE @Number1 int DECLARE @DataID2 int DECLARE @Number2 int DECLARE @DataID3 int DECLARE @Number3 int DECLARE @DataID4 int DECLARE @Number4 int DECLARE @DataID5 int DECLARE @Number5 int set @DataID1 = 0 set @Number1 = 0 set @DataID2 = 0 set @Number2 = 0 set @DataID3 = 0 set @Number3 = 0 set @DataID4 = 0 set @Number4 = 0 set @DataID5 = 0 set @Number5 = 0 if (@add_point >= " + conf[0].leftNum + " AND @add_point < " + conf[0].rightNum + @") begin set @DataID1 = " + conf[0].id1 + @" set @Number1 = " + conf[0].num1 + @" set @DataID2 = " + conf[0].id2 + @" set @Number2 = " + conf[0].num2 + @" set @DataID3 = " + conf[0].id3 + @" set @Number3 = " + conf[0].num3 + @" set @DataID4 = " + conf[0].id4 + @" set @Number4 = " + conf[0].num4 + @" set @DataID5 = " + conf[0].id5 + @" set @Number5 = " + conf[0].num5 + @" end else if (@add_point >= " + conf[1].leftNum + " AND @add_point < " + conf[1].rightNum + @") begin set @DataID1 = " + conf[1].id1 + @" set @Number1 = " + conf[1].num1 + @" set @DataID2 = " + conf[1].id2 + @" set @Number2 = " + conf[1].num2 + @" set @DataID3 = " + conf[1].id3 + @" set @Number3 = " + conf[1].num3 + @" set @DataID4 = " + conf[1].id4 + @" set @Number4 = " + conf[1].num4 + @" set @DataID5 = " + conf[1].id5 + @" set @Number5 = " + conf[1].num5 + @" end else if (@add_point >= " + conf[2].leftNum + " AND @add_point < " + conf[2].rightNum + @") begin set @DataID1 = " + conf[2].id1 + @" set @Number1 = " + conf[2].num1 + @" set @DataID2 = " + conf[2].id2 + @" set @Number2 = " + conf[2].num2 + @" set @DataID3 = " + conf[2].id3 + @" set @Number3 = " + conf[2].num3 + @" set @DataID4 = " + conf[2].id4 + @" set @Number4 = " + conf[2].num4 + @" set @DataID5 = " + conf[2].id5 + @" set @Number5 = " + conf[2].num5 + @" end else if (@add_point >= " + conf[3].leftNum + " AND @add_point < " + conf[3].rightNum + @") begin set @DataID1 = " + conf[3].id1 + @" set @Number1 = " + conf[3].num1 + @" set @DataID2 = " + conf[3].id2 + @" set @Number2 = " + conf[3].num2 + @" set @DataID3 = " + conf[3].id3 + @" set @Number3 = " + conf[3].num3 + @" set @DataID4 = " + conf[3].id4 + @" set @Number4 = " + conf[3].num4 + @" set @DataID5 = " + conf[3].id5 + @" set @Number5 = " + conf[3].num5 + @" end else if (@add_point >= " + conf[4].leftNum + " AND @add_point < " + conf[4].rightNum + @") begin set @DataID1 = " + conf[4].id1 + @" set @Number1 = " + conf[4].num1 + @" set @DataID2 = " + conf[4].id2 + @" set @Number2 = " + conf[4].num2 + @" set @DataID3 = " + conf[4].id3 + @" set @Number3 = " + conf[4].num3 + @" set @DataID4 = " + conf[4].id4 + @" set @Number4 = " + conf[4].num4 + @" set @DataID5 = " + conf[4].id5 + @" set @Number5 = " + conf[4].num5 + @" end else if (@add_point >= " + conf[5].leftNum + " AND @add_point < " + conf[5].rightNum + @") begin set @DataID1 = " + conf[5].id1 + @" set @Number1 = " + conf[5].num1 + @" set @DataID2 = " + conf[5].id2 + @" set @Number2 = " + conf[5].num2 + @" set @DataID3 = " + conf[5].id3 + @" set @Number3 = " + conf[5].num3 + @" set @DataID4 = " + conf[5].id4 + @" set @Number4 = " + conf[5].num4 + @" set @DataID5 = " + conf[5].id5 + @" set @Number5 = " + conf[5].num5 + @" end else if (@add_point >= " + conf[6].leftNum + " AND @add_point < " + conf[6].rightNum + @") begin set @DataID1 = " + conf[6].id1 + @" set @Number1 = " + conf[6].num1 + @" set @DataID2 = " + conf[6].id2 + @" set @Number2 = " + conf[6].num2 + @" set @DataID3 = " + conf[6].id3 + @" set @Number3 = " + conf[6].num3 + @" set @DataID4 = " + conf[6].id4 + @" set @Number4 = " + conf[6].num4 + @" set @DataID5 = " + conf[6].id5 + @" set @Number5 = " + conf[6].num5 + @" end INSERT INTO " + txt_sanvtName.Text + @".dbo.vitem (Account,Disable,Card,Login_time,Get_time,SName,CharName,Type, DataID1,Number1,DataID2,Number2,DataID3,Number3,DataID4,Number4,DataID5,Number5) values (@account,0,@cardid,@dtDate,@dtDate,0,0,0, @DataID1,@Number1,@DataID2,@Number2,@DataID3,@Number3,@DataID4,@Number4,@DataID5,@Number5)"; ret = CSGHelper.SqlCommand(cmd); if (ret == "success") { string msg = @"当前设定如下: 本服不设定非固定充值,非以下固定充值将以第三方设置比例结算。 (1)范围:" + conf[0].leftNum + "-" + conf[0].rightNum + "额外获得:" + conf[0].name1 + "*" + conf[0].num1 + ";" + conf[0].name2 + "*" + conf[0].num2 + ";" + conf[0].name3 + "*" + conf[0].num3 + ";" + conf[0].name4 + "*" + conf[0].num4 + ";" + conf[0].name5 + "*" + conf[0].num5 + @"; (2)范围:" + conf[1].leftNum + "-" + conf[1].rightNum + "额外获得:" + conf[1].name1 + "*" + conf[1].num1 + ";" + conf[1].name2 + "*" + conf[1].num2 + ";" + conf[1].name3 + "*" + conf[1].num3 + ";" + conf[1].name4 + "*" + conf[1].num4 + ";" + conf[1].name5 + "*" + conf[1].num5 + @"; (3)范围:" + conf[2].leftNum + "-" + conf[2].rightNum + "额外获得:" + conf[2].name1 + "*" + conf[2].num1 + ";" + conf[2].name2 + "*" + conf[2].num2 + ";" + conf[2].name3 + "*" + conf[2].num3 + ";" + conf[2].name4 + "*" + conf[2].num4 + ";" + conf[2].name5 + "*" + conf[2].num5 + @"; (4)范围:" + conf[3].leftNum + "-" + conf[3].rightNum + "额外获得:" + conf[3].name1 + "*" + conf[3].num1 + ";" + conf[3].name2 + "*" + conf[3].num2 + ";" + conf[3].name3 + "*" + conf[3].num3 + ";" + conf[3].name4 + "*" + conf[3].num4 + ";" + conf[3].name5 + "*" + conf[3].num5 + @"; (5)范围:" + conf[4].leftNum + "-" + conf[4].rightNum + "额外获得:" + conf[4].name1 + "*" + conf[4].num1 + ";" + conf[4].name2 + "*" + conf[4].num2 + ";" + conf[4].name3 + "*" + conf[4].num3 + ";" + conf[4].name4 + "*" + conf[4].num4 + ";" + conf[4].name5 + "*" + conf[4].num5 + @"; (6)范围:" + conf[5].leftNum + "-" + conf[5].rightNum + "额外获得:" + conf[5].name1 + "*" + conf[5].num1 + ";" + conf[5].name2 + "*" + conf[5].num2 + ";" + conf[5].name3 + "*" + conf[5].num3 + ";" + conf[5].name4 + "*" + conf[5].num4 + ";" + conf[5].name5 + "*" + conf[5].num5 + @"; (6)范围:" + conf[6].leftNum + "-" + conf[6].rightNum + "额外获得:" + conf[6].name1 + "*" + conf[6].num1 + ";" + conf[6].name2 + "*" + conf[6].num2 + ";" + conf[6].name3 + "*" + conf[6].num3 + ";" + conf[6].name4 + "*" + conf[6].num4 + ";" + conf[6].name5 + "*" + conf[6].num5 + @";"; MessageBox.Show(msg); } else { MessageBox.Show("创建recharge_history 的 Recharge_Update触发器失败!"); return; } }