public static Dictionary <string, int> GetAHLessItem() { Dictionary <string, int> result = new Dictionary <string, int>(); string sql = ""; sql += "WITH server_ahinfo AS"; sql += " (SELECT char_name, item_name, backup_count"; sql += " FROM ahitem"; sql += " WHERE server = (SELECT server FROM wowchar WHERE char_name = '" + ObjectManager.MyPlayer.Name + "'))"; sql += "SELECT req_item.item_name, req_item.backup_count - nvl(avi_item.item_count,0)"; sql += " FROM (SELECT item_name, backup_count FROM server_ahinfo) req_item,"; sql += " (SELECT item_name, item_count FROM itemsinbag WHERE char_name IN (SELECT char_name FROM server_ahinfo)) avi_item"; sql += " WHERE req_item.item_name = avi_item.item_name(+) AND req_item.backup_count > nvl(avi_item.item_count,0)"; DataTable dt = OraData.execSQL(sql); if (dt.Columns.Count == 0) { Logging.Write(string.Format("GetLessItem处理{0}时,出现错误", sql)); return(null); } foreach (DataRow dr in dt.Rows) { result.Add(dr[0].ToString(), Convert.ToInt32(dr[1])); } return(result); }
// 获取角色登陆信息 public static Dictionary <string, string> GetCharLoginInfo(string charID) { Dictionary <string, string> chars = new Dictionary <string, string>(); DataTable dt; if (string.IsNullOrWhiteSpace(charID)) { Logging.Write("输入为空"); return(chars); } string sql = string.Format("select char_name,server,char_idx,acc_list,acc_name,acc_pass from v_login_info where char_id={0}", charID); dt = OraData.execSQL(sql); if (dt.Columns.Count == 0) { Logging.Write(string.Format("处理{0}时,出现错误", sql)); return(chars); } chars.Clear(); foreach (DataRow dr in dt.Rows) { chars.Add("AccountName", dr["acc_name"].ToString()); chars.Add("AccountPass", dr["acc_pass"].ToString()); chars.Add("RealmName", dr["server"].ToString()); chars.Add("CharIdx", dr["char_idx"].ToString()); chars.Add("AccountList", dr["acc_list"].ToString()); } return(chars); }
public static DataTable GetCreationMap(int sk) { //商业技能(1-珠宝,2-铭文,3-锻造,4-炼金,5-裁缝,6-附魔)' string sql = string.Format("select item_name,need_item_name1,need_count1,need_item_name2,need_count2,disenchant from charcreation where char_name='{0}' and tradeskill={1}", ObjectManager.MyPlayer.Name, sk); DataTable dt = OraData.execSQL(sql); if (dt.Columns.Count == 0) { Logging.Write(string.Format("GetMineList处理{0}时,出现错误", sql)); return(null); } return(dt); }
public static DataTable GetAHList() { DataTable ahitems; string sql = string.Format("select item_name,item_minprice,item_maxprice,item_count,item_stacksize from ahitem where char_name='{0}'", ObjectManager.MyPlayer.Name); ahitems = OraData.execSQL(sql); if (ahitems.Columns.Count == 0) { Logging.Write(string.Format("GetAHList处理{0}时,出现错误", sql)); return(ahitems); } return(ahitems); }
public static List <string> GetMineList() { List <string> result = new List <string>(); string sql = string.Format("select item_name from mine_fj"); DataTable dt = OraData.execSQL(sql); if (dt.Columns.Count == 0) { Logging.Write(string.Format("GetMineList处理{0}时,出现错误", sql)); return(null); } foreach (DataRow dr in dt.Rows) { result.Add(dr[0].ToString()); } return(result); }
public static string GetParam(string Param) { string rtv = "", sql = ""; sql = string.Format("select nr from LazyParameters where bh='{0}'", Param); try { DataTable dt = OraData.execSQL(sql); foreach (DataRow dr in dt.Rows) { rtv = dr[0].ToString(); } } catch (Exception) { return(null); } return(rtv); }
// 获取角色背包信息 public static Dictionary <string, int> GetCharBagInfo(string CharName) { Dictionary <string, int> result = new Dictionary <string, int>(); DataTable dt; string sql = string.Format("select item_name,item_count from itemsinbag where char_name='{0}'", CharName); Logging.Write(sql); dt = OraData.execSQL(sql); if (dt.Columns.Count == 0) { Logging.Write(string.Format("处理{0}时,出现错误", sql)); return(null); } foreach (DataRow dr in dt.Rows) { result.Add(dr[0].ToString(), Convert.ToInt32(dr[1])); } return(result); }
/// <summary> /// 获取战斗列表 /// </summary> public static List <string> GetFightList() { List <string> result = new List <string>(); string sql = string.Format("select roll_type from fight_file"); try { DataTable dt = OraData.execSQL(sql); foreach (DataRow dr in dt.Rows) { result.Add(dr[0].ToString()); } } catch (Exception ex) { Logging.Write("GetFightList Error: " + ex.ToString()); return(null); } return(result); }
// 获取角色列表 public static Dictionary <string, string> GetChars() { Dictionary <string, string> chars = new Dictionary <string, string>(); DataTable dt; string sql = "select char_id,char_name from wowchar"; Logging.Write(sql); dt = OraData.execSQL(sql); if (dt.Columns.Count == 0) { Logging.Write(string.Format("处理{0}时,出现错误", sql)); return(chars); } chars.Clear(); foreach (DataRow dr in dt.Rows) { chars.Add(dr["char_id"].ToString(), dr["char_name"].ToString()); } return(chars); }
/// <summary> /// 获得制作列表,用于很多技能,除却 珠宝加工 /// </summary> /// <param name="Skill">技能名称(CF、MW、LJ)</param> /// <returns></returns> public static DataTable GetLianJin(string Skill) { if (string.IsNullOrWhiteSpace(Skill)) { Logging.Write("GetLianJin Error: 技能为空"); return(null); } DataTable dt; string sql = string.Format("select itemname,do_order,dischant,mail,needitem,havecd from char_lianjin c,lianjin l where (c.skill=l.skill and c.lianjin_itemname=l.itemname) and char_name = '{0}' and c.skill = '{1}' order by do_order", ObjectManager.MyPlayer.Name, Skill); try { dt = OraData.execSQL(sql); } catch (Exception ex) { Logging.Write("GetLianJin Error: " + ex.ToString()); return(null); } return(dt); }
/// <summary> /// 获取地图对应的采集列表(第一个是矿,第二个是草药) /// </summary> public static List <string> GetMapCollect(string MapName) { List <string> result = new List <string>(); string sql = string.Format("select mine_list,herb_list from map_file where map_name='{0}'", MapName); try { DataTable dt = OraData.execSQL(sql); foreach (DataRow dr in dt.Rows) { result.Add(dr[0].ToString()); result.Add(dr[1].ToString()); } } catch (Exception ex) { Logging.Write("GetMapCollect Error: " + ex.ToString()); return(null); } return(result); }
public static Dictionary <string, string> GetMailList() { Dictionary <string, string> result = new Dictionary <string, string>(); string sql = string.Format("select receiver_char_name,item_name from maillist where sender_char_name='{0}' or (sender_char_name='ALL' and server=(select server from wowchar where char_name='{0}'))", ObjectManager.MyPlayer.Name); DataTable dt = OraData.execSQL(sql); if (dt.Columns.Count == 0) { Logging.Write(string.Format("GetMailList处理{0}时,出现错误", sql)); return(null); } result.Clear(); foreach (DataRow dr in dt.Rows) { // 收件人是自己的话,跳过 if (dr[0].ToString().ToUpper().Equals(ObjectManager.MyPlayer.Name.ToUpper())) { continue; } result.Add(dr[1].ToString(), dr[0].ToString()); } return(result); }
public static DataTable GetJob(string MachineID) { string sql = string.Format("select runtime,char_id,char_name,dowhat from autologin where ((to_char(starttime,'hh24mi') = to_char(sysdate,'hh24mi') and everyday = 1) or to_char(starttime,'yyyymmddhh24mi') = to_char(sysdate,'yyyymmddhh24mi')) and machineid = '{0}'", MachineID); return(OraData.execSQL(sql)); }