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