private bool DB_CreateMail(CSCommon.Data.MailData mail)
{
string condition = "MailId = " + mail.MailId;
ServerFrame.DB.DBOperator dbOp = ServerFrame.DB.DBConnect.InsertData(condition, mail, true);
return(mDBConnect._ExecuteInsert(dbOp));
}
private void DB_RoleEnteInitMessages(UserRole role)//只有登录的时候调用
{
string condition = "OwnerId=" + role.RoleData.RoleId;
ServerFrame.DB.DBOperator dbOp = ServerFrame.DB.DBConnect.SelectData(condition, new CSCommon.Data.Message(), "");
System.Data.DataTable tab = mDBConnect._ExecuteSelect(dbOp, "Message");
if (tab != null)
{
foreach (System.Data.DataRow r in tab.Rows)
{
CSCommon.Data.Message msg = new CSCommon.Data.Message();
if (false == ServerFrame.DB.DBConnect.FillObject(msg, r))
{
continue;
}
DB_DelMessage(msg);
//发送消息
RPC.PackageWriter pkg = new RPC.PackageWriter();
H_RPCRoot.smInstance.HGet_PlanesServer(pkg).RPC_SendPlayerMsg(pkg, role.RoleData.RoleId, msg);
pkg.DoCommand(role.PlanesConnect, RPC.CommandTargetType.DefaultType);
}
}
else
{
System.Diagnostics.Debug.WriteLine("角色获取信息数据库执行失败:" + dbOp.SqlCode);
}
}
private void DB_SaveGiftData(UserRole role)
{
string condition = "OtherId = " + role.RoleData.RoleId;
ServerFrame.DB.DBOperator dbOp = ServerFrame.DB.DBConnect.ReplaceData(condition, role.GiftData, true);
mDBConnect._ExecuteInsert(dbOp);
}
public bool DB_CreateGird(CSCommon.Data.ConsignGridData data)
{
string condition = "GirdId = " + data.GirdId;
ServerFrame.DB.DBOperator dbOp = ServerFrame.DB.DBConnect.InsertData(condition, data, true);
return(mDBConnect._ExecuteInsert(dbOp));
}
private bool DB_DelMail(ulong mailId)
{
string condition = "MailId = " + mailId;
ServerFrame.DB.DBOperator dbOp = ServerFrame.DB.DBConnect.DelData(condition, new CSCommon.Data.MailData());
return(mDBConnect._ExecuteDelete(dbOp));
}
private void DB_SaveSocials(UserRole role)
{
var items = role.SocialManager.SaveSocialList();
foreach (var i in items)
{
CSCommon.Data.SocialData outItem = null;
foreach (var j in role.Socials)
{
if (j.OtherId == i.OtherId)
{
outItem = j;
break;
}
}
if (outItem != null)
{
string condition = "OtherId = " + i.OtherId;
ServerFrame.DB.DBOperator dbOp = ServerFrame.DB.DBConnect.UpdateData(condition, i, outItem);
mDBConnect._ExecuteUpdate(dbOp);
}
else
{
string condition = "OtherId = " + i.OtherId;
ServerFrame.DB.DBOperator dbOp = ServerFrame.DB.DBConnect.ReplaceData(condition, i, true);
mDBConnect._ExecuteInsert(dbOp);
}
}
role.Socials = items;
}
private void DB_InitSocial(UserRole role)
{
string condition = "OwnerId=" + role.RoleData.RoleId;
ServerFrame.DB.DBOperator dbOp = ServerFrame.DB.DBConnect.SelectData(condition, new CSCommon.Data.SocialData(), "");
System.Data.DataTable tab = mDBConnect._ExecuteSelect(dbOp, "SocialData");
if (tab != null)
{
List <CSCommon.Data.SocialData> items = new List <CSCommon.Data.SocialData>();
foreach (System.Data.DataRow r in tab.Rows)
{
CSCommon.Data.SocialData itemData = new CSCommon.Data.SocialData();
if (false == ServerFrame.DB.DBConnect.FillObject(itemData, r))
{
continue;
}
items.Add(itemData);
}
role.Socials.Clear();
role.Socials.AddRange(items);
role.SocialManager.InitSocialList(role);
items.Clear();
}
else
{
System.Diagnostics.Debug.WriteLine("角色获取关系数据库执行失败:" + dbOp.SqlCode);
}
}
public void Init(PlanesData[] planedatas)
{
foreach (var p in planedatas)
{
string condition = "PlaneId=" + p.PlanesId;
ServerFrame.DB.DBOperator dbOp = ServerFrame.DB.DBConnect.SelectData(condition, new CityData(), "");
System.Data.DataTable tab = UserRoleManager.Instance.DBConnect._ExecuteSelect(dbOp, "CityData");
if (tab != null)
{
List <CityData> citys = new List <CityData>();
foreach (System.Data.DataRow r in tab.Rows)
{
CSCommon.Data.CityData city = new CSCommon.Data.CityData();
if (false == ServerFrame.DB.DBConnect.FillObject(city, r))
{
continue;
}
citys.Add(city);
}
var world = new World();
world.Init(p.PlanesId, citys);
mWorlds[p.PlanesId] = world;
}
else
{
Log.Log.Mail.Print("WorldManager init PlanesData failed :{0}", condition);
}
}
}
private bool DB_DelMails(ulong roleId)
{
string condition = "OwnerId=" + roleId + " and StrItems = " + "\'" + "\'" + " and StrCurrencies = " + "\'" + "\'";
ServerFrame.DB.DBOperator dbOp = ServerFrame.DB.DBConnect.DelData(condition, new CSCommon.Data.MailData());
return(mDBConnect._ExecuteDelete(dbOp));
}
private bool DB_CreateMessage(CSCommon.Data.Message message)
{
string condition = "MessageId = " + message.MessageId;
ServerFrame.DB.DBOperator dbOp = ServerFrame.DB.DBConnect.InsertData(condition, message, true);
return(mDBConnect._ExecuteInsert(dbOp));
}
private void DB_DelMessage(CSCommon.Data.Message message)
{
string condition = "MessageId =" + message.MessageId;
ServerFrame.DB.DBOperator dbOp = ServerFrame.DB.DBConnect.DestroyData(condition, message);
mDBConnect._ExecuteDestroy(dbOp);
return;
}
private void DB_UpdateMail(CSCommon.Data.MailData mail)
{
string condition = "MailId = " + mail.MailId;
ServerFrame.DB.DBOperator dbOp = ServerFrame.DB.DBConnect.ReplaceData(condition, mail, true);
mDBConnect._ExecuteInsert(dbOp);
return;
}
public void DB_DelGird(CSCommon.Data.ConsignGridData data)
{
string condition = "GirdId =" + data.GirdId;
ServerFrame.DB.DBOperator dbOp = ServerFrame.DB.DBConnect.DestroyData(condition, data);
mDBConnect._ExecuteDestroy(dbOp);
return;
}
private bool DB_CreatGuildCom(CSCommon.Data.GuildCom Guild)
{
// 产生insert语句
string condition = "GuildId = " + Guild.GuildId;
ServerFrame.DB.DBOperator dbOp = ServerFrame.DB.DBConnect.InsertData(condition, Guild, true);
return(mDBConnect._ExecuteInsert(dbOp));
}
public void DB_DelGuildCom(CSCommon.Data.GuildCom Guild)
{
//产生Destroy语句
string condition = "GuildId =" + Guild.GuildId;
ServerFrame.DB.DBOperator dbOp = ServerFrame.DB.DBConnect.DestroyData(condition, Guild);
mDBConnect._ExecuteDestroy(dbOp);
return;
}
private CSCommon.Data.MailData DB_GetMail(ulong mailId)
{
string condition = "MailId = " + mailId;
ServerFrame.DB.DBOperator dbOp = ServerFrame.DB.DBConnect.SelectData(condition, new CSCommon.Data.MailData(), "");
System.Data.DataTable tab = mDBConnect._ExecuteSelect(dbOp, "MailData");
if (tab == null || tab.Rows.Count != 1)
{
return(null);
}
CSCommon.Data.MailData mail = new CSCommon.Data.MailData();
if (false == ServerFrame.DB.DBConnect.FillObject(mail, tab.Rows[0]))
{
return(null);
}
return(mail);
}
// public void CreatePlanesData(byte level,string name,byte state)
// {
// CSCommon.Data.PlanesData pd = new CSCommon.Data.PlanesData();
// pd.PlanesId = ServerFrame.Util.GenerateObjID(ServerFrame.GameObjectType.Server);
// pd.PlanesName = name;
// pd.CreateTime = System.DateTime.Now;
// pd.ActiveState = state;
//
// mPlanes.Add(pd.PlanesId, pd);
//
// string condition = "PlanesName=\'" + name + "\'";
// ServerFrame.DB.DBOperator dbOp = ServerFrame.DB.DBConnect.ReplaceData(condition, pd, true);
// mDataServer.DBLoaderConnect._ExecuteInsert(dbOp);
// }
CSCommon.Data.PlanesData LoadPlanesFromDB(string planesName)
{
string condition = "ActiveState>0 && PlanesName = \'" + planesName + "\'";
ServerFrame.DB.DBOperator dbOp = ServerFrame.DB.DBConnect.SelectData(condition, new CSCommon.Data.PlanesData(), "");
System.Data.DataTable tab = mDataServer.DBLoaderConnect._ExecuteSelect(dbOp, "CSCommon.Data.PlanesData");
if (tab == null || tab.Rows.Count != 1)
{
return(null);
}
CSCommon.Data.PlanesData pd = new CSCommon.Data.PlanesData();
if (false == ServerFrame.DB.DBConnect.FillObject(pd, tab.Rows[0]))
{
return(pd);
}
return(null);
}
private void DB_InitGiftData(UserRole role)
{
string condition = "OwnerId=" + role.RoleData.RoleId;
ServerFrame.DB.DBOperator dbOp = ServerFrame.DB.DBConnect.SelectData(condition, new CSCommon.Data.GiftData(), "");
System.Data.DataTable tab = mDBConnect._ExecuteSelect(dbOp, "GiftData");
if (tab != null && tab.Rows.Count == 1)
{
CSCommon.Data.GiftData gd = new CSCommon.Data.GiftData();
if (ServerFrame.DB.DBConnect.FillObject(gd, tab.Rows[0]))
{
role.GiftData = gd;
}
}
else
{
System.Diagnostics.Debug.WriteLine("角色获取礼物数据库执行失败:" + dbOp.SqlCode);
}
}
//加载数据库中的相关静态配置信息
public static void LoadDbConfig(ServerFrame.DB.DBConnect dbConnect)
{
ServerFrame.DB.DBOperator dbOp = ServerFrame.DB.DBConnect.SelectData("", new CSCommon.Data.CPlanesConfig(), "");
System.Data.DataTable tab = dbConnect._ExecuteSelect(dbOp, "planesconfig");
if (tab != null)
{
foreach (System.Data.DataRow r in tab.Rows)
{
CSCommon.Data.CPlanesConfig lPlanesConfig = new CSCommon.Data.CPlanesConfig();
if (false == ServerFrame.DB.DBConnect.FillObject(lPlanesConfig, r))
{
continue;
}
m_PlanesConfig[lPlanesConfig.PlanesServerId] = lPlanesConfig;
}
}
else
{
System.Diagnostics.Debug.WriteLine("加载位面管理地图信息失败:" + dbOp.SqlCode);
}
}
public CSCommon.Data.ConsignGridData GetGird(ulong id)
{
CSCommon.Data.ConsignGridData gird = new CSCommon.Data.ConsignGridData();
string condition = "GirdId =" + id;
ServerFrame.DB.DBOperator dbOp = ServerFrame.DB.DBConnect.SelectData(condition, gird, "");
System.Data.DataTable tab = mDBConnect._ExecuteSelect(dbOp, "ConsignGirdData");
if (tab != null && tab.Rows.Count == 1)
{
if (false == ServerFrame.DB.DBConnect.FillObject(gird, tab.Rows[0]))
{
return(null);
}
return(gird);
}
else
{
System.Diagnostics.Debug.WriteLine("GetGird failed:{0}" + id);
return(null);
}
}
void Tick()
{
if (mLogQueue.Count > 0)
{
ServerFrame.DB.DBLogData atom = null;
lock (this)
{
atom = mLogQueue.Dequeue();
}
try
{
string condition = "LogId = " + ServerFrame.DB.DBConnect.Guid2SqlString(atom.LogId);
ServerFrame.DB.DBOperator dbOp = ServerFrame.DB.DBConnect.ReplaceData(condition, atom, false);
mDBConnect._ExecuteInsert(dbOp);
}
catch (System.Exception ex)
{
Log.Log.Common.Print(ex.ToString());
Log.Log.Common.Print(ex.StackTrace.ToString());
}
}
}
public PlanesMgr(IDataServer server)
{
mDataServer = server;
//加载所有活跃位面
string condition = "ActiveState>0";
ServerFrame.DB.DBOperator dbOp = ServerFrame.DB.DBConnect.SelectData(condition, new CSCommon.Data.PlanesData(), "");
System.Data.DataTable tab = mDataServer.DBLoaderConnect._ExecuteSelect(dbOp, "CSCommon.Data.PlanesData");
if (tab == null)
{
return;
}
foreach (System.Data.DataRow r in tab.Rows)
{
CSCommon.Data.PlanesData pd = new CSCommon.Data.PlanesData();
if (false == ServerFrame.DB.DBConnect.FillObject(pd, r))
{
continue;
}
mPlanes.Add(pd.PlanesId, pd);
}
}
public RankData DB_LoadRankData(UserRole role)
{
RankData rd = new RankData();
rd.RoleId = role.RoleData.RoleId;
rd.PlanesId = role.RoleData.PlanesId;
rd.RoleName = role.RoleData.Name;
rd.Level = role.RoleData.Level;
rd.Fighting = 0;
rd.Exploit = 0;
rd.ExploitRank = 0;
string condition = "RoleId=" + rd.RoleId;
ServerFrame.DB.DBOperator dbOp = ServerFrame.DB.DBConnect.InsertData(condition, rd, false);
if (false == mDBConnect._ExecuteInsert(dbOp))
{
Log.Log.Common.Print("create RankData failed");
return(null);
}
return(rd);
}
private List <CSCommon.Data.MailData> DB_GetMails(string condition)
{
List <CSCommon.Data.MailData> mails = new List <CSCommon.Data.MailData>();
ServerFrame.DB.DBOperator dbOp = ServerFrame.DB.DBConnect.SelectData(condition, new CSCommon.Data.MailData(), "");
System.Data.DataTable tab = mDBConnect._ExecuteSelect(dbOp, "MailData");
if (tab != null)
{
foreach (System.Data.DataRow r in tab.Rows)
{
CSCommon.Data.MailData mail = new CSCommon.Data.MailData();
if (false == ServerFrame.DB.DBConnect.FillObject(mail, r))
{
continue;
}
mails.Add(mail);
}
}
else
{
Log.Log.Mail.Print("RPC_GetRoleMails failed :{0}", condition);
}
return(mails);
}
public void DB_InitAllGuildMember(GuildInstance guild)
{
ServerFrame.DB.DBOperator dbOp = new ServerFrame.DB.DBOperator();
dbOp.SqlCode = "select RoleId from RoleCom where GuildId=\'" + guild.GuildData.GuildId + "\'";
var tab = UserRoleManager.Instance.DBConnect._ExecuteSelect(dbOp, "RoleCom");
if (tab == null || tab.Rows.Count < 1)
{
return;
}
for (int i = 0; i < tab.Rows.Count; i++)
{
ulong roleId = (ulong)tab.Rows[i]["RoleId"];
if (roleId != 0)
{
var role = UserRoleManager.Instance.GetRole(roleId);
if (role != null)
{
guild.Members.Add(roleId, role);
}
}
}
}
// private void DB_CreatStranger(CSCommon.Data.StrangerInfo stranger)
// {
// // 产生insert语句
// string condition = "EnemyerId = " + stranger.StrangerId;
// ServerFrame.DB.DBOperator dbOp = ServerFrame.DB.DBConnect.InsertData(condition, stranger, true);
// mDBConnect._ExecuteInsert(dbOp);
// return;
// }
//
// private void DB_SaveStranger(CSCommon.Data.StrangerInfo stranger)
// {
// var condition = "EnemyerId=\'" + (stranger.StrangerId);
// var dbOp = ServerFrame.DB.DBConnect.UpdateData(condition, stranger, null);
// mDBConnect._ExecuteUpdate(dbOp);
// return;
// }
//
// private void DB_DelStranger(CSCommon.Data.StrangerInfo stranger)
// {
// //产生Destroy语句
// string condition = "EnemyerId =" + stranger.StrangerId;
// ServerFrame.DB.DBOperator dbOp = ServerFrame.DB.DBConnect.DestroyData(condition, stranger);
// mDBConnect._ExecuteDestroy(dbOp);
// return;
// }
#endregion
#region 创建加载角色
public UserRole TryCreatePlaye(CSCommon.Data.RoleDetail pd)
{
UserRole role = new UserRole();
role.RoleData.RoleId = pd.RoleId;
role.RoleData.Name = pd.RoleName;
role.RoleData.Sex = pd.Sex;
role.RoleData.Level = pd.RoleLevel; //change
role.RoleData.Camp = pd.Camp; //change
role.RoleData.Profession = pd.Profession; //change
role.RoleData.PlanesId = pd.PlanesId; //change
role.RoleData.MapName = pd.MapName;
string condition = "RoleId=" + pd.RoleId;
ServerFrame.DB.DBOperator dbOp = ServerFrame.DB.DBConnect.InsertData(condition, role.RoleData, false);
if (false == mDBConnect._ExecuteInsert(dbOp))
{
Log.Log.Common.Print("create rolecom failed");
return(null);
}
mRoles.Add(pd.RoleId, role);
RankData rd = new RankData();
rd.RoleId = pd.RoleId;
rd.PlanesId = pd.PlanesId;
rd.RoleName = pd.RoleName;
rd.Level = pd.RoleLevel;
rd.Fighting = 0;
rd.Exploit = 0;
rd.ExploitRank = 0;
UPdateRankData(rd);
return(role);
}