public static void InsertPIC(string p) { DataTable dt = FCDA_DAL.GetVolEleArcDtlByVolEleArcID(p); int i = 1; string dir = "10000-450000/110000/100001/"; FTP souFTp = new FTP() { hostname = ConfigurationManager.AppSettings["FCFtpIP"], username = ConfigurationManager.AppSettings["FCFtpUser"], password = ConfigurationManager.AppSettings["FCFtpPWD"] }; List <string> list = FTPHelper.ListDirectory(dir, souFTp, ""); foreach (DataRow row in dt.Rows) { string s = row[0].ToString(); VolEleArcDtl v = new VolEleArcDtl(); v.VolEleArcDtl_id = Guid.NewGuid(); v.VolEleArc_ID = new Guid(s); v.imgName = dir + list[i - 1]; FCDA_DAL.Insert_VolEleArcDtl(v); i++; } }
private void MyDeleteRecode(string slbh) { DataTable dt = FCDA_DAL.GetDeleteInfo(slbh); if (null != dt && dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { string busino = row["busino"].ToString(); Guid ArchiveId = new Guid(row["ArchiveId"].ToString()); FCDA_DAL.deleteRecode(busino, ArchiveId); } } }
private DataTable GetAllFailWB() { return(FCDA_DAL.GetAllFailWB()); }
/// <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); }
private static bool CanPush(string slbh) { return(FCDA_DAL.CanPust(slbh)); }