private void btn_AccountReflush_Click(object sender, EventArgs e) { CPlayerCtrl.LoadPlayerInfos(txt_svrForder.Text + "\\DataBase\\saves\\players.dat", true); List <Account> infos = CSGHelper.SelectAcountInfo(); lstv_Account.Items.Clear(); foreach (var info in infos) { //构建一个ListView的数据,存入数据库数据,以便添加到listView1的行数据中 ListViewItem lt = new ListViewItem(); //将数据库数据转变成ListView类型的一行数据 lt.Text = info.account; lt.SubItems.Add(info.password); lt.SubItems.Add(CPlayerCtrl.GetNameByAcc(lt.Text)); lt.SubItems.Add(info.enable); lt.SubItems.Add(info.privilege); lt.SubItems.Add(info.point); lt.SubItems.Add(info.ip); lt.SubItems.Add(info.LastLoginTime); lt.SubItems.Add(info.LastLogoutTime); //将lt数据添加到listView1控件中 lstv_Account.Items.Add(lt); } lstv_Account.EndUpdate(); lbl_AccountCount.Text = "帐号总数:" + infos.Count; }
public static bool InsertSanvtItem(string sanvtName, string account , UInt32 DataID1, UInt32 Number1 , UInt32 DataID2, UInt32 Number2 , UInt32 DataID3, UInt32 Number3 , UInt32 DataID4, UInt32 Number4 , UInt32 DataID5, UInt32 Number5) { if (sanvtName == string.Empty || account == string.Empty) { return(false); } if (DataID1 == 0 && Number1 == 0 && DataID2 == 0 && Number2 == 0 && DataID3 == 0 && Number3 == 0 && DataID4 == 0 && Number4 == 0 && DataID5 == 0 && Number5 == 0) { return(false); } string cmd = "INSERT INTO " + sanvtName + @".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,'" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "',getdate(),getdate(),0,0,0," + "" + DataID1 + "," + Number1 + "," + DataID2 + "," + Number2 + "," + DataID3 + "," + Number3 + "," + DataID4 + "," + Number4 + "," + DataID5 + "," + Number5 + ")"; string ret = CSGHelper.SqlCommand(cmd); if (ret != "success") { return(false); } return(true); }
private void btn_AcountAdd_Click(object sender, EventArgs e) { string account = txt_AcountName.Text; string pwd = txt_AcountPwd.Text; string result = CSGHelper.CreateAccount(account, pwd); MessageBox.Show(result); }
private void btn_AcountMdifyPwd_Click(object sender, EventArgs e) { string account = txt_AcountName.Text; string pwd = txt_AcountPwd.Text; string pwdnew = txt_AcountNewPwd.Text; string result = CSGHelper.ModifyPwd(account, pwd, pwdnew); MessageBox.Show(result); }
private void btn_sql_Click(object sender, EventArgs e) { if (!m_Active) { MessageBox.Show("软件尚未激活! 请联系软件发布人给予激活!"); return; } CSGHelper.SetSQLNames(txt_sqlAccountName.Text, txt_sqlSanvtName.Text, txt_sqlLogName.Text); if (btn_sql.Text == "连接数据库") { //连接数据库 string conn_str = "Data Source = " + sql_srvAddr + "," + sql_srvPort + "; Initial Catalog = " + txt_sqlAccountName.Text + "; User Id = " + sql_srvUser + "; Password = "******";"; //string conn_str = "server = " + sql_srvAddr + "," + sql_srvPort + "; database = " + txt_sqlAccountName.Text + "; uid = " + sql_srvUser + "; pwd = " + sql_srvPwd + ";"; if (!CSGHelper.SqlConn(conn_str)) { MessageBox.Show("数据库连接失败!"); return; } else { MessageBox.Show("数据库连接成功!"); btn_sql.Text = "断开连接"; lbl_sqlStatus.Text = "数据库已连接"; txt_sqlsvr.ReadOnly = true; txt_sqlPort.ReadOnly = true; txt_sqlAcc.ReadOnly = true; txt_sqlPwd.ReadOnly = true; txt_sqlAccountName.ReadOnly = true; txt_sqlSanvtName.ReadOnly = true; txt_sqlLogName.ReadOnly = true; } } else { if (!CSGHelper.SqlClose()) { MessageBox.Show("断开数据库连接失败!"); return; } else { btn_sql.Text = "连接数据库"; lbl_sqlStatus.Text = "数据库未连接"; txt_sqlsvr.ReadOnly = false; txt_sqlPort.ReadOnly = false; txt_sqlAcc.ReadOnly = false; txt_sqlPwd.ReadOnly = false; txt_sqlAccountName.ReadOnly = false; txt_sqlSanvtName.ReadOnly = false; txt_sqlLogName.ReadOnly = false; } } }
private void lstv_xbAcc_SelectedIndexChanged(object sender, EventArgs e) { if (lstv_xbAcc.SelectedIndices != null && lstv_xbAcc.SelectedIndices.Count > 0) { lstv_xbAcc.Items[xbPlayersInfoSltIndex].BackColor = Color.Transparent; xbPlayersInfoSltIndex = this.lstv_xbAcc.SelectedItems[0].Index; lstv_xbAcc.Items[xbPlayersInfoSltIndex].BackColor = Color.Pink; txt_xbAccount.Text = lstv_xbAcc.Items[xbPlayersInfoSltIndex].SubItems[0].Text; txt_xbName.Text = lstv_xbAcc.Items[xbPlayersInfoSltIndex].SubItems[1].Text; //查询代币 txt_dbCurr.Text = "" + CSGHelper.SelectAcountPoint(txt_xbAccount.Text); } }
private void lstv_xblog_SelectedIndexChanged(object sender, EventArgs e) { // if (lstv_xblog.SelectedIndices != null && lstv_xblog.SelectedIndices.Count > 0) { lstv_xblog.Items[xblogSltIndex].BackColor = Color.Transparent; xblogSltIndex = this.lstv_xblog.SelectedItems[0].Index; lstv_xblog.Items[xblogSltIndex].BackColor = Color.Pink; txt_xbAccount.Text = lstv_xblog.Items[xblogSltIndex].SubItems[0].Text; txt_xbName.Text = lstv_xblog.Items[xblogSltIndex].SubItems[1].Text; txt_xbId1.Text = lstv_xblog.Items[xblogSltIndex].SubItems[2].Text; txt_xbName1.Text = lstv_xblog.Items[xblogSltIndex].SubItems[3].Text; txt_xbCount1.Text = lstv_xblog.Items[xblogSltIndex].SubItems[4].Text; txt_xbId2.Text = lstv_xblog.Items[xblogSltIndex].SubItems[5].Text; txt_xbName2.Text = lstv_xblog.Items[xblogSltIndex].SubItems[6].Text; txt_xbCount2.Text = lstv_xblog.Items[xblogSltIndex].SubItems[7].Text; txt_xbId3.Text = lstv_xblog.Items[xblogSltIndex].SubItems[8].Text; txt_xbName3.Text = lstv_xblog.Items[xblogSltIndex].SubItems[9].Text; txt_xbCount3.Text = lstv_xblog.Items[xblogSltIndex].SubItems[10].Text; txt_xbId4.Text = lstv_xblog.Items[xblogSltIndex].SubItems[11].Text; txt_xbName4.Text = lstv_xblog.Items[xblogSltIndex].SubItems[12].Text; txt_xbCount4.Text = lstv_xblog.Items[xblogSltIndex].SubItems[13].Text; txt_xbId5.Text = lstv_xblog.Items[xblogSltIndex].SubItems[14].Text; txt_xbName5.Text = lstv_xblog.Items[xblogSltIndex].SubItems[15].Text; txt_xbCount5.Text = lstv_xblog.Items[xblogSltIndex].SubItems[16].Text; txt_xbId6.Text = ""; txt_xbName6.Text = ""; txt_xbCount6.Text = ""; txt_xbId7.Text = ""; txt_xbName7.Text = ""; txt_xbCount7.Text = ""; txt_xbId8.Text = ""; txt_xbName8.Text = ""; txt_xbCount8.Text = ""; txt_xbId9.Text = ""; txt_xbName9.Text = ""; txt_xbCount9.Text = ""; txt_xbId10.Text = ""; txt_xbName10.Text = ""; txt_xbCount10.Text = ""; //查询代币 txt_dbCurr.Text = "" + CSGHelper.SelectAcountPoint(txt_xbAccount.Text); } }
private void btn_FreezeListAcc_Click(object sender, EventArgs e) { for (int i = 0; i < lstv_GtList.Items.Count; i++) { string acc = lstv_GtList.Items[i].SubItems[0].Text; //封号 try { string log = CSGHelper.FreezeAccount(acc, 1, "非法登录或者使用外挂!", "GM"); LogHelper.WriteLog(System.AppDomain.CurrentDomain.BaseDirectory, acc + ":" + log, new StackTrace(new StackFrame(true))); } catch (Exception ex) { LogHelper.WriteLog(System.AppDomain.CurrentDomain.BaseDirectory, acc + ":" + ex.Message, new StackTrace(new StackFrame(true))); } } }
public static string CmdModyPwd(Mdfy_Pwd_Info modyInfo) { string ErrInfo = ""; try { //找出传递过来的用户名和密码 string name = ""; string oldpasswd = ""; string newpasswd = ""; if (modyInfo.key == "110") { name = modyInfo.name; oldpasswd = modyInfo.oldpasswd; newpasswd = modyInfo.newpasswd; ErrInfo = CSGHelper.ModifyPwd(name, oldpasswd, newpasswd); LogHelper.WriteLog(System.AppDomain.CurrentDomain.BaseDirectory, "ModifyPwd name:" + name + "\toldpasswd:" + oldpasswd + "\tnewpasswd:" + newpasswd, new StackTrace(new StackFrame(true))); } else { name = CSecurity.DecryptDES(modyInfo.name, modyInfo.key); oldpasswd = CSecurity.DecryptDES(modyInfo.oldpasswd, modyInfo.key); newpasswd = CSecurity.DecryptDES(modyInfo.newpasswd, modyInfo.key); if (name == modyInfo.name || oldpasswd == modyInfo.oldpasswd || newpasswd == modyInfo.newpasswd) { ErrInfo = "修改失败,请稍后再试!"; } else { ErrInfo = CSGHelper.ModifyPwd(name, oldpasswd, newpasswd); LogHelper.WriteLog(System.AppDomain.CurrentDomain.BaseDirectory, "ModifyPwd name:" + name + "\toldpasswd:" + oldpasswd + "\tnewpasswd:" + newpasswd, new StackTrace(new StackFrame(true))); } } } catch (Exception ex) { LogHelper.WriteLog(System.AppDomain.CurrentDomain.BaseDirectory, ex.Message, new StackTrace(new StackFrame(true))); ErrInfo = "注册失败,请稍后再试!"; } return(ErrInfo); }
private void btn_sql_Click(object sender, EventArgs e) { if (btn_sql.Text == "连接数据库") { //连接数据库 //* string conn_str = "Data Source = " + sql_srvAddr + "," + sql_srvPort + "; Initial Catalog = " + sqlAccountName + "; User Id = " + sql_srvUser + "; Password = "******";"; if (!CSGHelper.SqlConn(conn_str)) { MessageBox.Show("数据库连接失败!"); return; } else { MessageBox.Show("数据库连接成功!"); btn_sql.Text = "断开连接"; lbl_sqlStatus.Text = "数据库已连接"; txt_sqlsvr.ReadOnly = true; txt_sqlPort.ReadOnly = true; txt_sqlAcc.ReadOnly = true; txt_sqlPwd.ReadOnly = true; txt_sqlAccountName.ReadOnly = true; } } else { //* if (!CSGHelper.SqlClose()) { MessageBox.Show("断开数据库连接失败!"); return; } else { btn_sql.Text = "连接数据库"; lbl_sqlStatus.Text = "数据库未连接"; txt_sqlsvr.ReadOnly = false; txt_sqlPort.ReadOnly = false; txt_sqlAcc.ReadOnly = false; txt_sqlPwd.ReadOnly = false; txt_sqlAccountName.ReadOnly = false; } } }
public static string CmdRegister(Rg_Info rg_info) { string ErrInfo = ""; try { //找出传递过来的用户名和密码 string name = ""; string passwd = ""; if (rg_info.key == "110") { name = rg_info.name; passwd = rg_info.passwd; ErrInfo = CSGHelper.CreateAccount(name, passwd); LogHelper.WriteLog(System.AppDomain.CurrentDomain.BaseDirectory, "CreateAccount name:" + name + "\tpasswd:" + passwd + "\t" + ErrInfo, new StackTrace(new StackFrame(true))); } else { name = CSecurity.DecryptDES(rg_info.name, rg_info.key); passwd = CSecurity.DecryptDES(rg_info.passwd, rg_info.key); if (name == rg_info.name || passwd == rg_info.passwd) { ErrInfo = "注册失败,请稍后再试!"; } else { ErrInfo = CSGHelper.CreateAccount(name, passwd); LogHelper.WriteLog(System.AppDomain.CurrentDomain.BaseDirectory, "CreateAccount name:" + name + "\tpasswd:" + passwd, new StackTrace(new StackFrame(true))); } } } catch (Exception ex) { LogHelper.WriteLog(System.AppDomain.CurrentDomain.BaseDirectory, ex.Message, new StackTrace(new StackFrame(true))); ErrInfo = "注册失败,请稍后再试!"; } return(ErrInfo); }
private void btn_AcountFreeze_Click(object sender, EventArgs e) { string acc = CFormat.PureString(txt_AcountName.Text); if (acc == "") { return; } //封号 string log = ""; try { log = CSGHelper.FreezeAccount(acc, 1, "手动封禁!", "GM"); LogHelper.WriteLog(System.AppDomain.CurrentDomain.BaseDirectory, acc + ":" + log, new StackTrace(new StackFrame(true))); btn_AccountReflush_Click(null, null); } catch (Exception ex) { LogHelper.WriteLog(System.AppDomain.CurrentDomain.BaseDirectory, acc + ":" + ex.Message, new StackTrace(new StackFrame(true))); } MessageBox.Show("账户:" + acc + log); }
public static bool AddAcountPoint(string account, int dbCount) { if (!m_SqlConnected) return false; string cmd = "DECLARE @account varchar(21) \n" + "DECLARE @point int \n" + "DECLARE @old_point int \n" + "DECLARE @new_point int \n" + "set @account = '" + account + "' \n" + "set @point = " + dbCount + " \n" + "Select @old_point=point from " + m_sqlAccount + ".dbo.game_acc where account = @account \n" + "SET @new_point = @point + @old_point \n" + "Update " + m_sqlAccount + ".dbo.game_acc set point = @new_point where account = @account"; mutex.WaitOne(); string ret = CSGHelper.SqlCommand(cmd); mutex.ReleaseMutex(); if (ret != "success") { return false; } return true; }
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; } }
private void FreezeCheck() { //读取loginserverlog,获取非法信息列表 List <Illegal> nameList = GetIllegalList(); int FreezeCount = 0; int IllCount = 0; //更新列表 lstv_GtList.Items.Clear(); foreach (var name in nameList) { //过滤 if (m_FreezeFilterList != null) { bool filter = false; String PureAcount = CFormat.PureString(name.account); foreach (var item in m_FreezeFilterList) { if (PureAcount == item) { filter = true; break; } } if (filter) { continue; } } IllCount++; ListViewItem lvi = new ListViewItem(); lvi.Text = CFormat.PureString(name.account); //lvi.SubItems.Add(_id); lvi.SubItems.Add(CFormat.ToSimplified(CFormat.PureString(name.name))); lvi.SubItems.Add(name.time_str); if (cbx_AutoFreeze.Checked) { string acc = CFormat.PureString(name.account); //封号 try { string log = CSGHelper.FreezeAccount(acc, 1, "非法登录或者使用外挂!", "GM"); lvi.SubItems.Add(log); if (log == "冻结成功") { FreezeCount++; } LogHelper.WriteLog(System.AppDomain.CurrentDomain.BaseDirectory, acc + ":" + log, new StackTrace(new StackFrame(true))); } catch (Exception ex) { LogHelper.WriteLog(System.AppDomain.CurrentDomain.BaseDirectory, acc + ":" + ex.Message, new StackTrace(new StackFrame(true))); } } lstv_GtList.Items.Add(lvi); } lstv_GtList.EndUpdate(); lbl_IllCount.Text = IllCount.ToString(); lbl_FreezeCount.Text = FreezeCount.ToString(); }
private void btn_bxSend_Click(object sender, EventArgs e) { if (!m_Active) { MessageBox.Show("软件尚未激活! 请联系软件发布人给予激活!"); return; } if (txt_xbAccount.Text != string.Empty) { int xbCount1 = 0; int xbCount2 = 0; int xbCount3 = 0; int xbCount4 = 0; int xbCount5 = 0; int xbCount6 = 0; int xbCount7 = 0; int xbCount8 = 0; int xbCount9 = 0; int xbCount10 = 0; int xbId1 = 1; int xbId2 = 1; int xbId3 = 1; int xbId4 = 1; int xbId5 = 1; int xbId6 = 1; int xbId7 = 1; int xbId8 = 1; int xbId9 = 1; int xbId10 = 1; if (!string.IsNullOrEmpty(txt_xbCount1.Text) || CFormat.isNumberic(txt_xbCount1.Text)) { xbCount1 = Convert.ToInt32(txt_xbCount1.Text); } if (!string.IsNullOrEmpty(txt_xbCount2.Text) || CFormat.isNumberic(txt_xbCount2.Text)) { xbCount2 = Convert.ToInt32(txt_xbCount2.Text); } if (!string.IsNullOrEmpty(txt_xbCount3.Text) || CFormat.isNumberic(txt_xbCount3.Text)) { xbCount3 = Convert.ToInt32(txt_xbCount3.Text); } if (!string.IsNullOrEmpty(txt_xbCount4.Text) || CFormat.isNumberic(txt_xbCount4.Text)) { xbCount4 = Convert.ToInt32(txt_xbCount4.Text); } if (!string.IsNullOrEmpty(txt_xbCount5.Text) || CFormat.isNumberic(txt_xbCount5.Text)) { xbCount5 = Convert.ToInt32(txt_xbCount5.Text); } if (!string.IsNullOrEmpty(txt_xbCount6.Text) || CFormat.isNumberic(txt_xbCount6.Text)) { xbCount6 = Convert.ToInt32(txt_xbCount6.Text); } if (!string.IsNullOrEmpty(txt_xbCount7.Text) || CFormat.isNumberic(txt_xbCount7.Text)) { xbCount7 = Convert.ToInt32(txt_xbCount7.Text); } if (!string.IsNullOrEmpty(txt_xbCount8.Text) || CFormat.isNumberic(txt_xbCount8.Text)) { xbCount8 = Convert.ToInt32(txt_xbCount8.Text); } if (!string.IsNullOrEmpty(txt_xbCount9.Text) || CFormat.isNumberic(txt_xbCount9.Text)) { xbCount9 = Convert.ToInt32(txt_xbCount9.Text); } if (!string.IsNullOrEmpty(txt_xbCount10.Text) || CFormat.isNumberic(txt_xbCount10.Text)) { xbCount10 = Convert.ToInt32(txt_xbCount10.Text); } if (!string.IsNullOrEmpty(txt_xbId1.Text) || CFormat.isNumberic(txt_xbId1.Text)) { xbId1 = Convert.ToInt32(txt_xbId1.Text); if (xbId1 == 0) { xbId1 = 1; xbCount1 = 0; } } if (!string.IsNullOrEmpty(txt_xbId2.Text) || CFormat.isNumberic(txt_xbId2.Text)) { xbId2 = Convert.ToInt32(txt_xbId2.Text); if (xbId2 == 0) { xbId2 = 1; xbCount2 = 0; } } if (!string.IsNullOrEmpty(txt_xbId3.Text) || CFormat.isNumberic(txt_xbId3.Text)) { xbId3 = Convert.ToInt32(txt_xbId3.Text); if (xbId3 == 0) { xbId3 = 1; xbCount3 = 0; } } if (!string.IsNullOrEmpty(txt_xbId4.Text) || CFormat.isNumberic(txt_xbId4.Text)) { xbId4 = Convert.ToInt32(txt_xbId4.Text); if (xbId4 == 0) { xbId4 = 1; xbCount4 = 0; } } if (!string.IsNullOrEmpty(txt_xbId5.Text) || CFormat.isNumberic(txt_xbId5.Text)) { xbId5 = Convert.ToInt32(txt_xbId5.Text); if (xbId5 == 0) { xbId5 = 1; xbCount5 = 0; } } if (!string.IsNullOrEmpty(txt_xbId6.Text) || CFormat.isNumberic(txt_xbId6.Text)) { xbId6 = Convert.ToInt32(txt_xbId6.Text); if (xbId6 == 0) { xbId6 = 1; xbCount6 = 0; } } if (!string.IsNullOrEmpty(txt_xbId7.Text) || CFormat.isNumberic(txt_xbId7.Text)) { xbId7 = Convert.ToInt32(txt_xbId7.Text); if (xbId7 == 0) { xbId7 = 1; xbCount7 = 0; } } if (!string.IsNullOrEmpty(txt_xbId8.Text) || CFormat.isNumberic(txt_xbId8.Text)) { xbId8 = Convert.ToInt32(txt_xbId8.Text); if (xbId8 == 0) { xbId8 = 1; xbCount8 = 0; } } if (!string.IsNullOrEmpty(txt_xbId9.Text) || CFormat.isNumberic(txt_xbId9.Text)) { xbId9 = Convert.ToInt32(txt_xbId9.Text); if (xbId9 == 0) { xbId9 = 1; xbCount9 = 0; } } if (!string.IsNullOrEmpty(txt_xbId10.Text) || CFormat.isNumberic(txt_xbId10.Text)) { xbId10 = Convert.ToInt32(txt_xbId10.Text); if (xbId10 == 0) { xbId10 = 1; xbCount10 = 0; } } string msg = "\n" + "账户:" + txt_xbAccount.Text + "\n" + "角色:" + txt_xbName.Text + "\n" + "代币:" + txt_dbSend.Text + "\n"; if (txt_xbId1.Text != "" && xbCount1 != 0) { msg += "物品:" + txt_xbName1.Text + "\t数量:" + txt_xbCount1.Text + "\t\n"; } if (txt_xbId2.Text != "" && xbCount2 != 0) { msg += "物品:" + txt_xbName2.Text + "\t数量:" + txt_xbCount2.Text + "\t\n"; } if (txt_xbId3.Text != "" && xbCount3 != 0) { msg += "物品:" + txt_xbName3.Text + "\t数量:" + txt_xbCount3.Text + "\t\n"; } if (txt_xbId4.Text != "" && xbCount4 != 0) { msg += "物品:" + txt_xbName4.Text + "\t数量:" + txt_xbCount4.Text + "\t\n"; } if (txt_xbId5.Text != "" && xbCount5 != 0) { msg += "物品:" + txt_xbName5.Text + "\t数量:" + txt_xbCount5.Text + "\t\n"; } if (txt_xbId6.Text != "" && xbCount6 != 0) { msg += "物品:" + txt_xbName6.Text + "\t数量:" + txt_xbCount6.Text + "\t\n"; } if (txt_xbId7.Text != "" && xbCount7 != 0) { msg += "物品:" + txt_xbName7.Text + "\t数量:" + txt_xbCount7.Text + "\t\n"; } if (txt_xbId8.Text != "" && xbCount8 != 0) { msg += "物品:" + txt_xbName8.Text + "\t数量:" + txt_xbCount8.Text + "\t\n"; } if (txt_xbId9.Text != "" && xbCount9 != 0) { msg += "物品:" + txt_xbName9.Text + "\t数量:" + txt_xbCount9.Text + "\t\n"; } if (txt_xbId10.Text != "" && xbCount10 != 0) { msg += "物品:" + txt_xbName10.Text + "\t数量:" + txt_xbCount10.Text + "\t\n"; } msg += "\n确认信息无误?"; DialogResult dr = MessageBox.Show(msg, "对话框标题", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (dr != DialogResult.OK) { return; } //确保有效 if ((txt_xbId1.Text == "" || xbCount1 == 0) && (txt_xbId2.Text == "" || xbCount2 == 0) && (txt_xbId3.Text == "" || xbCount3 == 0) && (txt_xbId4.Text == "" || xbCount4 == 0) && (txt_xbId5.Text == "" || xbCount5 == 0)) { } else { string cmd = "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 ('" + txt_xbAccount.Text + "',0,CONVERT(varchar(100), GETDATE(), 21),getdate(),getdate(),0,0,0," + xbId1 + "," + xbCount1 + "," + xbId2 + "," + xbCount2 + "," + xbId3 + "," + xbCount3 + "," + xbId4 + "," + xbCount4 + "," + xbId5 + "," + xbCount5 + ")"; string ret = CSGHelper.SqlCommand(cmd); if (ret == "success") { SGExHandle.WriteXbLog(txt_xbAccount.Text + "\t" + txt_xbName.Text + "\t" + txt_xbId1.Text + "\t" + txt_xbName1.Text + "\t" + txt_xbCount1.Text + "\t" + txt_xbId2.Text + "\t" + txt_xbName2.Text + "\t" + txt_xbCount2.Text + "\t" + txt_xbId4.Text + "\t" + txt_xbName3.Text + "\t" + txt_xbCount3.Text + "\t" + txt_xbId5.Text + "\t" + txt_xbName4.Text + "\t" + txt_xbCount4.Text + "\t" + txt_xbId6.Text + "\t" + txt_xbName5.Text + "\t" + txt_xbCount5.Text + "\t"); ListViewItem lvi = new ListViewItem(); lvi.Text = txt_xbAccount.Text; lvi.SubItems.Add(txt_xbName.Text); lvi.SubItems.Add(txt_xbId1.Text); lvi.SubItems.Add(txt_xbName1.Text); lvi.SubItems.Add(txt_xbCount1.Text); lvi.SubItems.Add(txt_xbId2.Text); lvi.SubItems.Add(txt_xbName2.Text); lvi.SubItems.Add(txt_xbCount2.Text); lvi.SubItems.Add(txt_xbId3.Text); lvi.SubItems.Add(txt_xbName3.Text); lvi.SubItems.Add(txt_xbCount3.Text); lvi.SubItems.Add(txt_xbId4.Text); lvi.SubItems.Add(txt_xbName4.Text); lvi.SubItems.Add(txt_xbCount4.Text); lvi.SubItems.Add(txt_xbId5.Text); lvi.SubItems.Add(txt_xbName5.Text); lvi.SubItems.Add(txt_xbCount5.Text); lstv_xblog.Items.Add(lvi); } else { string msg2 = "\n" + "账户:" + txt_xbAccount.Text + "\n" + "角色:" + txt_xbName.Text + "\n"; if (txt_xbId1.Text != "" && xbCount1 != 0) { msg += "物品:" + txt_xbName1.Text + "\t数量:" + txt_xbCount1.Text + "\t\n"; } if (txt_xbId2.Text != "" && xbCount2 != 0) { msg += "物品:" + txt_xbName2.Text + "\t数量:" + txt_xbCount2.Text + "\t\n"; } if (txt_xbId3.Text != "" && xbCount3 != 0) { msg += "物品:" + txt_xbName3.Text + "\t数量:" + txt_xbCount3.Text + "\t\n"; } if (txt_xbId4.Text != "" && xbCount4 != 0) { msg += "物品:" + txt_xbName4.Text + "\t数量:" + txt_xbCount4.Text + "\t\n"; } if (txt_xbId5.Text != "" && xbCount5 != 0) { msg += "物品:" + txt_xbName5.Text + "\t数量:" + txt_xbCount5.Text + "\t\n"; } MessageBox.Show("发送失败,\t\n" + msg2); } } Thread.Sleep(200); if ((txt_xbId6.Text == "" || xbCount6 == 0) && (txt_xbId7.Text == "" || xbCount7 == 0) && (txt_xbId8.Text == "" || xbCount8 == 0) && (txt_xbId9.Text == "" || xbCount9 == 0) && (txt_xbId10.Text == "" || xbCount10 == 0)) { } else { string cmd = "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 ('" + txt_xbAccount.Text + "',0,CONVERT(varchar(100), GETDATE(), 21),getdate(),getdate(),0,0,0," + xbId6 + "," + xbCount6 + "," + xbId7 + "," + xbCount7 + "," + xbId8 + "," + xbCount8 + "," + xbId9 + "," + xbCount9 + "," + xbId10 + "," + xbCount10 + ")"; string ret = CSGHelper.SqlCommand(cmd); if (ret == "success") { SGExHandle.WriteXbLog(txt_xbAccount.Text + "\t" + txt_xbName.Text + "\t" + txt_xbId6.Text + "\t" + txt_xbName6.Text + "\t" + txt_xbCount6.Text + "\t" + txt_xbId7.Text + "\t" + txt_xbName7.Text + "\t" + txt_xbCount7.Text + "\t" + txt_xbId8.Text + "\t" + txt_xbName8.Text + "\t" + txt_xbCount8.Text + "\t" + txt_xbId9.Text + "\t" + txt_xbName9.Text + "\t" + txt_xbCount9.Text + "\t" + txt_xbId10.Text + "\t" + txt_xbName10.Text + "\t" + txt_xbCount10.Text + "\t"); ListViewItem lvi = new ListViewItem(); lvi.Text = txt_xbAccount.Text; lvi.SubItems.Add(txt_xbName.Text); lvi.SubItems.Add(txt_xbId6.Text); lvi.SubItems.Add(txt_xbName6.Text); lvi.SubItems.Add(txt_xbCount6.Text); lvi.SubItems.Add(txt_xbId7.Text); lvi.SubItems.Add(txt_xbName7.Text); lvi.SubItems.Add(txt_xbCount7.Text); lvi.SubItems.Add(txt_xbId8.Text); lvi.SubItems.Add(txt_xbName8.Text); lvi.SubItems.Add(txt_xbCount8.Text); lvi.SubItems.Add(txt_xbId9.Text); lvi.SubItems.Add(txt_xbName9.Text); lvi.SubItems.Add(txt_xbCount9.Text); lvi.SubItems.Add(txt_xbId10.Text); lvi.SubItems.Add(txt_xbName10.Text); lvi.SubItems.Add(txt_xbCount10.Text); lstv_xblog.Items.Add(lvi); } else { string msg2 = "\n" + "账户:" + txt_xbAccount.Text + "\n" + "角色:" + txt_xbName.Text + "\n"; if (txt_xbId6.Text != "" && xbCount6 != 0) { msg += "物品:" + txt_xbName6.Text + "\t数量:" + txt_xbCount6.Text + "\t\n"; } if (txt_xbId7.Text != "" && xbCount7 != 0) { msg += "物品:" + txt_xbName7.Text + "\t数量:" + txt_xbCount7.Text + "\t\n"; } if (txt_xbId8.Text != "" && xbCount8 != 0) { msg += "物品:" + txt_xbName8.Text + "\t数量:" + txt_xbCount8.Text + "\t\n"; } if (txt_xbId9.Text != "" && xbCount9 != 0) { msg += "物品:" + txt_xbName9.Text + "\t数量:" + txt_xbCount9.Text + "\t\n"; } if (txt_xbId10.Text != "" && xbCount10 != 0) { msg += "物品:" + txt_xbName10.Text + "\t数量:" + txt_xbCount10.Text + "\t\n"; } MessageBox.Show("发送失败,\t\n" + msg2); } } Thread.Sleep(200); //代币 if (!string.IsNullOrEmpty(txt_dbSend.Text) && CFormat.isNumberic(txt_dbSend.Text)) { int dbCount = Convert.ToInt32(txt_dbSend.Text); if (dbCount > 0) { //虚宝增加 string cmd = "DECLARE @account varchar(21) \n" + "DECLARE @point int \n" + "DECLARE @old_point int \n" + "DECLARE @new_point int \n" + "set @account = '" + txt_xbAccount.Text + "' \n" + "set @point = " + dbCount + " \n" + "Select @old_point=point from dbo.game_acc where account = @account \n" + "SET @new_point = @point + @old_point \n" + "Update dbo.game_acc set point = @new_point where account = @account"; string ret = CSGHelper.SqlCommand(cmd); if (ret == "success") { txt_dbCurr.Text = "" + CSGHelper.SelectAcountPoint(txt_xbAccount.Text); } else { MessageBox.Show("发送代币失败,代币:" + dbCount); } } } if (cbx_xbconf.Text == "新人起步") { m_SGExHandle.SendWorldWords("新人玩家 " + txt_xbName.Text + " 的新手起步已经发放,请到大鸿胪处领取虚宝,欢迎加入大家庭,祝游戏愉快。"); } } else { MessageBox.Show("请核对发放帐号!"); } }
private void btn_bxSend_Click(object sender, EventArgs e) { if (!m_Active) { MessageBox.Show("软件尚未激活! 请联系软件发布人给予激活!"); return; } if (txt_xbAccount.Text != string.Empty) { int xbCount1 = 0; int xbCount2 = 0; int xbCount3 = 0; int xbCount4 = 0; int xbCount5 = 0; int xbCount6 = 0; int xbCount7 = 0; int xbCount8 = 0; int xbCount9 = 0; int xbCount10 = 0; int xbId1 = 1; int xbId2 = 1; int xbId3 = 1; int xbId4 = 1; int xbId5 = 1; int xbId6 = 1; int xbId7 = 1; int xbId8 = 1; int xbId9 = 1; int xbId10 = 1; if (!string.IsNullOrEmpty(txt_xbCount1.Text) || CFormat.isNumberic(txt_xbCount1.Text)) { xbCount1 = Convert.ToInt32(txt_xbCount1.Text); } if (!string.IsNullOrEmpty(txt_xbCount2.Text) || CFormat.isNumberic(txt_xbCount2.Text)) { xbCount2 = Convert.ToInt32(txt_xbCount2.Text); } if (!string.IsNullOrEmpty(txt_xbCount3.Text) || CFormat.isNumberic(txt_xbCount3.Text)) { xbCount3 = Convert.ToInt32(txt_xbCount3.Text); } if (!string.IsNullOrEmpty(txt_xbCount4.Text) || CFormat.isNumberic(txt_xbCount4.Text)) { xbCount4 = Convert.ToInt32(txt_xbCount4.Text); } if (!string.IsNullOrEmpty(txt_xbCount5.Text) || CFormat.isNumberic(txt_xbCount5.Text)) { xbCount5 = Convert.ToInt32(txt_xbCount5.Text); } if (!string.IsNullOrEmpty(txt_xbCount6.Text) || CFormat.isNumberic(txt_xbCount6.Text)) { xbCount6 = Convert.ToInt32(txt_xbCount6.Text); } if (!string.IsNullOrEmpty(txt_xbCount7.Text) || CFormat.isNumberic(txt_xbCount7.Text)) { xbCount7 = Convert.ToInt32(txt_xbCount7.Text); } if (!string.IsNullOrEmpty(txt_xbCount8.Text) || CFormat.isNumberic(txt_xbCount8.Text)) { xbCount8 = Convert.ToInt32(txt_xbCount8.Text); } if (!string.IsNullOrEmpty(txt_xbCount9.Text) || CFormat.isNumberic(txt_xbCount9.Text)) { xbCount9 = Convert.ToInt32(txt_xbCount9.Text); } if (!string.IsNullOrEmpty(txt_xbCount10.Text) || CFormat.isNumberic(txt_xbCount10.Text)) { xbCount10 = Convert.ToInt32(txt_xbCount10.Text); } if (!string.IsNullOrEmpty(txt_xbId1.Text) || CFormat.isNumberic(txt_xbId1.Text)) { xbId1 = Convert.ToInt32(txt_xbId1.Text); if (xbId1 == 0) { xbId1 = 1; xbCount1 = 0; } } if (!string.IsNullOrEmpty(txt_xbId2.Text) || CFormat.isNumberic(txt_xbId2.Text)) { xbId2 = Convert.ToInt32(txt_xbId2.Text); if (xbId2 == 0) { xbId2 = 1; xbCount2 = 0; } } if (!string.IsNullOrEmpty(txt_xbId3.Text) || CFormat.isNumberic(txt_xbId3.Text)) { xbId3 = Convert.ToInt32(txt_xbId3.Text); if (xbId3 == 0) { xbId3 = 1; xbCount3 = 0; } } if (!string.IsNullOrEmpty(txt_xbId4.Text) || CFormat.isNumberic(txt_xbId4.Text)) { xbId4 = Convert.ToInt32(txt_xbId4.Text); if (xbId4 == 0) { xbId4 = 1; xbCount4 = 0; } } if (!string.IsNullOrEmpty(txt_xbId5.Text) || CFormat.isNumberic(txt_xbId5.Text)) { xbId5 = Convert.ToInt32(txt_xbId5.Text); if (xbId5 == 0) { xbId5 = 1; xbCount5 = 0; } } if (!string.IsNullOrEmpty(txt_xbId6.Text) || CFormat.isNumberic(txt_xbId6.Text)) { xbId6 = Convert.ToInt32(txt_xbId6.Text); if (xbId6 == 0) { xbId6 = 1; xbCount6 = 0; } } if (!string.IsNullOrEmpty(txt_xbId7.Text) || CFormat.isNumberic(txt_xbId7.Text)) { xbId7 = Convert.ToInt32(txt_xbId7.Text); if (xbId7 == 0) { xbId7 = 1; xbCount7 = 0; } } if (!string.IsNullOrEmpty(txt_xbId8.Text) || CFormat.isNumberic(txt_xbId8.Text)) { xbId8 = Convert.ToInt32(txt_xbId8.Text); if (xbId8 == 0) { xbId8 = 1; xbCount8 = 0; } } if (!string.IsNullOrEmpty(txt_xbId9.Text) || CFormat.isNumberic(txt_xbId9.Text)) { xbId9 = Convert.ToInt32(txt_xbId9.Text); if (xbId9 == 0) { xbId9 = 1; xbCount9 = 0; } } if (!string.IsNullOrEmpty(txt_xbId10.Text) || CFormat.isNumberic(txt_xbId10.Text)) { xbId10 = Convert.ToInt32(txt_xbId10.Text); if (xbId10 == 0) { xbId10 = 1; xbCount10 = 0; } } string msg = "\n" + "账户:" + txt_xbAccount.Text + "\n" + "角色:" + txt_xbName.Text + "\n" + "代币:" + txt_dbSend.Text + "\n"; if (txt_xbId1.Text != "" && xbCount1 != 0) { msg += "物品:" + txt_xbName1.Text + "\t数量:" + txt_xbCount1.Text + "\t\n"; } if (txt_xbId2.Text != "" && xbCount2 != 0) { msg += "物品:" + txt_xbName2.Text + "\t数量:" + txt_xbCount2.Text + "\t\n"; } if (txt_xbId3.Text != "" && xbCount3 != 0) { msg += "物品:" + txt_xbName3.Text + "\t数量:" + txt_xbCount3.Text + "\t\n"; } if (txt_xbId4.Text != "" && xbCount4 != 0) { msg += "物品:" + txt_xbName4.Text + "\t数量:" + txt_xbCount4.Text + "\t\n"; } if (txt_xbId5.Text != "" && xbCount5 != 0) { msg += "物品:" + txt_xbName5.Text + "\t数量:" + txt_xbCount5.Text + "\t\n"; } if (txt_xbId6.Text != "" && xbCount6 != 0) { msg += "物品:" + txt_xbName6.Text + "\t数量:" + txt_xbCount6.Text + "\t\n"; } if (txt_xbId7.Text != "" && xbCount7 != 0) { msg += "物品:" + txt_xbName7.Text + "\t数量:" + txt_xbCount7.Text + "\t\n"; } if (txt_xbId8.Text != "" && xbCount8 != 0) { msg += "物品:" + txt_xbName8.Text + "\t数量:" + txt_xbCount8.Text + "\t\n"; } if (txt_xbId9.Text != "" && xbCount9 != 0) { msg += "物品:" + txt_xbName9.Text + "\t数量:" + txt_xbCount9.Text + "\t\n"; } if (txt_xbId10.Text != "" && xbCount10 != 0) { msg += "物品:" + txt_xbName10.Text + "\t数量:" + txt_xbCount10.Text + "\t\n"; } msg += "\n确认信息无误?"; DialogResult dr = MessageBox.Show(msg, "对话框标题", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (dr != DialogResult.OK) { return; } //确保有效 if ((txt_xbId1.Text == "" || xbCount1 == 0) && (txt_xbId2.Text == "" || xbCount2 == 0) && (txt_xbId3.Text == "" || xbCount3 == 0) && (txt_xbId4.Text == "" || xbCount4 == 0) && (txt_xbId5.Text == "" || xbCount5 == 0)) { } else { bool result = CSGHelper.InsertSanvtItem(txt_xbAccount.Text , (uint)xbId1, (uint)xbCount1, (uint)xbId2, (uint)xbCount2, (uint)xbId3, (uint)xbCount3 , (uint)xbId4, (uint)xbCount4, (uint)xbId5, (uint)xbCount5); if (result) { SGExHandle.WriteXbLog(txt_xbAccount.Text + "\t" + txt_xbName.Text + "\t" + txt_xbId1.Text + "\t" + txt_xbName1.Text + "\t" + txt_xbCount1.Text + "\t" + txt_xbId2.Text + "\t" + txt_xbName2.Text + "\t" + txt_xbCount2.Text + "\t" + txt_xbId4.Text + "\t" + txt_xbName3.Text + "\t" + txt_xbCount3.Text + "\t" + txt_xbId5.Text + "\t" + txt_xbName4.Text + "\t" + txt_xbCount4.Text + "\t" + txt_xbId6.Text + "\t" + txt_xbName5.Text + "\t" + txt_xbCount5.Text + "\t"); ListViewItem lvi = new ListViewItem(); lvi.Text = txt_xbAccount.Text; lvi.SubItems.Add(txt_xbName.Text); lvi.SubItems.Add(txt_xbId1.Text); lvi.SubItems.Add(txt_xbName1.Text); lvi.SubItems.Add(txt_xbCount1.Text); lvi.SubItems.Add(txt_xbId2.Text); lvi.SubItems.Add(txt_xbName2.Text); lvi.SubItems.Add(txt_xbCount2.Text); lvi.SubItems.Add(txt_xbId3.Text); lvi.SubItems.Add(txt_xbName3.Text); lvi.SubItems.Add(txt_xbCount3.Text); lvi.SubItems.Add(txt_xbId4.Text); lvi.SubItems.Add(txt_xbName4.Text); lvi.SubItems.Add(txt_xbCount4.Text); lvi.SubItems.Add(txt_xbId5.Text); lvi.SubItems.Add(txt_xbName5.Text); lvi.SubItems.Add(txt_xbCount5.Text); lstv_xblog.Items.Add(lvi); } else { string msg2 = "\n" + "账户:" + txt_xbAccount.Text + "\n" + "角色:" + txt_xbName.Text + "\n"; if (txt_xbId1.Text != "" && xbCount1 != 0) { msg += "物品:" + txt_xbName1.Text + "\t数量:" + txt_xbCount1.Text + "\t\n"; } if (txt_xbId2.Text != "" && xbCount2 != 0) { msg += "物品:" + txt_xbName2.Text + "\t数量:" + txt_xbCount2.Text + "\t\n"; } if (txt_xbId3.Text != "" && xbCount3 != 0) { msg += "物品:" + txt_xbName3.Text + "\t数量:" + txt_xbCount3.Text + "\t\n"; } if (txt_xbId4.Text != "" && xbCount4 != 0) { msg += "物品:" + txt_xbName4.Text + "\t数量:" + txt_xbCount4.Text + "\t\n"; } if (txt_xbId5.Text != "" && xbCount5 != 0) { msg += "物品:" + txt_xbName5.Text + "\t数量:" + txt_xbCount5.Text + "\t\n"; } MessageBox.Show("发送失败,\t\n" + msg2); } } Thread.Sleep(200); if ((txt_xbId6.Text == "" || xbCount6 == 0) && (txt_xbId7.Text == "" || xbCount7 == 0) && (txt_xbId8.Text == "" || xbCount8 == 0) && (txt_xbId9.Text == "" || xbCount9 == 0) && (txt_xbId10.Text == "" || xbCount10 == 0)) { } else { bool result = CSGHelper.InsertSanvtItem(txt_xbAccount.Text , (uint)xbId6, (uint)xbCount6, (uint)xbId7, (uint)xbCount7, (uint)xbId8, (uint)xbCount8 , (uint)xbId9, (uint)xbCount9, (uint)xbId10, (uint)xbCount10); if (result) { SGExHandle.WriteXbLog(txt_xbAccount.Text + "\t" + txt_xbName.Text + "\t" + txt_xbId6.Text + "\t" + txt_xbName6.Text + "\t" + txt_xbCount6.Text + "\t" + txt_xbId7.Text + "\t" + txt_xbName7.Text + "\t" + txt_xbCount7.Text + "\t" + txt_xbId8.Text + "\t" + txt_xbName8.Text + "\t" + txt_xbCount8.Text + "\t" + txt_xbId9.Text + "\t" + txt_xbName9.Text + "\t" + txt_xbCount9.Text + "\t" + txt_xbId10.Text + "\t" + txt_xbName10.Text + "\t" + txt_xbCount10.Text + "\t"); ListViewItem lvi = new ListViewItem(); lvi.Text = txt_xbAccount.Text; lvi.SubItems.Add(txt_xbName.Text); lvi.SubItems.Add(txt_xbId6.Text); lvi.SubItems.Add(txt_xbName6.Text); lvi.SubItems.Add(txt_xbCount6.Text); lvi.SubItems.Add(txt_xbId7.Text); lvi.SubItems.Add(txt_xbName7.Text); lvi.SubItems.Add(txt_xbCount7.Text); lvi.SubItems.Add(txt_xbId8.Text); lvi.SubItems.Add(txt_xbName8.Text); lvi.SubItems.Add(txt_xbCount8.Text); lvi.SubItems.Add(txt_xbId9.Text); lvi.SubItems.Add(txt_xbName9.Text); lvi.SubItems.Add(txt_xbCount9.Text); lvi.SubItems.Add(txt_xbId10.Text); lvi.SubItems.Add(txt_xbName10.Text); lvi.SubItems.Add(txt_xbCount10.Text); lstv_xblog.Items.Add(lvi); } else { string msg2 = "\n" + "账户:" + txt_xbAccount.Text + "\n" + "角色:" + txt_xbName.Text + "\n"; if (txt_xbId6.Text != "" && xbCount6 != 0) { msg += "物品:" + txt_xbName6.Text + "\t数量:" + txt_xbCount6.Text + "\t\n"; } if (txt_xbId7.Text != "" && xbCount7 != 0) { msg += "物品:" + txt_xbName7.Text + "\t数量:" + txt_xbCount7.Text + "\t\n"; } if (txt_xbId8.Text != "" && xbCount8 != 0) { msg += "物品:" + txt_xbName8.Text + "\t数量:" + txt_xbCount8.Text + "\t\n"; } if (txt_xbId9.Text != "" && xbCount9 != 0) { msg += "物品:" + txt_xbName9.Text + "\t数量:" + txt_xbCount9.Text + "\t\n"; } if (txt_xbId10.Text != "" && xbCount10 != 0) { msg += "物品:" + txt_xbName10.Text + "\t数量:" + txt_xbCount10.Text + "\t\n"; } MessageBox.Show("发送失败,\t\n" + msg2); } } Thread.Sleep(200); //代币 if (!string.IsNullOrEmpty(txt_dbSend.Text) && CFormat.isNumberic(txt_dbSend.Text)) { int dbCount = Convert.ToInt32(txt_dbSend.Text); if (dbCount > 0) { //虚宝增加 bool result = CSGHelper.AddAcountPoint(txt_xbAccount.Text, dbCount); if (result) { txt_dbCurr.Text = "" + CSGHelper.SelectAcountPoint(txt_xbAccount.Text); } else { MessageBox.Show("发送代币失败,代币:" + dbCount); } } } if (cbx_xbconf.Text == "新人起步") { m_SGExHandle.SendWorldWords("新人玩家 " + txt_xbName.Text + " 的新手起步已经发放,请到大鸿胪处领取虚宝,欢迎加入大家庭,祝游戏愉快。"); } } else { MessageBox.Show("请核对发放帐号!"); } }