internal void InsertLog(ZZDYLOG log)
{
DbHelper dbHelper = new DbHelper();
dbHelper.SetProvider(MyDBType.Oracle);
string sql = dbHelper.CreateInsertStr <ZZDYLOG>(log, "ZZDYLOG", MyDBType.Oracle);
sql = sql.Trim().Replace("\r\n", "");
DbParameter[] param = dbHelper.GetParamArray <ZZDYLOG>(log, MyDBType.Oracle);
dbHelper.ExecuteNonQuery(MyDBType.Oracle, System.Data.CommandType.Text, sql, param);
}
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);
}
