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("'", "''"))); }