private string GetTXRXM(string slbh, string djlx) { BDCExtendDal dal = new BDCExtendDal(); DataTable dt = null; if (djlx.Equals("权属")) {//返回权利人 dt = dal.GetQLRBySLBH(slbh); } else if (djlx.Equals("抵押"))//返回抵押人 { dt = dal.GetDYRBySLBH(slbh); } else { dt = dal.GetTZRXMBySLBH(slbh); } string r = string.Empty; if (dt != null && dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { if (!r.Contains(dt.Rows[i][0].ToString())) { r += " " + dt.Rows[i][0].ToString(); } } } return(r.Trim()); }
public int ResetUploadFileCreateTime(DateTime createTime, string slbh, string CID) { try { BDCExtendDal bDCExtendDal = new BDCExtendDal(); return(bDCExtendDal.ResetUploadFileCreateTime(createTime, slbh, CID)); } catch (Exception ex) { throw new Exception(ex.Message); } }
internal static BDCFilterResult CheckState(PageParams param) { BDCFilterResult res = new BDCFilterResult(); BDCExtendDal dal = new BDCExtendDal(); DataTable hs = dal.GetHousesBySLBH(param.PrjId); if (hs == null || hs.Rows.Count == 0) { return(new BDCFilterResult { IsSuccess = true }); } string resStr = string.Empty; if (hs.Rows.Count > 0) { foreach (DataRow h in hs.Rows) { string tmp = How2Check(h["TSTYBM"].ToString(), param.PrjId); if (!string.IsNullOrEmpty(tmp)) { resStr += h["ZL"].ToString() + "已存在" + tmp + "业务"; } } } if (string.IsNullOrEmpty(resStr)) { res.IsSuccess = true; } else { res.IsSuccess = false; res.Message = resStr; //res.ConfirmType = -1; } return(res); }
/// <summary> /// 获取网备中的权利人名称 /// </summary> /// <param name="houseId"></param> /// <returns></returns> private WBInfoForAHouse GetInfoInWB(string houseId) { WBInfoForAHouse mc = getQlrMCInWB(houseId); if (mc != null) { return(mc); } else { BDCExtendDal dal = new BDCExtendDal(); string ychouseid = dal.GetYCHouseIdBy(houseId); mc = getQlrMCInWB(houseId); if (mc != null) { return(mc); } else { string schouseid = dal.GetSCHouseIdBy(houseId); return(getQlrMCInWB(houseId)); } } }
private IList <string> GetDJHouses(string slbh) { BDCExtendDal dal = new BDCExtendDal(); return(dal.GetHouseIdsBySLBH(slbh)); }
/// <summary> /// /// </summary> /// <param name="slbh"></param> /// <returns>0,权属,1,抵押,2,预告,3,查封</returns> private string getDJLXBySLBH(string slbh) { BDCExtendDal dal = new BDCExtendDal(); return(dal.GetDJLX(slbh)); }