~ulysseskao/CCSTrace.git

			@@ -18,14 +18,14 @@

			public LocateEquipment(int mCaseId, bool hasData, OracleConnection conn, OracleTransaction transaction)
			{
			string sqlStmt;
			OracleCommand command = null;
			OracleDataReader reader = null;

			SetCaseId(mCaseId);
			CaseId = mCaseId;

			try
			{
			string sqlStmt;
			if (hasData)
			{
			sqlStmt = "SELECT DSUFID,FSC,UFID,FDR,TPCLID FROM EOS.EVENTRECORD_EX WHERE CASEID = " + mCaseId;
			@@ -35,11 +35,11 @@

			if (reader.Read())
			{
			SetDsufid(Convert.ToInt32(reader["DSUFID"].ToString()));
			SetFsc(Convert.ToInt32(reader["FSC"].ToString()));
			SetUfid(Convert.ToInt32(reader["UFID"].ToString()));
			SetFdr(reader["FDR"].ToString());
			SetTpclid(reader["TPCLID"].ToString());
			DsUfid =Convert.ToInt32(reader["DSUFID"].ToString());
			Fsc = Convert.ToInt32(reader["FSC"].ToString());
			Ufid = Convert.ToInt32(reader["UFID"].ToString());
			Fdr = reader["FDR"].ToString();
			Tpclid = reader["TPCLID"].ToString();
			}
			}
			else
			@@ -50,87 +50,60 @@
			reader = command.ExecuteReader();

			if (reader.Read())
			SetDsufid(Convert.ToInt32(reader["UFID"].ToString()));
			DsUfid = Convert.ToInt32(reader["UFID"].ToString());
			}
			}
			catch (Exception e)
			{
			Console.WriteLine(e.Message);
			Console.WriteLine(e.StackTrace);
			Logger.Warn(e, e.Message);
			}
			finally
			{
			reader.Close();
			command.Dispose();
			reader?.Close();
			command?.Dispose();
			}
			}

			public int GetCaseId()
			public int CaseId
			{
			return _caseId;
			get { return _caseId; }
			set { _caseId = value; }
			}

			public void SetCaseId(int mCaseId)
			public int DsUfid
			{
			_caseId = mCaseId;
			get { return _dsUfid; }
			set { _dsUfid = value; }
			}

			public int GetDsufid()
			public int Fsc
			{
			return _dsUfid;
			get { return _fsc; }
			set { _fsc = value; }
			}

			public void SetDsufid(int mDsUfid)
			public int Ufid
			{
			_dsUfid = mDsUfid;
			get { return _ufid; }
			set { _ufid = value; }
			}

			public int GetFsc()
			public string Fdr
			{
			return _fsc;
			get { return _fdr; }
			set { _fdr = value; }
			}

			public void SetFsc(int mFsc)
			public string Tpclid
			{
			_fsc = mFsc;
			get { return _tpclid; }
			set { _tpclid = value; }
			}

			public int GetUfid()
			public string GetInsertSqlStmt()
			{
			return _ufid;
			}

			public void SetUfid(int mUfid)
			{
			_ufid = mUfid;
			}

			public string GetFdr()
			{
			return _fdr;
			}

			public void SetFdr(string mFdr)
			{
			_fdr = mFdr;
			}

			public string GetTpclid()
			{
			return _tpclid;
			}

			public void SetTpclid(string mTpclid)
			{
			_tpclid = mTpclid;
			}

			public string GetSqlStmt()
			{
			string sqlStmt;

			sqlStmt = "INSERT INTO EOS.EVENTRECORD_EX (CASEID,DSUFID,FSC,UFID,TPCLID,FDR) VALUES(" + GetCaseId() + "," + GetDsufid() + "," + GetFsc()
			+ "," + GetUfid() + ",'" + GetTpclid() + "','" + GetFdr() + "')";
			var sqlStmt = "INSERT INTO EOS.EVENTRECORD_EX (CASEID,DSUFID,FSC,UFID,TPCLID,FDR) VALUES(" + CaseId + "," + DsUfid + "," + Fsc
			+ "," + Ufid + ",'" + Tpclid + "','" + Fdr + "')";
			return sqlStmt;
			}