Esempio n. 1
0
        public static void Insert(ArchiveIndex archiveIndex, List <VolEleArc> volEleArc, HouseInfo houseInfo, List <Person> persons, Certificate certificate, HouseArchiveRelation houseArchiveRelation, PropArchiveRelation propArchiveRelation, List <VolEleArcDtl> volEleArcDtl)
        {
            using (TransactionScope ts = new TransactionScope())
            {
                Insert_ArchiveIndex(archiveIndex);
                foreach (VolEleArc item in volEleArc)
                {
                    Insert_VolEleArc(item);
                }

                Insert_HouseInfo(houseInfo);
                foreach (Person person in persons)
                {
                    Insert_Person(person);
                }

                Insert_Certificate(certificate);
                Insert_HouseArchiveRelation(houseArchiveRelation);
                Insert_PropArchiveRelation(propArchiveRelation);

                if (null != volEleArcDtl)
                {
                    foreach (VolEleArcDtl v in volEleArcDtl)
                    {
                        Insert_VolEleArcDtl(v);
                    }
                }

                //trans.Commit();
                ts.Complete();
            }
        }
Esempio n. 2
0
        private static PropArchiveRelation GetPropArchiveRelation(ArchiveIndex archiveIndex, Certificate certificate)
        {
            PropArchiveRelation propArchiveRelation = new PropArchiveRelation();

            propArchiveRelation.RelationID    = CreateGuid(32);
            propArchiveRelation.ArchiveId     = archiveIndex.ArchiveId;
            propArchiveRelation.CertificateID = certificate.CertificateID;

            return(propArchiveRelation);
        }
Esempio n. 3
0
        private static HouseArchiveRelation GetHouseArchiveRelation(ArchiveIndex archiveIndex, HouseInfo houseInfo)
        {
            HouseArchiveRelation houseArchiveRelation = new HouseArchiveRelation();

            houseArchiveRelation.RelationID   = CreateGuid(32);
            houseArchiveRelation.ArchiveId    = archiveIndex.ArchiveId;
            houseArchiveRelation.HouseInfo_ID = houseInfo.HouseInfo_ID;

            return(houseArchiveRelation);
        }
Esempio n. 4
0
        private static Certificate GetCertificate(ArchiveIndex archiveIndex, HouseInfo houseInfo, PageParams pageParams)
        {
            //GetDJB(pageParams.PrjId);



            Certificate cer = new Certificate();

            cer.ArchiveId       = archiveIndex.ArchiveId;
            cer.CertificateID   = CreateGuid(32);
            cer.HouseInfo_ID    = houseInfo.HouseInfo_ID;
            cer.Prop            = GetBDCZH(pageParams.PrjId);
            cer.CertificateType = GetCertificateType(cer.Prop);

            return(cer);
        }
Esempio n. 5
0
        private void Insert(ArchiveIndex archiveInfo)
        {
            string             sql  = "insert into ArchiveIndex(ArchiveId,ArchiveType,BusiNO,IsHistoray,ArchiveDate,Source,ReqType,HousePropertyType,FmBusiNo,IsOld) values(@ArchiveId,@ArchiveType,@BusiNO,@IsHistoray,@ArchiveDate,@Source,@ReqType,@HousePropertyType,@FmBusiNo,@IsOld)";
            List <DbParameter> list = new List <DbParameter>();

            ListAdd(list, "@ArchiveId", archiveInfo.ArchiveId);
            ListAdd(list, "@ArchiveType", archiveInfo.ArchiveType);
            ListAdd(list, "@BusiNO", archiveInfo.BusiNO);
            ListAdd(list, "@IsHistoray", archiveInfo.IsHistoray);
            ListAdd(list, "@ArchiveDate", archiveInfo.ArchiveDate);

            ListAdd(list, "@Source", archiveInfo.Source);
            ListAdd(list, "@ReqType", archiveInfo.ReqType);
            ListAdd(list, "@HousePropertyType", archiveInfo.HousePropertyType);
            ListAdd(list, "@FmBusiNo", archiveInfo.FmBusiNo);
            ListAdd(list, "@IsOld", archiveInfo.IsOld);

            int i = dbHelper.ExecuteNonQuery(MyDBType.Sql, trans, System.Data.CommandType.Text, sql, list.ToArray());
        }
