public DataSet GetPrprtcertInfo(string HouseID, string Area) { string sql = string.Format(@"select * from GetPrprtcertInfo where houseid='{0}'", HouseID); DataSet ds = OleDBHelper.GetDataSet(sql); return(ds); }
public NewDataSet GetNewDataSet(string name, string cardNo) { string sql = string.Format("Select * from FC_Da_FWZM Where Name='{0}' and CardNo='{1}'", name, cardNo); DataSet ds = OleDBHelper.GetDataSet(sql); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { IList <Table> tables = new List <Table>(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { Table t = new Table(); t.ProveResultID = ds.Tables[0].Rows[i]["ProveResultID"].ToString(); t.BusiID = ds.Tables[0].Rows[i]["BusiID"].ToString(); t.CardNo = ds.Tables[0].Rows[i]["CardNo"].ToString(); t.Name = ds.Tables[0].Rows[i]["Name"].ToString(); t.HouseSite = ds.Tables[0].Rows[i]["HouseSite"].ToString(); t.Source = ds.Tables[0].Rows[i]["Source"].ToString(); t.SourceDes = ds.Tables[0].Rows[i]["SourceDes"].ToString(); t.Area = ds.Tables[0].Rows[i]["Area"].ToString(); t.RightNo = ds.Tables[0].Rows[i]["RightNo"].ToString(); tables.Add(t); } NewDataSet set1 = new NewDataSet(); set1.Tables = tables.ToArray(); return(set1); } else { return(null); } }
public DataSet GetBuildRightInfo(string BuNo, string Area) { string sql = string.Format("select \"HouseID\",\"HCSID\",\"HYCID\",\"BuildingID\",\"RoomNo\",\"权证号\",\"登记坐落\",\"登记用途\" from BuildingRightInfo where BuNo ='{0}'", BuNo); DataSet ds = OleDBHelper.GetDataSet(sql); return(ds); }
internal DataTable getREInfoFromBDC(string strHouseSite, string strCertCode) { string sql = @"select h.tstybm as HID,tsgl.bdcdyh,h.zl,h.jzmj,ghyt.ytmc as ghyt,fwjg.itemname as fwjg from dj_dy dy left join dj_tsgl tsgl on tsgl.slbh = dy.slbh left join fc_h_qsdc h on h.tstybm = tsgl.tstybm left join fc_z_qsdc z on z.tstybm = h.lsztybm left join dic_item @xzbdcggk fwjg on fwjg.itemval = z.fwjg and fwjg.diccode = '1505181711115COR1KAPMB' left join DIC_FWYTLX @Xzbdcggk ghyt on ghyt.ytbm = h.ghyt where 1=1 "; if (!string.IsNullOrEmpty(strHouseSite)) { sql += string.Format(" and h.zl like '%{0}%'", strHouseSite); } if (!string.IsNullOrEmpty(strCertCode)) { sql += string.Format("and dy.bdczmh = '{0}'", strCertCode); } if (IsHasSQLInject(sql)) { return(null); } return(OleDBHelper.GetDataTable(sql)); }
public DataTable GetDYOpList(string strKeyWord, string sDate, string eDate, string strTXCertCode) { string sql = @"select dy.slbh 抵押业务宗号,dy.djyy 他项权利种类,h.qm 区名,z.fwzl 坐落,h.zl 坐落细则,dy.bdbzzqse 权利价值,dy.qlqssj 抵押起始日期,dy.qljssj 抵押结束日期,dy.bdczmh 他项权证号,dy.fj 他项权证附记,DECODE(dy.lifecycle,1,'已注销','现势') 注销状态 from dj_dy dy left join dj_tsgl tsgl on dy.slbh = tsgl.slbh left join fc_h_qsdc h on h.tstybm = tsgl.tstybm left join fc_z_qsdc z on z.tstybm = h.lsztybm where dy.qlqssj between to_date('{1}', 'yyyy/mm/dd hh24:mi:ss') and to_date('{2}','yyyy/mm/dd hh24:mi:ss') and dy.slbh in (select qlrgl.slbh from dj_qlrgl qlrgl left join dj_qlr qlr on qlr.qlrid = qlrgl.qlrid where qlr.qlrmc like '%{0}%' and qlrgl.qlrlx='抵押权人') and tsgl.bdclx='房屋' {3} group by dy.slbh,dy.djyy,h.qm,z.xmmc,z.fwzl,h.zl,dy.bdbzzqse,dy.qlqssj,dy.qljssj,dy.bdczmh,dy.fj,dy.lifecycle"; string where1 = ""; if (!string.IsNullOrEmpty(strTXCertCode)) { where1 = string.Format("and dy.bdczmh='{0}'", strTXCertCode); } sql = string.Format(sql, strKeyWord, sDate, eDate, where1); try { if (IsHasSQLInject(sql)) { return(null); } return(OleDBHelper.GetDataTable(sql)); } catch (Exception ex) { string str = ex.Message; return(null); } }
public DataSet GetHouseState(string HouseID) { string sql = string.Format("select * from GetHouseState where \"HouseID\" ='{0}'", HouseID); DataSet ds = OleDBHelper.GetDataSet(sql); return(ds); }
internal DataTable GetDYFormBDC(string slbh) { // string sql = @"select qlrgl.qlrmc 权利人,'房屋所有权' 权利种类,dj_dy.bdczmh 他项权证号,fc_h_qsdc.zh 幢号,fc_h_qsdc.dyh||'-'||fc_h_qsdc.fjh 房号,fc_h_qsdc.jzmj 建筑面积, //dj_dy.qlqssj 设定日期,dj_dy.bdbzzqse 权利价值,dj_dy.pgje 评估值,dj_dy.dyqx 约定期限, dj_dy.djyy 他项种类,dj_xgdjzx.djrq 注销日 //from dj_dy left join dj_tsgl on dj_dy.slbh=dj_tsgl.slbh left join fc_h_qsdc on fc_h_qsdc.tstybm=dj_tsgl.tstybm //left join dj_xgdjzx on dj_xgdjzx.slbh=dj_xgdjgl.zslbh //left join dj_xgdjgl on dj_xgdjgl.zslbh=dj_dy.slbh //left join dj_djb djb on djb.slbh=dj_xgdjgl.fslbh //left join dj_qlrgl qlrgl on qlrgl.slbh=dj_dy.slbh //left join ql_fwxg fwxg on fwxg.slbh=dj_dy.slbh //Where dj_dy.slbh ='{0}' and qlrgl.qlrlx='抵押权人' and dj_tsgl.bdclx='房屋' "; string sql = @"select A.*,dj_xgdjzx.Djrq 注销日期,'' as 注销原因 from ( select dj_dy.slbh, qlrgl.qlrmc 权利人,'房屋所有权' 权利种类,dj_dy.bdczmh 他项权证号,fc_h_qsdc.zh 幢号,fc_h_qsdc.dyh||'-'||fc_h_qsdc.fjh 房号,fc_h_qsdc.jzmj 建筑面积, dj_dy.qlqssj 设定日期,dj_dy.bdbzzqse 权利价值,dj_dy.pgje 评估值,dj_dy.dyqx 约定期限, dj_dy.djyy 他项种类 from dj_dy left join dj_xgdjgl gl on gl.zslbh=dj_dy.slbh left join dj_djb djb on djb.slbh=gl.fslbh left join dj_qlrgl qlrgl on qlrgl.slbh=dj_dy.slbh left join ql_fwxg fwxg on fwxg.slbh=dj_dy.slbh left join dj_tsgl on dj_dy.slbh=dj_tsgl.slbh left join fc_h_qsdc on fc_h_qsdc.tstybm=dj_tsgl.tstybm Where djb.slbh ='{0}' and qlrgl.qlrlx='抵押权人' and dj_tsgl.bdclx='房屋' ) A left join dj_xgdjgl on dj_xgdjgl.fslbh=A.slbh left join dj_xgdjzx on dj_xgdjzx.slbh=dj_xgdjgl.zslbh"; sql = string.Format(sql, slbh); if (IsHasSQLInject(sql)) { return(null); } return(OleDBHelper.GetDataTable(sql)); }
public DataSet GetFirstRegistedInfo(string HouseId) { string sql = string.Format(@"Select * from fc_djyz Where Upper(HouseId)='{0}'", HouseId.ToUpper()); return(OleDBHelper.GetDataSet(sql)); }
internal DataTable GetQSInfoListFromBDC(string bdczh, string qlrmc, string zjhm, string zl) { string sql = @"select distinct djb.slbh 业务ID,djb.slbh 自然状况登记簿ID,nvl(nvl(h.oracle_wb_houseid,h.oracle_houseinfo_id),h.tstybm) 房屋ID,djb.slbh 业务宗号,h.zl 房屋坐落,djb.djlx 登记类型,djb.djyy 业务种类,djb.bdczh 证号, djb.djrq 登簿时间,2 as 状态 from dj_djb djb left join dj_tsgl tsgl on tsgl.slbh=djb.slbh left join fc_h_qsdc h on h.tstybm=tsgl.tstybm left join fc_h_qsdc h on h.tstybm=tsgl.tstybm left join dj_qlrgl gl on gl.slbh=djb.slbh left join dj_qlr qlr on gl.qlrid=qlr.qlrid where gl.qlrlx='权利人' and tsgl.bdclx='房屋' and (djb.lifecycle=0 or djb.lifecycle is null) "; if (!string.IsNullOrEmpty(bdczh)) { sql += string.Format(" and djb.bdczh='{0}'", bdczh); } if (!string.IsNullOrEmpty(qlrmc)) { sql += string.Format(" and gl.qlrmc='{0}'", qlrmc); } if (!string.IsNullOrEmpty(zjhm)) { sql += string.Format(" and qlr.zjhm='{0}'", zjhm); } if (!string.IsNullOrEmpty(zl)) { sql += string.Format(" and h.zl like '%{0}%'", zl); } if (IsHasSQLInject(sql)) { return(null); } return(OleDBHelper.GetDataTable(sql)); }
/// <summary> /// 领证信息收费发证信息 /// </summary> /// <param name="ywzh"></param> /// <returns></returns> public DataTable GetCLF_LZXX_SFFZ(string ywzh) { string sql = string.Format(@"select State,FZState from CLF_LZXX_SFXX where ywzh='{0}'", ywzh); DataTable dt = OleDBHelper.GetDataTable(sql); DataTable dtCopy = dt.Copy(); dtCopy.TableName = "SFFZXX"; return(dtCopy); }
public DataTable GetCLF_CFXX(string ywzh) { string sql = string.Format("select * from CLF_CFXX where ywzh ='{0}'", ywzh); DataTable dt = OleDBHelper.GetDataTable(sql); DataTable dtCopy = dt.Copy(); dtCopy.TableName = "houseChaFenInfo"; return(dtCopy); }
public DataTable GetCLF_ZTXX(string ywzh) { string sql = string.Format("select * from CLF_ZTXX where YWZH='{0}'", ywzh); DataTable dt = OleDBHelper.GetDataTable(sql); DataTable dtCopy = dt.Copy(); dtCopy.TableName = "HouseOwnerInfo"; return(dtCopy); }
public DataTable GetCLF_ZTXX(string syqr, string qzbh) { string sql = string.Format("select * from CLF_ZTXX where syqr ='{0}' and QZBH like '%{1}%'", syqr, qzbh); DataTable dt = OleDBHelper.GetDataTable(sql); DataTable dtCopy = dt.Copy(); dtCopy.TableName = "HouseOwnerInfo"; return(dtCopy); }
public bool GetIsRegistedHouse(string HouseId) { string sql = string.Format(@"Select Count(1) From DJ_TSGL Left Join FC_H_QSDC on DJ_TSGL.TSTYBM=FC_H_QSDC.TSTYBM Where Nvl2(DJ_TSGL.LifeCycle,DJ_TSGL.LifeCycle,0)=0 And FC_H_QSDC.TSTYBM='{0}'", HouseId); int rowCount = OleDBHelper.GetScalar(sql); return(true); }
public DataTable GetCLF_LZXX_QTXX(string ywzh) { string sql = string.Format(@"select PrintState,SFState,FZState,DYQZBH from CLF_LZXX_DYXX where ywzh='{0}'", ywzh); DataTable dt = OleDBHelper.GetDataTable(sql); DataTable dtCopy = dt.Copy(); dtCopy.TableName = "QTXX"; return(dtCopy); }
internal DataTable GetQLRByFSLBH(string slbh) { string sql = @"select distinct qlr.qlrmc from dj_qlr qlr left join dj_qlrgl qlrgl on qlrgl.qlrid=qlr.qlrid left join dj_xgdjgl djgl on djgl.fslbh=qlrgl.slbh where djgl.zslbh='{0}' and qlrgl.qlrlx='权利人'"; sql = string.Format(sql, slbh); return(OleDBHelper.GetDataTable(sql)); }
/// <summary> /// 领证信息权证编号信息 /// </summary> /// <param name="ywzh"></param> /// <returns></returns> public DataTable GetCLF_LZXX_QZBH(string ywzh) { // string sql = string.Format(@"select DJB.BDCZH AS QZBH FROM (SELECT * FROM dj_xgdjgl WHERE BGLX='房屋变更') xgdjgl //left join dj_djb djb on xgdjgl.zslbh=djb.slbh where xgdjgl.fslbh='{0}'", ywzh); string sql = string.Format("select * from CLF_LZXX_QZBH where ywzh='{0}'", ywzh); DataTable dt = OleDBHelper.GetDataTable(sql); DataTable dtCopy = dt.Copy(); dtCopy.TableName = "FZXX"; return(dtCopy); }
public DataSet GetRegistesByHouseId(string HouseId) { string sql = string.Format(@"Select '权属' as RegistType,Count(1) as Times from DJ_TSGL Left join FC_H_QSDC on DJ_TSGL.TSTYBM=FC_H_QSDC.TSTYBM Where (DJ_TSGL.TSTYBM='{0}' or HSCID='{0}' or HYCID='{0}') and nvl2(DJ_TSGL.Lifecycle,DJ_TSGL.Lifecycle,0)=0 and exists(Select 1 from DJ_DJB where DJ_TSGL.SLBH=DJ_DJB.SLBH) union all Select '抵押' as RegistType,Count(1) as Times from DJ_TSGL Left join FC_H_QSDC on DJ_TSGL.TSTYBM=FC_H_QSDC.TSTYBM Where (DJ_TSGL.TSTYBM='{0}' or HSCID='{0}' or HYCID='{0}') and nvl2(DJ_TSGL.Lifecycle,DJ_TSGL.Lifecycle,0)=0 and exists(Select 1 from DJ_Dy where DJ_TSGL.SLBH=DJ_Dy.SLBH) union all Select '预告' as RegistType,Count(1) as Times from DJ_TSGL Left join FC_H_QSDC on DJ_TSGL.TSTYBM=FC_H_QSDC.TSTYBM Where (DJ_TSGL.TSTYBM='{0}' or HSCID='{0}' or HYCID='{0}') and nvl2(DJ_TSGL.Lifecycle,DJ_TSGL.Lifecycle,0)=0 and exists(Select 1 from DJ_YG where DJ_TSGL.SLBH=DJ_YG.SLBH) union all Select '查封' as RegistType,Count(1) as Times from DJ_TSGL Left join FC_H_QSDC on DJ_TSGL.TSTYBM=FC_H_QSDC.TSTYBM Where (DJ_TSGL.TSTYBM='{0}' or HSCID='{0}' or HYCID='{0}') and nvl2(DJ_TSGL.Lifecycle,DJ_TSGL.Lifecycle,0)=0 and exists(Select 1 from DJ_CF where DJ_TSGL.SLBH=DJ_CF.SLBH) ", HouseId); DataSet ds = OleDBHelper.GetDataSet(sql); return(ds); }
internal DataTable getBDCDYH(string zid) { string sql = @"select tstybm as 不动产户ID,bdcdyh as 不动产单元号,zl as 坐落,ycjzmj as 预测建筑面积,yctnjzmj as 预测套内面积,jzmj as 实测建筑面积,tnjzmj as 实测套内面积,HSCID as 原实测ID,FJBM as 房间编码 from fc_h_qsdc where lsztybm = '{0}' "; sql = string.Format(sql, zid); if (IsHasSQLInject(sql)) { return(null); } return(OleDBHelper.GetDataTable(sql)); }
internal DataTable GetQLRFromBDC(string slbh) { string sql = @"select qlrgl.qlrlx 权利人类型,qlr.qlrmc 权利人姓名,qlr.zjlb 证件类型,qlr.zjhm 证件号码,qlr.dz 联系地址,qlr.dh 联系电话,qlrgl.gyfe 份额,qlr.frdbxm 法定代表人 from dj_qlr qlr left join dj_qlrgl qlrgl on qlrgl.qlrid=qlr.qlrid where qlrgl.slbh='{0}'"; sql = string.Format(sql, slbh); if (IsHasSQLInject(sql)) { return(null); } return(OleDBHelper.GetDataTable(sql)); }
internal DataTable getCFFromBDC(string hid) { string sql = @"SELECT DISTINCT ''被执行人,cfjg 执行人,cffw 执行项目,DJSJ 查封日期,NVL(CFQX,decode (ceil(TO_CHAR(CFJSSJ-CFQSSJ)/365),1,'1',2,'2',3,'3',null)) 查封期限,BGRQ 解封录入日期,''备注 ,CFYY 查封信息, DJ_XGDJZX.DJYY 解封信息 FROM DJ_CF left join dj_XGDJGL ON DJ_CF.SLBH=DJ_XGDJGL.FSLBH LEFT JOIN DJ_XGDJZX ON DJ_XGDJGL.ZSLBH=DJ_XGDJZX.SLBH left join dj_tsgl tsgl on tsgl.slbh=dj_cf.slbh left join fc_h_qsdc h on h.tstybm=tsgl.tstybm Where h.tstybm = '{0}' or h.oracle_houseinfo_id = '{0}' or h.oracle_wb_houseid = '{0}' and tsgl.bdclx='房屋' "; sql = string.Format(sql, hid); if (IsHasSQLInject(sql)) { return(null); } return(OleDBHelper.GetDataTable(sql)); }
internal DataTable GetQLRMCBySLBH(string slbh, string IsDYQR) { string qlrlx = IsDYQR;//? "抵押权人" : "抵押人"; string sql = @"select qlr.qlrmc from dj_qlr qlr left join dj_qlrgl qlrgl on qlrgl.qlrid = qlr.qlrid where qlrgl.slbh = '{0}' and qlrgl.qlrlx = '{1}'"; sql = string.Format(sql, slbh, qlrlx); if (IsHasSQLInject(sql)) { return(null); } return(OleDBHelper.GetDataTable(sql)); }
internal DataTable GetDYBDCDYH(string slbh) { string sql = @"select tsgl.bdcdyh from dj_dy dy left join dj_tsgl tsgl on tsgl.slbh = dy.slbh left join fc_h_qsdc h on tsgl.tstybm = h.tstybm where dy.slbh = '{0}' "; sql = string.Format(sql, slbh); if (IsHasSQLInject(sql)) { return(null); } return(OleDBHelper.GetDataTable(sql)); }
internal DataTable GetCFInfoFromBDC(string hoID) { string sql = @"select cf.cfjg 执行法院,cf.cfwh 协助执行书号,cf.cfqssj 查封日期,NVL(cf.CFQX,decode (ceil(TO_CHAR(cf.CFJSSJ-cf.CFQSSJ)/365),1,'1',2,'2',3,'3',null)) 查封期限,cf.cfyy 查封原因 from dj_cf cf left join dj_tsgl tsgl on cf.slbh = tsgl.slbh left join fc_h_qsdc h on h.tstybm = tsgl.tstybm where h.tstybm = '{0}' or h.ORACLE_HOUSEINFO_ID = '{0}' or h.ORACLE_WB_HOUSEID = '{0}' and tsgl.bdclx='房屋'"; sql = string.Format(sql, hoID); if (IsHasSQLInject(sql)) { return(null); } return(OleDBHelper.GetDataTable(sql)); }
internal DataTable GetQLRZJHMBySLBH(string slbh, string isDyqr) { string sql = @"select qlr.zjhm from dj_djb djb left join dj_qlrgl gl on gl.slbh=djb.slbh left join dj_qlr qlr on qlr.qlrid=gl.qlrid where djb.slbh='{0}' and gl.qlrlx='{1}'"; sql = string.Format(sql, slbh, isDyqr); if (IsHasSQLInject(sql)) { return(null); } return(OleDBHelper.GetDataTable(sql)); }
internal DataTable GetFZFromBDC(string hID) { string sql = @"select z.fwzl 项目坐落,z.xmmc 项目名称,z.jzwmc 楼盘名称,h.dyh 单元号,h.fjh 房间号,h.jzmj 建筑面积,fwjg.itemname 结构,ghyt.ytmc 用途,z.jcnf 建成年代,z.zcs 总层数,h.sjc 所在层数,h.bdcdyh as 不动产单元号,nvl(h.FTTDMJ,h.DYTDMJ) as 土地面积 ,'' as 土地取得方式 from fc_h_qsdc h left join fc_z_qsdc z on h.lsztybm = z.tstybm left join dic_item@xzbdcggk fwjg on fwjg.itemval=z.fwjg and fwjg.diccode='1505181711115COR1KAPMB' left join DIC_FWYTLX@Xzbdcggk ghyt on ghyt.ytbm=h.ghyt where h.tstybm = '{0}' or h.oracle_houseinfo_id = '{0}' or h.oracle_wb_houseid = '{0}'"; sql = string.Format(sql, hID); if (IsHasSQLInject(sql)) { return(null); } return(OleDBHelper.GetDataTable(sql)); }
internal DataTable GetDYZL(string slbh) { // string sql = @"select h.zl from dj_dy dy //left join dj_tsgl tsgl on tsgl.slbh = dy.slbh //left join fc_h_qsdc h on tsgl.tstybm = h.tstybm //where dy.slbh = '{0}' "; string sql = @"select sjd.zl from dj_sjd sjd where sjd.slbh='{0}'"; sql = string.Format(sql, slbh); if (IsHasSQLInject(sql)) { return(null); } return(OleDBHelper.GetDataTable(sql)); }
/// <summary> /// 根据buildingId检查这个一栋房子是否有房屋做过登记 /// </summary> /// <param name="buildingId"></param> /// <returns>true 表示做过登记</returns> public bool GetIsRegistedBuilding(string buildingId) { //string sql = string.Format("select count(1) from dj_tsgl gl left join fc_h_qsdc h on gl.tstybm=h.tstybm where h.lsztybm='{0}'", buildingId); //string sql2= string.Format("select count(1) from dj_tsgl gl left join fc_z_qsdc z on gl.tstybm=z.tstybm where z.tstybm='{0}'", buildingId); //int rowCount = OleDBHelper.GetScalar(sql); //if (rowCount == 0) //{ // int ret2= OleDBHelper.GetScalar(sql2); // return ret2>0; //} string sql = string.Format(@"Select Count(1) From DJ_TSGL Left Join FC_H_QSDC on DJ_TSGL.TSTYBM=FC_H_QSDC.TSTYBM Left Join FC_Z_QSDC on FC_H_QSDC.LSZTYBM=FC_Z_QSDC.TSTYBM Where Nvl2(DJ_TSGL.LifeCycle,DJ_TSGL.LifeCycle,0)=0 And FC_Z_QSDC.TSTYBM='{0}'", buildingId); int rowCount = OleDBHelper.GetScalar(sql); return(true); }
internal DataTable GetQSInfoFromBDC(string slbh) { string sql = @"select djb.slbh 业务ID,djb.slbh 自然状况登记簿ID,nvl(nvl(h.oracle_wb_houseid,h.oracle_houseinfo_id),h.tstybm) 房屋ID,djb.slbh 业务宗号,2 as 状态,qm.qm 行政区,fwytlx.ytmc 产别,'' as 来源,h.zl 房屋坐落, item.itemname 共有性质,djb.djlx 登记类型,djb.djyy 业务种类,djb.bdczh 所有权证号,djb.zsxlh 证书印刷号,djb.djrq 登簿时间 from dj_djb djb left join dj_tsgl tsgl on tsgl.slbh = djb.slbh left join fc_h_qsdc h on h.tstybm = tsgl.tstybm left join dic_fwytlx@xzbdcggk fwytlx on fwytlx.ytbm=h.Ghyt LEFT JOIN dic_item@xzbdcggk item on item.itemval=djb.gyfs and item.diccode='150106151438XH6KL22QEP' left join fc_qm qm on qm.id=h.qm where djb.slbh = '{0}' and tsgl.bdclx='房屋' "; sql = string.Format(sql, slbh); if (IsHasSQLInject(sql)) { return(null); } return(OleDBHelper.GetDataTable(sql)); }
internal DataTable getCertInfoFromBDC(string strBusNo, string stringstrCertCode) { string sql = @"select slbh 抵押业务宗号, bdczmh 不动产证明号,'苏' 不动产证明省份,'徐州市' 不动产证明市级,FZND 不动产证明年份,bdczmh 不动产证明序号,'抵押权' as 证明权利或事项,qt 其他,fj 附记,djrq 登簿日期,zsxlh 证书印刷号,DYLX AS LX,BDCDJ.f_ParseDic('预告登记种类',YGDJZL) AS YGDJZL from dj_dy where 1=1 "; if (!string.IsNullOrEmpty(strBusNo)) { sql += string.Format(" and dj_dy.slbh = '{0}'", strBusNo); } if (!string.IsNullOrEmpty(stringstrCertCode)) { sql += string.Format(" and bdczmh = '{0}'", stringstrCertCode); } if (IsHasSQLInject(sql)) { return(null); } return(OleDBHelper.GetDataTable(sql)); }