internal int UPDATECERTINFO(string yWH, string qLRZJH, string bDCQZH, string lZRXM, string lZRZJH, string ySXLH, string ySXLHP, string machineCode)
{
string[] zjhArray = qLRZJH.Split('、');
DataTable dt = GetSLBH(yWH, "", zjhArray[0], bDCQZH);
if (null != dt && dt.Rows.Count > 0)
{
string slbh = dt.Rows[0]["SLBH"].ToString();
string tableName = dt.Rows[0]["TABLENAME"].ToString();
DJ_FJD fjd = CreateFJD(yWH, machineCode, 1);
DJ_FJD_FB fb = CreateFJD_FB(yWH, bDCQZH, ySXLH);
DJ_FJD_LJR ljr = null;
if (!string.IsNullOrEmpty(ySXLHP))
{
byte[] arr = Convert.FromBase64String(ySXLHP);
ljr = CreateFJD_LJR(yWH, lZRXM, "1", lZRZJH, arr);
}
else
{
ljr = CreateFJD_LJR(yWH, lZRXM, "1", lZRZJH, null);
}
return(UpdateFJD(fjd, fb, ljr, tableName, ySXLH));
}
return(-1);
}
private DJ_FJD_LJR CreateFJD_LJR(string ywh, string ljrmc, string zjlx, string zjhm, byte[] ljrzp)
{
DJ_FJD_LJR ljr = new DJ_FJD_LJR();
ljr.LJRZP = ljrzp;
ljr.LJBH = Guid.NewGuid().ToString();
ljr.SLBH = ywh;
ljr.LJR = ljrmc;
ljr.LJRSFZJLX = zjlx;
ljr.LJRSFZJH = zjhm;
return(ljr);
}
private void DeleteLJR(DJ_FJD_LJR ljr)
{
DbHelper dbHelper = new DbHelper();
try
{
string sql = string.Format("delete from DJ_FJD_LJR where slbh='{0}'", ljr.SLBH);
dbHelper.SetProvider(MyDBType.Oracle);
dbHelper.ExecuteNonQuery(MyDBType.Oracle, System.Data.CommandType.Text, sql, null);
}
catch (Exception ex)
{
throw ex;
}
finally
{
dbHelper.CloseConn();
}
}
private int UpdateFJD(DJ_FJD fjd, DJ_FJD_FB fb, DJ_FJD_LJR ljr, string tableName, string zsxlh)
{
try
{
//using (TransactionScope ts = new TransactionScope())
//{
InsertFJD(fjd);
InsertFJD_FB(fb);
InsertFJD_LZR(ljr);
UpdateWFM_ACTINST(fjd.SLBH);
UpdateZSXLH(fjd.SLBH, tableName, zsxlh);
//ts.Complete();
return(0);
//}
}
catch (Exception ex)
{
string str = ex.Message;
WriteLog("C:\\LOG.txt", ex.Message);
return(-1);
}
}
private int InsertFJD_LZR(DJ_FJD_LJR ljr)
{
DbHelper dbHelper = new DbHelper();
try
{
DeleteLJR(ljr);
string sql = dbHelper.CreateInsertStr <DJ_FJD_LJR>(ljr, "DJ_FJD_LJR", MyDBType.Oracle);
sql = sql.Trim().Replace("\r\n", "");
DbParameter[] param = dbHelper.GetParamArray <DJ_FJD_LJR>(ljr, MyDBType.Oracle);
dbHelper.SetProvider(MyDBType.Oracle);
return(dbHelper.ExecuteNonQuery(MyDBType.Oracle, System.Data.CommandType.Text, sql, param));
}
catch (Exception ex)
{
WriteLog("C:\\LOG.txt", ex.Message);
throw ex;
}
finally
{
dbHelper.CloseConn();
}
}
