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)); }