32 lines
1.1 KiB
C#
32 lines
1.1 KiB
C#
using System;
|
|
using System.Collections.Generic;
|
|
using System.Data;
|
|
using System.Data.OracleClient;
|
|
using System.Linq;
|
|
|
|
namespace WX.CRM.DAL.Exam
|
|
{
|
|
public class EXAM_ITEMBANK_DAL
|
|
{
|
|
public decimal GenerateExam(decimal paperType, decimal eid)
|
|
{
|
|
try
|
|
{
|
|
var p = new List<OracleParameter>
|
|
{
|
|
new OracleParameter{ ParameterName = "p_paperType", OracleType = OracleType.Number, Value = paperType },
|
|
new OracleParameter{ ParameterName = "p_eid", OracleType = OracleType.Number, Value = eid },
|
|
new OracleParameter {ParameterName = "p_paperId", OracleType = OracleType.Number, Direction = ParameterDirection.Output},
|
|
};
|
|
|
|
OracleHelper.ExecuteNonQuery(CommandType.StoredProcedure, "PACK_EXAM.GenerateExam", p.ToArray());
|
|
return decimal.Parse(string.Format("{0}", p.Single(m => m.ParameterName == "p_paperId").Value));
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
throw;
|
|
}
|
|
}
|
|
}
|
|
}
|