public static void SetOneCourseDidNotSubmit(long kkno, long skno) { var courseBriefcase = BriefcaseControl.GetBriefcase(kkno); var classInfoTable = OfflineDataControl.GetClassInfoTable(kkno); var classInfoRows = classInfoTable.Select(string.Format("上课编号 = '{0}'", skno)); classInfoRows.First().BeginEdit(); classInfoRows.First()["上课状态"] = "未提交"; classInfoRows.First().EndEdit(); courseBriefcase.AddTable(classInfoTable); courseBriefcase.WriteBriefcase(); }
/// <summary> /// 保存上课表 并更新PropertiesBriefcase中的上课状态. /// </summary> /// <param name="kkno"></param> public static void SaveSkTable(long kkno, long skno, SKTABLE_07_VIEW skRecord) { var fDataModule = new DataModule(); var sktable = from c in fDataModule.GetSktable07Viewro() where c.KKNO == kkno select c; // 拉取上课表 var sktableList = sktable.ToList(); var courseBriefcase = BriefcaseControl.GetBriefcase(kkno); var skdatatable = courseBriefcase.FindTable("SKTABLE"); //将上课表转换成datatable var skDatarow = skdatatable.Select(string.Format("SKNO = {0}", skno)); skDatarow.First().BeginEdit(); skDatarow.First()["EDITMANNO"] = skRecord.EDITMANNO; skDatarow.First()["EDITDATE"] = skRecord.EDITDATE; skDatarow.First()["DMFS"] = skRecord.DMFS; skDatarow.First()["CDRS"] = skRecord.CDRS; skDatarow.First()["ZCRS"] = skRecord.ZCRS; skDatarow.First()["ZTRS"] = skRecord.ZTRS; skDatarow.First()["KKRS"] = skRecord.KKRS; skDatarow.First()["SKDATE"] = skRecord.SKDATE; skDatarow.First()["XKDATE"] = skRecord.XKDATE; skDatarow.First().EndEdit(); skdatatable = EnumerableExtension.ListToDataTable(skdatatable.ToList <SKTABLE_07_VIEW> (), "SKTABLE"); courseBriefcase.AddTable(skdatatable); courseBriefcase.WriteBriefcase(); var classInfoTable = OfflineDataControl.GetClassInfoTable(kkno); //var classInfoTable = courseBriefcase.FindTable("ClassInfo"); var classInfoRow = classInfoTable.Select(string.Format("上课编号='{0}'", skno)); classInfoRow.First().BeginEdit(); classInfoRow.First()["上课状态"] = "已签到"; classInfoRow.First().EndEdit(); courseBriefcase.AddTable(classInfoTable); courseBriefcase.WriteBriefcase(); //todo:改PropertiesBriefcase!!!! //foreach (DataRow sktableRow in skdatatable.Rows) { // if ((Int16)sktableRow["SKZT"] == 3) // continue; // var index = sktableList.FindIndex(a => a.SKNO == (long) sktableRow["SKNO"]); // sktableRow.BeginEdit(); // sktableRow[["ZTRS"]] //} //courseBriefcase.AddTable (skdatatable); // 将datatable写入briefcase中 //var ttttt = courseBriefcase.FindTable("SKTABLE"); //courseBriefcase.WriteBriefcase (); // 写入硬盘 ////刷新PropertiesBriefcase //RefreshClassInfoTable(courseBriefcase , sktableList); }