用友u8V13提示不存在的年度
發(fā)布時間：2025/9/29 10:51:00 作者：Admin 閱讀：31
廣告：
select * from UA_Period where cAcc_Id='008' and iYear=2025
INSERT [dbo].[UA_Period] ([cAcc_Id], [iYear], [iId], [dBegin], [dEnd], [bIsDelete]) VALUES (N'999', 2025, 1, CAST(N'2025-01-01T00:00:00.000' AS DateTime), CAST(N'2025-01-31T00:00:00.000' AS DateTime), 0) INSERT [dbo].[UA_Period] ([cAcc_Id], [iYear], [iId], [dBegin], [dEnd], [bIsDelete]) VALUES (N'999', 2025, 2, CAST(N'2025-02-01T00:00:00.000' AS DateTime), CAST(N'2025-02-28T00:00:00.000' AS DateTime), 0) INSERT [dbo].[UA_Period] ([cAcc_Id], [iYear], [iId], [dBegin], [dEnd], [bIsDelete]) VALUES (N'999', 2025, 3, CAST(N'2025-03-01T00:00:00.000' AS DateTime), CAST(N'2025-03-31T00:00:00.000' AS DateTime), 0) INSERT [dbo].[UA_Period] ([cAcc_Id], [iYear], [iId], [dBegin], [dEnd], [bIsDelete]) VALUES (N'999', 2025, 4, CAST(N'2025-04-01T00:00:00.000' AS DateTime), CAST(N'2025-04-30T00:00:00.000' AS DateTime), 0) INSERT [dbo].[UA_Period] ([cAcc_Id], [iYear], [iId], [dBegin], [dEnd], [bIsDelete]) VALUES (N'999', 2025, 5, CAST(N'2025-05-01T00:00:00.000' AS DateTime), CAST(N'2025-05-31T00:00:00.000' AS DateTime), 0) INSERT [dbo].[UA_Period] ([cAcc_Id], [iYear], [iId], [dBegin], [dEnd], [bIsDelete]) VALUES (N'999', 2025, 6, CAST(N'2025-06-01T00:00:00.000' AS DateTime), CAST(N'2025-06-30T00:00:00.000' AS DateTime), 0) INSERT [dbo].[UA_Period] ([cAcc_Id], [iYear], [iId], [dBegin], [dEnd], [bIsDelete]) VALUES (N'999', 2025, 7, CAST(N'2025-07-01T00:00:00.000' AS DateTime), CAST(N'2025-07-31T00:00:00.000' AS DateTime), 0) INSERT [dbo].[UA_Period] ([cAcc_Id], [iYear], [iId], [dBegin], [dEnd], [bIsDelete]) VALUES (N'999', 2025, 8, CAST(N'2025-08-01T00:00:00.000' AS DateTime), CAST(N'2025-08-31T00:00:00.000' AS DateTime), 0) INSERT [dbo].[UA_Period] ([cAcc_Id], [iYear], [iId], [dBegin], [dEnd], [bIsDelete]) VALUES (N'999', 2025, 9, CAST(N'2025-09-01T00:00:00.000' AS DateTime), CAST(N'2025-09-30T00:00:00.000' AS DateTime), 0) INSERT [dbo].[UA_Period] ([cAcc_Id], [iYear], [iId], [dBegin], [dEnd], [bIsDelete]) VALUES (N'999', 2025, 10, CAST(N'2025-10-01T00:00:00.000' AS DateTime), CAST(N'2025-10-31T00:00:00.000' AS DateTime), 0) INSERT [dbo].[UA_Period] ([cAcc_Id], [iYear], [iId], [dBegin], [dEnd], [bIsDelete]) VALUES (N'999', 2025, 11, CAST(N'2025-11-01T00:00:00.000' AS DateTime), CAST(N'2025-11-30T00:00:00.000' AS DateTime), 0) INSERT [dbo].[UA_Period] ([cAcc_Id], [iYear], [iId], [dBegin], [dEnd], [bIsDelete]) VALUES (N'999', 2025, 12, CAST(N'2025-12-01T00:00:00.000' AS DateTime), CAST(N'2025-12-31T00:00:00.000' AS DateTime), 0)
廣告：
相關(guān)文章
