/// <summary>
/// 新的任务参数
/// </summary>
/// <param name="n2m">任务参数</param>
public void InsertParms(TasksN2M n2m)
{
try
{
string sql = @"insert into qm_task_n2m
(idx,
refidx,
refname,
attrname,
attrval)
values
(:idx,
:refidx,
:refname,
:attrname,
:attrval)";
OracleParameter[] param = new OracleParameter[]
{
new OracleParameter(":idx", n2m.idx),
new OracleParameter(":refidx", n2m.refidx),
new OracleParameter(":refname", n2m.refname),
new OracleParameter(":attrname", n2m.attrname),
new OracleParameter(":attrval", n2m.attrval)
};
qmdb.ExecuteNonQuery(qmdb.p_trans, CommandType.Text, sql, param);
}
catch (QMException ex)
{
throw ex;
}
}
/// <summary>
/// 获得参数
/// </summary>
/// <param name="taskid">任务Id</param>
/// <param name="refname">参数组</param>
/// <returns></returns>
public IList <TasksN2M> GetParms(string taskid, string refname = "")
{
IList <TasksN2M> task = new List <TasksN2M>();
TasksN2M t = null;
try
{
string sql = "select * from qm_task_n2m where refidx = '" + taskid + "'";
if (refname != "")
{
sql += "and refname = '" + refname + "'";
}
OracleDataReader dr = qmdb.ExecuteReader(CommandType.Text, sql);
while (dr.Read())
{
t = new TasksN2M();
t.idx = dr["IDX"].ToString();
t.refidx = dr["REFIDX"].ToString();
t.refname = dr["REFNAME"].ToString();
t.attrname = dr["ATTRNAME"].ToString();
t.attrval = dr["ATTRVAL"].ToString();
task.Add(t);
}
dr.Close();
}
catch (QMException ex)
{
throw ex;
}
finally
{
qmdb.Disponse();
}
return(task);
}
