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