Esempio n. 6
0
        private static ArchiveIndex GetArchiveIndex(PageParams pageParams)
        {
            DJ_XGDJGL xgdjgl = GetXGDJGL(pageParams.PrjId);
            DJ_TSGL   tsgl   = GetTSGL(pageParams.PrjId);

            ArchiveIndex archiveIndex = new ArchiveIndex();

            archiveIndex.ArchiveId = CreateGuid(32);
            //archiveIndex.DaCode = archiveIndex.ArchiveId.ToString();
            archiveIndex.ArchiveType = GetArchiveType(tsgl.DJZL);
            archiveIndex.BusiNO      = pageParams.PrjId;
            archiveIndex.IsHistoray  = GetHistry(tsgl.LIFECYCLE);
            archiveIndex.ArchiveDate = DateTime.Now.ToString("yyyy-MM-dd").Replace("-", "");
            archiveIndex.ReqType     = tsgl.DJZL;
            if (null != xgdjgl)
            {
                archiveIndex.FmBusiNo = xgdjgl.FSLBH;
            }
            return(archiveIndex);
        }
Esempio n. 7
0
        public static int Insert_ArchiveIndex(ArchiveIndex archiveIndex)
        {
            string             sql  = "insert into ArchiveIndex(ArchiveId,ArchiveType,BusiNO,IsHistoray,ArchiveDate,Source,ReqType,HousePropertyType,FmBusiNo) values(@ArchiveId,@ArchiveType,@BusiNO,@IsHistoray,@ArchiveDate,@Source,@ReqType,@HousePropertyType,@FmBusiNo)";
            List <DbParameter> list = new List <DbParameter>();

            ListAdd(list, "@ArchiveId", archiveIndex.ArchiveId);
            //list.Add(new SqlParameter);
            //ListAdd(list,"@DaCode", archiveIndex.DaCode);
            ListAdd(list, "@ArchiveType", archiveIndex.ArchiveType);
            ListAdd(list, "@BusiNO", archiveIndex.BusiNO);
            ListAdd(list, "@IsHistoray", archiveIndex.IsHistoray);
            ListAdd(list, "@ArchiveDate", archiveIndex.ArchiveDate);

            ListAdd(list, "@Source", archiveIndex.Source);
            ListAdd(list, "@ReqType", archiveIndex.ReqType);
            ListAdd(list, "@HousePropertyType", archiveIndex.HousePropertyType);
            ListAdd(list, "@FmBusiNo", archiveIndex.FmBusiNo);

            DbHelper.SetProvider(MyDBType.Sql);
            return(DbHelper.ExecuteNonQuery(MyDBType.Sql, System.Data.CommandType.Text, sql, list.ToArray()));
        }
Esempio n. 8
0
        private static List <VolEleArc> GetVolEleArc(ArchiveIndex archiveIndex, PageParams pageParams)
        {
            List <VolEleArc> list = new List <VolEleArc>();

            List <WFM_ATTACHLST> wfm_ATTACHLST_list = GetWFM_ATTACHLST_list(pageParams);

            foreach (WFM_ATTACHLST doc in wfm_ATTACHLST_list)
            {
                if (doc.CNAME == "流程附件")
                {
                    continue;
                }
                VolEleArc volEleArc = new VolEleArc();
                volEleArc.ArchiveId    = archiveIndex.ArchiveId;
                volEleArc.EleArcVol_ID = CreateGuid(32);
                volEleArc.EleArcName   = doc.CNAME;
                list.Add(volEleArc);
            }


            return(list);
        }
