private void CheckWBInBDC(DataTable dt, Action <DataRow, string, string> Write, string pch) { string sql = @"Select ContractBuyer.HouseId,ContractBuyer.BuyerName,PledgeSate,houseState, SaleItemInfo.ItemName+BuildingInfo.BuildingName+'-'+HouseInfo.UnitNo+'-'+HouseInfo.HouseNo as zl from ContractBuyer left join ContractSign on ContractBuyer.ContractId=ContractSign.ContractId left join HouseInfo on ContractSign.HouseInfoID =HouseInfo.HouseId left join BuildingInfo on HouseInfo.buildingid=BuildingInfo.BuildingInfo_ID left join SaleItemInfo on BuildingInfo.SaleItemID=SaleItemInfo.SaleItemID where ContractBuyer.HouseId='{0}' and ContractSign.flag<>2"; SQLDBHelper db = SQLDBHelper.CreateInstance(); if (dt != null && dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { DataTable wbdt = db.GetTable(string.Format(sql, dt.Rows[i]["HouseId"].ToString())); if (wbdt != null && wbdt.Rows.Count > 0) { if (!wbdt.Rows[0]["BuyerName"].ToString().Equals(dt.Rows[i]["QLR"])) { Write(dt.Rows[i], "网备中的网签人和查封登记被执行人不一致", pch); } } } } }
//数据准备 ------可销售的房屋的抵押状态一定要对到 private DataTable CheckDataParper() { string sql = @"Select Houseid,PledgeSate,houseState, SaleItemInfo.ItemName+BuildingInfo.BuildingName+'-'+HouseInfo.UnitNo+'-'+HouseInfo.HouseNo as zl from HouseInfo left join BuildingInfo on HouseInfo.buildingid=BuildingInfo.BuildingInfo_ID left join SaleItemInfo on BuildingInfo.SaleItemID=SaleItemInfo.SaleItemID where HouseState='可销售'"; SQLDBHelper db = SQLDBHelper.CreateInstance(); return(db.GetTable(sql)); }
/// <summary> /// 数据准备 /// </summary> private DataTable CheckDataParper() { string sql = @"select distinct HouseId,HouseState, SaleItemInfo.ItemName+BuildingInfo.BuildingName+'-'+HouseInfo.UnitNo+'-'+HouseInfo.HouseNo as zl from HouseInfo left join BuildingInfo on HouseInfo.buildingid=BuildingInfo.BuildingInfo_ID left join SaleItemInfo on BuildingInfo.SaleItemID=SaleItemInfo.SaleItemID order by houseState "; SQLDBHelper dbhelper = SQLDBHelper.CreateInstance(); DataTable dt = dbhelper.GetTable(sql); return(dt); }