/// <summary> /// 得到审核主表最新的一个实体 /// </summary> /// <param name="conn">OracleConnection</param> /// <param name="formid">formid</param> /// <returns></returns> public FLOW_FLOWRECORDMASTER_T GetFlowerMasterIDByFormid(OracleConnection conn, string formid) { try { FLOW_FLOWRECORDMASTER_T model = new FLOW_FLOWRECORDMASTER_T(); string selSql = "SELECT INSTANCEID,FORMID,EDITUSERID,EDITUSERNAME FROM FLOW_FLOWRECORDMASTER_T WHERE FORMID=:FORMID ORDER BY CREATEDATE DESC"; OracleParameter[] pageparm = { new OracleParameter(":FORMID", OracleType.NVarChar, 100) }; pageparm[0].Value = formid; DataTable dt = OracleDataProvider.GetDataTable(conn, selSql, pageparm); if (dt.Rows.Count > 0) { //多次提交单据的时候,取最新的一条数据 model.INSTANCEID = dt.Rows[0]["INSTANCEID"].ToString(); // model.FORMID = dt.Rows[0]["FORMID"].ToString(); // model.EDITUSERID = dt.Rows[0]["EDITUSERID"].ToString(); // model.EDITUSERNAME = dt.Rows[0]["EDITUSERNAME"].ToString(); // } return(model); } catch (Exception e) { throw new Exception(e.Message, e); } }
/// <summary> /// 获取元数据 /// </summary> /// <param name="formid">formid</param> /// <returns></returns> public static string GetMetadataByFormid(string formid) { try { string sql = "select businessobject from FLOW_FLOWRECORDMASTER_T where formid='" + formid + "' order by createdate desc "; using (OracleConnection con = new OracleConnection(ADOHelper.ContextOracleConnection)) { try { con.Open(); DataTable dt = OracleDataProvider.GetDataTable(con, sql); if (dt != null && dt.Rows.Count > 0) { return(dt.Rows[0]["businessobject"].ToString());//取新新的一条 } else { return(""); } } catch (Exception ex) { LogHelper.WriteLog("获取元数据:GetMetadataByFormid-> OracleDataProvider.GetDataTable:异常信息:" + ex.Message); return(""); } finally { if (con.State == ConnectionState.Open) { con.Close(); } LogHelper.WriteLog("获取元数据:GetMetadataByFormid-> SQL=" + sql); } } } catch (Exception ex) { LogHelper.WriteLog("获取元数据:GetMetadataByFormid:异常信息:" + ex.Message); return(""); } }