//读取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); }