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));
}
