void LoadCSV(string pos)
{
ReoMain.Worksheets.Clear();
string[] folders = System.IO.Directory.GetFiles(pos);
for (int i = 0; i < folders.Length; i++)
{
string folder = folders[i];
string oneInfo = System.IO.Path.GetFileName(folder);
string ex = System.IO.Path.GetExtension(folder);
string name = System.IO.Path.GetFileNameWithoutExtension(folder);
if (ex == ".csv")
{
var worksheet = ReoMain.CreateWorksheet(name);
ReoMain.Worksheets.Add(worksheet);
try
{
LoadCsv(File.OpenRead(pos + oneInfo), worksheet);
}
catch (Exception d)
{
EdLib.AskMsg("读取资料库时发生严重异常，错误信息：\n" + d.ToString() + "\n" + d.Message);
}
//EdLib.AskMsg("Worksheets.Count = " + ReoMain.Worksheets.Count);
}
}
}
public void WorkSheedName(bool Update)
{
if (Update == false)
{
for (int i = reoGridControl.Worksheets.Count - 1; i >= 0; i--)
{
reoGridControl.RemoveWorksheet(i);
}
var sheet = reoGridControl.CurrentWorksheet;
var sheeds = new List();
for (int i = 0; i < listDate.Count; i++)
{
string nameWorkSheet = ((listDate[i].Month) + "." + (listDate[i].Year)).ToString();
/* if (i == 0)
* {
* sheet.Name = nameWorkSheet;
* }*/
//else
//{
reoGridControl.AddWorksheet(reoGridControl.CreateWorksheet(nameWorkSheet));
//}
}
}
else
{
int countOfWorkSheed = reoGridControl.Worksheets.Count;
List <string> sheetsNames = new List <string>();
sheetsNames.Clear();
for (int i = 0; i < countOfWorkSheed; i++)
{
sheetsNames.Add(reoGridControl.Worksheets[i].Name);
}
for (int i = 0; i < listDate.Count; i++)
{
string nameWorkSheet = ((listDate[i].Month) + "." + (listDate[i].Year)).ToString();
if (!sheetsNames.Contains(nameWorkSheet))
{
reoGridControl.AddWorksheet(reoGridControl.CreateWorksheet(nameWorkSheet));
}
}
}
}