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 <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); }