/// <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;
}
}
