private static DataTable GetHouseInfoFrmWB(string qlrmc, string zjhm, DataTable dt)
{
BDCSrvSoap soap = new BDCSrvSoapClient();
DataSet ds = soap.SPF_WFZMCX(qlrmc, zjhm, null);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
try
{
string lif = ds.Tables[0].Rows[i]["QZSTATE"].ToString();
string zf = ds.Tables[0].Rows[i]["USETYPE"].ToString();
if (lif.ToLower().Trim().Equals("0") && zf.ToLower().Trim().Equals("住宅"))
{
DataRow row = dt.NewRow();
row["房屋坐落"] = ds.Tables[0].Rows[i]["ZL"].ToString() + " 注：此信息来自网备";
dt.Rows.Add(row);
}
}
catch
{
continue;
}
}
}
return(dt);
}
public DataSet UpdateCSDJStateForSPF(DataSet dsHouses, string Area)
{
//return string.Empty;
BDCSrvSoap soap = new BDCSrvSoapClient();
return(soap.UpdateCSDJStateForSPF(dsHouses, Area));
}
public ActionResult GetZLFromWB(string qlrmc, string zjhm)
{
string zl = string.Empty;
BDCSrvSoap soap = new BDCSrvSoapClient();
DataSet ds = soap.SPF_WFZMCX(qlrmc, zjhm, null);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
try
{
string lif = ds.Tables[0].Rows[i]["YGDJ"].ToString();
string zf = ds.Tables[0].Rows[i]["SaleHouseUse"].ToString();
if (lif.ToLower().Trim().Equals("0") && zf.ToLower().Trim().Equals("住宅"))
{
if (string.IsNullOrEmpty(zl))
{
zl = "\r\n" + ds.Tables[0].Rows[i]["ZL"].ToString();
}
else
{
zl += "\r\n" + ds.Tables[0].Rows[i]["ZL"].ToString();
}
}
}
catch
{
continue;
}
}
}
return(Content(zl, "text/plain"));
}
public EasyUIGridModel GetWBInfoResult(WBQueryForm form)
{
//string cfwbService = ConfigurationManager.AppSettings["FWCFAddress"].ToString();
BDCSrvSoap soap = new BDCSrvSoapClient();
DataSet ds = soap.SPF_WFZMCX(form.QLRXM, form.ZJHM, form.Address);
IList <WBInfo> wbinfos = new List <WBInfo>();
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
WBInfo w = new WBInfo();
w.HouseID = ds.Tables[0].Rows[i]["HouseID"].ToString();
w.BuildingID = ds.Tables[0].Rows[i]["BuildingID"].ToString();
w.ZL = ds.Tables[0].Rows[i]["ZL"].ToString();
w.QLRMC = ds.Tables[0].Rows[i]["QLRMC"].ToString();
w.ZJHM = ds.Tables[0].Rows[i]["ZJHM"].ToString();
w.JZMJ = Convert.ToDouble(ds.Tables[0].Rows[i]["JZMJ"]);
w.ContractNO = ds.Tables[0].Rows[i]["ContractNO"].ToString();
w.SignDate = Convert.ToDateTime(ds.Tables[0].Rows[i]["SignDate"]);
wbinfos.Add(w);
}
}
EasyUIGridModel ret = new EasyUIGridModel(0, wbinfos.Count, wbinfos);
return(ret);
}
/// <summary>
/// 根据
/// </summary>
/// <param name="HouseIds"></param>
/// <returns></returns>
public EasyUIGridModel GetWBInfoByHouseIds(IList <string> HouseIds)
{
if (HouseIds.Count > 0)
{
BDCSrvSoap soap = new BDCSrvSoapClient();
IList <WBInfoForAHouse> wbinfos = new List <WBInfoForAHouse>();
foreach (string hid in HouseIds)
{
string paramstring = "HouseID=" + hid;
DataSet ds = soap.SPF_FC_FWQK(paramstring);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
WBInfoForAHouse w = new WBInfoForAHouse();
w.HID = ds.Tables[0].Rows[0]["HID"].ToString();
w.XMMC = ds.Tables[0].Rows[0]["XMMC"].ToString();
w.LPMC = ds.Tables[0].Rows[0]["LPMC"].ToString();
w.DYH = ds.Tables[0].Rows[0]["DYH"].ToString();
w.FJH = ds.Tables[0].Rows[0]["FJH"].ToString();
w.JZMJ = ds.Tables[0].Rows[0]["JZMJ"].ToString();
w.FWZT = ds.Tables[0].Rows[0]["FWZT"].ToString();
w.CFZT = ds.Tables[0].Rows[0]["CFZT"].ToString();
w.DYZT = ds.Tables[0].Rows[0]["DYZT"].ToString();
w.ZXZT = ds.Tables[0].Rows[0]["ZXZT"].ToString();
if (ds.Tables[1] != null && ds.Tables[1].Rows.Count > 0)
{
w.MCList = new List <string>();
w.ZJLXList = new List <string>();
w.ZJHMList = new List <string>();
w.LXDHList = new List <string>();
w.LXDZList = new List <string>();
for (int i = 0; i < ds.Tables[1].Rows.Count; i++)
{
w.MCList.Add(ds.Tables[1].Rows[i]["MC"].ToString());
w.ZJLXList.Add(ds.Tables[1].Rows[i]["ZJLX"].ToString());
w.ZJHMList.Add(ds.Tables[1].Rows[i]["ZJHM"].ToString());
w.LXDZList.Add(ds.Tables[1].Rows[i]["LXDZ"].ToString());
}
}
wbinfos.Add(w);
}
else
{
wbinfos.Add(new WBInfoForAHouse {
XMMC = "网备中无此房屋"
});
}
}
EasyUIGridModel ret = new EasyUIGridModel(0, wbinfos.Count, wbinfos);
return(ret);
}
else
{
return(null);
}
}
private WBInfoForAHouse getQlrMCInWB(string houseid)
{
BDCSrvSoap soap = new BDCSrvSoapClient();
string paramstring = "HouseID=" + houseid;
DataSet ds = soap.SPF_FC_FWQK(paramstring);
WBInfoForAHouse w = null;
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
w = new WBInfoForAHouse();
w.HID = ds.Tables[0].Rows[0]["HID"].ToString();
w.XMMC = ds.Tables[0].Rows[0]["XMMC"].ToString();
w.LPMC = ds.Tables[0].Rows[0]["LPMC"].ToString();
w.DYH = ds.Tables[0].Rows[0]["DYH"].ToString();
w.FJH = ds.Tables[0].Rows[0]["FJH"].ToString();
w.JZMJ = ds.Tables[0].Rows[0]["JZMJ"].ToString();
w.FWZT = ds.Tables[0].Rows[0]["FWZT"].ToString();
w.CFZT = ds.Tables[0].Rows[0]["CFZT"].ToString();
w.DYZT = ds.Tables[0].Rows[0]["DYZT"].ToString();
w.ZXZT = ds.Tables[0].Rows[0]["ZXZT"].ToString();
if (ds.Tables[1] != null && ds.Tables[1].Rows.Count > 0)
{
w.MCList = new List <string>();
w.ZJLXList = new List <string>();
w.ZJHMList = new List <string>();
w.LXDHList = new List <string>();
w.LXDZList = new List <string>();
for (int i = 0; i < ds.Tables[1].Rows.Count; i++)
{
w.MCList.Add(ds.Tables[1].Rows[i]["MC"].ToString());
w.ZJLXList.Add(ds.Tables[1].Rows[i]["ZJLX"].ToString());
w.ZJHMList.Add(ds.Tables[1].Rows[i]["ZJHM"].ToString());
w.LXDZList.Add(ds.Tables[1].Rows[i]["LXDZ"].ToString());
}
}
}
return(w);
}
public DataSet UpdateYGDJStateForCG(DataSet dsHouses, string Area)
{
BDCSrvSoap soap = new BDCSrvSoapClient();
return(soap.UpdateYGDJStateForCG(dsHouses, Area));
}
private BDCFilterResult CheckInCLF(IList <XGZHAndQLR> xgzhAndQlrs, string djlx, string slbh, string tzr)
{
BDCSrvSoap soap = new BDCSrvSoapClient();
bool find = false;
string htbah = "";
foreach (XGZHAndQLR xgzhAndQlr in xgzhAndQlrs)
{
IList <string> qlrs = xgzhAndQlr.QLRS;
if (qlrs.Count > 0)
{
foreach (string qlr in qlrs)
{
IDictionary <string, string> paramss = new Dictionary <string, string>();
paramss["CQZH"] = xgzhAndQlr.XGZH;
paramss["SYQR"] = qlr;
FC_CLMMHT_WSData ht_Data = new FC_CLMMHT_WSData("CLF_FC_CLMMHT", "2000");
string backDatas = ht_Data.GetWebServiceData(paramss, null);
var bdc = ht_Data.XMLParsing(backDatas);
if (bdc.data != null && bdc.data.dt != null && bdc.data.dt.Rows.Count > 0)
{
find = true;
htbah = bdc.data.dt.Rows[0]["CLHTBAH"].ToString();
break;
}
}
}
}
BDCFilterResult ret = new BDCFilterResult {
IsSuccess = true
};
if (djlx.Equals("权属")) //转移的通知人是不是和义务人一样
{ //
if (find)
{
string message = "";
bool isSucess = IfTZRInCLR(htbah, tzr, ref message);
if (isSucess)
{
return(new BDCFilterResult {
IsSuccess = true
});
}
else
{
return(new BDCFilterResult {
IsSuccess = false, Message = "存量房系统中购房者为：" + message, ConfirmType = 1
});
}
}
else
{
return(new BDCFilterResult {
IsSuccess = false, Message = "存量房系统中未发现交易信息"
});
}
}
else if (djlx.Equals("查封") || djlx.Equals("抵押"))
{
if (find)
{
string message = "";
bool isSucess = IfTZRInCLR(htbah, tzr, ref message);
if (isSucess)
{
return(new BDCFilterResult {
IsSuccess = true
});
}
else
{
return(new BDCFilterResult {
IsSuccess = false, Message = "存量房系统中存在交易信息购房者为：" + message, ConfirmType = 1
});
}
}
else
{
return(new BDCFilterResult {
IsSuccess = true
});
}
}
return(new BDCFilterResult {
IsSuccess = true
});
}
