/// <summary>
        /// RNANDCN插入一条数据
        /// </summary>
        /// <param name="pid"></param>
        /// <param name="rnandcn"></param>
        /// <param name="head"></param>
        public void InsertRNANDCN(string pid, RNANDCN rnandcn, Head head, ref DateTime?createtime)
        {
            RnandcnManager rm = new RnandcnManager();

            rnandcn.PID        = pid;
            rnandcn.REALEUNUM  = head.EstateNum;
            rnandcn.YWH        = head.RecFlowID;
            rnandcn.JRYWBM     = head.RecType;
            rnandcn.QXDM       = head.AreaCode;
            rnandcn.CREATETIME = head.CreateDate;
            createtime         = head.CreateDate;


            rm.Insert("RNANDCN", "PID", false, rnandcn);
        }
        public void AnalysisBizFileToSubmit(string file, string pid)
        {
            DateTime?createtime = null; // 创建时间
            DateTime?djsj       = null; // 登记时间
            DateTime?slsj       = null; // 受理时间
            DateTime?zxsj       = null; // 注销时间
            string   ajzt       = null; // 案件状态
            string   qszt       = null; // 权属装填
            string   djxl       = null; // 登记类型名称



            Head                 head    = XMLHelper.GetBizHeadInfo(file);
            RNANDCN              rnandcn = new RNANDCN();
            MSGTIMERECORD        mtd     = new MSGTIMERECORD();
            RnandcnManager       rm      = new RnandcnManager();
            MsgmanageManager     mgr     = new MsgmanageManager(); // JK库的MSGMANAGE表
            MsgtimerecordManager mdr     = new MsgtimerecordManager();
            HolidayManager       hgr     = new HolidayManager();
            string               today   = head.CreateDate.ToString("yyyyMMddhhmmss");

            //string today2 = "20191018";
            ICollection <RNANDCN> list = rm.Query("select * from RNANDCN where realeunum = '" + head.PreEstateNum + "' and ywh='" + head.RecFlowID + "' and to_char(createtime,'yyyyMMddhhmiss') = '" + today + "' ");
            MSGMANAGE             msg  = mgr.Query("select * from MSGMANAGE WHERE ESTATENUM ='" + head.PreEstateNum + "' and recflowid = '" + head.RecFlowID + "' and to_char(CREATEDATE,'yyyyMMddhhmiss') = '" + today + "'").ToList().FirstOrDefault();

            if (msg != null)
            {
                mtd.UPTIME   = msg.UPTIME;                     //上传时间
                mtd.UPSTATUS = Convert.ToString(msg.UPSTATUS); //报文状态
            }

            if (list.Count == 0)
            {
                InsertRNANDCN(pid, rnandcn, head, ref createtime);
                List <dynamic> entities   = GetSmtInstance(file, head, ref djsj, ref slsj, ref zxsj, ref ajzt, ref qszt, ref djxl);
                string[]       entityName = GetBizDataSonNodeName(file).ToArray();
                int            index      = 0;
                foreach (var entity in entities)
                {
                    EntityManager em = new EntityManager();
                    em.Insert(entityName[index], "PID", false, entity);
                    index++;
                }
                mtd.DJSJ = djsj;
                mtd.SLSJ = slsj;
                mtd.ZXSJ = zxsj;
                mtd.AJZT = ajzt;
                mtd.QSZT = qszt;
                mtd.DJXL = djxl;
                //HOLIDAY holiday = hgr.Query("SELECT * FROM HOLIDAY WHERE TO_CHAR(DAY,'yyyyMMdd') = "+ today + "").FirstOrDefault();
                //if (holiday!=null)
                //{
                //    mtd.ISHOLIDAY = holiday.STATUS;
                //}
                if ("2".Equals(qszt) && slsj != null && zxsj != null)
                {
                    mtd.ISHOLIDAY = CompareDate((DateTime)slsj, (DateTime)zxsj, hgr)[0];
                    mtd.INTERVAL  = CompareDate((DateTime)slsj, (DateTime)zxsj, hgr)[1];
                    mtd.DVALUE    = CompareDate((DateTime)slsj, (DateTime)zxsj, hgr)[2];
                }
                else if (slsj != null && djsj != null)
                {
                    mtd.ISHOLIDAY = CompareDate((DateTime)slsj, (DateTime)djsj, hgr)[0];
                    mtd.INTERVAL  = CompareDate((DateTime)slsj, (DateTime)djsj, hgr)[1];
                    mtd.DVALUE    = CompareDate((DateTime)slsj, (DateTime)djsj, hgr)[2];
                }



                InsertMSGTIMERECORD(pid, mtd, head);
            }
            else
            {
                //根据JK库报文状态,实时更新。
                MSGTIMERECORD msgtd = mdr.Query("select * from MSGTIMERECORD WHERE BDCDYH ='" + head.PreEstateNum + "'and ywh = '" + head.RecFlowID + "' and to_char(CREATETIME,'yyyyMMddhhmiss') = '" + today + "'").ToList().FirstOrDefault();
                if (msgtd != null)
                {
                    msgtd.UPSTATUS = mtd.UPSTATUS;
                    UpdateMSGTIMERECORD(msgtd);
                }
            }
        }