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