public TopicCreate GetTopicById(int id) { var paramArray = new[] { new OracleParameter("V_ID", OracleDbType.Int32) { Value = id }, new OracleParameter("CUR", OracleDbType.RefCursor) { Direction = ParameterDirection.Output } }; var table = GetDataSetBySp("GetTopicByID", paramArray).Tables[0]; return(DataTableSerializer.ToList <TopicCreate>(table).FirstOrDefault()); }
public FileCreate GetFileByFileID(long id) { var paramArray = new[] { new OracleParameter("V_ID", OracleDbType.Int64) { Value = id }, new OracleParameter("CUR", OracleDbType.RefCursor) { Direction = ParameterDirection.Output } }; var table = GetDataSetBySp("GetFileByFileID", paramArray).Tables[0]; return(DataTableSerializer.ToList <FileCreate>(table).FirstOrDefault()); }
public FILEINFO DownloadFile(long id, string userID) { var paramArray = new[] { new OracleParameter("V_ID", OracleDbType.Int64) { Value = id }, new OracleParameter("V_UserID", OracleDbType.NVarchar2) { Value = userID }, new OracleParameter("cur", OracleDbType.RefCursor) { Direction = ParameterDirection.Output } }; var table = GetDataSetBySp("DownloadFile2", paramArray).Tables[0]; return(DataTableSerializer.ToList <FILEINFO>(table).FirstOrDefault()); }