public DataTable LND_PROC_GETCERTQUERY(string LZRZJH)
{
if (!string.IsNullOrEmpty(LZRZJH))
{
ZZDYLOG log = new ZZDYLOG();
log.ID = Guid.NewGuid().ToString();
log.CallTime = DateTime.Now;
log.IntefaceName = "LND_PROC_GETCERTQUERY";
log.keyValues = "@LZRZJH=" + LZRZJH;
DataTable dt = null;
ZZDZ_DAL dal = new ZZDZ_DAL();
try
{
if (null == dic)
{
dic = GetBanks(bank_person);
}
if (dic.Keys.Contains(LZRZJH))
{
string bank = dic[LZRZJH];
dt = dal.GetCerQuery_Bank(bank);
}
else
{
dt = dal.GetCerQuery(LZRZJH);
}
if (null != dt && dt.Rows.Count > 0)
{
log.ReturnState = true.ToString();
log.RevurnVale = "返回" + dt.Rows.Count + "行";
}
else
{
log.ReturnState = false.ToString();
log.RevurnVale = "无数据返回";
}
return(dt);
}
catch (Exception ex)
{
log.ReturnState = false.ToString();
log.RevurnVale = "错误：" + ex.Message;
}
finally
{
dal.InsertLog(log);
}
}
return(null);
}
public DataTable LND_PROC_GETCERTINFO(string ywh, string QLRZJH, string BDCQZH)
{
ZZDYLOG log = new ZZDYLOG();
log.ID = Guid.NewGuid().ToString();
log.CallTime = DateTime.Now;
log.IntefaceName = "LND_PROC_GETCERTINFO";
log.keyValues = "@ywh=" + ywh + "|@QLRZJH=" + QLRZJH + "|@BDCQZH=" + BDCQZH;
if (string.IsNullOrEmpty(ywh) && string.IsNullOrEmpty(QLRZJH) && string.IsNullOrEmpty(BDCQZH))
{
log.ReturnState = false.ToString();
log.RevurnVale = "所有参数都为空";
return(null);
}//201709050055
ZZDZ_DAL dal = new ZZDZ_DAL();
try
{
DataTable dt = dal.GetCerInfo(ywh, QLRZJH, BDCQZH);
if (null != dt && dt.Rows.Count > 0)
{
if (IsPrintPicture)
{
InitBDCPicture(dt);
}
log.ReturnState = true.ToString();
log.RevurnVale = "返回" + dt.Rows.Count + "行";
}
else
{
log.ReturnState = false.ToString();
log.RevurnVale = "无数据返回";
}
return(dt);
}
catch (Exception ex)
{
log.ReturnState = false.ToString();
log.RevurnVale = "错误：" + ex.Message;
}
finally
{
dal.InsertLog(log);
}
return(null);
}
public int LND_PROC_UPDATECERTINFO(string YWH, string QLRZJH, string BDCQZH, string LZRXM, string LZRZJH, string YSXLH, string YSXLHP, string machineCode)
{
ZZDYLOG log = new ZZDYLOG();
log.ID = Guid.NewGuid().ToString();
log.CallTime = DateTime.Now;
log.IntefaceName = "LND_PROC_UPDATECERTINFO";
log.keyValues = "@ywh=" + YWH + "|@QLRZJH=" + QLRZJH + "|@BDCQZH=" + BDCQZH + "|@LZRXM=" + LZRXM + "|@LZRZJH=" + LZRZJH + "|@YSXLH=" + YSXLH + "|@machineCode=" + machineCode;
ZZDZ_DAL dal = new ZZDZ_DAL();
try
{
if (string.IsNullOrEmpty(machineCode))
{
log.ReturnState = false.ToString();
log.RevurnVale = "machineCode为空";
return(-1);
}
int count = dal.UPDATECERTINFO(YWH, QLRZJH, BDCQZH, LZRXM, LZRZJH, YSXLH, YSXLHP, machineCode);
if (count > 0)
{
log.ReturnState = true.ToString();
}
else
{
log.ReturnState = false.ToString();
}
log.RevurnVale = "返回值：" + count;
return(count);
}
catch (Exception ex)
{
log.ReturnState = false.ToString();
log.RevurnVale = "错误：" + ex.Message;
}
finally
{
dal.InsertLog(log);
}
return(-1);
}
private string GetZDTBybdcdyh(string bdcdyh, string ywh)
{
ZZDZ_DAL dal = new ZZDZ_DAL();
if (bdcdyh.Contains("等"))
{
bdcdyh = bdcdyh.Substring(0, bdcdyh.IndexOf("等"));
}
string fileid = dal.GetFileID(bdcdyh, "宗地图");
//fileid="File-160511101022-CCJO0QOR";
//string ftppath="/2016/05/11/Bin-160511101022-UX1AH5HK.PDF";
string ftppath = dal.GetFtpPath(fileid, "'宗地图','宗地示意图','宗地草图'");
if (!string.IsNullOrEmpty(ftppath))
{
//string filePath = GetFileFromFTP(ftppath);
return(GetFileFromFTP(ftppath));
}
return("");
}
private string GetFCFHTBybdcdyh(string bdcdyh, string ywh)
{
ZZDZ_DAL dal = new ZZDZ_DAL();
string fileid = "";
DataTable dt = GetALLBDCDYH(ywh);
foreach (DataRow row in dt.Rows)
{
fileid = dal.GetFileID(row[0].ToString(), "分层分户草图");
if (!string.IsNullOrEmpty(fileid))
{
break;
}
}
string ftppath = dal.GetFtpPath(fileid, "'分层分户草图'");
//string filePath = GetFileFromFTP(ftppath);
return(GetFileFromFTP(ftppath));
}
private DataTable GetALLBDCDYH(string ywh)
{
ZZDZ_DAL dal = new ZZDZ_DAL();
return(dal.GetALLBDCDYH(ywh));
}
