-- ´´½¨É¾³ýµÄ´æ´¢¹ý³Ì

CREATE PROCEDURE DeleteInterfacerecord	--´æ´¢¹ý³ÌÃû³Æ
    @MonthsAgo INT	--´æ´¢¹ý³Ì²ÎÊý
AS
BEGIN
    DECLARE @CutOffDate DATE = DATEADD(MONTH, -@MonthsAgo, GETDATE()); --ÉùÃ÷²ÎÊý
 
    DELETE FROM dt_Interfacerecord	--Êý¾Ý¿â±íÃû
    WHERE interface_createtime < @CutOffDate; --ÅжÏÌõ¼þµÄÁÐÃû
END
GO
--	´´½¨Ìí¼ÓµÄ´æ´¢¹ý³Ì
CREATE PROCEDURE Add_inventory
    @SN NVARCHAR(255),
    @Name NVARCHAR(255),
		@FigureNumber NVARCHAR(255),
    @area NVARCHAR(15),
		@HeatNumber NVARCHAR(50),
    @BilletNumber INT,
		@OnlineTime datetime,
    @Operator NVARCHAR(50),
		@stationCode NVARCHAR(30),
    @jobID NVARCHAR(255),
		@ID uniqueidentifier,
    @remark NVARCHAR(max)
AS
BEGIN
    INSERT INTO dt_inventory (SN, Name,FigureNumber,area,HeatNumber,BilletNumber,OnlineTime,Operator,remark,stationCode,jobID,ID)
    VALUES (@SN, @Name,@FigureNumber,@area,@HeatNumber,@BilletNumber,@OnlineTime,@Operator,@remark,@stationCode,@jobID,@ID)
 
    -- ·µ»ØвåÈëµÄÓû§ID
    --SELECT SCOPE_IDENTITY() AS NewUserID;
END
GO

-- ɾ³ýÃûΪ YourProcedureName µÄ´æ´¢¹ý³Ì
--IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Add_inventory]') AND type in (N'P', N'PC'))
--DROP PROCEDURE [dbo].Add_inventory;

-- ²éѯËùÓд洢¹ý³Ì
--SELECT * FROM information_schema.Routines WHERE ROUTINE_TYPE = 'PROCEDURE';

--Ö´Ðв»ÐèÒª²ÎÊýµÄ´æ´¢¹ý³Ì
--EXEC DeleteInterfacerecord

--Ö´Ðдø²ÎÊýµÄ´æ´¢¹ý³Ì
--EXEC DeleteInterfacerecord @MonthsAgo = 6

--ʹÓÃsp_executesql´æ´¢¹ý³Ì£¬ÕâÖÖ·½·¨¿ÉÒÔÌṩ¶îÍâµÄ²ÎÊýÉùÃ÷ºÍÀàÐͼì²é£º
--DECLARE @Param1 NVARCHAR(100) = 'Value1', @Param2 INT = 123
--EXEC sp_executesql
--    N'EXEC YourProcedureName @Param1, @Param2',
--    N'@Param1 NVARCHAR(100), @Param2 INT',
--    @Param1, @Param2

--Ö±½ÓÔÚÓ¦ÓóÌÐò´úÂëÖе÷Óô洢¹ý³Ì£¬ÀýÈçÔÚC#ÖÐʹÓÃADO.NET£º
--using (SqlConnection conn = new SqlConnection(connectionString))
--{
--    SqlCommand cmd = new SqlCommand("YourProcedureName", conn);
--    cmd.CommandType = CommandType.StoredProcedure;
--    cmd.Parameters.AddWithValue("@Param1", "Value1");
--    cmd.Parameters.AddWithValue("@Param2", 123);
--    conn.Open();
--    cmd.ExecuteNonQuery();
--}