//读取GameEvent表；
void readGameEvent()
{
// Read sample data from CSV file
using (ReadWriteCsv.CsvFileReader reader = new ReadWriteCsv.CsvFileReader("D://GameEvent.CSV"))
{
ReadWriteCsv.CsvRow row = new ReadWriteCsv.CsvRow();
int i = 1;
while (reader.ReadRow(row))
{
Model.GameEvent temp = new Model.GameEvent();
if (i > 4)
{
temp.id = row[0];
temp.eventSign = row[1];
int.TryParse(row[2], out temp.eventType);
temp.eventName = row[3];
temp.eventTalk = row[4];
temp.eventRoles = row[5];
gEvent.Add(temp);
}
i++;
}
}
}
void readGameMonster()
{
using (ReadWriteCsv.CsvFileReader reader = new ReadWriteCsv.CsvFileReader("D://GameMonster.CSV"))
{
ReadWriteCsv.CsvRow row = new ReadWriteCsv.CsvRow();
int i = 1;
while (reader.ReadRow(row))
{
Model.GameMonster temp = new Model.GameMonster();
if (i > 4)
{
temp.id = row[0];
temp.MonsterName = row[1];
int.TryParse(row[2], out temp.TypeID);
temp.TeamHeadIcon = row[3];
int.TryParse(row[4], out temp.BaseLife);
int.TryParse(row[5], out temp.BaseDef);
int.TryParse(row[6], out temp.BaseAct);
float.TryParse(row[7], out temp.AttrProp);
mEvent.Add(temp);
}
i++;
}
}
}
void readGameTalk()
{
using (ReadWriteCsv.CsvFileReader reader = new ReadWriteCsv.CsvFileReader("D://GameTalk.CSV"))
{
ReadWriteCsv.CsvRow row = new ReadWriteCsv.CsvRow();
int i = 1;
while (reader.ReadRow(row))
{
Model.GameTalk temp = new Model.GameTalk();
if (i > 4)
{
temp.id = row[0];
//int.TryParse(row[1], out temp.ResultType);
temp.TalkGroup = row[1];
temp.TalkRole = row[2];
int.TryParse(row[3], out temp.RoleHead);
temp.EventName = row[4];
temp.TalkSelect = row[5];
gTalk.Add(temp);
}
i++;
}
}
}
void readGamePartner()
{
using (ReadWriteCsv.CsvFileReader reader = new ReadWriteCsv.CsvFileReader("D://GamePartner.CSV"))
{
ReadWriteCsv.CsvRow row = new ReadWriteCsv.CsvRow();
int i = 1;
while (reader.ReadRow(row))
{
Model.GamePartner temp = new Model.GamePartner();
if (i > 4)
{
temp.id = row[0];
//int.TryParse(row[1], out temp.ResultType);
temp.PartnerName = row[1];
int.TryParse(row[2], out temp.TypeId);
int.TryParse(row[3], out temp.BaseLife);
int.TryParse(row[4], out temp.BaseDef);
int.TryParse(row[5], out temp.BaseAct);
float.TryParse(row[6], out temp.TalentProp);
gPartner.Add(temp);
}
i++;
}
}
}
void readGameBattle()
{
using (ReadWriteCsv.CsvFileReader reader = new ReadWriteCsv.CsvFileReader("D://GameBattle.CSV"))
{
ReadWriteCsv.CsvRow row = new ReadWriteCsv.CsvRow();
int i = 1;
while (reader.ReadRow(row))
{
Model.GameBattle temp = new Model.GameBattle();
if (i > 4)
{
temp.id = row[0];
//int.TryParse(row[1], out temp.ResultType);
temp.BattleObject = row[1];
temp.BattleWise = row[2];
gBattle.Add(temp);
}
i++;
}
}
}
void readTalkResult()
{
using (ReadWriteCsv.CsvFileReader reader = new ReadWriteCsv.CsvFileReader("D://TalkResult.CSV"))
{
ReadWriteCsv.CsvRow row = new ReadWriteCsv.CsvRow();
int i = 1;
while (reader.ReadRow(row))
{
Model.TalkResult temp = new Model.TalkResult();
if (i > 4)
{
temp.id = row[0];
int.TryParse(row[1], out temp.ResultType);
temp.ResultName = row[2];
temp.EventTalk = row[3];
temp.EventGroup = row[4];
talkR.Add(temp);
}
i++;
}
}
}
/// <summary>
/// Reads a row of data from a CSV file
/// </summary>
/// <param name="row"></param>
/// <returns></returns>
public bool ReadRow(CsvRow row)
{
row.LineText = ReadLine();
if (String.IsNullOrEmpty(row.LineText))
{
return(false);
}
int pos = 0;
int rows = 0;
while (pos < row.LineText.Length)
{
string value;
// Special handling for quoted field
if (row.LineText[pos] == '"')
{
// Skip initial quote
pos++;
// Parse quoted value
int start = pos;
while (pos < row.LineText.Length)
{
// Test for quote character
if (row.LineText[pos] == '"')
{
// Found one
pos++;
// If two quotes together, keep one
// Otherwise, indicates end of value
if (pos >= row.LineText.Length || row.LineText[pos] != '"')
{
pos--;
break;
}
}
pos++;
}
value = row.LineText.Substring(start, pos - start);
value = value.Replace("\"\"", "\"");
}
else
{
// Parse unquoted value
int start = pos;
while (pos < row.LineText.Length && row.LineText[pos] != ',')
{
pos++;
}
value = row.LineText.Substring(start, pos - start);
}
// Add field to list
if (rows < row.Count)
{
row[rows] = value;
}
else
{
row.Add(value);
}
rows++;
// Eat up to and including next comma
while (pos < row.LineText.Length && row.LineText[pos] != ',')
{
pos++;
}
if (pos < row.LineText.Length)
{
pos++;
}
}
// Delete any unused items
while (row.Count > rows)
{
row.RemoveAt(rows);
}
// Return true if any columns read
return(row.Count > 0);
}
public bool ReadRow(CsvRow row)
{
row.LineText = this.ReadLine();
if (string.IsNullOrEmpty(row.LineText))
{
return(false);
}
int i = 0;
int num = 0;
while (i < row.LineText.Length)
{
string text;
if (row.LineText[i] == '"')
{
i++;
int num2 = i;
for (; i < row.LineText.Length; i++)
{
if (row.LineText[i] != '"')
{
continue;
}
i++;
if (i < row.LineText.Length && row.LineText[i] == '"')
{
continue;
}
i--;
break;
}
text = row.LineText.Substring(num2, i - num2);
text = text.Replace("\"\"", "\"");
}
else
{
int num3 = i;
for (; i < row.LineText.Length && row.LineText[i] != ','; i++)
{
}
text = row.LineText.Substring(num3, i - num3);
}
if (num < row.Count)
{
((List <string>)row)[num] = text;
}
else
{
row.Add(text);
}
num++;
for (; i < row.LineText.Length && row.LineText[i] != ','; i++)
{
}
if (i < row.LineText.Length)
{
i++;
}
}
while (row.Count > num)
{
row.RemoveAt(num);
}
return(row.Count > 0);
}
