Exemple #1
0
        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];
                    }
                }
            }
        }
Exemple #2
0
        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) + "'"
                                  + ")");
        }