:::tip{title="提示"}
桌面OA 缺少脚本 请更新
:::


![image.png](/static/img/69340a85a361e27a34d9dce0310deaff.image.webp)

```
--测试代码
exec sp_executesql N'SELECT 
    [Extent1].[use_UpdatePosDayAfter] AS [use_UpdatePosDayAfter], 
    [Extent1].[use_id] AS [use_id], 
    [Extent1].[use_level] AS [use_level], 
    [Extent1].[use_name] AS [use_name], 
    [Extent1].[emp_id] AS [emp_id], 
    [Extent2].[emp_name] AS [emp_name], 
    [Extent2].[dpt_id2] AS [dpt_id2], 
    [Extent2].[pst_id] AS [pst_id], 
    [Extent1].[use_pws] AS [use_pws], 
    [Extent1].[use_shp] AS [use_shp], 
    [Extent1].[use_UpdatePosDay] AS [use_UpdatePosDay], 
    [Extent1].[sys_valid] AS [sys_valid]
    FROM  [dbo].[BAS_USER] AS [Extent1]
    LEFT OUTER JOIN [dbo].[BAS_EMP] AS [Extent2] ON [Extent1].[emp_id] = [Extent2].[emp_id]
    WHERE (((UPPER(LTRIM(RTRIM([Extent1].[use_id])))) = (UPPER(LTRIM(RTRIM(@p__linq__0))))) OR ((UPPER(LTRIM(RTRIM([Extent1].[use_id]))) IS NULL) AND (UPPER(LTRIM(RTRIM(@p__linq__0))) IS NULL))) AND ((CASE WHEN (1 = @p__linq__1) THEN CASE WHEN (1 = [Extent1].[sys_valid]) THEN cast(1 as bit) WHEN (1 <> [Extent1].[sys_valid]) THEN cast(0 as bit) END ELSE cast(1 as bit) END) = 1)',N'@p__linq__0 nvarchar(4000),@p__linq__1 bit',@p__linq__0=N'hbd',@p__linq__1=1
```


ALTER TABLE BAS_USER ADD use_UpdatePosDayAfter [int] NOT NULL




![image.png](/static/img/cfb53ed63a12267d8b5d9610fe66bd09.image.webp)
	update   BAS_USER set use_UpdatePosDayAfter=0
        
        
        
```
	ALTER TABLE BAS_USER ADD use_UpdatePosDayAfter [int] NOT NULL

	update   BAS_USER set use_UpdatePosDayAfter=0


	ALTER TABLE dat_ckfc ADD  [wg_dhd_id_new] [nvarchar](50) NULL
	
	ALTER TABLE dat_ckpf ADD  [wg_dhd_id_new] [nvarchar](50) NULL
		ALTER TABLE dat_ckpt ADD  [wg_dhd_id_new] [nvarchar](50) NULL

```

9.0部署2025.11.10报错

:::tip{title="提示"}
传递给系统调用的数据区域太小。
:::




![image.png](/static/img/a9748e6fb708ab4b3d4c8875adf46bb5.image.webp)

![image.png](/static/img/290a97de35e8308360aaa702e0e1db07.image.webp)

:::note{title="注"}
WIN11 打印小票提示这个，驱动有问题，删除打印机重新安装一下即可
:::

传递给系统调用的数据区域太小

:::tip{title="提示"}
决策分析：大数据查询-一直转圈圈

:::




![image.png](/static/img/b1520c9f22ef3ac469ce4dd0dc4e204e.image.webp)

:::tip{title="提示"}
排查服务器端已经生产了查询文件，但是就是不下载

![image.png](/static/img/059aba74263d91af4ab2b39b834de087.image.webp)


解决：更改IIS根目录的Web.config文件

![image.png](/static/img/3aff0f546f70024fd78485724f399d85.image.webp)
:::

大数据查询-一直转圈圈

:::tip{title="提示"}
选择款式--筛选字段顺序更改？

:::



![613bf87719c0197eb6d7f08f7bc5a2cb.png](/static/img/4b4f6c223a992037cafda80a92a9a8d7.613bf87719c0197eb6d7f08f7bc5a2cb.webp)


![9fe0b06aed9241257806b4780589f5c0.png](/static/img/a4c35e4969b650998f386e1113ee3197.9fe0b06aed9241257806b4780589f5c0.webp)

选择款式--筛选字段顺序更改

:::tip{title="提示"}
无效、有效会员卡
:::


一、登录后台系统

![image.png](/static/img/bb486ac8c2c7b65427f390ee5fd0ce90.image.webp)

二、会员管理---会员管理--VIP卡管理

![image.png](/static/img/de94f9e1caa447595d8ed16675387fdd.image.webp)
三、搜索会员卡--状态---有效/无效即可
![image.png](/static/img/220f0b8c02e1995b15b954d3d12c0780.image.webp)