Ejemplo n.º 1
0
        public static IList <JTCY> ReadJTCYExcel(string path)
        {
            ObservableCollection <JTCY> jTCies = ExcelUtils.GetExcelToObjectToObservableCollection <JTCY>(path, ReadJTCYExcelXMLPath);
            ObservableCollection <JTCY> hzs    = ExcelUtils.GetExcelToObjectToObservableCollection <JTCY>(path, ReadHZExcelXMLPath);

            ObservableCollection <JTCY> list = new ObservableCollection <JTCY>();

            foreach (JTCY hz in hzs)
            {
                hz.YHZGX = "02";

                bool flag = true;
                for (int a = list.Count - 1; a >= 0; a--)
                {
                    if (list[a].CBFBM == hz.CBFBM)
                    {
                        flag = false;
                        break;
                    }
                }
                if (flag)
                {
                    list.Add(hz);
                }
            }
            //去除家庭成员 没有名字的情况
            foreach (JTCY jtcy in jTCies)
            {
                if (!Utils.IsStrNull(jtcy.XM))
                {
                    list.Add(jtcy);
                }
            }
            return(list);
        }
Ejemplo n.º 2
0
        /// <summary>
        /// 设置界址线表
        /// </summary>
        /// <param name="jsydDic"></param>
        /// <param name="jzxs"></param>
        internal static void SetJZXs(ObservableCollection <JSYD> jsyds, ObservableCollection <JZXInfo> jzxs)
        {
            Dictionary <string, ObservableCollection <JZXInfo> > dic = null;

            try
            {
                dic = Utils.GetGroupDicToList("BZDH", jzxs);
            }
            catch (Exception e)
            {
                MessageBox.Show("界址线表:宗地编码:" + e.Message);
                return;
            }


            ObservableCollection <JZXInfo> list;

            foreach (JSYD jsyd in jsyds)
            {
                if (!Utils.IsStrNull(jsyd.ZDNUM) && dic.TryGetValue(jsyd.ZDNUM, out list))
                {
                    jsyd.JZXInfos = list;
                }
            }
        }
Ejemplo n.º 3
0
        private void SelectDir_Click(object sender, RoutedEventArgs e)
        {
            string dir = FileUtils.SelectDir();

            if (!Utils.IsStrNull(dir))
            {
                model.Dir = dir;
                IList <string> list = FileUtils.SelectAllDirFiles(dir, ".xls", FileSelectRelation.Contains, false);
                AddFile(list);
            }
        }
Ejemplo n.º 4
0
 /// <summary>
 /// 替换word中的内容
 /// </summary>
 /// <param name="replaceViewModels"></param>
 /// <param name="doc"></param>
 public static void ReplaceText(IList <ReplaceViewModel> replaceViewModels, Document doc)
 {
     foreach (ReplaceViewModel replaceViewModel in replaceViewModels)
     {
         string oldText = replaceViewModel.OldText;
         string newText = replaceViewModel.NewText;
         if (newText == null)
         {
             newText = "";
         }
         if (!Utils.IsStrNull(oldText))
         {
             int changeCount = doc.Range.Replace(oldText, newText, true, false);
         }
     }
 }
Ejemplo n.º 5
0
        private void AddDirFile_Click(object sender, RoutedEventArgs e)
        {
            string dir = FileUtils.SelectDir();

            if (!Utils.IsStrNull(dir))
            {
                model.Dir = dir;
                DirClass dirClass = new DirClass(dir);
                if (model.IsDiGuiChaZhao)
                {
                    AddFile(dirClass.FindFileAll());
                }
                else
                {
                    AddFile(dirClass.Files);
                }
            }
        }
Ejemplo n.º 6
0
        /// <summary>
        /// 代码关系转换 为文字关系
        /// </summary>
        /// <param name="hzs"></param>
        private static void DMToText(IList <JTCY> hzs)
        {
            int value;
            Dictionary <string, string> yhzgxDic = ExcelRead.ReadExcelToDic(System.AppDomain.CurrentDomain.BaseDirectory + "家庭关系代码.xls", 0);

            foreach (JTCY hz in hzs)
            {
                foreach (JTCY jtcy in hz.jTCies)
                {
                    string sex = jtcy.XB;
                    if (sex != null)
                    {
                        if (int.TryParse(sex, out value))
                        {
                            if (value % 2 == 0)
                            {
                                jtcy.XB = "男";
                            }
                            else
                            {
                                jtcy.XB = "女";
                            }
                        }
                    }
                    string yhzgx = jtcy.YHZGX;

                    if (!Utils.IsStrNull(yhzgx) && yhzgxDic.TryGetValue(yhzgx, out yhzgx))
                    {
                        jtcy.YHZGX = yhzgx;
                    }
                    string sfgyr = jtcy.SFGYR;
                    if (sfgyr == "1" || sfgyr == "是")
                    {
                        jtcy.SFGYR = "是";
                    }
                    else
                    {
                        jtcy.SFGYR = "否";
                    }
                }
            }
        }
