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