private string GetZXRQ(string slbh)
{
FC_DY_INFO_DAL dal = new FC_DY_INFO_DAL();
string zxrq = dal.GetZXRQ(slbh);
return(zxrq);
}
private string GetDYZL(string slbh)
{
//string bdcdyh = "";
FC_DY_INFO_DAL dal = new FC_DY_INFO_DAL();
DataTable dt = dal.GetDYZL(slbh);
if (null != dt && dt.Rows.Count > 0)
{
return(dt.Rows[0][0].ToString());
}
return("");
//if (null != dt && dt.Rows.Count > 0)
//{
// //foreach (DataRow row in dt.Rows)
// //{
// // if (string.IsNullOrEmpty(bdcdyh))
// // {
// // bdcdyh = row["ZL"].ToString();
// // }
// // else
// // {
// // bdcdyh += " " + row["ZL"].ToString();
// // }
// //}
//}
//return bdcdyh;
}
public DataTable getDYFromBDC(string slbh)
{
FC_DY_INFO_DAL dal = new FC_DY_INFO_DAL();
DataTable dt = dal.GetDYFormBDC(slbh);
return(dt);
}
private string GetDYBDCDYH(string slbh)
{
string bdcdyh = "";
FC_DY_INFO_DAL dal = new FC_DY_INFO_DAL();
DataTable dt = dal.GetDYBDCDYH(slbh);
if (null != dt)
{
if (dt.Rows.Count > 1)
{
bdcdyh = dt.Rows[0]["BDCDYH"].ToString() + "等共" + dt.Rows.Count + "个";
//foreach (DataRow row in dt.Rows)
//{
// if(string.IsNullOrEmpty(bdcdyh))
// {
// bdcdyh = row["BDCDYH"].ToString();
// }
// else
// {
// bdcdyh+=" "+ row["BDCDYH"].ToString();
// }
//}
}
if (dt.Rows.Count == 1)
{
bdcdyh = dt.Rows[0]["BDCDYH"].ToString();
}
}
return(bdcdyh);
}
public DataTable getCFFromBDC(string hid)
{
FC_DY_INFO_DAL dal = new FC_DY_INFO_DAL();
DataTable dt = dal.getCFFromBDC(hid);
return(dt);
}
public DataTable getFZFromBDC(string HID)
{
FC_DY_INFO_DAL dal = new FC_DY_INFO_DAL();
DataTable dt = dal.GetFZFromBDC(HID);
return(dt);
}
public DataTable getQSInfoListFromBDC(string bdczh, string qlrmc, string zjhm, string zl)
{
FC_DY_INFO_DAL dal = new FC_DY_INFO_DAL();
DataTable dt = InitQLRInfoDT(dal.GetQSInfoListFromBDC(bdczh, qlrmc, zjhm, zl));
return(dt);
}
public DataTable getDYOpFlowFromBDC(string ywzh, string txqzh, string cqr, string zjhm, string fwzl, string yhmc)
{
FC_DY_INFO_DAL dal = new FC_DY_INFO_DAL();
DataTable dt = InitZXRQ(dal.getDYOpFlowFromBDC(ywzh, txqzh, cqr, zjhm, fwzl, yhmc));
return(dt);
}
public DataTable getDYOpListFromBDC(string strKeyWord, string sDate, string eDate, string strTXCertCode, string fzSDate, string fzEDate)
{
FC_DY_INFO_DAL dal = new FC_DY_INFO_DAL();
DataTable resDT = dal.GetDYOpList(strKeyWord, sDate, eDate, strTXCertCode, fzSDate, fzEDate);
if (null != resDT && resDT.Rows.Count > 0)
{
resDT = InitDyInfoDT(resDT);
}
return(resDT);
}
public DataTable getCertInfoFromBDC(string strBusNo, string strCertCode)
{
FC_DY_INFO_DAL dal = new FC_DY_INFO_DAL();
DataTable dt = dal.getCertInfoFromBDC(strBusNo, strCertCode);
if (null != dt && dt.Rows.Count > 0)
{
dt = InitDYCerInfoDT(dt);
}
return(dt);
}
public DataTable getBDCDYH_by_ZID(string zid)
{
FC_DY_INFO_DAL dal = new FC_DY_INFO_DAL();
try
{
zid = new Guid(zid).ToString("D").ToUpper();
}
catch
{ }
return(dal.getBDCDYH(zid));
}
private object GetZJHMFromBDC(string slbh, string qlrlx)
{
string qlrmc = "";
FC_DY_INFO_DAL dal = new FC_DY_INFO_DAL();
DataTable dt = null;
dt = dal.GetQLRZJHMBySLBH(slbh, qlrlx);
if (null != dt && dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
string name = row[0].ToString();
if (!qlrmc.Equals(name))
{
qlrmc += " " + name;
}
}
qlrmc = qlrmc.Trim();
}
return(qlrmc);
}
private string GetQLRMCFromBDC(string slbh, string IsDyqr)
{
string qlrmc = "";
FC_DY_INFO_DAL dal = new FC_DY_INFO_DAL();
DataTable dt = null;
dt = dal.GetQLRMCBySLBH(slbh, IsDyqr);
if (null != dt && dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
string name = row[0].ToString();
if (!qlrmc.Equals(name))
{
qlrmc += " " + name;
}
}
qlrmc = qlrmc.Trim();
}
else
{
if (IsDyqr.Equals("抵押人"))
{
dt = dal.GetQLRByFSLBH(slbh);
if (null != dt && dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
string name = row[0].ToString();
if (!qlrmc.Equals(name))
{
qlrmc += " " + name;
}
}
qlrmc = qlrmc.Trim();
}
}
}
return(qlrmc);
}
public DataTable getREInfoFromBDC(string strHouseSite, string strCertCode)
{
FC_DY_INFO_DAL dal = new FC_DY_INFO_DAL();
return(dal.getREInfoFromBDC(strHouseSite, strCertCode));
}
