/// <summary> /// 建设用地和宗地图对比 /// </summary> /// <param name="jsyd"></param> /// <param name="zdinfo"></param> /// <returns></returns> private string CheckJSYD_Zdinfo(JSYD jsyd, Zdinfo zdinfo, int cellIndex) { StringBuilder sb = new StringBuilder(); if (!Utils.StrEquals(jsyd.TFH, zdinfo.TUFU)) { //sb.Append("、图幅号是:" + zdinfo.TUFU); } if (jsyd.ZDMJ != zdinfo.AREA) { sb.Append("、宗地面积是:" + zdinfo.AREA); } if (jsyd.ZDMJ < jsyd.SYQMJ) { sb.Append("、宗地面积小于使用权面积"); } double dt = jsyd.ZDMJ - jsyd.SYQMJ - jsyd.CZMJ; if (Math.Abs(dt) > 0.001) { sb.Append("、宗地面积 减 使用权 减 超占 面积 = " + dt); } if (jsyd.JZZDZMJ != zdinfo.ZDMJ) { sb.Append("、占地面积是:" + zdinfo.ZDMJ); } if (sb.Length > 0) { sb.Insert(0, "宗地表和地籍表MDB对比:"); CheckZJDWriteError(jsyd.Row, cellIndex, sb.ToString()); return(sb.ToString()); } return(""); }
/// <summary> /// 户主必须是第一个人 /// </summary> /// <param name="jsyd"></param> /// <param name="saveDir"></param> public void ExportZJD_WTS(JSYD jsyd, string saveDir) { string docTempletePath = JSYDCustom.WTSDocPath; XWPFDocument doc = WordRead.Read(docTempletePath); //Dictionary<string, XMLObject> jtcyXML = XMLRead.XmlToObjects(JSYDCustom.JTCYXMLPath); //WordWrite.ReplaceText(doc, jtcyXML, jsyd.HZs[0]); IList <JTCY> oneJtcys = jsyd.HZs[0].JTCies; IList <XWPFParagraph> ps = doc.Paragraphs; StringBuilder sb = new StringBuilder(); WordWrite.ReplaceText(ps[3].Runs[0], "孙", ""); //第二段加入户主 WordWrite.SetRun(ps[4].Runs[0], jsyd.HZs[0].XM + "(" + jsyd.HZs[0].GMSFHM + ")", ps[2].Runs[0]); for (int a = 0; a < oneJtcys.Count; a++) { JTCY jtcy = oneJtcys[a]; sb.Append(jtcy.XM + "(" + jtcy.GMSFHM + ")"); if (a < oneJtcys.Count - 1) { sb.Append("、"); } if (a % 2 != 0 && a != 0) { if (a < oneJtcys.Count - 1) { sb.Append("\n\t"); } if (a != 1) { sb.Insert(0, " "); } //两个人就为一行数据 WordWrite.SetRun(ps[3].Runs[0], sb.ToString(), ps[2].Runs[0]); sb.Remove(0, sb.Length); } } if (sb.Length > 0) { sb.Append("\n\t"); if (oneJtcys.Count > 2) { sb.Insert(0, " "); } //第三段加入家庭成员 WordWrite.SetRun(ps[3].Runs[0], sb.ToString(), ps[2].Runs[0]); sb.Remove(0, sb.Length); } string saveName = GetZJDSaveFileName(jsyd, saveDir, docTempletePath); WordWrite.SaveToFile(doc, saveName); }
/// <summary> /// 得到宅基地文件保存的名称 /// </summary> /// <param name="jsyd"></param> /// <param name="saveDir"></param> /// <param name="docTempletePath"></param> /// <returns></returns> public static string GetZJDSaveFileName(JSYD jsyd, string saveDir, string docTempletePath) { IList <JTCY> hzs = jsyd.HZs; string hzmcTotal = hzs[0].XM; for (int a = 1; a < hzs.Count; a++) { hzmcTotal = hzmcTotal + "_" + hzs[a].XM; } return(saveDir + "\\" + jsyd.ZDNUM + "(" + hzmcTotal + ")\\" + Path.GetFileName(docTempletePath)); }
private bool SaveZJDWorkbook(JSYD jsyd, ZJDDataSourceViewModel model) { bool flag = false; IList <NF> nfs = jsyd.NFs; IList <JTCY> jtcys = jsyd.HZs; IList <Floor> floors = jsyd.Floors; if (Utils.CheckListExists(nfs) && Utils.CheckListExists(jtcys) && Utils.CheckListExists(floors)) { flag = true; ExcelManager.ExcelWrite.Save(jsyd.Row, model.JSYDTablePath); ExcelManager.ExcelWrite.Save(nfs[0].Row, model.NFTablePath); ExcelManager.ExcelWrite.Save(jtcys[0].Row, model.JTCYTablePath); } return(flag); }
public virtual void Table_Click(object sender, MouseButtonEventArgs e) { GridControl gridControl = sender as GridControl; JSYDPagerPageViewModel model = gridControl.CurrentItem as JSYDPagerPageViewModel; if (model != null) { JSYD jsyd = model.JSYD; JSYDDataShowWindow window = new JSYDDataShowWindow(jsyd, dataSourceViewModel); window.ShowDialog(); model.QLRMC = jsyd.QLRMC; model.ZDNUM = jsyd.ZDNUM; model.BZ = jsyd.BZ; } }
private void ExportZJD(JSYD jsyd, ZJDExportDataViewModel model) { string saveDir = model.SaveDir; //档案袋 if (model.IsDangAnDai) { //Type type = jsyd.JZXInfos.GetType(); //Type typeA = Type.GetType(type.AssemblyQualifiedName); //Console.WriteLine(type.AssemblyQualifiedName); zjdDao.ExportZJD_DangAnDai(jsyd, saveDir); } //审批表 if (model.IsSPB) { zjdDao.ExportZJD_SPB(jsyd, saveDir); } //委托书 if (model.IsWTS) { zjdDao.ExportZJD_WTS(jsyd, saveDir); } //声明书 if (model.IsSMS) { zjdDao.ExportZJD_SMS(jsyd, saveDir); } //权籍调查表 if (model.IsQJDCB) { if (Utils.CheckListExists(jsyd.QZBs)) { if (Utils.CheckListExists(jsyd.JZXInfos)) { zjdDao.ExportZJD_QJDCB(jsyd, saveDir); } } } //测绘报告 if (model.IsCHBG) { zjdDao.ExportZJD_CHBG(jsyd, saveDir); } }
public JSYDPagerPageViewModel(JSYD jsyd) { ZDNUM = jsyd.ZDNUM; QLRMC = ""; if (jsyd.HZs != null) { foreach (JTCY jtcy in jsyd.HZs) { QLRMC = jtcy.XM + "、" + QLRMC; } if (QLRMC.Length > 0) { QLRMC = QLRMC.Remove(QLRMC.Length - 1, 1); } bz = jsyd.BZ; } //IsChecked = true; this.JSYD = jsyd; }
public void ExportZJD_SMS(JSYD jsyd, string saveDir) { string docTempletePath = JSYDCustom.SMSDocPath; XWPFDocument doc = WordRead.Read(docTempletePath); Dictionary <string, XMLObject> jsydXML = XMLRead.XmlToObjects(JSYDCustom.JSYDXMLPath); WordWrite.ReplaceText(doc, jsydXML, jsyd); Dictionary <string, XMLObject> xzdmXML = XMLRead.XmlToObjects(JSYDCustom.ZJDXZDMMLPath); WordWrite.ReplaceText(doc, xzdmXML, jsyd.ZJDXZDM); Dictionary <string, XMLObject> jtcyXML = XMLRead.XmlToObjects(JSYDCustom.JTCYXMLPath); WordWrite.ReplaceText(doc, jtcyXML, jsyd.HZs[0]); IList <JTCY> jTCies = jsyd.HZs[0].JTCies; StringBuilder sb = new StringBuilder(); for (int a = 0; a < jTCies.Count; a++) { JTCY jtcy = jTCies[a]; if (a % 2 == 0) { sb.Append(jtcy.XM + "(" + jtcy.GMSFHM + ")、"); } else { sb.Append(jtcy.XM + "(" + jtcy.GMSFHM + ")、\r\n"); } } sb.Remove(sb.Length - 1, 1); Dictionary <string, string> replaceDic = new Dictionary <string, string>(); replaceDic.Add("JTCYCount", jsyd.HZs[0].JTCies.Count + ""); replaceDic.Add("Jtcy", sb.ToString()); WordWrite.ReplaceText(doc, replaceDic); string saveName = GetZJDSaveFileName(jsyd, saveDir, docTempletePath); WordWrite.SaveToFile(doc, saveName); }
public JSYDDataShowWindow(JSYD jsyd, ZJDDataSourceViewModel dataSourceViewModel) : this() { this.JSYD = jsyd; ectypalJSYD = JSYDCustom.Clone(jsyd); this.dataSourceViewModel = dataSourceViewModel; this.DataContext = ectypalJSYD; if (MyUtils.Utils.CheckListExists(ectypalJSYD.HZs)) { JTCYTable.ItemsSource = ectypalJSYD.HZs[0].JTCies; LXDHTexEdit.Text = JSYD.HZs[0].LXDH; JTCYCountTextEdit.Content = JSYD.HZs[0].JTCies.Count; } //NFTable.ItemsSource = ectypalJSYD.NFs; //FloorTable.ItemsSource = ectypalJSYD.Floors; //QZBTable.ItemsSource = ectypalJSYD.QZBs; //BSBTable.ItemsSource = ectypalJSYD.JZXInfos; //签章表 ContextMenu aMenu = new ContextMenu(); MenuItem lastMenu = new MenuItem(); lastMenu.Header = "上行插入"; lastMenu.Click += QZBTableLastMenu_Click; aMenu.Items.Add(lastMenu); MenuItem nextMenu = new MenuItem(); nextMenu.Header = "下行行插入"; nextMenu.Click += QZBTableNextMenu_Click; aMenu.Items.Add(nextMenu); MenuItem deleteMenu = new MenuItem(); deleteMenu.Header = "删除"; deleteMenu.Click += QZBTableDeleteMenu_Click; aMenu.Items.Add(deleteMenu); QZBTable.ContextMenu = aMenu; //标示表 ContextMenu bMenu = new ContextMenu(); MenuItem blastMenu = new MenuItem(); blastMenu.Header = "上行插入"; blastMenu.Click += BSBTableLastMenu_Click; bMenu.Items.Add(blastMenu); MenuItem bnextMenu = new MenuItem(); bnextMenu.Header = "下行行插入"; bnextMenu.Click += BSBTableNextMenu_Click; bMenu.Items.Add(bnextMenu); MenuItem bdeleteMenu = new MenuItem(); bdeleteMenu.Header = "删除"; bdeleteMenu.Click += BSBTableDeleteMenu_Click; bMenu.Items.Add(bdeleteMenu); BSBTable.ContextMenu = bMenu; //注入标示表 PageAddDangAnDdaiQZBAndBSB(); //检查农房表 与 建设用地表 GetNF_Floor_Area(); TipBox1.Text = "未确权颁证\r\n遗失/灭失\r\n已提交原件"; TipBox2.Text = "其他情形\r\n改建扩建"; TipBox3.Text = "自建\r\n翻建"; }
public void ExportZJD_CHBG(JSYD jsyd, string saveDir) { string docTempletePath = JSYDCustom.CHBGDocPath; XWPFDocument doc = WordRead.Read(docTempletePath); Dictionary <string, XMLObject> xzdmXML = XMLRead.XmlToObjects(JSYDCustom.ZJDXZDMMLPath); WordWrite.ReplaceText(doc, xzdmXML, jsyd.ZJDXZDM); Dictionary <string, XMLObject> jsydXML = XMLRead.XmlToObjects(JSYDCustom.JSYDXMLPath); WordWrite.ReplaceText(doc, jsydXML, jsyd); Dictionary <string, XMLObject> jtcyXML = XMLRead.XmlToObjects(JSYDCustom.JTCYXMLPath); WordWrite.ReplaceText(doc, jtcyXML, jsyd.HZs[0]); Dictionary <string, XMLObject> nfXML = XMLRead.XmlToObjects(JSYDCustom.NFXMLPath); WordWrite.ReplaceText(doc, nfXML, jsyd.NFs[0]); Dictionary <string, string> replaceDic = new Dictionary <string, string>(); replaceDic.Add("Company", "四川旭普信息产业发展有限公司"); string zdnum = jsyd.ZDNUM; replaceDic.Add("Qjbh", zdnum.Substring(6, 3) + "-" + zdnum.Substring(9, 3) + "-" + zdnum.Substring(12, 2) + "-" + zdnum.Substring(14, 5)); foreach (NF nf in jsyd.NFs) { if (replaceDic.ContainsKey("JZJG")) { replaceDic["JZJG"] = replaceDic["JZJG"] + "、" + nf.JG; } else { replaceDic.Add("JZJG", nf.JG); } } StringBuilder sb = new StringBuilder(); foreach (Floor f in jsyd.Floors) { sb.Append("S" + f.SZC + " = " + f.CJZMJ + " 平方米 "); } replaceDic.Add("FCMJ", sb.ToString()); XMLTable xmlTable = XMLRead.GetXmlToXMLTabl(JSYDCustom.FloorXMLPath)[0]; XWPFTable table = WordWrite.ReplaceTable_Font <Floor>(doc, xmlTable, jsyd.Floors); int rowX = xmlTable.RowStartIndex + jsyd.Floors.Count; while (table.Rows.Count - rowX > 1) { table.RemoveRow(rowX); } WordWrite.ReplaceText(doc, replaceDic); string saveName = GetZJDSaveFileName(jsyd, saveDir, docTempletePath); WordWrite.SaveToFile(doc, saveName); }
public void ExportZJD_QJDCB(JSYD jsyd, string saveDir) { string docTempletePath = JSYDCustom.QJDCBDocPath; XWPFDocument doc = WordRead.Read(docTempletePath); //写入界址签章表 IList <QZB> qzbs = jsyd.QZBs; WordWrite.SetTableRowObj(doc, qzbs, JZXInfoCustom.qzbReflect); //写入标示表 IList <JZXInfo> jzxinfos = jsyd.JZXInfos; JZXInfoCustom.CreateBSB(doc, jzxinfos); Dictionary <string, XMLObject> jsydXML = XMLRead.XmlToObjects(JSYDCustom.JSYDXMLPath); WordWrite.ReplaceText(doc, jsydXML, jsyd); Dictionary <string, XMLObject> xzdmXML = XMLRead.XmlToObjects(JSYDCustom.ZJDXZDMMLPath); WordWrite.ReplaceText(doc, xzdmXML, jsyd.ZJDXZDM); Dictionary <string, XMLObject> jtcyXML = XMLRead.XmlToObjects(JSYDCustom.JTCYXMLPath); WordWrite.ReplaceText(doc, jtcyXML, jsyd.HZs[0]); Dictionary <string, XMLObject> nfXML = XMLRead.XmlToObjects(JSYDCustom.NFXMLPath); WordWrite.ReplaceText(doc, nfXML, jsyd.NFs[0]); Dictionary <string, string> replaceDic = new Dictionary <string, string>(); replaceDic.Add("Company", "四川旭普信息产业发展有限公司"); string zdnum = jsyd.ZDNUM; replaceDic.Add("Qjbh", zdnum.Substring(6, 3) + "-" + zdnum.Substring(9, 3) + "-" + zdnum.Substring(12, 2) + "-" + zdnum.Substring(14, 5)); //本宗地已取得原土地使用证: 简镇清集用(1990)字第0304 - 37号; 原房屋所有权证: 简农房权字第1002010383号; StringBuilder sb = new StringBuilder(); string str = jsyd.YTDSYZSH; if (!Utils.IsStrNull(str)) { sb.Append("原土地使用证:" + str + ";"); } str = jsyd.NFs[0].SYQZH; if (!Utils.IsStrNull(str)) { sb.Append("原房屋所有权证:" + str + ";"); } if (sb.Length > 0) { sb.Insert(0, "本宗地已取得"); } replaceDic.Add("Tag0", sb.ToString()); WordWrite.ReplaceText(doc, replaceDic); string saveName = GetZJDSaveFileName(jsyd, saveDir, docTempletePath); WordWrite.SaveToFile(doc, saveName); }
public void ExportZJD_SPB(JSYD jsyd, string saveDir) { string docTempletePath = JSYDCustom.SPBDocPath; XWPFDocument doc = WordRead.Read(docTempletePath); Dictionary <string, XMLObject> jsydXML = XMLRead.XmlToObjects(JSYDCustom.JSYDXMLPath); WordWrite.ReplaceText(doc, jsydXML, jsyd); Dictionary <string, XMLObject> xzdmXML = XMLRead.XmlToObjects(JSYDCustom.ZJDXZDMMLPath); WordWrite.ReplaceText(doc, xzdmXML, jsyd.ZJDXZDM); Dictionary <string, XMLObject> jtcyXML = XMLRead.XmlToObjects(JSYDCustom.JTCYXMLPath); WordWrite.ReplaceText(doc, jtcyXML, jsyd.HZs[0]); Dictionary <string, XMLObject> nfXML = XMLRead.XmlToObjects(JSYDCustom.NFXMLPath); WordWrite.ReplaceText(doc, nfXML, jsyd.NFs[0]); Dictionary <string, string> replaceDic = new Dictionary <string, string>(); replaceDic.Add("JTCYCount", jsyd.HZs[0].JTCies.Count + ""); replaceDic.Add("JTCYs", JTCYCustom.ToStringJTCYs(jsyd.HZs[0])); WordWrite.ReplaceText(doc, replaceDic); //替换符号 Dictionary <String, IList <RunCustomer> > docDic = WordRead.GetDocxDic(doc); IList <RunCustomer> customers; //房屋来源 if (docDic.TryGetValue(jsyd.NFs[0].FWLY, out customers)) { WordWrite.ReplaceSmpbol(customers[0]); } //土地证位置是第一个 if (docDic.TryGetValue(jsyd.NFs[0].YJTTDSYZ, out customers)) { WordWrite.ReplaceSmpbol(customers[0]); } //房产证位置是第二个 if (docDic.TryGetValue(jsyd.NFs[0].YFWSYQZ, out customers)) { WordWrite.ReplaceSmpbol(customers[1]); } if (jsyd.GYFS == "共同共有") { if (docDic.TryGetValue("是", out customers)) { WordWrite.ReplaceSmpbol(customers[1]); } if (docDic.TryGetValue("共同共有", out customers)) { WordWrite.ReplaceSmpbol(customers[0]); } } else { if (docDic.TryGetValue("否", out customers)) { WordWrite.ReplaceSmpbol(customers[1]); } } string saveName = GetZJDSaveFileName(jsyd, saveDir, docTempletePath); WordWrite.SaveToFile(doc, saveName); }
public void ExportZJD_DangAnDai(JSYD jsyd, string saveDir) { string docTempletePath = JSYDCustom.DanAnDaiDocPath; XWPFDocument doc = WordRead.Read(docTempletePath); Dictionary <string, XMLObject> jsydXML = XMLRead.XmlToObjects(JSYDCustom.JSYDXMLPath); WordWrite.ReplaceText(doc, jsydXML, jsyd); Dictionary <string, XMLObject> xzdmXML = XMLRead.XmlToObjects(JSYDCustom.ZJDXZDMMLPath); WordWrite.ReplaceText(doc, xzdmXML, jsyd.ZJDXZDM); Dictionary <string, XMLObject> jtcyXML = XMLRead.XmlToObjects(JSYDCustom.JTCYXMLPath); WordWrite.ReplaceText(doc, jtcyXML, jsyd.HZs[0]); Dictionary <string, IList <RunCustomer> > docDic = WordRead.GetDocxDic(doc); IList <RunCustomer> runCustomers; NF nf = jsyd.NFs[0]; //土地证位置是第一个 if (nf.YJTTDSYZ.Equals("遗失/灭失")) { if (docDic.TryGetValue("遗失声明", out runCustomers)) { WordWrite.ReplaceSmpbol(runCustomers[0]); } if (docDic.TryGetValue("土地登记档案", out runCustomers)) { WordWrite.ReplaceSmpbol(runCustomers[0]); } } else { if (docDic.TryGetValue(nf.YJTTDSYZ, out runCustomers)) { WordWrite.ReplaceSmpbol(runCustomers[0]); } } //房屋来源 if (nf.YFWSYQZ.Equals("遗失/灭失")) { if (docDic.TryGetValue("遗失声明", out runCustomers)) { WordWrite.ReplaceSmpbol(runCustomers[1]); } if (docDic.TryGetValue("房屋登记档案", out runCustomers)) { WordWrite.ReplaceSmpbol(runCustomers[0]); } } else { if (docDic.TryGetValue(nf.YFWSYQZ, out runCustomers)) { WordWrite.ReplaceSmpbol(runCustomers[1]); } } //房屋来源 if (docDic.TryGetValue(nf.FWLY, out runCustomers)) { WordWrite.ReplaceSmpbol(runCustomers[0]); } string saveName = GetZJDSaveFileName(jsyd, saveDir, docTempletePath); WordWrite.SaveToFile(doc, saveName); }
public IList <string> CheckZJD(JSYD jsyd, ZJDDataSourceViewModel model) { IList <string> erros = new List <string>(); ZJDXZDM xzdm = jsyd.ZJDXZDM; Zdinfo zdinfo = jsyd.Zdinfo; string error; if (zdinfo == null) { CheckZJDWriteError(jsyd.Row, model.JSYDTableErrorCellIndex, "未找到宗地表"); erros.Add("未找到宗地表"); } else { error = CheckJSYD_Zdinfo(jsyd, zdinfo, model.JSYDTableErrorCellIndex); if (error != "") { erros.Add(error); } } IList <NF> nfs = jsyd.NFs; if (nfs == null) { CheckZJDWriteError(jsyd.Row, model.JSYDTableErrorCellIndex, "未找到农房表"); erros.Add("未找到农房表"); } else { error = CheckNF(nfs, model.NFTableErrorCellIndex); if (error != "") { erros.Add(error); } IList <Floor> floors = jsyd.Floors; if (floors == null) { CheckZJDWriteError(jsyd.Row, model.JSYDTableErrorCellIndex, "未找到分层表"); erros.Add("未找到分层表"); } else { if (Utils.IsStrNull(jsyd.YTDSYZSH) && nfs[0].YJTTDSYZ != "未确权颁证") { erros.Add("无土地证 农房表 填写的不是 未确权颁证"); } error = CheckFloor(floors, model.FloorTableErrorCellIndex); if (error != "") { erros.Add(error); } error = CheckNF_Floor(nfs, floors, model.FloorTableErrorCellIndex); if (error != "") { erros.Add(error); } } } IList <JTCY> hzs = jsyd.HZs; CheckHZs(hzs, model.JTCYTableErrorCellIndex); IList <QZB> qzbs = jsyd.QZBs; IList <JZXInfo> jzxInfos = jsyd.JZXInfos; return(erros); }