// Dictionary 道具，数量
public static string getRewardList(Dictionary <int, int> rewardList)
{
string result = "";
string name = "";
foreach (var item in rewardList)
{
ItemCFGData data = ItemCFG.getInstance().getValue(item.Key);
if (data != null)
{
name = data.m_itemName;
}
else
{
name = "";
}
result += string.Format("id : {0}, name:{1}, count : {2}", item.Key, name, item.Value);
result += "<br />";
}
return(result);
}
public static string getRewardList(List <ParamItem> rewardList)
{
string result = "";
string name = "";
for (int i = 0; i < rewardList.Count; i++)
{
ItemCFGData data = ItemCFG.getInstance().getValue(rewardList[i].m_itemId);
if (data != null)
{
name = data.m_itemName;
}
else
{
name = "";
}
result += string.Format("id : {0}, name:{1}, count : {2}", rewardList[i].m_itemId, name, rewardList[i].m_itemCount);
result += "<br />";
}
return(result);
}
public override OpRes exportData(StreamWriter sheet, ExportParam param, int dbServerId)
{
int skip = 0;
List <Dictionary <string, object> > data = null;
sheet.WriteLine("时间,玩家ID,任务ID,任务名称,道具id,道具名称,数量,道具id,道具名称,数量,道具id,道具名称,数量,道具id,道具名称,数量,道具id,道具名称,数量");
int t = 0;
XmlConfig xml = ResMgr.getInstance().getRes("money_reason.xml");
List <ParamItem> rewardList = new List <ParamItem>();
while (true)
{
data = nextData(ref skip, 1000, m_imq, m_tableName, dbServerId, DbName.DB_PUMP);
if (data == null)
{
break;
}
for (int i = 0; i < data.Count; i++)
{
sheet.Write(Convert.ToDateTime(data[i]["genTime"]).ToLocalTime().ToString());
sheet.Write(",");
t = Convert.ToInt32(data[i]["playerId"]);
sheet.Write(t);
sheet.Write(",");
t = Convert.ToInt32(data[i]["taskId"]);
sheet.Write(t);
sheet.Write(",");
QusetCFGData qd = QuestCFG.getInstance().getValue(t);
if (qd != null)
{
sheet.Write(qd.m_questName);
}
sheet.Write(",");
rewardList.Clear();
Tool.parseItemFromDic(data[i]["items"] as Dictionary <string, object>, rewardList);
for (int j = 0; j < rewardList.Count; j++)
{
sheet.Write(rewardList[j].m_itemId);
sheet.Write(",");
ItemCFGData pItem = ItemCFG.getInstance().getValue(rewardList[j].m_itemId);
if (pItem != null)
{
sheet.Write(pItem.m_itemName);
}
sheet.Write(",");
sheet.Write(rewardList[j].m_itemCount);
if (j != rewardList.Count - 1)
{
sheet.Write(",");
}
}
sheet.WriteLine();
}
}
return(OpRes.opres_success);
}
