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);
}
}
}
}
}
//单例实例化DBHelper 节约内存
public static SQLDBHelper CreateInstance()
{
if (dbh == null)
{
dbh = new SQLDBHelper();
}
return(dbh);
}
//数据准备 ------可销售的房屋的抵押状态一定要对到
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);
}
