/// <summary> /// 查询余额 /// </summary> /// <param name="QQID"></param> /// <returns></returns> public static int SearchGoldFromDB(string QQID) { IRQQUtil.WritePluginLogFile(logfile, "\n开始查询" + DateTime.Now); try { DataBase.MySqlUtil mySqlUtil = new DataBase.MySqlUtil(); mySqlUtil.SetDBInfo(dbIP, dbName, dbUser, dbPwd, dbPort, dbFile); string SqlString = "select gold from characters where qqid =" + QQID; mySqlUtil.SetCammandText(SqlString); var iResult = mySqlUtil.Execute(); var c = iResult.Tables[0].Rows.Count; if (c == 0) { IRQQUtil.WritePluginLogFile(logfile, "\n数据库中没有" + DateTime.Now); return(-1); } else { string goldnum = iResult.Tables[0].Rows[0].ItemArray[0].ToString(); IRQQUtil.WritePluginLogFile(logfile, "\n查寻数据库成功" + DateTime.Now); return(int.Parse(goldnum)); } } catch (Exception ex) { IRQQUtil.WritePluginLogFile(logfile, "\n查寻数据库失败" + ex + DateTime.Now); return(-2); } }
public static bool Test() { //数据库信息 // string dbIP = "127.0.0.1"; string dbName = "qqplugin"; string dbUser = "******"; string dbPwd = "qwerty123456"; short dbPort = 3306; string dbFile = ""; string QQID = "745569561"; IRQQUtil.WritePluginLogFile(logfile, "\n开始查询" + DateTime.Now); try { DataBase.MySqlUtil mySqlUtil = new DataBase.MySqlUtil(); mySqlUtil.SetDBInfo(dbIP, dbName, dbUser, dbPwd, dbPort, dbFile); string SqlString = "select * from gold"; mySqlUtil.SetCammandText(SqlString); var iResult = mySqlUtil.Execute(); Utils utils = new Utils(); //GoldClass goldClass = new GoldClass(); var goldClass = Utils.DataSetToEntity <GoldClass>(iResult, 0); var a = iResult.Tables[0].Rows[0]; var c = iResult.Tables[0].Rows.Count; if (c == 0) { IRQQUtil.WritePluginLogFile(logfile, "\n数据库中没有" + DateTime.Now); return(false); } else { string goldnum = iResult.Tables[0].Rows[0].ItemArray[0].ToString(); IRQQUtil.WritePluginLogFile(logfile, "\n查寻数据库成功" + DateTime.Now); return(true); } } catch (Exception ex) { IRQQUtil.WritePluginLogFile(logfile, "\n查寻数据库失败" + ex + DateTime.Now); return(false); } }
/// <summary> /// 测试发工资用 /// </summary> public static void GiveGold() { DataBase.MySqlUtil mySqlUtil = new DataBase.MySqlUtil(); mySqlUtil.SetDBInfo(dbIP, dbName, dbUser, dbPwd, dbPort, dbFile); string SqlString = "update characters set gold = gold + 200"; mySqlUtil.SetCammandText(SqlString); try { mySqlUtil.ExecuteNonQuery(); IRQQUtil.WritePluginLogFile(logfile, "写入数据库成功(gold)" + DateTime.Now); } catch (Exception ex) { IRQQUtil.WritePluginLogFile(logfile, "写入数据库失败(gold)" + DateTime.Now); } }
/// <summary> /// 更新幸运值 /// </summary> /// <param name="QQID"></param> /// <param name="newLucky"></param> /// <returns></returns> public static bool UpdateLuckyToDB(string QQID, int newLucky) { DataBase.MySqlUtil mySqlUtil = new DataBase.MySqlUtil(); mySqlUtil.SetDBInfo(dbIP, dbName, dbUser, dbPwd, dbPort, dbFile); string SqlString = "update characters set lucky = " + newLucky + " where qqid = " + QQID; mySqlUtil.SetCammandText(SqlString); try { mySqlUtil.ExecuteNonQuery(); IRQQUtil.WritePluginLogFile(logfile, "写入数据库成功(lucky)" + DateTime.Now); return(true); } catch (Exception ex) { IRQQUtil.WritePluginLogFile(logfile, "写入数据库失败(lucky)" + DateTime.Now); return(false); } }
/// <summary> /// 新增技能装备状态 /// </summary> /// <param name="QQID"></param> /// <param name="skillEquip"></param> /// <returns></returns> public static bool AddSkillOwnToDB(string QQID, int skillEquip) { DataBase.MySqlUtil mySqlUtil = new DataBase.MySqlUtil(); mySqlUtil.SetDBInfo(dbIP, dbName, dbUser, dbPwd, dbPort, dbFile); string SqlString = "insert into skill_own values(\"" + QQID + "\",\"" + skillEquip + "\")"; mySqlUtil.SetCammandText(SqlString); try { mySqlUtil.ExecuteNonQuery(); IRQQUtil.WritePluginLogFile(logfile, "增加数据库成功" + DateTime.Now); return(true); } catch (Exception ex) { IRQQUtil.WritePluginLogFile(logfile, "增加数据库失败" + ex + DateTime.Now); return(false); } }
/// <summary> /// 查询余额大于某值的人员列表 /// </summary> /// <param name="goldNum"></param> /// <returns></returns> public static List <string> SearchGoldListFromDB(int goldNum) { IRQQUtil.WritePluginLogFile(logfile, "\n开始查询" + DateTime.Now); try { DataBase.MySqlUtil mySqlUtil = new DataBase.MySqlUtil(); mySqlUtil.SetDBInfo(dbIP, dbName, dbUser, dbPwd, dbPort, dbFile); string SqlString = "select qqid from characters where gold >=" + goldNum; mySqlUtil.SetCammandText(SqlString); var iResult = mySqlUtil.Execute(); var c = iResult.Tables[0].Rows.Count; if (c == 0) { IRQQUtil.WritePluginLogFile(logfile, "\n数据库中没有" + DateTime.Now); return(null); } else { List <string> qqIDlist = new List <string>(); for (int i = 0; i < c; i++) { var a = iResult.Tables[0].Rows[i]; qqIDlist.Add(a.ItemArray[0].ToString()); } IRQQUtil.WritePluginLogFile(logfile, "\n查寻数据库成功" + DateTime.Now); return(qqIDlist); } } catch (Exception ex) { IRQQUtil.WritePluginLogFile(logfile, "\n查寻数据库失败" + ex + DateTime.Now); return(null); } }
/// <summary> /// 查询是否有技能 /// </summary> /// <param name="QQID"></param> /// <returns></returns> public static SkillThief SearchSkillThiefFromDB(string QQID) { IRQQUtil.WritePluginLogFile(logfile, "\n开始查询" + DateTime.Now); try { DataBase.MySqlUtil mySqlUtil = new DataBase.MySqlUtil(); mySqlUtil.SetDBInfo(dbIP, dbName, dbUser, dbPwd, dbPort, dbFile); string SqlString = "select * from skill_thief where qqid =" + QQID; mySqlUtil.SetCammandText(SqlString); var iResult = mySqlUtil.Execute(); var c = iResult.Tables[0].Rows.Count; // if (c == 0) { IRQQUtil.WritePluginLogFile(logfile, "\n数据库中没有" + DateTime.Now); return(null); } else { SkillThief skillThief = new SkillThief(); skillThief.QQid = iResult.Tables[0].Rows[0].ItemArray[0].ToString(); skillThief.SkillChance = iResult.Tables[0].Rows[0].ItemArray[1].ToString(); skillThief.EffLower = iResult.Tables[0].Rows[0].ItemArray[2].ToString(); skillThief.EffUpper = iResult.Tables[0].Rows[0].ItemArray[3].ToString(); IRQQUtil.WritePluginLogFile(logfile, "\n查寻数据库成功" + DateTime.Now); return(skillThief); } // } catch (Exception ex) { IRQQUtil.WritePluginLogFile(logfile, "\n查寻数据库失败" + ex + DateTime.Now); return(null); } }
/// <summary> /// 更新技能数值 /// </summary> /// <param name="QQID"></param> /// <param name="skillChance"></param> /// <param name="effLower"></param> /// <param name="effUpper"></param> /// <returns></returns> public static bool UpdateSkillThiefToDB(string QQID, int skillChance, int effLower, int effUpper) { DataBase.MySqlUtil mySqlUtil = new DataBase.MySqlUtil(); mySqlUtil.SetDBInfo(dbIP, dbName, dbUser, dbPwd, dbPort, dbFile); string SqlString = "update skill_thief set skill_chance = " + skillChance + ",eff_lower = " + effLower + ",eff_upper = " + effUpper + " where qqid = " + QQID; mySqlUtil.SetCammandText(SqlString); try { mySqlUtil.ExecuteNonQuery(); IRQQUtil.WritePluginLogFile(logfile, "写入数据库成功(gold)" + DateTime.Now); return(true); } catch (Exception ex) { IRQQUtil.WritePluginLogFile(logfile, "写入数据库失败(gold)" + DateTime.Now); return(false); } }