/// <summary>
/// 生成条件的json字符串
/// </summary>
/// <param name="workflowObj"></param>
/// <param name="paras"></param>
/// <returns></returns>
private string GetConditionJson(DicEnum.WORKFLOW_OBJECT workflowObj, List <WorkflowConditionParaDto> paras)
{
StringBuilder json = new StringBuilder("[");
var form = Request.Form;
for (int i = 0; i < 5; i++)
{
if (string.IsNullOrEmpty(form["def1pro" + i]) || string.IsNullOrEmpty(form["def1oper" + i]))
{
continue;
}
var para = paras.Find(_ => _.description.Equals(form["def1pro" + i]) && _.operator_type_id.Equals(form["def1oper" + i]));
if (para == null)
{
continue;
}
// 根据不同的条件定义类型获取不同类型的值
if (para.data_type == (int)DicEnum.QUERY_PARA_TYPE.DROPDOWN)
{
json.Append("{\"col_name\":\"" + para.col_name + "\",\"operator\":\""
+ para.operator_type_id + "\",\"value\":\"" + form["def1val" + i + "0"] + "\"},");
}
else if (para.data_type == (int)DicEnum.QUERY_PARA_TYPE.MULTI_DROPDOWN)
{
json.Append("{\"col_name\":\"" + para.col_name + "\",\"operator\":\""
+ para.operator_type_id + "\",\"value\":\"" + form["def1val" + i + "2"] + "\"},");
}
else if (para.data_type == (int)DicEnum.QUERY_PARA_TYPE.SINGLE_LINE || para.data_type == (int)DicEnum.QUERY_PARA_TYPE.NUMBER)
{
json.Append("{\"col_name\":\"" + para.col_name + "\",\"operator\":\""
+ para.operator_type_id + "\",\"value\":\"" + form["def1val" + i + "1"] + "\"},");
}
else if (para.data_type == (int)DicEnum.QUERY_PARA_TYPE.CHANGED)
{
json.Append("{\"col_name\":\"" + para.col_name + "\",\"operator\":\""
+ para.operator_type_id + "\",\"value\":\"1\"},");
}
}
if (json.ToString().Equals("["))
{
return(null);
}
json.Remove(json.Length - 1, 1);
json.Append("]");
return(json.ToString());
}
/// <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>
/// 生成事件的json字符串
/// </summary>
/// <param name="workflowObj"></param>
/// <param name="paras"></param>
/// <returns></returns>
private string GetEventJson(DicEnum.WORKFLOW_OBJECT workflowObj, List <WorkflowConditionParaDto> paras)
{
StringBuilder json = new StringBuilder("[");
var formData = Request.Form;
foreach (var para in paras)
{
if (string.IsNullOrEmpty(formData["ck" + para.id]) || (!formData["ck" + para.id].Equals("on")))
{
continue; // 未选择此事件
}
if (para.data_type == (int)DicEnum.QUERY_PARA_TYPE.DROPDOWN)
{
if (string.IsNullOrEmpty(formData["slt" + para.id])) // 未选择下拉框值
{
continue;
}
json.Append("{\"event\":\"" + para.col_name + "\",\"value\":\"" + formData["slt" + para.id] + "\"},");
}
else if (para.data_type == (int)DicEnum.QUERY_PARA_TYPE.DYNAMIC)
{
if (string.IsNullOrEmpty(formData["slt" + para.id]) || string.IsNullOrEmpty(formData["ipt" + para.id])) // 未选择下拉框值或未输入文本框值
{
continue;
}
json.Append("{\"event\":\"" + para.col_name + "\",\"value\":\"" + formData["ipt" + para.id] + "\",\"unit\":\"" + formData["slt" + para.id] + "\"},");
}
else if (para.data_type == (int)DicEnum.QUERY_PARA_TYPE.BOOLEAN)
{
json.Append("{\"event\":\"" + para.col_name + "\",\"value\":\"1\"},");
}
}
if (json.ToString().Equals("["))
{
return(null);
}
json.Remove(json.Length - 1, 1);
json.Append("]");
return(json.ToString());
}
private string GetUpdateJson(DicEnum.WORKFLOW_OBJECT workflowObj, List <WorkflowConditionParaDto> paras)
{
StringBuilder json = new StringBuilder("[");
var form = Request.Form;
for (int i = 0; i < 5; i++)
{
if (string.IsNullOrEmpty(form["def2pro" + i]))
{
continue;
}
var para = paras.Find(_ => form["def2pro" + i].Equals(_.id.ToString()));
if (para == null)
{
continue;
}
// 根据不同的条件定义类型获取不同类型的值
if (para.data_type == (int)DicEnum.QUERY_PARA_TYPE.DROPDOWN)
{
json.Append("{\"col_name\":\"" + para.col_name + "\",\"value\":\""
+ form["def2val" + i + "0"] + "\"},");
}
else if (para.data_type == (int)DicEnum.QUERY_PARA_TYPE.DYNAMIC)
{
json.Append("{\"col_name\":\"" + para.col_name + "\",\"value\":\""
+ form["def2val" + i + "1"] + "\",\"refer\":\"" + form["def2val" + i + "0"] + "\"},");
}
}
if (json.ToString().Equals("["))
{
return(null);
}
json.Remove(json.Length - 1, 1);
json.Append("]");
return(json.ToString());
}
/// <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);
}