Esempio n. 9
0
        private static List <Person> GetPerson(ArchiveIndex archiveIndex, PageParams pageParams)
        {
            List <Person> list = new List <Person>();

            List <DJ_QLR> qlr_list = GetQlr(pageParams.PrjId);

            if (null != qlr_list && qlr_list.Count > 0)
            {
                foreach (DJ_QLR qlr in qlr_list)
                {
                    Person person = new Person();
                    person.ArchiveId  = archiveIndex.ArchiveId;
                    person.PersonID   = CreateGuid(32);
                    person.PersonType = GetPersonType(qlr.QLRID, pageParams.PrjId);
                    person.Name       = qlr.QLRMC;
                    person.CardNO     = qlr.ZJHM;
                    person.Sex        = qlr.XB;
                    list.Add(person);
                }
            }

            return(list);
        }
        private void ArchiveIndices()
        {
            CreateDirectory(IndicesFolder);

            var archiveIndexPath = new FileInfo($@"{IndicesFolder}\{"archiveIndex.xml"}");
            var archiveIndex     = new ArchiveIndex(DataSource, archiveIndexPath, _fileIndex);

            archiveIndex.Persist();

            var contextDocumentationIndexPath = new FileInfo($@"{IndicesFolder}\{"contextDocumentationIndex.xml"}");
            var contextDocumentationIndex     = new ContextDocumentationIndex(DataSource.ContextDocuments, contextDocumentationIndexPath, _fileIndex);

            contextDocumentationIndex.Persist();

            var tableIndexPath = new FileInfo($@"{IndicesFolder}\{"tableIndex.xml"}");

            _tableIndex = new TableIndex(DataSource, tableIndexPath, _fileIndex);
            _tableIndex.Persist();

            // TODO NiceToHave - Add and build docIndex if present
            //ArchiveEmbededResource("Schemas.standard.docIndex.xsd", new FileInfo(String.Format(@"{0}\{1}", SchemasStandardFolder, "docIndex.xsd")));

            _fileIndex.Persist();
        }
Esempio n. 11
0
        /// <summary>
        /// 插入产权处档案库
        /// </summary>
        /// <param name="pageParams"></param>
        /// <returns>1:插入成功;0:宗地业务;异常信息:失败</returns>
        public static BDCFilterResult Insert_FCDA(PageParams pageParams)
        {
            BDCFilterResult res = new BDCFilterResult();

            try
            {
                if (IsFW(pageParams.PrjId))
                {
                    if (CanPush(pageParams.PrjId))
                    {
                        ArchiveIndex archiveIndex = GetArchiveIndex(pageParams);

                        HouseInfo houseInfo = GetHouseInfo(pageParams);

                        Certificate certificate = GetCertificate(archiveIndex, houseInfo, pageParams);

                        List <Person> person_list = GetPerson(archiveIndex, pageParams);

                        List <VolEleArc> volEleArc = GetVolEleArc(archiveIndex, pageParams);
                        //List<VolEleArcDtl> volEleArcDtl_list = GetVolEleArcDtl(volEleArc, pageParams);

                        PropArchiveRelation  propArchiveRelation  = GetPropArchiveRelation(archiveIndex, certificate);
                        HouseArchiveRelation houseArchiveRelation = GetHouseArchiveRelation(archiveIndex, houseInfo);

                        FCDA_DAL.Insert(archiveIndex, volEleArc, houseInfo, person_list, certificate, houseArchiveRelation, propArchiveRelation, null);
                        res.ConfirmType = 0;
                        res.IsSuccess   = true;
                        res.Message     = "成功!业务已经成功推送!";
                    }
                    else
                    {
                        res.ConfirmType = 0;
                        res.IsSuccess   = false;
                        res.Message     = "失败!该业务已经推送!";
                    }
                }
                else
                {
                    res.ConfirmType = 0;
                    res.IsSuccess   = false;
                    res.Message     = "拒绝!未找到业务宗号或非房产业务,暂不推送";
                }
            }
            catch (Exception ex)
            {
                res.ConfirmType = 0;
                res.IsSuccess   = false;
                res.Message     = "失败!" + ex.Message;
            }
            FC_DA_TAG tag = new FC_DA_TAG();

            tag.ID        = Guid.NewGuid().ToString();
            tag.ISSUCCESS = res.IsSuccess?"1":"0";
            tag.MESSAGE   = res.Message;
            tag.PUSHDATE  = DateTime.Now;
            tag.PUSHUSER  = pageParams.UserName;
            tag.SLBH      = pageParams.PrjId;

            InsertLog(tag);
            return(res);
        }