/// <summary> /// 获取业务检查对象 /// </summary> /// <param name="paramName"></param> /// <returns></returns> internal CheckObject[] GetBusinessCheckObjects(string paramName) { try { string sql = ""; if (paramName == "*") { sql = string.Format("select a.Summary,a.ValidateType,a.CompareType,a.MaximumValue,a.MinimumValue,a.ParamToValidate,a.ParamToCompare,a.SQL,b.Repeated, a.CheckType from t_frm_BusinessChecks a left join t_frm_BusinessParams b on a.BusinessID = b.BusinessID and a.ParamToValidate = b.ParamName where a.BusinessID = '{0}' and a.Enabled=1 order by a.Idx", BusinessName); } else { sql = string.Format("select a.Summary,a.ValidateType,a.CompareType,a.MaximumValue,a.MinimumValue,a.ParamToValidate,a.ParamToCompare,a.SQL,b.Repeated, a.CheckType from t_frm_BusinessChecks a left join t_frm_BusinessParams b on a.BusinessID = b.BusinessID and a.ParamToValidate = b.ParamName where a.BusinessID = '{0}' and a.ParamToValidate = '{1}' and a.Enabled=1 order by a.Idx", BusinessName, paramName); } DataTable data = Frm_Helper.GetDataSet_SQL(sql).Tables[0]; if (data.Rows.Count == 0 && paramName != "*") //2016-7-01 && paramName != "*" { throw new RFException(string.Format(AlertMessage.Business_NoCheckParam, paramName)); } CheckObject[] objects = new CheckObject[data.Rows.Count]; for (int i = 0; i < data.Rows.Count; i++) { objects[i] = new CheckObject(); objects[i].Summary = FormatSummary(data.Rows[i]["Summary"].ToString()); objects[i].ValidateType = data.Rows[i]["ValidateType"].ToString(); objects[i].CompareType = data.Rows[i]["CompareType"].ToString(); objects[i].MaxValue = data.Rows[i]["MaximumValue"].ToString(); objects[i].MinValue = data.Rows[i]["MinimumValue"].ToString(); objects[i].ValidateParamName = data.Rows[i]["ParamToValidate"].ToString(); objects[i].CompareParamName = data.Rows[i]["ParamToCompare"].ToString(); objects[i].Sql = data.Rows[i]["SQL"].ToString(); objects[i].Sql = objects[i].Sql.Replace(':', '@'); objects[i].Repeated = data.Rows[i]["Repeated"].ToString() == "True" ? true : false; //2016-06-23 增加初始参数是否为重复执行 objects[i].CheckType = data.Rows[i]["CheckType"] == DBNull.Value ? 0 : int.Parse(data.Rows[i]["CheckType"].ToString()); //0.警告后终止;1.警告继续;2.警告后确认是否继续 objects[i].Index = i; } return(objects); } catch (Exception ex) { throw ex; } }
internal CheckObject[] GetCheckObjects(string businessId, string paramName) { try { string sql = ""; if (paramName == "*") { sql = string.Format("select Summary,ValidateType,CompareType,MaximumValue,MinimumValue,ParamToValidate,ParamToCompare,SQL from t_frm_BusinessChecks where BusinessID = '{0}' and Enabled=1 order by Idx", businessId); } else { sql = string.Format("select Summary,ValidateType,CompareType,MaximumValue,MinimumValue,ParamToValidate,ParamToCompare,SQL from t_frm_BusinessChecks where BusinessID = '{0}' and ParamToValidate = '{1}' and Enabled=1 order by Idx", businessId, paramName); } DataTable data = Frm_Helper.GetDataSet_SQL(sql).Tables[0]; if (data.Rows.Count == 0) { throw new RFException("业务检查参数[" + paramName + "]不存在!"); } CheckObject[] objects = new CheckObject[data.Rows.Count]; for (int i = 0; i < data.Rows.Count; i++) { objects[i] = new CheckObject(); objects[i].Summary = data.Rows[i]["Summary"].ToString(); objects[i].ValidateType = data.Rows[i]["ValidateType"].ToString(); objects[i].CompareType = data.Rows[i]["CompareType"].ToString(); objects[i].MaxValue = data.Rows[i]["MaximumValue"].ToString(); objects[i].MinValue = data.Rows[i]["MinimumValue"].ToString(); objects[i].ValidateParamName = data.Rows[i]["ParamToValidate"].ToString(); objects[i].CompareParamName = data.Rows[i]["ParamToCompare"].ToString(); objects[i].Sql = data.Rows[i]["SQL"].ToString(); objects[i].Sql = objects[i].Sql.Replace(':', '@'); } return(objects); } catch (Exception ex) { Loger.Error(ex); throw ex; } }