公司最近在实施ERP，公司也买了不少站点数，但在实施使用过程中，还是经常遇到提示站点数限制的提示。一直想写个查询数据的客户端软件。由于一直忙于出口模块的二次开发，所以软件迟迟没能写好。但我尽可能早些能把这个软件写出来，也与有此需要的朋友共同分享。
现已整理了一些基础资料的SQL语句，我没有取出基本资料的所有字段，只取出了公司需要的部分字段。大家可根据金蝶BOS中的字段描述工具，在此基础上稍作修改，即可使用。
基础资料的内码：
客户：1
部门：2
职员：3
物料：4
仓库：5
供应商：8
客户：
SELECT dbo.t_Item.FNumber AS 代码, dbo.t_Item.FName AS 名称, dbo.t_Item.FFullName AS 全名, dbo.t_Item.FItemID as 内码, dbo.t_Item.FParentID AS 类代码, dbo.t_Item.FUnUsed AS 是否禁用 FROM dbo.t_Item WHERE (dbo.t_Item.FItemClassID = 1) order by dbo.t_Item.FNumber
部门：
SELECT dbo.t_Item.FNumber AS 代码, dbo.t_Item.FName AS 名称, dbo.t_Item.FFullName AS 全名, dbo.t_Item.FItemID as 内码, dbo.t_Item.FParentID AS 类代码, dbo.t_Item.FUnUsed AS 是否禁用 FROM dbo.t_Item WHERE (dbo.t_Item.FItemClassID =2) order by dbo.t_Item.FNumber
职员：
SELECT dbo.t_Item.FItemID AS 内码, dbo.t_Item.FParentID AS 类代码, dbo.t_Item.FUnUsed AS 是否禁用, dbo.t_Item.FNumber AS 代码, dbo.t_Item.FName AS 名称, dbo.t_Item.FFullName AS 全名, dbo.t_Emp.FMobilePhone AS 移动电话, dbo.t_Department.FNumber AS 部门代码, dbo.t_Department.FName AS 部门名称, CASE WHEN dbo.t_Emp.FGender = 1068 THEN '男' WHEN dbo.t_Emp.FGender = 1069 THEN '女' END AS 性别, dbo.t_Emp.FBirthday AS 生日, dbo.t_Emp.FEmail AS 邮件地址, dbo.t_Emp.FAddress AS 住址, dbo.t_Emp.FPhone AS 电话, dbo.t_Emp.FID AS 身份证号码, dbo.t_Emp.FDuty AS 职务, dbo.t_Emp.FDegree AS 文化程度, dbo.t_Emp.FHireDate AS 入职日期, dbo.t_Emp.FLeaveDate AS 离职日期, dbo.t_Emp.FEmpGroupID AS 职员组代码, dbo.t_Emp.FItemDepID AS 部门号, dbo.t_Emp.FNote AS 备注, dbo.t_Emp.FParentID AS 上级代码, dbo.t_Emp.FDepartmentID AS 部门内码, dbo.t_Emp.FEmpGroup AS 职员组名称, dbo.t_Emp.FJobTypeID AS 工种 FROM dbo.t_Item INNER JOIN dbo.t_Emp ON dbo.t_Item.FItemID = dbo.t_Emp.FItemID INNER JOIN dbo.t_Department ON dbo.t_Emp.FDepartmentID = dbo.t_Department.FItemID WHERE (dbo.t_Item.FItemClassID =3) order by dbo.t_Item.FNumber
物料：
SELECT dbo.t_ICItem.FNumber AS 代码, dbo.t_ICItem.FName AS 名称, dbo.t_ICItem.FFullName AS 全名, dbo.t_ICItem.FModel AS 规格型号, CASE WHEN dbo.t_ICItem.FErpClsID = 1 THEN '外购' WHEN dbo.t_ICItem.FErpClsID = 2 THEN '自制' WHEN dbo.t_ICItem.FErpClsID = 3 THEN '委外加工' WHEN dbo.t_ICItem.FErpClsID = 5 THEN '虚拟件' END AS 物料属性, CASE WHEN dbo.t_ICItem.FUseState = 341 THEN '使用' WHEN dbo.t_ICItem.FUseState = 342 THEN '历史资料' WHEN dbo.t_ICItem.FUseState = 343 THEN '将使用' WHEN dbo.t_ICItem.FUseState = 344 THEN '逐步淘汰' END AS 使用状态, CASE WHEN dbo.t_ICItem.FTrack = 76 THEN '加权平均法' WHEN dbo.t_ICItem.FTrack =77 THEN '移动平均法' WHEN dbo.t_ICItem.FTrack = 78 THEN '先进先出法' WHEN dbo.t_ICItem.FTrack = 79 THEN '后进先出法' WHEN dbo.t_ICItem.FTrack = 80 THEN '分批认定法(批内移动平均法)' WHEN dbo.t_ICItem.FTrack = 81 THEN '计划成本法' WHEN dbo.t_ICItem.FTrack = 20308 THEN '分批认定法(批内先进先出法)' END AS 计价方法, dbo.t_Item.FItemID as 内码, dbo.t_Item.FParentID AS 类代码, dbo.t_Item.FUnUsed AS 是否禁用 FROM dbo.t_Item INNER JOIN dbo.t_ICItem ON dbo.t_Item.FItemID = dbo.t_ICItem.FItemID WHERE (dbo.t_Item.FItemClassID = 4) order by dbo.t_ICItem.FNumber
仓库：
SELECT dbo.t_Item.FNumber AS 代码, dbo.t_Item.FName AS 名称, dbo.t_Item.FFullName AS 全名, dbo.t_Item.FItemID as 内码, dbo.t_Item.FParentID AS 类代码, dbo.t_Item.FUnUsed AS 是否禁用 FROM dbo.t_Item WHERE (dbo.t_Item.FItemClassID = 5) order by dbo.t_Item.FNumber
供应商：
SELECT dbo.t_Item.FNumber AS 代码, dbo.t_Item.FName AS 名称, dbo.t_Item.FFullName AS 全名, dbo.t_Item.FItemID as 内码, dbo.t_Item.FParentID AS 类代码, dbo.t_Item.FUnUsed AS 是否禁用 FROM dbo.t_Item WHERE (dbo.t_Item.FItemClassID =8) order by dbo.t_Item.FNumber
我已验证使用这些程序。最近我会增加其它基础资料SQL语句。希望能给大家提供些帮助。