/// <summary>
/// 从特定字典集合组合表和字典参数
/// </summary>
/// <param name="dic"></param>
public static void CopyToDictionaryAndParms(this yuan.YuanMemoryDB.YuanTable my, Dictionary <short, object> dic)
{
if (dic.Count > 0)
{
my.Refresh();
my.DeleteRows.Clear();
my.Clear();
foreach (KeyValuePair <short, object> item in dic)
{
if (item.Key == 0)
{
Dictionary <string, string> tempDic = ((Dictionary <object, object>)item.Value).DicObjTo <string, string>();
my.TableName = tempDic["TableName"];
my.TableKey = tempDic["TableKey"];
}
else if (item.Key == 1)
{
my.mParms = ((Dictionary <object, object>)item.Value).DicObjTo <short, object>().ToByteObject();
}
else
{
string[] listDc = (string[])item.Value;
int dcNum = 0;
string dcStr = string.Empty;
foreach (string dc in listDc)
{
if (dcNum == 0)
{
dcStr = dc;
}
else
{
if (my.Count < dcNum)
{
yuan.YuanMemoryDB.YuanRow tempRow = new yuan.YuanMemoryDB.YuanRow();
tempRow.Add(dcStr, dc);
my.Rows.Add(tempRow);
}
else
{
my.Rows[dcNum - 1].Add(dcStr, dc);
}
}
dcNum++;
}
}
}
}
}
/// <summary>
/// 拍卖到时间时，移除此条拍卖
/// </summary>
/// <param name="index"></param>
public void RemoveItem(int index)
{
yuan.YuanMemoryDB.YuanTable yTable = AuctionCompany.auctionCompany.auctionTable;
yuan.YuanMemoryDB.YuanRow yRow = yTable.SelectRowEqual("id", index.ToString());
if (null == yRow)
{
return;
}
yTable.Rows.Remove(yRow);
m_scrollView.UpdateListItem(AuctionCompany.auctionCompany.auctionTable.Rows.Count);
aucTable = AuctionCompany.auctionCompany.auctionTable;
}
private int maxTowerLevel = 30;// 困魔塔最大层数
// Use this for initialization
void Start()
{
yuan.YuanMemoryDB.YuanTable bossTower = YuanUnityPhoton.GetYuanUnityPhotonInstantiate().ytBosstower;
List <string> ids = bossTower.GetColumnText("id");
maxTowerLevel = ids.Count;
int layer = 0;
yuan.YuanMemoryDB.YuanRow yRow = null;
string item = "";
for (int i = 0; i < ids.Count; i++)
{
layer = int.Parse(ids[i]);
yRow = bossTower.SelectRowEqual("id", ids[i]);
bossTowerInfoDic.Add(layer, yRow);
item = yRow["itemlist"].YuanColumnText.Trim();
if (string.IsNullOrEmpty(item))
{
continue;
}
string[] items = item.Split(';');
itemList.Add(layer, items);
if (i == maxTowerLevel - 1)
{
//显示首次通关奖励
string rewardItem = yRow["rewarditem"].YuanColumnText.Trim();
if (!string.IsNullOrEmpty(rewardItem))
{
firstRewardItem.SetItemInfo(rewardItem);
firstRewardItem.DisableItem();
}
}
}
//if (isFirst)
//{
// //yield return new WaitForSeconds(1.0f);
// InitItemGrid();
// InitGoldAndExp(currLayer);
// isFirst = false;
//}
if (!BtnGameManagerBack.isTown())
{
closeBtn.SetActive(false);
}
}
/// <summary>
/// 判断是否可以强化该装备
/// </summary>
/// <param name="oldID">要强化的装备号</param>
/// <param name="index">装备所在包裹编号</param>
/// <param name="useBlood">是否使用血石头</param>
/// <param name="yt">人物表</param>
void EquepmentBuild(string oldID, int index, int useBlood, yuan.YuanMemoryDB.YuanTable yt)
{
bool canBuild = false;
bool useBloodBuild = false;
if (useBlood == 0)
{
canBuild = true;
}
else
{
if (int.Parse(yt.Rows[0]["Bloodstone"].YuanColumnText) >= useBlood)
{
canBuild = true;
useBloodBuild = true;
}
else
{
canBuild = false;
}
}
if (canBuild)
{
if (useBloodBuild)
{
// InRoom.GetInRoomInstantiate().SetSetPlayerBehavior(yuan.YuanPhoton.PlayerBehaviorType.GameFunction , parseInt(yuan.YuanPhoton.GameFunction.UpdateEquipBlood).ToString());
realBuild(oldID, index, yt);
}
else
{
int useRandom = 0;
useRandom = Random.Range(0, 100);
RandomBuild = 90 - Mathf.Abs(30 - InRoom.GetInRoomInstantiate().serverTime.Minute);
if (useRandom <= RandomBuild)
{
realBuild(oldID, index, yt);
}
else
{
// 强化失败
}
}
}
else
{
// 不可强化
}
}
public void SetFrist(yuan.YuanMemoryDB.YuanTable mYt, DelListBack mEvent, int mNum, UIGrid mGrid, List <BtnArena> mListBtns, string btnFunction, BtnGameManager.DegSetBtn degSetBtn, string mName)
{
this.myGrid = mGrid;
this.myListBtns = mListBtns;
this.myBtnFunction = btnFunction;
this.myDegSetBtn = degSetBtn;
this.myName = mName;
this.yt = mYt;
this.eventListBack = mEvent;
this.listNum = mNum;
this.maxPage = yt.Count / listNum;
if (yt.Count % listNum > 0)
{
maxPage++;
}
SetPage(0);
}
public void Sort(SortType mSortType, string mSortRowName, string mKeyName)
{
if (mSortType == SortType.desc)
{
Dictionary <string, int> dic = new Dictionary <string, int>();
for (int i = 0; i < yt.Rows.Count; i++)
{
dic.Add(yt.Rows[i][mKeyName].YuanColumnText, int.Parse(yt.Rows[i][mSortRowName].YuanColumnText));
}
var result = from pair in dic orderby pair.Value descending select pair;
yuan.YuanMemoryDB.YuanTable tempTable = new yuan.YuanMemoryDB.YuanTable("", "");
tempTable.Rows = yt.Rows;
yt.Rows = new List <yuan.YuanMemoryDB.YuanRow>();
foreach (KeyValuePair <string, int> r in result)
{
yt.Add(tempTable.SelectRowEqual(mKeyName, r.Key));
}
}
else if (mSortType == SortType.asc)
{
Dictionary <string, int> dic = new Dictionary <string, int>();
for (int i = 0; i < yt.Rows.Count; i++)
{
dic.Add(yt.Rows[i][mKeyName].YuanColumnText, int.Parse(yt.Rows[i][mSortRowName].YuanColumnText));
}
var result = from pair in dic orderby pair.Value ascending select pair;
yuan.YuanMemoryDB.YuanTable tempTable = new yuan.YuanMemoryDB.YuanTable("", "");
tempTable.Rows = yt.Rows;
yt.Rows = new List <yuan.YuanMemoryDB.YuanRow>();
foreach (KeyValuePair <string, int> r in result)
{
yt.Add(tempTable.SelectRowEqual(mKeyName, r.Key));
}
}
SetPage(0);
}
/// <summary>
/// 初始化列表，显示拍卖信息
/// </summary>
/// <param name="tempTable"></param>
public void ShowAuctionItems(yuan.YuanMemoryDB.YuanTable tempTable)
{
EnableGrid(true);
m_scrollView = itemGrid.transform.GetComponent <LoopScrollView>();
m_scrollView.Init(true);
m_scrollView.UpdateListItem(tempTable.Rows.Count);
m_scrollView.SetDelegate(UpdateItemInfo, ItemOnClick);
aucTable = tempTable;
for (int i = 0; i < itemGrid.transform.childCount; i++)
{
if (tempTable.Rows.Count != 0 && i <= tempTable.Rows.Count)
{
UpdateItemInfo(itemGrid.transform.GetChild(i).gameObject);
}
}
}
public void Dispose()
{
OutTime = 0;
Prams = null;
yt = null;
}
void Awake()
{
my = this;
yt = new yuan.YuanMemoryDB.YuanTable("GuildAddMoney" + this.name, "");
}
// Use this for initialization
void Awake()
{
yt = new yuan.YuanMemoryDB.YuanTable("PlayerInformation" + this.name, "");
}
public void SetPVP1RevengeList(yuan.YuanMemoryDB.YuanTable mYt)
{
for (int i = 0; i < listPVP1.Count; i++)
{
listPVP1[i].gameObject.SetActiveRecursively(false);
}
for (int i = 0; i < mYt.Rows.Count; i++)
{
if (listPVP1.Count > i)
{
listPVP1[i].playerID = mYt.Rows[i]["PlayerID"].YuanColumnText;
listPVP1[i].lblPlayerName.text = mYt.Rows[i]["PlayerName"].YuanColumnText;
listPVP1[i].yr = mYt.Rows[i];
listPVP1[i].lblPlayerLevel.text = "Lv" + mYt.Rows[i]["PlayerLevel"].YuanColumnText;
listPVP1[i].picPlayer.atlas = PanelStatic.StaticYuanPicManger.picPlayer[int.Parse(mYt.Rows[i]["ProID"].YuanColumnText) - 1].atlas;
listPVP1[i].picPlayer.spriteName = PanelStatic.StaticYuanPicManger.picPlayer[int.Parse(mYt.Rows[i]["ProID"].YuanColumnText) - 1].spriteName;
string[] bePVPInfo = mYt.Rows[i]["pvp1BeInfo"].YuanColumnText.Split(',');
if (bePVPInfo[1].Trim() == "0")
{
listPVP1[i].lblPlayerPro.text = string.Format("{0}[00ff00]{1}", System.DateTime.Parse(bePVPInfo[3]).ToShortTimeString(), StaticLoc.Loc.Get("info339"));
}
else
{
listPVP1[i].lblPlayerPro.text = string.Format("{0}[ff0000]{1}", System.DateTime.Parse(bePVPInfo[3]).ToShortTimeString(), StaticLoc.Loc.Get("info339"));
}
//listPVP1[i].lblPlayerPro.text = RefreshList.GetPro(mYt.Rows[i]["ProID"].YuanColumnText);
if (myGrid.gameObject.active)
{
listPVP1[i].gameObject.SetActiveRecursively(true);
if (bePVPInfo[2].Trim() == "2")
{
listPVP1[i].btnAddLable.text = StaticLoc.Loc.Get("info341");
listPVP1[i].picNew.gameObject.active = false;
}
else
{
listPVP1[i].btnAddLable.text = StaticLoc.Loc.Get("info342");
listPVP1[i].picNew.gameObject.active = true;
}
}
else
{
listPVP1[i].gameObject.SetActiveRecursively(false);
}
}
else
{
BtnPlayerForTeam tempPlayer = (BtnPlayerForTeam)Instantiate(btnPlayerForOnePVP);
tempPlayer.GetComponent <UIToggle>().group = 7;
tempPlayer.transform.parent = myGrid.transform;
tempPlayer.transform.localPosition = Vector3.zero;
tempPlayer.transform.localScale = new Vector3(1, 1, 1);
tempPlayer.btnAddMessage.target = this.gameObject;
tempPlayer.btnAddMessage.functionName = "BtnPVP1";
tempPlayer.btnAddLable.text = StaticLoc.Loc.Get("info338");
tempPlayer.lblPlayerPro.text = RefreshList.GetPro(mYt.Rows[i]["ProID"].YuanColumnText);
tempPlayer.playerID = mYt.Rows[i]["PlayerID"].YuanColumnText;
tempPlayer.lblPlayerName.text = mYt.Rows[i]["PlayerName"].YuanColumnText;
tempPlayer.picPlayer.atlas = PanelStatic.StaticYuanPicManger.picPlayer[int.Parse(mYt.Rows[i]["ProID"].YuanColumnText) - 1].atlas;
tempPlayer.picPlayer.spriteName = PanelStatic.StaticYuanPicManger.picPlayer[int.Parse(mYt.Rows[i]["ProID"].YuanColumnText) - 1].spriteName;
tempPlayer.lblPlayerLevel.text = "Lv" + mYt.Rows[i]["PlayerLevel"].YuanColumnText;
tempPlayer.yr = mYt.Rows[i];
string[] bePVPInfo = mYt.Rows[i]["pvp1BeInfo"].YuanColumnText.Split(',');
if (bePVPInfo[2].Trim() == "2")
{
tempPlayer.btnAddLable.text = StaticLoc.Loc.Get("info343");
tempPlayer.picNew.gameObject.active = false;
}
else
{
tempPlayer.btnAddLable.text = StaticLoc.Loc.Get("info342");
tempPlayer.picNew.gameObject.active = true;
}
if (bePVPInfo[1].Trim() == "0")
{
tempPlayer.lblPlayerPro.text = string.Format("{0}[00ff00]{1}", System.DateTime.Parse(bePVPInfo[3]).ToShortTimeString(), StaticLoc.Loc.Get("info339"));
}
else
{
tempPlayer.lblPlayerPro.text = string.Format("{0}[ff0000]{1}", System.DateTime.Parse(bePVPInfo[3]).ToShortTimeString(), StaticLoc.Loc.Get("info340"));
}
listPVP1.Add(tempPlayer);
if (!myGrid.gameObject.active)
{
tempPlayer.gameObject.SetActiveRecursively(false);
}
}
myGrid.repositionNow = true;
}
}
private void RefreshPlayerList(yuan.YuanMemoryDB.YuanTable mYt)
{
foreach (BtnPlayerForTeam item in listBtn)
{
item.gameObject.SetActiveRecursively(false);
}
if (mYt.Rows.Count > 0)
{
lblNull.gameObject.active = false;
}
else
{
lblNull.gameObject.active = true;
//if (listType != ListType.Firends&&listType!=ListType.Team)
//{
// this.transform.parent.gameObject.SetActiveRecursively(false);
InActiveChild();
//}
if (listType == ListType.Team)
{
if (ytPlayerLegionList.Count > 0 || ytPlayerList.Count > 0)
{
lblNull.gameObject.active = false;
if (ytPlayerList.Count > 0)
{
teamType = TeamType.Team;
}
else if (ytPlayerLegionList.Count > 0)
{
teamType = TeamType.Legion;
}
else
{
teamType = TeamType.Team;
}
playerInfo.teamType = teamType;
}
else
{
//Debug.Log("+++++++++++++++++++++");
// this.transform.parent.gameObject.SetActiveRecursively(false);
InActiveChild();
foreach (BtnPlayerForTeam item in listBtn)
{
item.gameObject.SetActiveRecursively(false);
}
}
}
}
int num = 0;
foreach (yuan.YuanMemoryDB.YuanRow item in mYt.Rows)
{
UIToggle ckb;
if (num < listBtn.Count)
{
int numPro = int.Parse(item["ProID"].YuanColumnText.Trim()) - 1;
listBtn[num].picPlayer.atlas = yuanPicManager.picPlayer[numPro].atlas;
listBtn[num].picPlayer.spriteName = yuanPicManager.picPlayer[numPro].spriteName;
listBtn[num].lblPlayerName.text = item["PlayerName"].YuanColumnText.Trim();
listBtn[num].lblPlayerLevel.text = item["PlayerLevel"].YuanColumnText.Trim();
listBtn[num].lblPlayerPro.text = GetPro(item["ProID"].YuanColumnText.Trim());
if (listType == ListType.Guild)
{
if (int.Parse(item["GuildPosition"].YuanColumnText.Trim()) == 1)
{
listBtn[num].GuildPosition.text = StaticLoc.Loc.Get("info950");
}
else if (int.Parse(item["GuildPosition"].YuanColumnText.Trim()) == 2)
{
listBtn[num].GuildPosition.text = StaticLoc.Loc.Get("info947");
}
else if (int.Parse(item["GuildPosition"].YuanColumnText.Trim()) == 3)
{
listBtn[num].GuildPosition.text = StaticLoc.Loc.Get("info948");
}
else if (int.Parse(item["GuildPosition"].YuanColumnText.Trim()) == 4)
{
listBtn[num].GuildPosition.text = StaticLoc.Loc.Get("buttons705");
}
else if (int.Parse(item["GuildPosition"].YuanColumnText.Trim()) == 5)
{
listBtn[num].GuildPosition.text = StaticLoc.Loc.Get("info964");
}
else if (int.Parse(item["GuildPosition"].YuanColumnText.Trim()) == 0)
{
listBtn[num].GuildPosition.text = StaticLoc.Loc.Get("info949");
}
}
listBtn[num].yr = item;
ckb = listBtn[num].GetComponent <UIToggle>();
ckb.isChecked = false;
listBtn[num].gameObject.SetActiveRecursively(true);
}
else
{
BtnPlayerForTeam btnforTeamTemp = ((GameObject)Instantiate(btnPlayerForTeam)).GetComponent <BtnPlayerForTeam>();
btnforTeamTemp.GetComponent <UIToggle>().group = 5;
UIButtonMessage btnMessage = btnforTeamTemp.GetComponent <UIButtonMessage>();
btnMessage.target = this.gameObject;
if (txtMailAddressee != null)
{
btnMessage.functionName = "SetMailAddress";
}
else
{
btnMessage.functionName = "SetPlayerInfo";
}
btnforTeamTemp.yr = item;
btnforTeamTemp.playerInfo = this.playerInfo;
btnforTeamTemp.transform.parent = this.transform;
btnforTeamTemp.transform.localPosition = Vector3.zero;
btnforTeamTemp.transform.localScale = new Vector3(1, 1, 1);
int numPro = int.Parse(item["ProID"].YuanColumnText.Trim()) - 1;
btnforTeamTemp.picPlayer.atlas = yuanPicManager.picPlayer[numPro].atlas;
btnforTeamTemp.picPlayer.spriteName = yuanPicManager.picPlayer[numPro].spriteName;
btnforTeamTemp.lblPlayerName.text = item["PlayerName"].YuanColumnText.Trim();
btnforTeamTemp.lblPlayerLevel.text = item["PlayerLevel"].YuanColumnText.Trim();
btnforTeamTemp.lblPlayerPro.text = GetPro(item["ProID"].YuanColumnText.Trim());
if (listType == ListType.Guild)
{
if (int.Parse(item["GuildPosition"].YuanColumnText.Trim()) == 1)
{
btnforTeamTemp.GuildPosition.text = StaticLoc.Loc.Get("info950");
}
else if (int.Parse(item["GuildPosition"].YuanColumnText.Trim()) == 2)
{
btnforTeamTemp.GuildPosition.text = StaticLoc.Loc.Get("info947");
}
else if (int.Parse(item["GuildPosition"].YuanColumnText.Trim()) == 3)
{
btnforTeamTemp.GuildPosition.text = StaticLoc.Loc.Get("info948");
}
else if (int.Parse(item["GuildPosition"].YuanColumnText.Trim()) == 4)
{
btnforTeamTemp.GuildPosition.text = StaticLoc.Loc.Get("buttons705");
}
else if (int.Parse(item["GuildPosition"].YuanColumnText.Trim()) == 5)
{
btnforTeamTemp.GuildPosition.text = StaticLoc.Loc.Get("info964");
}
else if (int.Parse(item["GuildPosition"].YuanColumnText.Trim()) == 0)
{
btnforTeamTemp.GuildPosition.text = StaticLoc.Loc.Get("info949");
}
}
ckb = btnforTeamTemp.GetComponent <UIToggle>();
ckb.group = 5;
UIPanel tempPanel = btnforTeamTemp.GetComponent <UIPanel>();
if (tempPanel != null)
{
Destroy(tempPanel);
}
listBtn.Add(btnforTeamTemp);
}
if (num == 0)
{
ckb.isChecked = true;
}
num++;
}
myGrid.repositionNow = true;
}
void Awake()
{
ytPlayerList = new yuan.YuanMemoryDB.YuanTable(rowNameList, "PlayerID");
ytPlayerLegionList = new yuan.YuanMemoryDB.YuanTable("LegionList", "");
ytIDs = new yuan.YuanMemoryDB.YuanTable(rowNameList + "IDs", "");
}
// Use this for initialization
void Awake()
{
yt = new yuan.YuanMemoryDB.YuanTable("GuildSkil" + this.name, "");
}
void Awake()
{
yt = new yuan.YuanMemoryDB.YuanTable("ParentSection" + this.name, "");
}
/// <summary>
/// 完成任务方法
/// </summary>
/// <param name="taskID">任务id</param>
void TaskDoneAsID(string taskID)
{
//任务表,需要服务器取到 taskTable
yuan.YuanMemoryDB.YuanTable taskTable = new yuan.YuanMemoryDB.YuanTable("taskTable", "id");
foreach (yuan.YuanMemoryDB.YuanRow rows in taskTable.Rows)
{
if (rows["id"].YuanColumnText == taskID)
{
MainTask task = new MainTask();
task.taskName = rows["TaskName"].YuanColumnText;
task.taskType = (MainTaskType)int.Parse(rows["TaskType"].YuanColumnText);
task.id = rows["id"].YuanColumnText;
task.needType = (MainTaskNeedType)int.Parse(rows["id"].YuanColumnText);
task.needId = rows["TaskNeedInfo"].YuanColumnText;
task.leixing = GetIntDBAsName("BranchType", 0, rows);
task.jindu = 0;
task.RewardItemMaster = getTaskReward(rows, task.RewardItemMaster, "RewardItemMaster");
task.RewardItemSoldier = getTaskReward(rows, task.RewardItemSoldier, "RewardItemSoldier");
task.RewardItemRobber = getTaskReward(rows, task.RewardItemRobber, "RewardItemRobber");
task.reward = getTaskReward(rows, task.RewardItemRobber, "RewardItemMaster");
task.doneType = rows["ConditonInfo"].YuanColumnText;
task.ExcludeTask = rows["ExcludeTask"].YuanColumnText;
if (task.taskType == (MainTaskType)4)
{
task.doneItem = task.doneType.Substring(15, 7);
}
string itemid2;
if (task.reward.itemId.Length > 4)
{
itemid2 = task.reward.itemId.Substring(0, 2);
if (itemid2 == "88")
{
//道具id
// task.reward.itemId;
}
else
if (itemid2 == "72")
{
//坐骑id
//task.reward.itemId;
}
else
{
//装备id
// task.reward.itemId;
InRoom.GetInRoomInstantiate().SetSetPlayerBehavior(yuan.YuanPhoton.PlayerBehaviorType.GetItem, task.reward.itemId);
}
}
//经验值
//task.reward.exp
//增加的声望值，字段"Prestige"
//20
//金币
//task.reward.gold
//血石
//task.reward.rank
//角色表,需要服务器取到 playerTable
yuan.YuanMemoryDB.YuanTable playerTable = new yuan.YuanMemoryDB.YuanTable("playerTable", "id");
playerTable.Rows[0]["CompletTask"].YuanColumnText += taskID + ";";
string[] strArray;
string[] taskStrs;
int i;
strArray = playerTable.Rows[0]["Task"].YuanColumnText.Split(';');
for (i = 0; i < strArray.Length; i++)
{
taskStrs = strArray[i].Split(',');
if (taskStrs.Length > 1 && taskStrs[0] == taskID)
{
strArray[i] = "";
}
}
for (i = 0; i < strArray.Length; i++)
{
if (strArray[i] != "")
{
playerTable.Rows[0]["Task"].YuanColumnText += strArray[i] + ";";
}
}
}
}
}
