public Tuple <DataTable, DataTable> GetSplc(SPLCEntity Data)
{
//找当前应该是那个节点数据
//要根据当前操作人对应的角色组找审批流程以及节点
if (Data.MENUID.IsEmpty())
{
throw new LogicException("请确认查找审批流程的菜单号信息!");
}
string sql = $@"select JDID,JDNAME from";
sql += " SPLCDEFD A,SPLCJD B WHERE A.BILLID=B.BILLID AND A.STATUS=2 ";
if (employee.Id.ToInt() > 0)
{
sql += " and exists(select 1 from USER_ROLE C where C.ROLEID=B.ROLEID and C.USERID=" + employee.Id + ")";
}
sql += (" AND A.MENUID= " + Data.MENUID);
DataTable splc = DbHelper.ExecuteTable(sql);
//找最后一个审批数据
var i = 1;
string sql1 = $@"select JDID from";
sql1 += " SPLCJG_MENU WHERE 1=1 ";
sql1 += (" AND MENUID= " + Data.MENUID);
sql1 += (" AND BILLID= " + Data.JLBH);
sql1 += " order by CLSJ desc";
DataTable spBillJg = DbHelper.ExecuteTable(sql1);
if (spBillJg.Rows.Count > 0)
{
i = spBillJg.Rows[0][0].ToString().ToInt();
}
string sqlxz = $@"select JDID,JGID,JGTYPE,JGMC from";
sqlxz += " SPLCDEFD A,SPLCJG B WHERE A.BILLID=B.BILLID AND A.STATUS=2 ";
if (employee.Id.ToInt() > 0)
{
sqlxz += " and exists(select 1 from USER_ROLE C,SPLCJD D";
sqlxz += " where A.BILLID=D.BILLID and C.ROLEID=D.ROLEID and C.USERID=" + employee.Id + ")";
}
sqlxz += (" AND A.MENUID= " + Data.MENUID);
sqlxz += (" AND B.JDID= " + i);
DataTable splxz = DbHelper.ExecuteTable(sqlxz);
splxz.NewEnumColumns <审批结果类型>("JGTYPE", "JGTYPENAME");
return(new Tuple <DataTable, DataTable>(
splc,
splxz
));
}
//返回节点数据，并且返回当前节点要面临的操作步骤
public UIResult Srchsplc(SPLCEntity Data)
{
var res = service.XtglService.GetSplc(Data);
return(new UIResult(
new
{
splc = res.Item1,
splxz = res.Item2
}
));
}
