public static void EditRule(string pnkey, string ruleid, string wt, string err, string para, string low, string high, string ruleres, string tc)
{
var sql = "update PnRulesVM set WhichTest=@WhichTest,ErrAbbr=@ErrAbbr,Param=@Param,LowLimit=@LowLimit,HighLimit=@HighLimit,RuleRes= @RuleRes,TestCase= @TestCase where RuleID = @RuleID";
var pa = new Dictionary <string, string>();
pa.Add("@RuleID", ruleid);
pa.Add("@WhichTest", wt);
pa.Add("@ErrAbbr", err);
pa.Add("@Param", para);
pa.Add("@LowLimit", low);
pa.Add("@HighLimit", high);
pa.Add("@RuleRes", ruleres);
pa.Add("@TestCase", tc);
DBUtility.ExeLocalSqlNoRes(sql, pa);
PnMESVM.BindMesTab(pnkey, wt);
}
public static void AddRule(string pnkey, string ruleid, string wt, string err, string para, string low, string high, string ruleres, string tc)
{
var sql = "insert into PnRulesVM(PnKey,RuleID,WhichTest,ErrAbbr,Param,LowLimit,HighLimit,RuleRes,CreateDate,TestCase) values(@PnKey,@RuleID,@WhichTest,@ErrAbbr,@Param,@LowLimit,@HighLimit,@RuleRes,@CreateDate,@TestCase)";
var pa = new Dictionary <string, string>();
pa.Add("@PnKey", pnkey);
pa.Add("@RuleID", ruleid);
pa.Add("@WhichTest", wt);
pa.Add("@ErrAbbr", err);
pa.Add("@Param", para);
pa.Add("@LowLimit", low);
pa.Add("@HighLimit", high);
pa.Add("@RuleRes", ruleres);
pa.Add("@CreateDate", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
pa.Add("@TestCase", tc);
DBUtility.ExeLocalSqlNoRes(sql, pa);
PnMESVM.BindMesTab(pnkey, wt);
}
