自动生成DAL. 和Model层的代码工具，源码，CodeGen

-- ================================================================================================================ -- Stored Procedures generated by LLBLGen v1.2.2285.16127 Final on Friday, January 09, 2009, 12:30:38 PM -- For the Low Level Business Logic Layer for the database 'CampusPlanning' -- ================================================================================================================ SET NOCOUNT ON GO USE [CampusPlanning] GO -- ======================================================================================================== -- [Stored Procedures generated for table: CP_BaanCodeValue_1] GO INSERT INTO CP_BaanCodeValue_1 ( InnerID, BaanCodeID, BaanCode, ImportYear, ImportWKID, WK00, WK01, WK02, WK03, WK04, WK05, WK06, WK07, WK08, WK09, WK10, WK11, WK12, WK13, WK14, WK15, WK16, WK17, WK18, WK19, WK20, WK21, WK22, WK23, WK24, WK25, WK26, WK27, WK28, WK29, WK30, WK31, WK32, WK33, WK34, WK35, WK36, WK37, WK38, WK39, WK40, WK41, WK42, WK43, WK44, WK45, WK46, WK47, WK48, WK49, WK50, WK51, WK52, WK53, WK54 ) VALUES ( @iInnerID, @iBaanCodeID, @sBaanCode, @iImportYear, @iImportWKID, @curWK00, ISNULL(@curWK01, ((0))), ISNULL(@curWK02, ((0))), ISNULL(@curWK03, ((0))), ISNULL(@curWK04, ((0))), ISNULL(@curWK05, ((0))), ISNULL(@curWK06, ((0))), ISNULL(@curWK07, ((0))), ISNULL(@curWK08, ((0))), ISNULL(@curWK09, ((0))), ISNULL(@curWK10, ((0))), ISNULL(@curWK11, ((0))), ISNULL(@curWK12, ((0))), ISNULL(@curWK13, ((0))), ISNULL(@curWK14, ((0))), ISNULL(@curWK15, ((0))), ISNULL(@curWK16, ((0))), ISNULL(@curWK17, ((0))), ISNULL(@curWK18, ((0))), ISNULL(@curWK19, ((0))), ISNULL(@curWK20, ((0))), ISNULL(@curWK21, ((0))), ISNULL(@curWK22, ((0))), ISNULL(@curWK23, ((0))), ISNULL(@curWK24, ((0))), ISNULL(@curWK25, ((0))), ISNULL(@curWK26, ((0))), ISNULL(@curWK27, ((0))), ISNULL(@curWK28, ((0))), ISNULL(@curWK29, ((0))), ISNULL(@curWK30, ((0))), ISNULL(@curWK31, ((0))), @curWK32, ISNULL(@curWK33, ((0))), ISNULL(@curWK34, ((0))), ISNULL(@curWK35, ((0))), ISNULL(@curWK36, ((0))), ISNULL(@curWK37, ((0))), ISNULL(@curWK38, ((0))), ISNULL(@curWK39, ((0))), ISNULL(@curWK40, ((0))), @curWK41, ISNULL(@curWK42, ((0))), ISNULL(@curWK43, ((0))), ISNULL(@curWK44, ((0))), ISNULL(@curWK45, ((0))), @curWK46, ISNULL(@curWK47, ((0))), ISNULL(@curWK48, ((0))), ISNULL(@curWK49, ((0))), ISNULL(@curWK50, ((0))), ISNULL(@curWK51, ((0))), ISNULL(@curWK52, ((0))), ISNULL(@curWK53, ((0))), ISNULL(@curWK54, ((0))) ) SELECT InnerID, BaanCodeID, BaanCode, ImportYear, ImportWKID, WK00, WK01, WK02, WK03, WK04, WK05, WK06, WK07, WK08, WK09, WK10, WK11, WK12, WK13, WK14, WK15, WK16, WK17, WK18, WK19, WK20, WK21, WK22, WK23, WK24, WK25, WK26, WK27, WK28, WK29, WK30, WK31, WK32, WK33, WK34, WK35, WK36, WK37, WK38, WK39, WK40, WK41, WK42, WK43, WK44, WK45, WK46, WK47, WK48, WK49, WK50, WK51, WK52, WK53, WK54 FROM CP_BaanCodeValue_1 -- [End of Stored Procedures for table: CP_BaanCodeValue_1] -- ======================================================================================================== GO -- ======================================================================================================== -- [Stored Procedures generated for table: CP_BaanCodeValueImport_1] GO INSERT INTO CP_BaanCodeValueImport_1 ( InnerID, BaanCodeID, BaanCode, CalculateFlag, ImportUserID, ImportYear, ImportWKID, WK00, WK01, WK02, WK03, WK04, WK05, WK06, WK07, WK08, WK09, WK10, WK11, WK12, WK13, WK14, WK15, WK16, WK17, WK18, WK19, WK20, WK21, WK22, WK23, WK24, WK25, WK26, WK27, WK28, WK29, WK30, WK31, WK32, WK33, WK34, WK35, WK36, WK37, WK38, WK39, WK40, WK41, WK42, WK43, WK44, WK45, WK46, WK47, WK48, WK49, WK50, WK51, WK52, WK53, WK54 ) VALUES ( @iInnerID, @iBaanCodeID, @sBaanCode, @iCalculateFlag, @iImportUserID, @iImportYear, @iImportWKID, @curWK00, ISNULL(@curWK01, ((0))), ISNULL(@curWK02, ((0))), ISNULL(@curWK03, ((0))), ISNULL(@curWK04, ((0))), ISNULL(@curWK05, ((0))), ISNULL(@curWK06, ((0))), ISNULL(@curWK07, ((0))), ISNULL(@curWK08, ((0))), ISNULL(@curWK09, ((0))), ISNULL(@curWK10, ((0))), ISNULL(@curWK11, ((0))), ISNULL(@curWK12, ((0))), ISNULL(@curWK13, ((0))), ISNULL(@curWK14, ((0))), ISNULL(@curWK15, ((0))), ISNULL(@curWK16, ((0))), ISNULL(@curWK17, ((0))), ISNULL(@curWK18, ((0))), ISNULL(@curWK19, ((0))), ISNULL(@curWK20, ((0))), ISNULL(@curWK21, ((0))), ISNULL(@curWK22, ((0))), ISNULL(@curWK23, ((0))), ISNULL(@curWK24, ((0))), ISNULL(@curWK25, ((0))), ISNULL(@curWK26, ((0))), ISNULL(@curWK27, ((0))), ISNULL(@curWK28, ((0))), ISNULL(@curWK29, ((0))), ISNULL(@curWK30, ((0))), ISNULL(@curWK31, ((0))), ISNULL(@curWK32, ((0))), ISNULL(@curWK33, ((0))), ISNULL(@curWK34, ((0))), ISNULL(@curWK35, ((0))), ISNULL(@curWK36, ((0))), ISNULL(@curWK37, ((0))), ISNULL(@curWK38, ((0))), ISNULL(@curWK39, ((0))), ISNULL(@curWK40, ((0))), ISNULL(@curWK41, ((0))), ISNULL(@curWK42, ((0))), ISNULL(@curWK43, ((0))), ISNULL(@curWK44, ((0))), ISNULL(@curWK45, ((0))), ISNULL(@curWK46, ((0))), ISNULL(@curWK47, ((0))), ISNULL(@curWK48, ((0))), ISNULL(@curWK49, ((0))), ISNULL(@curWK50, ((0))), ISNULL(@curWK51, ((0))), ISNULL(@curWK52, ((0))), ISNULL(@curWK53, ((0))), ISNULL(@curWK54, ((0))) ) SELECT InnerID, BaanCodeID, BaanCode, CalculateFlag, ImportUserID, ImportYear, ImportWKID, WK00, WK01, WK02, WK03, WK04, WK05, WK06, WK07, WK08, WK09, WK10, WK11, WK12, WK13, WK14, WK15, WK16, WK17, WK18, WK19, WK20, WK21, WK22, WK23, WK24, WK25, WK26, WK27, WK28, WK29, WK30, WK31, WK32, WK33, WK34, WK35, WK36, WK37, WK38, WK39, WK40, WK41, WK42, WK43, WK44, WK45, WK46, WK47, WK48, WK49, WK50, WK51, WK52, WK53, WK54 FROM CP_BaanCodeValueImport_1 -- [End of Stored Procedures for table: CP_BaanCodeValueImport_1] -- ======================================================================================================== GO -- ======================================================================================================== -- [Stored Procedures generated for table: CP_PriceBookMaterial_1] GO INSERT INTO CP_PriceBookMaterial_1 ( PlatFormID, ImportUserID, ImportYear, ImporMonth, Month00, Month01, Month02, Month03, Month04, Month05, Month06, Month07, Month08, Month09, Month10, Month11, Month12 ) VALUES ( @iPlatFormID, @iImportUserID, @iImportYear, @iImporMonth, @curMonth00, @curMonth01, @curMonth02, @curMonth03, @curMonth04, @curMonth05, @curMonth06, @curMonth07, @curMonth08, @curMonth09, @curMonth10, @curMonth11, @curMonth12 ) SELECT InnerID, PlatFormID, ImportUserID, ImportYear, ImporMonth, Month00, Month01, Month02, Month03, Month04, Month05, Month06, Month07, Month08, Month09, Month10, Month11, Month12 FROM CP_PriceBookMaterial_1 -- [End of Stored Procedures for table: CP_PriceBookMaterial_1] -- ======================================================================================================== GO -- ======================================================================================================== -- [Stored Procedures generated for table: CP_PriceBookSelling_1] GO INSERT INTO CP_PriceBookSelling_1 ( PlatFormID, ImportUserID, ImportYear, ImporMonth, Month00, Month01, Mont