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