/// <summary>
/// 取得指定处理类型的时限纪录
/// </summary>
/// <param name="dealtype"></param>
/// <returns></returns>
public DataSet GetUndoRulesDataSetByDealType(RuleDealType dealtype)
{
SqlParameter paramClbz = new SqlParameter(param_clbz, SqlDbType.Int);
paramClbz.Value = (int)dealtype;
SqlParameter paramJlzt = new SqlParameter(param_jlzt, SqlDbType.Int);
paramJlzt.Value = (int)RecordState.Invalid; //注意这里的sql语句是Valid !=
return(_sqlHelper.ExecuteDataSet(cstSelectUndoRuleRecordByDealType,
new SqlParameter[] { paramClbz, paramJlzt }));
}
/// <summary>
/// 取得指定处理类型的时限纪录
/// </summary>
/// <param name="type"></param>
/// <returns></returns>
public Collection <QCRuleRecord> GetRuleRecords(RuleDealType type)
{
Collection <QCRuleRecord> records = new Collection <QCRuleRecord>();
DataSet ds = _rulerecorddal.GetUndoRulesDataSetByDealType(type);
if (ds != null && ds.Tables.Count > 0)
{
DataTable dt = ds.Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
QCRuleRecord qcrr = _rulerecorddal.DataRow2QCRuleRecord(dt.Rows[i]);
if (qcrr != null)
{
records.Add(qcrr);
}
}
}
return(records);
}
