/// <summary> /// 设置规则信息 /// </summary> /// <param name="noRuleInfo"></param> /// <param name="departmentId"></param> public void SetNoRuleInfo(JNoRuleInfo noRuleInfo, string departmentId) { ParameterData parData = new ParameterData(); parData.参数ID = SqlHelper.GetCmpUID(); parData.参数名称 = NoRuleModel.NoRuleParName; parData.参数标记 = departmentId; parData.参数取值 = noRuleInfo.ToString(); _pm.WriteParameter(parData); }
public ParameterData ReadParameter(string parName, string parTag) { SQL sql = CreateSQL("读取参数配置", "select 参数ID,参数名称,参数标记,参数取值 from 影像参数信息 where 参数名称=:参数名称 and 参数标记=:参数标记"); sql.AddParameter("参数名称", parName); sql.AddParameter("参数标记", parTag); DataTable dtPar = sql.ExecuteSql(); if (dtPar == null || dtPar.Rows.Count <= 0) { return(null); } ParameterData parData = new ParameterData(); parData.BindRowData(dtPar.Rows[0]); return(parData); }
/// <summary> /// 获取规则信息 /// </summary> /// <param name="departmentId"></param> /// <returns></returns> public JNoRuleInfo GetNoRuleInfo(string departmentId) { DataTable parInfo = _pm.GetParameterInfo(NoRuleParName, departmentId); if (parInfo == null || parInfo.Rows.Count <= 0) { return(null); } ParameterData parData = new ParameterData(); parData.BindRowData(parInfo.Rows[0]); JNoRuleInfo noRule = JsonHelper.DeserializeObject <JNoRuleInfo>(parData.参数取值); if (noRule == null) { return(null); } return(noRule); }
/// <summary> /// 更新参数 /// </summary> /// <param name="parData"></param> public void WriteParameter(ParameterData parData) { string parId = GetParameterId(parData.参数名称, parData.参数标记); string sql = ""; if (string.IsNullOrEmpty(parId)) { parId = parData.参数ID; sql = "insert into 影像参数信息(参数ID,参数名称,参数标记,参数取值) values(:参数ID, :参数名称, :参数标记, :参数取值)"; sql = SqlHelper.GetSqlBiz().GetSqlContext("插入影像参数信息", sql); } else { sql = "update 影像参数信息 set 参数取值=:参数取值 where 参数ID=:参数ID"; sql = SqlHelper.GetSqlBiz().GetSqlContext("更新影像参数信息", sql); } _dbHelper.ExecuteSQL(sql, new SqlParamInfo[] { new SqlParamInfo("参数名称", DbType.String, parData.参数名称), new SqlParamInfo("参数标记", DbType.String, parData.参数标记), new SqlParamInfo("参数取值", DbType.String, parData.参数取值), new SqlParamInfo("参数ID", DbType.String, parId) }); }