private float m_worldY; //由二维坐标转三维坐标时需要确定Y坐标
#endregion Fields
#region Constructors
private MapConfig()
{
m_dictionary = new Dictionary<string, float>();
csvUtil = CsvUtil.getInstance();
allMsg = csvUtil.LoadCsvFile(URL);
fillMapData();
}
public void CreateFile()
{
var users = new VkontakteService(VkontakteService.Token).UsersSearch();
var data = CsvUtil.Render(users);
File.WriteAllText("topusers.csv", data);
}
// アプリケーションの開始イベント
void App_Startup(object sender, StartupEventArgs e)
{
List<CsvTest> list = new List<CsvTest>();
list.Add(new CsvTest("テスト\r\n文\"字１", 1111, 12.006, DateTime.Now));
list.Add(new CsvTest("テスト文字２", 1112, 13.006, DateTime.Today));
list.Add(new CsvTest("テスト文字３", 1113, 14.006, DateTime.MinValue));
ContractUtil DataUtil = new ContractUtil();
bool ret1 = DataUtil.Compare(list[0], list[1]);
bool ret2 = DataUtil.Compare(list[2], list[2]);
CsvUtil csv = new CsvUtil(Encoding.UTF8, true);
// csv.Write(list, @"D:\\momiji\\sample.csv");
// List<CsvTest> list2 = csv.Read<CsvTest>(@"D:\\momiji\\sample.csv");
List<CsvTest> list2 = csv.Read<CsvTest>(null);
// 例外ハンドラの登録
this.DispatcherUnhandledException += App_DispatcherUnhandledException;
AppDomain.CurrentDomain.UnhandledException += App_UnhandledException;
// アプリケーションの初期化
ContextModel.loginInfo.ShainInfo.SHAIN_CD = "000001";
SystemEnviroment.Init();
// ウィンドウの表示
Window window = GetPlugin.Load("Window1");
window.Show();
}
public MyObject _LoadFromAssets()
{
MyObject obj = new MyObject();
CsvUtil.LoadObject <MyObject>("Assets/Resources/CsvForSaveData.csv", ref obj);
return(obj);
}
//记录单点重量CSV
private void recDotWeight()
{
//Time NozzalNumber DotWeight
string strheadline = "Time,NozzalNumber,DotWeight";
string line = String.Empty;
if (!File.Exists(PatternWeightSettings.FilePathDotWeight))
{
//时间 型号 实际重量(mg) 重量范围(mg) 状态 NG原因
CsvUtil.WriteLine(PatternWeightSettings.FilePathDotWeight, strheadline);
}
else
{
line = String.Format("{0},{1},{2}", DateTime.Now.ToString(), ((ValueType)this.Valve.Key).ToString(), this.Valve.weightPrm.SingleDotWeight);
CsvUtil.WriteLine(PatternWeightSettings.FilePathDotWeight, line);
}
if (!String.IsNullOrEmpty(PatternWeightSettings.FilePathDotWeightUser))
{
if (!File.Exists(PatternWeightSettings.FilePathDotWeightUser))
{
CsvUtil.WriteLine(PatternWeightSettings.FilePathDotWeightUser, strheadline);
}
else
{
CsvUtil.WriteLine(PatternWeightSettings.FilePathDotWeightUser, line);
}
}
}
public async Task WriteCsvRecordsTestAsync()
{
FileHelper.CreateDirectory("temp");
string tempPath = "temp/" + DateTime.Now.ToString("yyyyMMddhhmmss.fff") + ".csv";
bool success = false;
try
{
await CsvUtil.WriteRecordsAsync(Persons, tempPath);
}
catch
{
success = false;
}
finally
{
if (File.Exists(tempPath))
{
success = true;
File.Delete(tempPath);
}
}
Assert.IsTrue(success);
}
public void ReadCSV()
{
bugableObjectFunctionInfoList = CsvUtil.LoadObjects <BugableObjectFunctionInfo>("bugableObjectFunction.csv");
enabledBugableObjectFunctionInfoDict = new Dictionary <string, List <BugableObjectFunctionInfo> >();
notEnabledBugableObjectFunctionInfoDict = new Dictionary <string, List <BugableObjectFunctionInfo> >();
foreach (BugableObjectFunctionInfo info in bugableObjectFunctionInfoList)
{
if (!enabledBugableObjectFunctionInfoDict.ContainsKey(info.objectId))
{
enabledBugableObjectFunctionInfoDict[info.objectId] = new List <BugableObjectFunctionInfo>();
notEnabledBugableObjectFunctionInfoDict[info.objectId] = new List <BugableObjectFunctionInfo>();
}
//ReadDatabase(info);
string prerequisiteString = info.prerequisite;
if (prerequisiteString.Length != 0)
{
//Debug.Log("prerequisite for function " + info.identifier + " is " + prerequisiteString);
Achievement prerequisite = AchievementManager.Instance.achievementDictionary[prerequisiteString];
if (prerequisite.state != AchievementState.complete)
{
notEnabledBugableObjectFunctionInfoDict[info.objectId].Add(info);
continue;
}
}
enabledBugableObjectFunctionInfoDict[info.objectId].Add(info);
}
//Debug.Log("finish load bugableObjectFunction.csv");
}
public static bool Init()
{
items = new Map <int, CsvLevelItem>();
Objv objv = CsvUtil.GetObjvByName("Level");
for (int i = 0; i < objv.rowCount; i++)
{
CsvLevelItem item = new CsvLevelItem();
item.index = (int)objv.QueryByIndex(i, "Index");
item.name = (string)objv.QueryByIndex(i, "Name");
string type = (string)objv.QueryByIndex(i, "Type");
item.etype.Clear();
if (type != "")
{
string[] typeStr = type.Split('~');
for (int index = 0; index < typeStr.Length; index++)
{
EnemyType Etype = new EnemyType();
string[] etypeStr = typeStr[index].Split('+');
Etype.type = int.Parse(etypeStr[0]);
Etype.num = int.Parse(etypeStr[1]);
item.etype.Add(Etype);
}
}
string obstacle = (string)(objv.QueryByIndex(i, "Obstacle"));
if (obstacle != "")
{
string[] ObstacleStr = obstacle.Split('~');
for (int index = 0; index < ObstacleStr.Length; index++)
{
ObstacleType Etype = new ObstacleType();
string[] etypeStr = ObstacleStr[index].Split('+');
Etype.type = int.Parse(etypeStr[0]);
Etype.pos = ComUnitl.String2Vector3(etypeStr[1]);
}
}
item.ornamental = (string)(objv.QueryByIndex(i, "Ornamental"));
item.numtype1 = (int)(objv.QueryByIndex(i, "NumType1"));
item.param1 = (int)(objv.QueryByIndex(i, "Param1-1"));
item.numtype2 = (int)(objv.QueryByIndex(i, "NumType2"));
item.param2 = (int)(objv.QueryByIndex(i, "Param2-1"));
item.target = (string)(objv.QueryByIndex(i, "Target"));
item.txt = (string)(objv.QueryByIndex(i, "Txt"));
items[item.index] = item;
}
return(true);
}
public void Init()
{
List <NarrationInfo> narrationInfoList = CsvUtil.LoadObjects <NarrationInfo>("narration.csv");
narrationDictionary = new Dictionary <string, List <NarrationInfo> >();
foreach (NarrationInfo info in narrationInfoList)
{
if (!info.isVisibleForTest && CheatSettings.Instance.skipTestingNarrations)
{
continue;
}
string identifier = info.identifier;
string[] splitIdentifier = info.identifier.Split('_');
if (splitIdentifier.Length > 2)
{
Debug.LogError("narration identifier format is wrong " + info.identifier);
}
if (splitIdentifier.Length == 2)
{
identifier = splitIdentifier[0];
}
if (!narrationDictionary.ContainsKey(identifier))
{
narrationDictionary[identifier] = new List <NarrationInfo>();
}
narrationDictionary[identifier].Add(info);
}
}
bool LoadAll(string path)
{
// load & make a table with GreetingWords csv
var loadGreetingWords = CsvUtil.LoadObjects <GreetingWords>(path + "TestDataForCSV - GreetingWords.csv");
_greetingWords = new Dictionary <string, GreetingWords>();
for (int i = 0; i < loadGreetingWords.Count; i++)
{
_greetingWords.Add(loadGreetingWords[i].Key, loadGreetingWords[i]);
}
// load & make a table with defaultValue csv
var LoadDefault = CsvUtil.LoadObjects <DefaultValue>(path + "TestDataForCSV - DefaultValue.csv");
_defaultValue = new Dictionary <int, DefaultValue>();
foreach (var info in LoadDefault)
{
_defaultValue.Add(info.id, info);
}
//ksh
var loadKshWords = CsvUtil.LoadObjects <KshWords>(path + "TestDataKSH.csv");
_kshWords = new Dictionary <string, KshWords>();
for (int i = 0; i < loadKshWords.Count; i++)
{
_kshWords.Add(loadKshWords[i].Key, loadKshWords[i]);
}
return(true);
}
public void TestLoadMultiWithSpacesInHeader()
{
// Header first, then N values
// #Field headers are ignored
// This time we don't want any prefixing since not trimmed
string csvData = @"String Field, FloatField ,#Description, Int Field , EnumField
""This,has,commas,in it"",2.34,Something ignored,35,Red
Hello World,256.25,""Notes here"",10003,Purple
Zaphod Beeblebrox,3.1,""Amazingly amazing"",000359,Green";
List <TestObject> objs;
using (var ms = new MemoryStream(Encoding.UTF8.GetBytes(csvData)))
{
using (var sr = new StreamReader(ms))
{
objs = CsvUtil.LoadObjects <TestObject>(sr);
}
}
TestObject t = objs[0];
t = objs[1];
t = objs[2];
}
private void WriteTable(string sql)
{
using var status = WaitStatus.StartRows(Path.GetFileName(_filePath));
var fileMode = _truncateExistingFile ? FileMode.Create : FileMode.Append;
using var stream = File.Open(_filePath, fileMode, FileAccess.Write, FileShare.None);
using var writer = new StreamWriter(stream, _fileEncoding);
using var statement = _notebook.Prepare(sql);
var args = statement.GetArgs(_env.Vars);
statement.ExecuteStream(args, OnHeader, OnRow, CancellationToken.None);
void OnHeader(List <string> columnNames)
{
if (_headerRow)
{
writer.WriteLine(string.Join(_separator, columnNames.Select(c => CsvUtil.QuoteCsv(c, _separator))));
}
}
void OnRow(object[] row)
{
_cancel.ThrowIfCancellationRequested();
CsvUtil.WriteCsvLine(writer, _separator, row);
status.IncrementRows();
}
}
private static void CopyRows(DataTable target, IEnumerable <DataRow> rows, List <string> headerList)
{
foreach (var row in from line in rows let s = CsvUtil.GetRowValues(line) where !IsGeographicLevelIgnored(s, headerList) select line)
{
target.Rows.Add(row.ItemArray);
}
}
public void Save()
{
if (m_UseStars.Count > 0)
{
CsvUtil.SaveObjects(m_UseStars, m_ArchiveFilePath);
}
}
public void CSV分割()
{
string text = "1+1=,2,1,3,4\r\n2+2=,4,1,2,3";
var actual = CsvUtil.analyze(text);
List <Dictionary <string, string> > expected = new List <Dictionary <string, string> >();
expected.Add(new Dictionary <string, string>()
{
{ "0", "1+1=" },
{ "1", "2" },
{ "2", "1" },
{ "3", "3" },
{ "4", "4" },
});
expected.Add(new Dictionary <string, string>()
{
{ "0", "2+2=" },
{ "1", "4" },
{ "2", "1" },
{ "3", "2" },
{ "4", "3" },
});
CollectionAssert.AreEqual(expected[0], actual[0], "0行目で失敗");
CollectionAssert.AreEqual(expected[1], actual[1], "1行目で失敗");
}
public void Init()
{
List <NarrativeInfo> narrativeInfoList = CsvUtil.LoadObjects <NarrativeInfo>("narrative.csv");
narrativeActionDictionary = new Dictionary <string, HashSet <NarrativeAction> >();
narrativeInfoDictionary = new Dictionary <string, NarrativeInfo>();
enabledNarrativeActionNames = new HashSet <string>();
enabledNarrativeActions = new HashSet <NarrativeAction>();
activeNarrativeActions = new List <NarrativeAction>();
foreach (NarrativeInfo info in narrativeInfoList)
{
narrativeInfoDictionary[info.identifier] = info;
System.Type narrativeType = System.Type.GetType(info.narrativeAction);
NarrativeAction action = (NarrativeAction)System.Activator.CreateInstance(narrativeType, info);
Achievement achievement = AchievementManager.Instance.achievementDictionary[info.achievement];
if (achievement.state == AchievementState.complete)
{
continue;
}
if (achievement.state == AchievementState.active)
{
activeNarrativeActions.Add(action);
}
if (!narrativeActionDictionary.ContainsKey(info.achievement))
{
narrativeActionDictionary[info.achievement] = new HashSet <NarrativeAction>();
}
narrativeActionDictionary[info.achievement].Add(action);
}
}
public ActionResult SpecialistOrders(string text)
{
if (System.Web.HttpContext.Current.Request.IsPost())
{
var sigIds = Regex.Split(text, @"[^\d]").Where(x => !x.IsEmpty()).Select(decimal.Parse).ToList();
var sources = SourceService.GetAll().Select(x => new { x.Source_ID, x.Name })
.ToDictionary(x => x.Source_ID, x => x.Name);
var result = sigIds.GetRows(1000).SelectMany(ids =>
OrderDetailService.GetAll(x =>
ids.Contains(x.StudentInGroup_ID.Value))
.Select(x => new{ x.OrderID, x.StudentInGroup_ID }).ToList())
.ToDictionary(x => x.StudentInGroup_ID, x => x.OrderID);
var sigs = sigIds.GetRows(1000).SelectMany(ids =>
StudentInGroupService.GetAll(x =>
ids.Contains(x.StudentInGroup_ID))
.Select(x => new { x.StudentInGroup_ID, x.StudentInGroupSources }).ToList()
).Select(x => _.List(x.StudentInGroup_ID.ToString(),
result.GetValueOrDefault(x.StudentInGroup_ID).NotNullString() ??
x.StudentInGroupSources.Select(y => y.Source_ID).ToList().Select(y => sources[y]).FirstOrDefault()));
return(File(StringUtils.Encoding1251.GetBytes(CsvUtil.Render(sigs)),
"text/csv", "SpecialistOrders.csv"));
}
return(View());
}
public void SaveResult(string pathDir)
{
string path = pathDir;
DirUtils.CreateDir(path);
//this.FileName = this.FileName.Replace(':', '_');
path = path + "\\" + DateTime.Now.ToString("yyyyMMdd HHmmss");
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append(this.Barcode + "\r\n");
stringBuilder.Append(FluidProgram.CurrentOrDefault().RuntimeSettings.CustomParam.RTVParam.Depart + "\r\n");
stringBuilder.Append(FluidProgram.CurrentOrDefault().RuntimeSettings.CustomParam.RTVParam.ComputerInfo + "\r\n");
stringBuilder.Append(FluidProgram.CurrentOrDefault().RuntimeSettings.CustomParam.RTVParam.MachineInfo + "\r\n");
stringBuilder.Append(this.GetBarcodePart(this.Barcode) + "\r\n");
stringBuilder.Append(FluidProgram.CurrentOrDefault().RuntimeSettings.CustomParam.RTVParam.ProductLineInfo + "\r\n");
stringBuilder.Append(FluidProgram.CurrentOrDefault().RuntimeSettings.CustomParam.RTVParam.OwkInfo + "\r\n");
stringBuilder.Append(FluidProgram.CurrentOrDefault().RuntimeSettings.CustomParam.RTVParam.UserInfo + "\r\n");
stringBuilder.Append(this.GetProgramRunTime() + "\r\n");
stringBuilder.Append(this.GetProgramEndTime() + "\r\n");
stringBuilder.Append("No Width MaxValue MinValue Height MaxValue MinValue" + "\r\n");
for (int i = 0; i < this.Results.Count; i++)
{
string s = "";
s += (1 + i).ToString() + " ";
s += this.Results[i][0] + " ";
s += this.Results[i][1] + " ";
s += this.Results[i][2] + " ";
s += this.Results[i][3] + " ";
s += this.Results[i][4] + " ";
s += this.Results[i][5];
stringBuilder.Append(s + "\r\n");
}
CsvUtil.WriteLine(path, stringBuilder.ToString());
}
private void recdPatternWeight()
{
string strheadline = "时间,型号,实际重量(mg),重量范围(mg),状态,NG原因";
string line = String.Empty;
//记录拼版重量CSV
if (!File.Exists(PatternWeightSettings.FilePathMatrixWeight))
{
//时间 型号 实际重量(mg) 重量范围(mg) 状态 NG原因
CsvUtil.WriteLine(PatternWeightSettings.FilePathMatrixWeight, strheadline);
}
else
{
line = String.Format("{0},{1},{2},{3},{4}", DateTime.Now.ToString(), FluidProgram.Current.Name, this.Valve.weightPrm.DifferWeight, String.Format("{0}-{1}", (getPatWgt(this.shotNums) * (1 - this.Valve.weightPrm.WeightOffset / 100.0d)), (getPatWgt(this.shotNums) * (1 + this.Valve.weightPrm.WeightOffset / 100.0d))), this.CaliPatWgtResult());
CsvUtil.WriteLine(PatternWeightSettings.FilePathMatrixWeight, line);
}
if (!String.IsNullOrEmpty(PatternWeightSettings.FilePathMatrixWeightUser))
{
if (!File.Exists(PatternWeightSettings.FilePathMatrixWeightUser))
{
CsvUtil.WriteLine(PatternWeightSettings.FilePathMatrixWeightUser, strheadline);
}
else
{
CsvUtil.WriteLine(PatternWeightSettings.FilePathMatrixWeightUser, line);
}
}
}
static void Main(string[] args)
{
if (args.Length < 6)
{
PrintUsage();
Pause();
return;
}
string output;
double xs, ys, h;
int xd, yd;
try
{
output = args[0];
xs = double.Parse(args[1]);
ys = double.Parse(args[2]);
h = double.Parse(args[3]);
xd = int.Parse(args[4]);
yd = int.Parse(args[5]);
}
catch (Exception e)
{
Console.WriteLine("Exception while parsing arguments: ");
Console.WriteLine(e.Message);
Console.WriteLine("Stack trace:");
Console.WriteLine(e.StackTrace);
Console.Write("Passed arguments: ");
foreach (var arg in args)
{
Console.Write($"{arg} ");
}
Console.WriteLine();
PrintUsage();
Pause();
return;
}
Console.WriteLine($"Generating grid {xd} by {yd} starting from ({xs}; {ys}) with cell size {h} ...");
GridData res = GridData.AllocateNew(new GridSize(xd, yd));
for (int xi = 0; xi < xd; xi++)
{
for (int yi = 0; yi < yd; yi++)
{
double x = xs + xi * h;
double y = ys + yi * h;
res[xi, yi] = Function(x, y);
}
}
Console.WriteLine($"Writing result to {output} ...");
CsvUtil.ExportToFile(res, output);
Console.WriteLine("Done.");
Pause();
}
public ActionResult DirectBannerPrices(int?companyId, long?bannerId, string token)
{
var model = new DirectBannerPricesVM {
BannerId = bannerId,
Token = token ?? Session[YandexAuthService.SessionKey].NotNullString()
};
var service = token.IsEmpty() ? DirectApiService : new DirectApiService(token: token);
if (companyId.HasValue)
{
var bannerIds = service.GetActiveBanners(
new GetBannersInfo {
CampaignIDS = new[] { companyId.Value }
}).Select(x => x.BannerID).ToArray();
var prices = service.GetBannerPhrases(bannerIds).ToList();
var data = prices.Select(x =>
_.List(x.BannerID.ToString(), x.Price.ToString(),
(x.Prices.ToList().Select((price, i) => Tuple.Create(i + 1, price < x.Price))
.FirstOrDefault(y => y.Item2).GetOrDefault(y => y.Item1)).ToString(), x.Phrase)
.AddFluent(x.Prices.Select(z => z.ToString()))
);
return(File(StringUtils.Encoding1251.GetBytes(CsvUtil.Render(data)),
"text/csv", "bannerprices.csv"));
}
if (bannerId.HasValue)
{
model.Prices = service.GetBannerPhrases(new[] { bannerId.Value }).ToList();
}
return(View(model));
}
private static async Task <Either <IEnumerable <ValidationError>, Unit> > ValidateMetaRows(
DataColumnCollection cols, DataRowCollection rows)
{
var errors = new List <ValidationError>();
var idx = 0;
foreach (DataRow row in rows)
{
idx++;
try
{
ImporterMetaService.GetMetaRow(CsvUtil.GetColumnValues(cols), row);
}
catch (Exception e)
{
errors.Add(new ValidationError($"error at row {idx}: {MetaFileHasInvalidValues.GetEnumLabel()} : {e.Message}"));
}
}
if (errors.Count > 0)
{
return(errors);
}
return(Unit.Instance);
}
public string Csv(UrlHelper urlHelper)
{
_url = urlHelper;
var coursesData = GetCoursesData();
return(CsvUtil.Render(coursesData));
}
static void Main(string[] args)
{
string absF = args[0];
string prF = args[1];
string stF = args[2];
var abs = CsvUtil.ImportFromFile(absF);
var pr = CsvUtil.ImportFromFile(prF);
var st = CsvUtil.ImportFromFile(stF);
var mask = args[3].Trim().Split(';').Select(
i =>
{
var coords = i.Trim().Split(',').Select(j => int.Parse(j.Trim())).ToArray();
return(new GridIndex(coords[0], coords[1]));
}).ToList();
double[,] res = new double[mask.Count, 5];
for (int i = 0; i < mask.Count; i++)
{
res[i, 0] = abs[mask[i]];
res[i, 1] = pr[mask[i]];
res[i, 2] = pr[mask[i]] - abs[mask[i]];
res[i, 3] = st[mask[i]];
res[i, 4] = st[mask[i]] - abs[mask[i]];
}
CsvUtil.ExportToFile(res, args[4]);
}
public void TestSaveMulti()
{
List <TestObject> objs = new List <TestObject>()
{
new TestObject("Hello there", 123, 300.2f, TestObject.Colour.Blue),
new TestObject("This,has,commas", 42, 12.123f, TestObject.Colour.Purple),
new TestObject("Semi;colons", 40001, -75.2f, TestObject.Colour.Green),
};
using (var stream = new MemoryStream(256))
{
using (var w = new StreamWriter(stream))
{
CsvUtil.SaveObjects(objs, w);
w.Flush();
stream.Seek(0, SeekOrigin.Begin);
var r = new StreamReader(stream);
var content = r.ReadToEnd();
var expected = @"StringField,IntField,FloatField,EnumField
Hello there,123,300.2,Blue
""This,has,commas"",42,12.123,Purple
""Semi;colons"",40001,-75.2,Green";
}
}
}
public static void Main(string[] args)
{
//JAVA TO C# CONVERTER WARNING: The original Java variable was marked 'final':
//ORIGINAL LINE: final String resultsFolder = "target"+java.io.File.separatorChar+"results";
string resultsFolder = "target" + Path.DirectorySeparatorChar + "results";
//JAVA TO C# CONVERTER WARNING: The original Java variable was marked 'final':
//ORIGINAL LINE: final String reportsFolder = "target"+java.io.File.separatorChar+"reports";
string reportsFolder = "target" + Path.DirectorySeparatorChar + "reports";
string longTermBenchmarkResultFilename = System.getProperty("longTermBenchmarkResultFile");
if (!string.ReferenceEquals(longTermBenchmarkResultFilename, null))
{
File longTermBenchmarkResultFile = new File(longTermBenchmarkResultFilename);
longTermBenchmarkResultFile.ParentFile.mkdirs();
if (longTermBenchmarkResultFile.exists())
{
// Do nothing, append current results later
}
else
{
FileUtil.appendStringToFile("name;" + "number of runs;" + "database;" + "history level;" + "starttime;" + "platform;" + "number of threads;" + "duration;" + "throughput", longTermBenchmarkResultFilename);
}
TabularResultSet longTermResultTable = (new BenchmarkLongtermAggregator(resultsFolder)).execute();
FileUtil.appendStringToFile(CsvUtil.resultSetAsCsv(longTermResultTable), longTermBenchmarkResultFilename);
}
writeReport(resultsFolder, reportsFolder, "benchmark", new BenchmarkAggregator(resultsFolder), "Benchmark Duration Report");
}
public void WriteCsv(StreamWriter s)
{
foreach (var dt in DataTables)
{
s.WriteLine(string.Join(",", dt.Columns.Select(CsvUtil.EscapeCsv)));
CsvUtil.WriteCsv(dt.Rows, s);
}
}
public void Export(string fileName)
{
using (var writer = File.CreateText(fileName))
foreach (var item in StringFile.Items)
{
writer.WriteLine(CsvUtil.Format(new[] { item.Id.ToString(), item.Name, item.Value }));
}
}
public void Reload()
{
m_UseStars.Clear();
if (File.Exists(m_ArchiveFilePath))
{
m_UseStars = CsvUtil.LoadObjects <UseStarInfo>(m_ArchiveFilePath);
}
}
void InitCSV()
{
todoListInfoDictionary = new Dictionary <string, TodoListInfo>();
todoListList = CsvUtil.LoadObjects <TodoListInfo>("todoList.csv");
foreach (TodoListInfo todoListInfo in todoListList)
{
todoListInfoDictionary[todoListInfo.identifier] = todoListInfo;
}
}
public ActionResult DownloadResults(int id)
{
UserTestService.LoadWith(x => x.User, x => x.Test);
var userTests = _.List(GetUserTests(id, false));
var data = UserTestResultService.GetResultData(userTests);
return(File(StringUtils.Encoding1251.GetBytes(CsvUtil.Render(data)),
"text/csv", "TestResults-{0}.csv".FormatWith(id)));
}
public async Task ReadCsvRecordsTestAsync()
{
var persons = await CsvUtil.GetRecordsAsync <Person>("Sample/persons.csv");
Assert.AreEqual(persons?.Count, 5);
Assert.AreEqual(persons?[0].Name, "baby");
Assert.AreEqual(persons?[0].Age, 1);
Assert.AreEqual(persons?[0].Salary, 0);
Assert.AreEqual(persons?[0].BirthDate, new DateTime(2018, 1, 1));
}
public static CsvUtil getInstance()
{
if (m_instance == null)
m_instance = new CsvUtil();
return m_instance;
}
private MemberConfig()
{
m_records = new List<MemberInfo>();
csvUtil = CsvUtil.getInstance();
dealWithMsg();
}
