public void initializeDB()
{
string p = @"./kuroyukiDB/listDB.csv";
//read the json
//var sourceContent = File.ReadAllText(p);
//parse as array
// var sourceobjects = JArray.Parse("[" + sourceContent + "]");
//JObject source = JObject.Parse(sourceContent);
//GroupMeals jp = (GroupMeals)JsonConvert.DeserializeObject(sourceContent);//result为上面的Json数据
CsvFileHelper myCsv = new CsvFileHelper(p, Encoding.UTF8);
var myData = myCsv.GetListCsvData();
long GID = 0;
string MLN = "";
foreach (List <string> ele in myData)
{
if (ele[0] != "")
{
GID = long.Parse(ele[0]);
}
else if (ele[1] != "")
{
MLN = ele[1];
}
else
{
GroupMeals temp = new GroupMeals();
temp.GroupId = GID;
temp.MealListName = MLN;
foreach (string elem in ele)
{
if (elem != "")
{
temp.Meals.Add(elem);
}
}
groupMealsDb.Add(temp);
}
}
groupMealsDb.Sort();
//其他的操作
myCsv.Dispose();
//updateFile();
}
public string addLst(long groupId, string mealListName)
{
int i = -99;
bool flag = false;
string result;
foreach (GroupMeals ele in groupMealsDb)
{
if (ele.GroupId == groupId)
{
i++;
}
if (ele.MealListName == mealListName && ele.GroupId == groupId)
{
flag = true;
}
}
if (flag)
{
result = "该菜单已存在";
}
else if (i >= 3)
{
result = "该群菜单数量已满";
}
else
{
GroupMeals temp = new GroupMeals();
temp.GroupId = groupId;
temp.MealListName = mealListName;
temp.Meals.Add("empty");
groupMealsDb.Add(temp);
updateFile();
result = "菜单已添加";
}
return(result);
}
