コード例 #1
0
        internal void UpdateScProduct()
        {
            string sql = "UPDATE " + clsGlobals.Gesin + "[tblGIScProduct] SET " +
                         "[GIProductID] = " + GIProductID +
                         ",[ScProductStatus]= " + ScProductStatus +
                         ",[ScProductComment]= '" + ScProductComment +
                         "',[ProductID]= " + ProductID +
                         ",[ColorID]= " + ColorID +
                         ",[GIProductStatus]= " + GIProductStatus +
                         ",[ProductComment]= '" + ProductComment +
                         "',[SurplusRate]= " + SurplusRate +
                         ",[ReferenceNo1]= '" + ReferenceNo1 +
                         "',[ReferenceNo2]= '" + ReferenceNo2 +
                         "',[ExpShippingDate]= '" + ExpShippingDate.ToString("yyyy-MM-dd") +
                         "',[ExpArrivalDate]= '" + ExpArrivalDate.ToString("yyyy-MM-dd") +
                         "',[VendorID]= " + VendorID +
                         ",[VendorSiteID]= " + VendorSiteID +
                         ",[PurchaseTypeID]= " + PurchaseTypeID +
                         ",[DefaultWarehouseID]= " + DefaultWarehouseID +
                         ",[DivisionID]= " + DivisionID +
                         ",[CollectionID]= " + CollectionID +
                         ",[VOSeasonID]= " + VOSeasonID +
                         ",[VONote]= '" + VONote +
                         "',[VOMessage]= '" + VOMessage +
                         "',[VOStatus]= " + VOStatus +
                         ",[VOID]= " + VOID +
                         ",[VOCode]= '" + VOCode +
                         "',[VoPdfStatus]= " + VoPdfStatus +
                         ",[ModifiedByUserID]= " + clsGlobals.GIPar.UserID +
                         ",[ModifiedDate]= GETDATE() WHERE[ScenarioID]= " + ScenarioID + " AND[ProductColorID]= " + ProductColorID;

            //Conexion.StartSession();
            Conexion.GDatos.RunSql(sql);
            Conexion.EndSession();
        }
コード例 #2
0
        internal void UpdateVOParameter()
        {
            string sql = "UPDATE " + clsGlobals.Gesin + "[tblGIParameter] SET " +
                         "[ReferenceNo1] ='" + ReferenceNo1 +
                         "',[ReferenceNo2] = '" + ReferenceNo2 +
                         "',[ExpShippingDate] = '" + ExpShippingDate.ToString("yyyy-MM-dd") +
                         "',[ExpArrivalDate] = '" + ExpArrivalDate.ToString("yyyy-MM-dd") +
                         "',[VendorID] = " + VendorID +
                         ",[VendorSiteID] = " + VendorSiteID +
                         ",[PurchaseTypeID] = " + PurchaseTypeID +
                         ",[DefaultWarehouseID] = " + DefaultWarehouseID +
                         ",[DivisionID] = " + DivisionID +
                         ",[CollectionID] = " + CollectionID +
                         ",[SeasonID] = " + SeasonID +
                         ",[VONote] = '" + VONote +
                         "',[VOMessage] = '" + VOMessage +
                         "',[ModifiedByUserID] = " + clsGlobals.GIPar.UserID +
                         ",[ModifiedDate] = GETDATE()" +
                         "WHERE[GIParameterID]=100";

            //Conexion.StartSession();
            Conexion.GDatos.RunSql(sql);
            Conexion.EndSession();
        }
コード例 #3
0
        internal void UpdateScenario()
        {
            string sql = "UPDATE " + clsGlobals.Gesin + "[tblGIScenario] SET [ScenarioDesc] = '" + ScenarioDesc + "', [ScenarioStatus] = " + ScenarioStatus +
                         ", [ReferenceNo1] = '" + ReferenceNo1 + "', [ReferenceNo2] = '" + ReferenceNo2 + "', [ExpShippingDate] = '" +
                         ExpShippingDate.ToString("yyyy-MM-dd") + "', [ExpArrivalDate] = '" + ExpArrivalDate.ToString("yyyy-MM-dd") + "', [VendorID] = " +
                         VendorID + ", [VendorSiteID] = " + VendorSiteID + ", [PurchaseTypeID] = " + PurchaseTypeID + ", [DivisionID] = " + DivisionID +
                         ", [CollectionID] = " + CollectionID + ", [VOSeasonID] = " + VOSeasonID + ", [VONote] = '" + VONote + "', [VOMessage] = '" + VOMessage +
                         "', [ModifiedByUserID] = " + clsGlobals.GIPar.UserID + ", [ModifiedDate] = GETDATE() WHERE [GIScenarioID]=" + clsGlobals.GIPar.ScenarioID;

            //Conexion.StartSession();
            Conexion.GDatos.RunSql(sql);
            Conexion.EndSession();
        }