Ejemplo n.º 7
0
        public void AddFile(IList <string> files2)
        {
            IList <FileNameCustom> fileNameCustoms = new List <FileNameCustom>();

            if (!Utils.CheckListExists(files2))
            {
                return;
            }
            if (Utils.IsStrNull(Filter))
            {
                for (int a = 0; a < files2.Count; a++)
                {
                    FileNameCustom custom = new FileNameCustom(files2[a]);
                    fileNameCustoms.Add(custom);
                }
                addFilePagerPage.AddObject(fileNameCustoms);
                return;
            }
            IList <string> files = new List <string>();
            int            count = files2.Count;

            string[] filters = FileterToEndWith();
            for (int a = 0; a < count; a++)
            {
                string path = files2[a];
                string ex   = System.IO.Path.GetExtension(path);
                if (path != null && Array.IndexOf(filters, ex) != -1)
                {
                    files.Add(path);
                }
            }


            for (int a = 0; a < files.Count; a++)
            {
                FileNameCustom custom = new FileNameCustom(files[a]);
                fileNameCustoms.Add(custom);
            }
            addFilePagerPage.AddObject(fileNameCustoms);
        }
Ejemplo n.º 8
0
        /// <summary>
        /// excel 转换为jtcy 对象
        /// </summary>
        /// <param name="path">Excel路径</param>
        /// <returns></returns>
        public static ObservableCollection <JTCY> GetExcelToHZS(string path)
        {
            ObservableCollection <JTCY> list = ExcelUtils.GetExcelToObjectToObservableCollection <JTCY>(path, XMLPath);
            ObservableCollection <JTCY> hzs  = GetJTCYSToHz(list);

            //户主放在第一位
            for (int b = 0; b < hzs.Count; b++)
            {
                JTCY hz = hzs[b];
                if (Utils.IsStrNull(hz.GMSFHM))
                {
                    hzs.RemoveAt(b);
                    b--;
                    continue;
                }
                IList <JTCY> jTCies = hz.JTCies;
                for (int a = 1; a < jTCies.Count; a++)
                {
                    JTCY jTCY = jTCies[a];
                    if (jTCY.YHZGX == "户主")
                    {
                        jTCies.RemoveAt(a);
                        jTCies.Insert(0, jTCY);
                        break;
                    }
                }
                for (int a = 2; a < jTCies.Count; a++)
                {
                    JTCY jTCY = jTCies[a];
                    if (jTCY.YHZGX == "妻")
                    {
                        jTCies.RemoveAt(a);
                        jTCies.Insert(1, jTCY);
                        break;
                    }
                }
            }

            return(hzs);
        }
Ejemplo n.º 9
0
        internal static void SetHZs(IList <JSYD> jsyds, IList <JSYD> gyrs, IList <JTCY> hzs)
        {
            Dictionary <string, JTCY> hzZJHMDic = null;

            try
            {
                hzZJHMDic = MyUtils.Utils.GetGroupDic("GMSFHM", hzs);
            }
            catch (Exception e)
            {
                MessageBox.Show("家庭成员表:证件号码:" + e.Message);
                return;
            }
            Dictionary <string, IList <JSYD> > gyrDic = Utils.GetGroupDicToList("ZDNUM", gyrs);
            JTCY         hz;
            IList <JSYD> gyrTem;

            foreach (JSYD jsyd in jsyds)
            {
                string zjhm = jsyd.ZJHM;
                if (!Utils.IsStrNull(zjhm) && hzZJHMDic.TryGetValue(zjhm, out hz))
                {
                    jsyd.HZs.Add(hz);
                }
                //
                string zdnum = jsyd.ZDNUM;
                if (gyrDic.TryGetValue(zdnum, out gyrTem))
                {
                    foreach (JSYD gyr in gyrTem)
                    {
                        zjhm = gyr.ZJHM;
                        if (!Utils.IsStrNull(zjhm) && hzZJHMDic.TryGetValue(zjhm, out hz))
                        {
                            jsyd.HZs.Add(hz);
                        }
                    }
                }
            }
        }
