/// <summary>
/// 获取工作流规则的各种定义信息
/// </summary>
/// <param name="obj"></param>
/// <param name="userId"></param>
/// <returns></returns>
public List <List <WorkflowConditionParaDto> > GetWorkflowFormByObject(DicEnum.WORKFLOW_OBJECT obj, long userId)
{
List <List <WorkflowConditionParaDto> > parasList = new List <List <WorkflowConditionParaDto> >();
QueryCommonBLL queryBll = new QueryCommonBLL();
var groupList = queryBll.GetQueryGroup((int)obj);
List <string> types = new List <string> {
"事件", "条件", "更新", "其他操作", "通知", "备注"
};
var queryParaDal = new DAL.d_query_para_dal();
foreach (var tp in types)
{
if (groupList.Exists(_ => tp.Equals(_.name)))
{
var grp = groupList.Find(_ => tp.Equals(_.name));
//parasList.Add(queryBll.GetConditionParaVisiable(userId, grp.id));
string sql = $"select id,data_type_id as data_type,default_value as defaultValue,col_name,col_comment as description,ref_sql,ref_url,operator_type_id from d_query_para where query_para_group_id={grp.id} and is_visible=1 ";
var paras = queryParaDal.FindListBySql <WorkflowConditionParaDto>(sql);
foreach (var dto in paras)
{
if (dto.data_type == (int)DicEnum.QUERY_PARA_TYPE.DROPDOWN ||
dto.data_type == (int)DicEnum.QUERY_PARA_TYPE.MULTI_DROPDOWN ||
dto.data_type == (int)DicEnum.QUERY_PARA_TYPE.DYNAMIC)
{
var dt = queryParaDal.ExecuteDataTable(dto.ref_sql);
if (dt != null)
{
dto.values = new List <DictionaryEntryDto>();
foreach (System.Data.DataRow row in dt.Rows)
{
dto.values.Add(new DictionaryEntryDto(row[0].ToString(), row[1].ToString()));
}
}
}
}
parasList.Add(paras);
}
else
{
parasList.Add(null);
}
}
return(parasList);
}
/// <summary>
/// 获取工作流规则的条件定义
/// </summary>
/// <param name="obj"></param>
/// <param name="userId"></param>
/// <returns></returns>
public List <List <WorkflowConditionParaDto> > GetWorkflowFormConditionByObject(DicEnum.WORKFLOW_OBJECT obj, long userId)
{
List <List <WorkflowConditionParaDto> > parasList = new List <List <WorkflowConditionParaDto> >();
QueryCommonBLL queryBll = new QueryCommonBLL();
var groupList = queryBll.GetQueryGroup((int)obj);
var grp = groupList.Find(_ => "条件".Equals(_.name));
string sql = $"select id,data_type_id as data_type,default_value as defaultValue,col_name,col_comment as description,ref_sql,ref_url,operator_type_id,(select name from d_general where id=operator_type_id) as operatorName from d_query_para where query_para_group_id={grp.id} and is_visible=1 and operator_type_id is not null";
var paras = new DAL.d_query_para_dal().FindListBySql <WorkflowConditionParaDto>(sql);
sql = $"select distinct(col_comment) from d_query_para where query_para_group_id={grp.id} and is_visible=1 and operator_type_id is not null";
var cdts = new DAL.d_query_para_dal().FindListBySql <string>(sql);
foreach (var cdt in cdts)
{
var dtos = (from prm in paras where cdt.Equals(prm.description) select prm).ToList();
foreach (var dto in dtos)
{
if (dto.data_type == (int)DicEnum.QUERY_PARA_TYPE.DROPDOWN ||
dto.data_type == (int)DicEnum.QUERY_PARA_TYPE.MULTI_DROPDOWN ||
dto.data_type == (int)DicEnum.QUERY_PARA_TYPE.DYNAMIC)
{
var dt = new DAL.d_query_para_dal().ExecuteDataTable(dto.ref_sql);
if (dt != null)
{
dto.values = new List <DictionaryEntryDto>();
foreach (System.Data.DataRow row in dt.Rows)
{
dto.values.Add(new DictionaryEntryDto(row[0].ToString(), row[1].ToString()));
}
}
}
}
parasList.Add(dtos);
}
return(parasList);
}
