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); }