Ejemplo n.º 10
0
        /// <summary>
        /// 所有家庭成员 设置到户主中 去
        /// </summary>
        /// <param name="jtcys"></param>
        /// <returns></returns>
        private static ObservableCollection <JTCY> GetJTCYSToHz(ObservableCollection <JTCY> jtcys)
        {
            if (jtcys == null)
            {
                return(null);
            }

            string tem   = "";
            int    index = 1;

            foreach (JTCY jtcy in jtcys)
            {
                if (!Utils.IsStrNull(jtcy.CBFBM))
                {
                    tem        = (index++) + "";
                    jtcy.CBFBM = tem;
                }
                else
                {
                    jtcy.CBFBM = tem;
                }
            }
            Dictionary <string, ObservableCollection <JTCY> > jtcyGroupDic = Utils.GetGroupDicToList("CBFBM", jtcys);
            ObservableCollection <JTCY> hzs = new ObservableCollection <JTCY>();

            foreach (string cbfbm in jtcyGroupDic.Keys)
            {
                IList <JTCY> oneJTCY = jtcyGroupDic[cbfbm];
                JTCY         hz      = FindOneJtcyHZ(oneJTCY);
                if (hz != null)
                {
                    hz.JTCies = oneJTCY;
                    hzs.Add(hz);
                }
            }
            return(hzs);
        }
Ejemplo n.º 11
0
        /// <summary>
        /// 导出 农村土地家庭承包农户基本情况信息表(一)
        /// </summary>
        /// <param name="hzs"></param>
        public static bool ExportBsicInformationExcel(IList <JTCY> hzs, string saveDir)
        {
            Dictionary <string, string> dklbDic = new Dictionary <string, string>();

            dklbDic.Add("10", "承包地");
            dklbDic.Add("21", "自留地");
            dklbDic.Add("22", "机动地");
            dklbDic.Add("23", "开荒地");
            dklbDic.Add("99", "其他集体土地");


            if (Utils.IsStrNull(saveDir))
            {
                return(false);
            }
            string basicInformationExxcelTemplete       = System.AppDomain.CurrentDomain.BaseDirectory + "CBDTemplete\\农村土地家庭承包农户基本情况信息表(一)模板.xls";
            Dictionary <int, XMLTable>     ClazzDic     = XMLRead.GetXmlToXMLTabl(System.AppDomain.CurrentDomain.BaseDirectory + "CBDTemplete\\WriteJTCYBaicInformationExcel.xml");
            Dictionary <string, XMLObject> xmlObjectDic = XMLRead.XmlToObjects(System.AppDomain.CurrentDomain.BaseDirectory + "CBDTemplete\\WriteJTCYBaicInformationExcel.xml");



            string basicInformationExxcelTemplete2       = System.AppDomain.CurrentDomain.BaseDirectory + "CBDTemplete\\农村土地承包经营权(家庭承包)台帐(二)模板.xls";
            Dictionary <int, XMLTable>     ClazzDic2     = XMLRead.GetXmlToXMLTabl(System.AppDomain.CurrentDomain.BaseDirectory + "CBDTemplete\\WriteDKBaicInformationExcel.xml");
            Dictionary <string, XMLObject> xmlObjectDic2 = XMLRead.XmlToObjects(System.AppDomain.CurrentDomain.BaseDirectory + "CBDTemplete\\WriteDKBaicInformationExcel.xml");


            string cbfbm;

            if (Utils.CheckListExists(hzs))
            {
                DMToText(hzs);
                foreach (JTCY hz in hzs)
                {
                    string cbfdz = hz.DZ;
                    if (!cbfdz.EndsWith("组"))
                    {
                        cbfdz = cbfdz.Substring(0, cbfdz.LastIndexOf("组")) + "组";
                    }
                    int index = cbfdz.IndexOf("镇");
                    if (index == -1)
                    {
                        index = cbfdz.IndexOf("乡");
                    }
                    hz.DZ = cbfdz.Substring(index + 1, cbfdz.Length - index - 1);
                    XMLTable  xmlTable = ClazzDic[0];
                    IWorkbook workbook = ExcelRead.ReadExcel(basicInformationExxcelTemplete);
                    ISheet    sheet    = workbook.GetSheetAt(0);
                    //家庭成员表行数据插入
                    ExcelWrite.WriteObjects(sheet, xmlTable, hz.jTCies);
                    //家庭成员表 文字替换
                    ExcelWrite.ReplaceTextByXMLObject(sheet, hz, xmlObjectDic);
                    ExcelWrite.Save(workbook, saveDir + "//TZ-" + hz.CBFBM.Substring(0, 14) + " " + cbfdz + "\\TZ4 -" + hz.CBFBM + "-1农村土地家庭承包农户基本情况信息表(一).xls");

                    //写地块表
                    Dictionary <string, string> tdlylxDic = ExcelRead.ReadExcelToDic(System.AppDomain.CurrentDomain.BaseDirectory + "CBDTemplete\\土地利用类型映射表.xlsx", 0);
                    IList <DK> dks = hz.DKs;
                    if (dks == null)
                    {
                        continue;
                    }
                    foreach (DK dk in dks)
                    {
                        if (dk.DKLB == "21")
                        {
                            dk.ZLDMJ = Math.Round(dk.HTMJ, 2).ToString("f2");
                        }
                        else
                        {
                            dk.ELCBMJ = Math.Round(dk.HTMJ, 2).ToString("f2");
                        }


                        string dklb = dk.DKLB;
                        if (dklb != null)
                        {
                            if (dklbDic.TryGetValue(dklb, out dklb))
                            {
                                //地块类别无法识别的情况
                                dk.DKLB = dklb;
                            }
                        }
                        string tdlylx = dk.TDLYLX;
                        if (tdlylx != null)
                        {
                            if (tdlylxDic.TryGetValue(tdlylx, out tdlylx))
                            {
                                dk.TDLYLX = tdlylx;
                            }
                        }
                    }
                    IWorkbook workbook2 = ExcelRead.ReadExcel(basicInformationExxcelTemplete2);
                    ISheet    sheet2    = workbook2.GetSheetAt(0);
                    ExcelWrite.ReplaceTextByXMLObject(sheet2, hz, xmlObjectDic);
                    ExcelWrite.WriteObjects(sheet2, ClazzDic2[0], hz.DKs);


                    for (int a = 0; a < dks.Count; a++)
                    {
                        IRow row = sheet.GetRow(a + 5);
                    }

                    ExcelWrite.Save(workbook2, saveDir + "//TZ-" + hz.CBFBM.Substring(0, 14) + " " + cbfdz + "\\TZ4 -" + hz.CBFBM + "-2农村土地承包经营权(家庭承包)台帐(二).xls");
                }
                return(true);
            }
            return(false);
        }
