| | |
|---|
| | | var sortName = string.IsNullOrEmpty(model.sortName) ? "a.PAGE_GROUP" : model.sortName; |
|---|
| | | var keyWhere = model.keyWhere; |
|---|
| | | string keyType = model.keyType; |
|---|
| | | string keyWord = model.keyWord; |
|---|
| | | var sbSql = new StringBuilder(); |
|---|
| | | sbSql.Append(" SELECT * FROM "); |
|---|
| | | sbSql.Append(" (SELECT N'(' +[Org].[FNumber] + N')' +[Org].[NAME] AS [FSubsidiary2] ,"); |
|---|
| | |
|---|
| | | sbSql.Append(" [f].[supp_name] AS [SuppLierId] , [g].[departmentname] AS [department2] ,"); |
|---|
| | | sbSql.Append(" ( CASE WHEN ( [a].[is_ng] = N'A' ) THEN N'正常' ELSE N'禁用' END ) AS [IsNg] "); |
|---|
| | | sbSql.Append(", [a].*,ROW_NUMBER() OVER(ORDER BY org.FNumber asc ,a.depot_code asc) AS RowIndex "); |
|---|
| | | if (string.IsNullOrEmpty(keyWord)) |
|---|
| | | { |
|---|
| | | sbSql.Append(",'' as kcQty"); |
|---|
| | | } |
|---|
| | | else |
|---|
| | | { |
|---|
| | | sbSql.Append(", isnull((select top 1 库存对比 from [dbo].[即时库存差异表] where 物料ID=" + keyWord + " and 仓库ID=[a].[depot_id]),'('+a.depot_name+')0/0') AS [kcQty] "); |
|---|
| | | } |
|---|
| | | if (string.IsNullOrEmpty(keyType)) |
|---|
| | | { |
|---|
| | | sbSql.Append(",cast(0 as bit) as chkInt"); |
|---|
