public async Task StudentFetchData() { Students = await SyncStudents.ToCollectionAsync(); if (Students.Count == 0) { Student student = new Student { Id = "athanbonis", Name = "Αθανάσιος Μπόνης", Free = false, Lunch = false, Dinner = false }; await SyncStudents.InsertAsync(student); } }
/// <summary> /// /// </summary> /// <param name="unitName"></param> /// <param name="joinYear"></param> /// <param name="className"></param> /// <returns></returns> public SyncStudents SyncAllStudents(string unitName, string joinYear, string className) { SyncStudents collection = new SyncStudents(); DataTable dtSource = this.poxy.GetStudent(unitName, joinYear, className, string.Empty); if (dtSource != null && dtSource.Rows.Count > 0) { foreach (DataRow row in dtSource.Rows) { SyncStudent data = new SyncStudent(); data.Code = Convert.ToString(row["XH"]); data.Name = Convert.ToString(row["XM"]); data.IDCard = Convert.ToString(row["SFZH"]); data.Gender = Convert.ToString(row["XB"]); data.JoinYear = Convert.ToString(row["RXNF"]); data.School.UnitCode = Convert.ToString(row["xxdm"]); data.School.UnitName = Convert.ToString(row["xxmc"]); collection.Add(data); } } return collection; }
/// <summary> /// 同步学生数据。 /// </summary> /// <param name="unitName"></param> /// <param name="joinYear"></param> /// <param name="className"></param> /// <returns></returns> public SyncStudents SyncAllStudents(string unitName, string joinYear, string className) { string err = null; DataTable dtSource = this.poxy.SyncAllStudents(unitName, joinYear, className, out err); if (!string.IsNullOrEmpty(err)) { throw new Exception("同步学校[" + unitName + "]下班级[" + joinYear + "#" + className + "]学生数据发生异常:" + err); } SyncStudents students = new SyncStudents(); if (dtSource != null && dtSource.Rows.Count > 0) { foreach (DataRow row in dtSource.Rows) { SyncStudent item = new SyncStudent(); item.Code = string.Format("{0}", row["Code"]); item.Name = string.Format("{0}", row["Name"]); item.Gender = string.Format("{0}", row["Gender"]); item.IDCard = string.Format("{0}", row["IDCard"]); item.JoinYear = string.Format("{0}", row["JoinYear"]); students.Add(item); } } return students; }