新增文章

文章标题分类内容

var aUserId = aContext.UserId.ToString();            // 当前用户 id
         var aFOrgId = aContext.CurrentOrganizationInfo.ID;   // 当前组织 id

#region|  取得：系统设置          |

var aSql = $@"/*dialect*/
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- 读取：系统设置

select * from (
   --------------------------------------------------------------------------------------------
      select  FOrgId

,a1.value('(Seq)[1]', 'int')                FSeq
         ,a1.value('(FUserId/User/Id)[1]', 'int')    FUserId

,a1.value('(FUserId/User/Name)[1]', 'nvarchar(50)')  FUserName

,a1.value('(FType)[1]', 'nvarchar(50)')  FType
         ,a1.value('(FValue)[1]', 'int')          FValue

from t_Bas_SysParameter

cross apply  FParameters.nodes('/FHead/FEntity/FEntity')  T(a1)

where FParameterObjId = 'aGsf_SysSet'
   --------------------------------------------------------------------------------------------
   ) a where FUserId = {aUserId} and FOrgId in ( 0,{aFOrgId} )
   
   order by FOrgId desc

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
";
         DynamicObjectCollection aTable1 = DBServiceHelper.ExecuteDynamicObject(aContext, aSql);
         #endregion