Ejemplo n.º 1
0
        /// <summary>
        /// 柜体导入数据库
        /// </summary>
        /// <param name="orderDaetail"></param>
        /// <param name="IssueMaterialBills"></param>
        public static void ShengCanJuTableToDB(DataTable CabinetTable, DataTable IssueMaterialBillsTable, DataTable AluminumGlassLeftTable, DataTable AluminumGlassRightTable, DataTable MaterialRequisitionTopTable, DataTable MaterialRequisitionUnderTable, DataTable A6PackagingSheetTable, DataTable SpeedDfBeautyTable, DataTable PlateDoorSheetWorkSheetTable, DataTable PlateDoorHandleSheetTable, DataTable ClassicDoorSheetTable, DataTable ClassicDoorHandleSheetTable, DataTable SidibJobListSheetTable, DataTable SiddibRequisitionFormSheetTable, DataTable TurandotWorkSheetTable, DataTable MaterialRequisitionSheetTable, DataTable TurandotEbonyWorkSheetTable, DataTable TurandotBlackSandalwoodMaterialListTable)
        {
            SqlParameter[] param = new SqlParameter[] {
                new SqlParameter("@Pro_CabinetTableTable", SqlDbType.Structured)
                {
                    Value = CabinetTable
                },
                new SqlParameter("@Pro_IssueMaterialBillsTable", SqlDbType.Structured)
                {
                    Value = IssueMaterialBillsTable
                },
                new SqlParameter("@Pro_AluminumGlassLeftTable", SqlDbType.Structured)
                {
                    Value = AluminumGlassLeftTable
                },
                new SqlParameter("@Pro_AluminumGlassRightTable", SqlDbType.Structured)
                {
                    Value = AluminumGlassRightTable
                },
                new SqlParameter("@Pro_MaterialRequisitionTopTable", SqlDbType.Structured)
                {
                    Value = MaterialRequisitionTopTable
                },
                new SqlParameter("@Pro_MaterialRequisitionUnderTable", SqlDbType.Structured)
                {
                    Value = MaterialRequisitionUnderTable
                },
                new SqlParameter("@Pro_A6PackagingSheetTable", SqlDbType.Structured)
                {
                    Value = A6PackagingSheetTable
                },
                new SqlParameter("@Pro_SpeedDfBeautyTable", SqlDbType.Structured)
                {
                    Value = SpeedDfBeautyTable
                },
                new SqlParameter("@Pro_PlateDoorSheetWorkSheetTable", SqlDbType.Structured)
                {
                    Value = PlateDoorSheetWorkSheetTable
                },
                new SqlParameter("@Pro_PlateDoorHandleSheetTable", SqlDbType.Structured)
                {
                    Value = PlateDoorHandleSheetTable
                },
                new SqlParameter("@Pro_ClassicDoorSheetTable", SqlDbType.Structured)
                {
                    Value = ClassicDoorSheetTable
                },
                new SqlParameter("@Pro_ClassicDoorHandleSheetTable", SqlDbType.Structured)
                {
                    Value = ClassicDoorHandleSheetTable
                },
                new SqlParameter("@Pro_SidibJobListSheetTable", SqlDbType.Structured)
                {
                    Value = SidibJobListSheetTable
                },
                new SqlParameter("@Pro_SiddibRequisitionFormSheetTable", SqlDbType.Structured)
                {
                    Value = SiddibRequisitionFormSheetTable
                },
                new SqlParameter("@Pro_TurandotWorkSheetTable", SqlDbType.Structured)
                {
                    Value = TurandotWorkSheetTable
                },
                new SqlParameter("@Pro_MaterialRequisitionSheetTable", SqlDbType.Structured)
                {
                    Value = MaterialRequisitionSheetTable
                },
                new SqlParameter("@Pro_TurandotEbonyWorkSheetTable", SqlDbType.Structured)
                {
                    Value = TurandotEbonyWorkSheetTable
                },
                new SqlParameter("@Pro_TurandotBlackSandalwoodMaterialListTable", SqlDbType.Structured)
                {
                    Value = TurandotBlackSandalwoodMaterialListTable
                }
            };

            DBUtility.ExecStoredProcedure("[InsertShengCanJuTableToSQL]", param);
        }
Ejemplo n.º 2
0
        /// <summary>
        /// 柜体导入数据库
        /// </summary>
        /// <param name="orderDaetail"></param>
        /// <param name="IssueMaterialBills"></param>
        public static void CommitDataTableToDB(DataTable orderDaetail, DataTable IssueMaterialBills, DataTable GetMaterialBillsDataTable, DataTable PackingListTable, DataTable GlassIssueMaterialBills1Table, DataTable GlassIssueMaterialBills2Table, DataTable Packing_ListTable, DataTable Packing_ListA6Table, DataTable A6NoPaintSheetTable, DataTable MeiWenqiBlankingSheetTable, DataTable MeiWenqiRequisitionSheetTable, DataTable A6WenqiBlankingSheetTable, DataTable SuctionMoldingDoorSheetMaterialListTable, DataTable FeedSingleBlisterDoorPlankSheetTable)
        {
            SqlParameter[] param = new SqlParameter[] {
                new SqlParameter("@Pro_OrderDetail", SqlDbType.Structured)
                {
                    Value = orderDaetail
                },
                new SqlParameter("@Pro_IssueMaterialBills", SqlDbType.Structured)
                {
                    Value = IssueMaterialBills
                },
                new SqlParameter("@Pro_GetMaterialBills", SqlDbType.Structured)
                {
                    Value = GetMaterialBillsDataTable
                },
                new SqlParameter("@Pro_PackingList", SqlDbType.Structured)
                {
                    Value = PackingListTable
                },
                new SqlParameter("@Pro_GlassIssueMaterialBills1", SqlDbType.Structured)
                {
                    Value = GlassIssueMaterialBills1Table
                },
                new SqlParameter("@Pro_GlassIssueMaterialBills2", SqlDbType.Structured)
                {
                    Value = GlassIssueMaterialBills2Table
                },
                new SqlParameter("@Pro_Packaging", SqlDbType.Structured)
                {
                    Value = Packing_ListTable
                },
                new SqlParameter("@Pro_PackagingA6", SqlDbType.Structured)
                {
                    Value = Packing_ListA6Table
                },
                new SqlParameter("@A6NoPaintSheetTable", SqlDbType.Structured)
                {
                    Value = A6NoPaintSheetTable
                },
                new SqlParameter("@MeiWenqiBlankingSheetTable", SqlDbType.Structured)
                {
                    Value = MeiWenqiBlankingSheetTable
                },
                new SqlParameter("@MeiWenqiRequisitionSheetTable", SqlDbType.Structured)
                {
                    Value = MeiWenqiRequisitionSheetTable
                },
                new SqlParameter("@A6WenqiBlankingSheetTable", SqlDbType.Structured)
                {
                    Value = A6WenqiBlankingSheetTable
                },
                new SqlParameter("@Pro_SuctionMoldingDoorSheetMaterialListTable", SqlDbType.Structured)
                {
                    Value = SuctionMoldingDoorSheetMaterialListTable
                },
                new SqlParameter("@Pro_FeedSingleBlisterDoorPlankSheetTable", SqlDbType.Structured)
                {
                    Value = FeedSingleBlisterDoorPlankSheetTable
                }
            };

            DBUtility.ExecStoredProcedure("[InsertCabinetMaterialListToSQL]", param);
        }