/// <summary> /// 签章表更新 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void DangAnDaiRefeshMDB_Click(object sender, RoutedEventArgs e) { string selectDir = FileUtils.SelectDir(); int a = 0; if (!MyUtils.Utils.IsStrNull(selectDir)) { MyAction myAction = new MyAction(new Action(() => { DirClass dirClass = new DirClass(selectDir); foreach (string dir in dirClass.Dirs) { DirClass dangAnDaiDir = new DirClass(dir); string path = dangAnDaiDir.FindFileAllSelectOne("权籍", FileSelectRelation.Contains); if (MyUtils.Utils.CheckFileExists(path)) { string[] array = System.IO.Path.GetFileName(dir).Split('('); string zdnum = array[0]; IList <QZB> qzbs = QZBCustom.DocToDaAnDaiQZB(path, zdnum); if (MyUtils.Utils.CheckListExists(qzbs)) { //删除以前的签章表 MDBUtils.DeleteBySql(model.QZ_BSMDBPath, "Delete From " + QZBCustom.QZBTableName + " Where BZDH ='" + zdnum + "'"); //保存现在的 MDBUtils.WriteData(model.QZ_BSMDBPath, QZBCustom.QZBTableName, qzbs); a++; } } } }) , "更新签章表"); CommHelper.FastTask(myAction); } }
/// <summary> /// 保存内容 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Save_Click(object sender, RoutedEventArgs e) { double areaDX = GetNF_Floor_Area(); if ((areaDX == 0 && Utils.MessageBoxShow("确定保存吗?")) || Utils.MessageBoxShow("农房表与分层表,面积之差:" + areaDX + ",确定保存吗?")) { JSYDCustom.SavejSYDRow(ectypalJSYD, dataSourceViewModel); //电话号码设置 if (MyUtils.Utils.CheckListExists(JSYD.HZs)) { JSYD.HZs[0].LXDH = LXDHTexEdit.Text; } if (MyUtils.Utils.CheckListExists(JSYD.QZBs)) { //删除以前的签章表 MDBUtils.DeleteBySql(dataSourceViewModel.QZ_BSMDBPath, "Delete From " + QZBCustom.QZBTableName + " Where BZDH ='" + JSYD.ZDNUM + "'"); //保存现在的 MDBUtils.WriteData(dataSourceViewModel.QZ_BSMDBPath, QZBCustom.QZBTableName, ectypalJSYD.QZBs); } if (MyUtils.Utils.CheckListExists(JSYD.JZXInfos)) { //删除以前的标示表 MDBUtils.DeleteBySql(dataSourceViewModel.QZ_BSMDBPath, "Delete From " + JZXInfoCustom.JZXTableName + " Where BZDH ='" + JSYD.ZDNUM + "'"); //保存现在的 MDBUtils.WriteData(dataSourceViewModel.QZ_BSMDBPath, JZXInfoCustom.JZXTableName, ectypalJSYD.JZXInfos); } //对象复制 ReflectUtils.ClassCopy(ectypalJSYD, JSYD); } }
public static ObservableCollection <Zdinfo> GetMDBToZdinfos(string mdbPath) { //IList<Zdinfo> list = ExcelUtils.GetExcelToObject<NF>(path, XMLPath); ObservableCollection <Zdinfo> list = Utils.ListToObservableCollection(MDBUtils.ReadAllData <Zdinfo>("Zdinfo", mdbPath)); return(list); }
public static ObservableCollection <QZB> GetMDBToQZB(string mdbPath) { ObservableCollection <QZB> list = MDBUtils.ReadAllDataToObservableCollection <QZB>(QZBTableName, mdbPath); return(list); }
public static ObservableCollection <JZXInfo> GetMDBToJZX(string mdbPath) { ObservableCollection <JZXInfo> list = MyUtils.Utils.ListToObservableCollection(MDBUtils.ReadAllData <JZXInfo>(JZXTableName, mdbPath)); int len = list.Count; int a = 0; int b = 0; for (int i = 0; i < len - 1; i++) //外循环为排序趟数,len个数进行len-1趟 { for (int j = 0; j < len - 1 - i; j++) { //内循环为每趟比较的次数,第i趟比较len-i次 string qdh1 = list[j].QDH; string qdh2 = list[j + 1].QDH; if (qdh1 != null && qdh2 != null) { if (int.TryParse(qdh1.Replace("J", ""), out a) && int.TryParse(qdh2.Replace("J", ""), out b)) { if (a > b) { // 相邻元素比较,若逆序则交换(升序为左大于右,降序反之) var temp = list[j]; list[j] = list[j + 1]; list[j + 1] = temp; } } } } } return(list); }