protected void LoadSln() { foreach (OleDbDataReader rd in OleDB.EachRows("select * from TSolution")) { Solution = new EnSolution(); IList <Boolean> ActiveWeekArr = ExBuildListWithHexChar.HexStrToBooleanList(rd["FActiveWeek"].ToString()); if (ActiveWeekArr.Count == Solution.ActiveWeekArr.Length) { for (var i = 0; i < ActiveWeekArr.Count; i++) { Solution.ActiveWeekArr[i] = ActiveWeekArr[i]; } } IList <Int32> LessonNumberArr = ExBuildListWithHexChar.HexStrToInt32List(rd["FLessonNumber"].ToString()); if (LessonNumberArr.Count == Solution.LessonNumberArr.Length) { for (var i = 0; i < LessonNumberArr.Count; i++) { Solution.LessonNumberArr[i] = LessonNumberArr[i]; } } } }
protected void SaveSln(EnSolution solution) { OleDB.ExecuteNonQuery("delete from TSolution"); OleDB.ExecuteNonQuery("insert into TSolution (FActiveWeek, FLessonNumber) values (" + "'" + ExBuildListWithHexChar.GetHexStr(solution.ActiveWeekArr) + "'" + ",'" + ExBuildListWithHexChar.GetHexStr(solution.LessonNumberArr) + "'" + ")"); }