zhengcaioa.git - Gitblit

			@@ -79,7 +79,7 @@
			go

			--çµè¯å¡ç±»åå®ä¹
			insert into [adm_goods_classify] values('d309d1af-5086-453a-b5a2-58b344dfff97','çµè¯å¡','A','e4c93811-b9b1-4998-89f5-c416ebab0c07',getdate(),'e4c93811-b9b1-4998-89f5-c416ebab0c07',getdate(),'04')
			insert into [adm_goods_classify] values('d309d1af-5086-453a-b5a2-58b344dfff97','çµè¯å¡','A','e4c93811-b9b1-4998-89f5-c416ebab0c07',getdate(),'e4c93811-b9b1-4998-89f5-c416ebab0c07',getdate(),'04');
			--è¡¥è´´åå¸å®ä¹
			insert into [sys_code] values('107bc4e5-f13a-4d25-bd47-e4b1e61aed8a','t_sim_bind','cardpro','çµè¯è¡¥è´´','A','e4c93811-b9b1-4998-89f5-c416ebab0c07',getdate(),'e4c93811-b9b1-4998-89f5-c416ebab0c07',getdate())

			@@ -103,11 +103,25 @@
			--çµè¯è´¹è®°å½æç»
			insert into [plt_page] values('5E973843-7EB4-41A6-B49B-192208647B2C','1','çµè¯è´¹ç¨è®°å½','',4,'/SimCost/Index/','01','M','967b0bdd-cd5d-4660-8c72-7f744c07751b','',0,'A','e4c93811-b9b1-4998-89f5-c416ebab0c07',getdate(),'e4c93811-b9b1-4998-89f5-c416ebab0c07',getdate())

			create view v_sim_cost as
			select a.[id],[sim_id],[user_id],[allow_amount],[bill_amount],[bill_year],[bill_month],[status],[up_time]
			,b.goods_name,c.user_name
			FROM [t_sim_cost] a inner join adm_goods_manage b on a.sim_id =b.Id
			left join plt_user c on a.user_id=c.Id
			go
			USE [zhengcaioa]
			GO

			/**** Object: View [dbo].[v_sim_cost] Script Date: 2021/6/21 9:13:40 ****/
			SET ANSI_NULLS ON
			GO

			SET QUOTED_IDENTIFIER ON
			GO

			create view [dbo].[v_sim_cost] as
			SELECT a.id, a.sim_id, a.user_id, a.allow_amount, a.bill_amount, a.amount, a.bill_year, a.bill_month, a.accounted_time, a.status,
			a.up_time, b.goods_name AS simcard, c.user_name AS username
			FROM dbo.t_sim_cost AS a INNER JOIN
			dbo.adm_goods_manage AS b ON a.sim_id = b.Id LEFT OUTER JOIN
			dbo.plt_user AS c ON a.user_id = c.Id
			GO




			>>>>>>> a6b6b4303483395bf6ff745f5abf171552afae38