public static void SaveAhInfo(string seller, string item, int prize)
{
if (string.IsNullOrWhiteSpace(seller))
{
return;
}
if (string.IsNullOrWhiteSpace(item))
{
return;
}
OraData.execSQLCmd(string.Format("begin add_ahinfo('{0}','{1}','{2}',{3}); end;", ObjectManager.MyPlayer.Name, seller, item, prize));
}
/// <summary>保存char背包信息</summary>
public static void SaveInfo_Bag(Dictionary <string, int> bag)
{
if (bag == null)
{
return;
}
foreach (KeyValuePair <string, int> item in bag)
{
string sql = string.Format("begin add_bag('{0}','{1}',{2}); end;", ObjectManager.MyPlayer.Name, item.Key, item.Value);
Logging.Write(sql);
if (!OraData.execSQLCmd(sql))
{
Logging.Write(string.Format("处理{0}时，出现错误", sql));
}
}
}
/// <summary>
/// 向数据库写入附加日志信息
/// </summary>
/// <param name="LogType">日志类型</param>
/// <param name="LogText">日志内容</param>
public static void WriteLog(string LogType, string LogText)
{
if (string.IsNullOrWhiteSpace(LogType))
{
return;
}
if (string.IsNullOrWhiteSpace(LogText))
{
return;
}
string char_name = ObjectManager.MyPlayer.Name;
if (string.IsNullOrWhiteSpace(ObjectManager.MyPlayer.Name) || char_name.Contains("Error"))
{
char_name = "系统";
}
Logging.Write(LogText);
OraData.execSQLCmd(string.Format("insert into wowlog (logtype,logtext,char_name,machineid) values ('{0}','{1}','{2}','{3}')", LogType.Replace("'", "''"), LogText.Replace("'", "''"), char_name, LazySettings.MachineID));
}
public static void SaveCharGold(string char_name, int gold)
{
if (string.IsNullOrWhiteSpace(char_name))
{
Logging.Write("角色名字为空");
return;
}
if (gold == null)
{
Logging.Write("金币数量为空");
return;
}
string sql = string.Format("begin gold('{0}',{1}); end;", char_name, gold);
if (!OraData.execSQLCmd(sql))
{
Logging.Write(string.Format("处理{0}时，出现错误", sql));
}
}
/// <summary>
/// 向数据库写Lazy的日志信息
/// </summary>
/// <param name="LogText">日志内容</param>
public static void WriteLazyLog(string LogText)
{
//if (!IsWriteLazy.Equals("Y")) return;
if (string.IsNullOrWhiteSpace(LogText))
{
return;
}
string role_name = "";
if (string.IsNullOrWhiteSpace(ObjectManager.MyPlayer.Name))
{
role_name = "系统";
}
else
{
role_name = ObjectManager.MyPlayer.Name;
}
OraData.execSQLCmd(string.Format("insert into lazylog (char_name,logtext) values ('{0}','{1}')", role_name, LogText.Replace("'", "''")));
}
