请示类别要增加  维修申请   维修付款申请

维修申请的时候可以同步申请费用

维修申请  审批的时候要加上追责  责任人  金额

分类  办公设备、生产设备、车辆、其他

菜单  设备管理   14     =》设备管理 01  =》  设备分类   /Pages/Property/ShebeiCateList.aspx   04    一堆用例

                                                          =》设备管理 /Pages/Property/ShebeimanageList.aspx  02 一堆用例
                                                          =>  维修管理  /Pages/Property/ShebeiWeixiuList.aspx  03 一堆用例

字典表   工作计划性质   18   设备维修申请     19 维修付款申请  完成

USE [ECTEST_NEW]
GO

/****** Object:  Table [dbo].[OA_ShebeiCate]    Script Date: 2025/9/28 9:02:12 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[OA_ShebeiCate](
 [Keyid] [int] IDENTITY(1,1) NOT NULL,
 [MemberId] [uniqueidentifier] NULL,
 [Name] [varchar](50) NULL,
 [Status] [int] NULL,
 [LastUpdateTime] [datetime] NULL,
 [Operator] [varchar](20) NULL,
 [Remark] [varchar](200) NULL,
 CONSTRAINT [PK_OA_ShebeiCate] PRIMARY KEY CLUSTERED
(
 [Keyid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

 USE [ECTEST_NEW]
GO

/****** Object:  Table [dbo].[OA_ShebeiManage]    Script Date: 2025/9/28 9:45:15 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[OA_ShebeiManage](
 [Keyid] [int] IDENTITY(1,1) NOT NULL,
 [MemberId] [uniqueidentifier] NULL,
 [CateId] [int] NULL,
 [Name] [nvarchar](50) NULL,
 [Price] [money] NULL,
 [Anzhuangdidian] [nvarchar](20) NULL,
 [QiyongTime] [datetime] NULL,
 [Status] [int] NULL,
 [Zerenren] [int] NULL,
 [ZerenrenName] [nvarchar](20) NULL,
 [LastUpdateTime] [datetime] NULL,
 [Operator] [nvarchar](20) NULL,
 [Remark] [nvarchar](500) NULL,
 CONSTRAINT [PK_OA_ShebeiManage] PRIMARY KEY CLUSTERED
(
 [Keyid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

 USE [ECTEST_NEW]
GO

/****** Object:  Table [dbo].[OA_ShebeiWeixiu]    Script Date: 2025/9/28 9:45:15 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[OA_ShebeiWeixiu](
 [Keyid] [int] IDENTITY(1,1) NOT NULL,
 [MemberId] [uniqueidentifier] NULL,
 [ShebeiId] [int] NULL,
 [WeixiuTime] [datetime] NULL,
 [CateId] [int] NULL,
 [Anzhuangdidian] [nvarchar](20) NULL,
 [Name] [nvarchar](50) NULL,
 [Remark] [nvarchar](500) NULL,
 [WeixiuPrice] [money] NULL,
 [Zerenren] [int] NULL,
 [ZerenrenName] [nvarchar](20) NULL,
 [DanzePrice] [money] NULL,

 [WeixiuShebeiId] [int] NULL,
 [FukuanShebeiId] [int] NULL,
 [FukuanshenqingId] [int] NULL,
 [Shifoufufei] [int] NULL,
 [CreateTime] [datetime] NULL,
 [Creator] [nvarchar](20) NULL,
 [LastUpdateTime] [datetime] NULL,
 [Operator] [nvarchar](20) NULL,

 CONSTRAINT [PK_OA_ShebeiWeixiu] PRIMARY KEY CLUSTERED
(
 [Keyid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

update   [OA_Kaipiaoshenqing] set Huikuanmoney = Kehumoney  where  [Shenqingleixing]='预付款开票';

-- 表结构：employees(id, dept_id, salary, dept_avg_salary)  where  a.KaipiaoshenqingId =
UPDATE [OA_Kaipiaoshenqing]
SET  Huikuanmoney = aaa.PayedMoney

from  (

select eoe.KaipiaoshenqingId ,sum(pt.PayedMoney) PayedMoney  from  [EC_OrderExtend] eoe inner join Pay_TradingSingle pt    on    eoe.Keyid = pt.OrderId  GROUP BY eoe.KaipiaoshenqingId

) as aaa   where [OA_Kaipiaoshenqing].Keyid = aaa.KaipiaoshenqingId and     [OA_Kaipiaoshenqing].[Shenqingleixing]='订单开票';