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 GetFirstRegistedInfo(string HouseId) { string sql = string.Format(@"Select * from fc_djyz Where Upper(HouseId)='{0}'", HouseId.ToUpper()); return(OleDBHelper.GetDataSet(sql)); }
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 DataSet GetHouseState(string HouseID) { string sql = string.Format("select * from GetHouseState where \"HouseID\" ='{0}'", HouseID); DataSet ds = OleDBHelper.GetDataSet(sql); return(ds); }
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); }
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); }