public string BuildAccessTypeString(string operationCode, string userCode, string codes, string createUserColumnName) { string text = ""; string functionStructureParentCode = SystemManageDAO.GetFunctionStructureParentCode(operationCode); string queryString = string.Format(" select accessRange.groupCode,SystemGroup.FullID,RoleLevel from accessRange left join SystemGroup on accessRange.GroupCode=SystemGroup.GroupCode where OperationCode = '{0}' and (( AccessRangeType=0 and relationCode = '{1}' ) or ( AccessRangeType=1 and relationCode in ( {2} ) ) ) ", new object[] { operationCode, userCode, codes }); QueryAgent agent = new QueryAgent(); DataSet set = agent.ExecSqlForDataSet(queryString); agent.Dispose(); foreach (DataRow row in set.Tables[0].Rows) { if (!row.IsNull("FullID")) { string text4 = row["FullID"].ToString(); int num = 0; if (!row.IsNull("RoleLevel")) { num = (int)row["RoleLevel"]; } if (num == 0) { text = text + string.Format("or (CaseCode in ( Select a2.CaseCode from workflowCase a2 where a2.ProcedureCode in(select c1.ProcedureCode from WorkFlowProcedure c1 where isnull(c1.SysType, '') = '') and exists(select 1 from SystemGroup a1 where a1.GroupName in\t(dbo.GetProcedureNameByCaseCode(a2.CaseCode))\tand a1.ParentCode in (select a.GroupCode from SystemGroup a where a.GroupName =dbo.GetProjectNameByCaseCode(a2.CaseCode) and a.classcode='{1}') and a1.FullID like '{0}%'))\t)", text4, functionStructureParentCode); } } } return(text); }
/// <summary> /// 原先的到点 /// </summary> /// <param name="operationCode"></param> /// <param name="userCode"></param> /// <param name="stationCodes"></param> /// <param name="tableName"></param> /// <param name="keyColumnName"></param> /// <returns></returns> public static string BuildAccessRangeString(string operationCode, string userCode, string stationCodes, string tableName, string keyColumnName) { string classCode = SystemManageDAO.GetFunctionStructureParentCode(operationCode); string codes = BuildStationCodeString(stationCodes); return(BuildAccessResourceString(operationCode, classCode, userCode, codes, tableName, keyColumnName)); }
public static string BuildAccessRangeStringNoGroupCode(string operationCode, string userCode, string stationCodes, string tableName, string keyColumnName, string typeColumnName, string createUserColumnName) { string classCode = SystemManageDAO.GetFunctionStructureParentCode(operationCode); string codes = BuildStationCodeString(stationCodes); string text3 = BuildAccessResourceString(operationCode, classCode, userCode, codes, tableName, keyColumnName, createUserColumnName); string text4 = BuildAccessTypeStringNoGroupCode(operationCode, classCode, userCode, codes, tableName, keyColumnName, typeColumnName, createUserColumnName); return(string.Format("( {0} {1} )", text3, text4)); }