Ejemplo n.º 12
0
Archivo: ZJDDao.cs Proyecto: YB9527/CG
        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);
        }
Ejemplo n.º 13
0
Archivo: ZJDDao.cs Proyecto: YB9527/CG
        /// <summary>
        /// 检查农房表
        /// </summary>
        /// <param name="jsyd"></param>
        /// <param name="nfs"></param>
        private string CheckNF(IList <NF> nfs, int cellIndex)
        {
            StringBuilder sb  = new StringBuilder();
            NF            nf  = nfs[0];
            double        tem = 0;
            //检查层数
            int csInt;

            foreach (NF nf1 in nfs)
            {
                tem += nf1.CJZMJ;
                if (nf1.SZC == null)
                {
                    continue;
                }
                string[] csArray = nf1.SZC.Split('、');
                foreach (string csStr in csArray)
                {
                    if (int.TryParse(csStr, out csInt))
                    {
                        if (nf.ZCS < csInt)
                        {
                            sb.Append("、所在层中有 大于 总层 的数字");
                            CheckZJDWriteError(nf1.Row, cellIndex, "、所在层中有 大于 总层 的数字");
                        }
                    }
                    else
                    {
                        sb.Append("、所在层中填写有不是数字");
                        CheckZJDWriteError(nf1.Row, cellIndex, "、所在层中填写有不是数字");
                    }
                }
                if (nf1.CZTJG + "结构" != nf1.JG)
                {
                    sb.Append("、层主体结构 与 结构一致");
                    CheckZJDWriteError(nf1.Row, cellIndex, "、层主体结构一致");
                }
            }
            if (Math.Abs(nf.JZMJ - tem) > 0.001)
            {
                sb.Append("、层建筑面积 与 建筑面积不相等");
                CheckZJDWriteError(nf.Row, cellIndex, "、层建筑面积 与 建筑面积不相等字");
            }
            if (nf.JZMJ < nf.FZMJ)
            {
                sb.Append("、层建筑面积 小于 建筑面积");
                CheckZJDWriteError(nf.Row, cellIndex, "、层建筑面积 小于 建筑面积");
            }
            for (int a = 1; a < nfs.Count; a++)
            {
                NF temNF = nfs[a];
                if (nf.SYQZH != temNF.SYQZH)
                {
                    sb.Append("、所有权号不一致");
                    CheckZJDWriteError(temNF.Row, cellIndex, "、所有权号不一致");
                }
                if (nf.QLRMC != temNF.QLRMC)
                {
                    sb.Append("、权利人名称不一致");
                    CheckZJDWriteError(temNF.Row, cellIndex, "、权利人名称不一致");
                }
                if (nf.ZJHM != temNF.ZJHM)
                {
                    sb.Append("、证件号码不一致");
                    CheckZJDWriteError(temNF.Row, cellIndex, "、证件号码不一致");
                }
                if (nf.ZCS != temNF.ZCS)
                {
                    sb.Append("、总层数不一致");
                    CheckZJDWriteError(temNF.Row, cellIndex, "、总层数不一致");
                }

                if (nf.JZMJ != temNF.JZMJ)
                {
                    sb.Append("、建筑面积不一致");
                    CheckZJDWriteError(temNF.Row, cellIndex, "、建筑面积不一致");
                }
                if (nf.ZCS != temNF.CS)
                {
                    sb.Append("、总层数 与 层数不一致");
                    CheckZJDWriteError(temNF.Row, cellIndex, "、总层数 与 层数不一致");
                }
                if (nf.FWLY != temNF.FWLY)
                {
                    sb.Append("、房屋来源 不一致");
                    CheckZJDWriteError(temNF.Row, cellIndex, "、房屋来源 不一致");
                }
                if (nf.YJTTDSYZ != temNF.YJTTDSYZ)
                {
                    sb.Append("、土地权属来源(是否有原件)不一致");
                    CheckZJDWriteError(temNF.Row, cellIndex, "、房屋来源 不一致");
                }
                if (nf.YFWSYQZ != temNF.YFWSYQZ)
                {
                    sb.Append("、房屋权属来源(是否有原件)不一致");
                    CheckZJDWriteError(temNF.Row, cellIndex, "、房屋权属来源(是否有原件)不一致");
                }
                if (nf.JGRQ != temNF.JGRQ)
                {
                    sb.Append("、竣工日期不一致");
                    CheckZJDWriteError(temNF.Row, cellIndex, "、竣工日期不一致");
                }
                if (nf.ZL != temNF.ZL)
                {
                    sb.Append("、坐落不一致");
                    CheckZJDWriteError(temNF.Row, cellIndex, "、坐落不一致");
                }
                if (nf.ZL != temNF.ZL)
                {
                    sb.Append("、产权来源不一致");
                    CheckZJDWriteError(temNF.Row, cellIndex, "、产权来源不一致");
                }
                if (nf.ZL != temNF.ZL)
                {
                    sb.Append("、产权来源不一致");
                    CheckZJDWriteError(temNF.Row, cellIndex, "、产权来源不一致");
                }
            }
            //(nf.YJTTDSYZ == "已提交原件" || nf.YFWSYQZ == "已提交原件") || (
            if (nf.YJTTDSYZ == "未确权颁证" && nf.YFWSYQZ == "未确权颁证")
            {
                if (nf.FWLY != "其他情形")
                {
                    sb.Append("、房屋来源不是其他情形");
                    CheckZJDWriteError(nf.Row, cellIndex, "、产权来源不一致");
                }
                if (nf.CQLY != "自建")
                {
                    sb.Append("、产权来源不是自建");
                    CheckZJDWriteError(nf.Row, cellIndex, "、产权来源不是自建");
                }
            }
            else
            {
                if (!(nf.FWLY == "改建扩建" || nf.FWLY == "其他情形"))
                {
                    sb.Append("、房屋来源不是改建扩建");
                    CheckZJDWriteError(nf.Row, cellIndex, "、房屋来源不是改建扩建、其他情形");
                }
                if (!(nf.CQLY == "翻建" || nf.CQLY == "自建"))
                {
                    sb.Append("、产权来源不是翻建");
                    CheckZJDWriteError(nf.Row, cellIndex, "、产权来源不是翻建、自建");
                }
            }
            if (Utils.IsStrNull(nf.SYQZH))
            {
                if (nf.YFWSYQZ != "未确权颁证")
                {
                    sb.Append("、无证号,但填写的是 确权颁证");
                    CheckZJDWriteError(nf.Row, cellIndex, "、无证号,但填写的是 确权颁证");
                }
            }
            else
            {
                if (nf.YFWSYQZ == "未确权颁证")
                {
                    sb.Append("、有证号,但填写的是 未确权颁证");
                    CheckZJDWriteError(nf.Row, cellIndex, "、有证号,但填写的是 未确权颁证");
                }
            }

            if (sb.Length > 0)
            {
                sb.Insert(0, "农房表自查:");

                return(sb.ToString());
            }
            return("");
        }
Ejemplo n.º 14
0
Archivo: ZJDDao.cs Proyecto: YB9527/CG
        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);
        }