Sunday, November 19, 2023

Dyncraft


Souce Code 

VS Continue without code

select the project 

get letest version(icon click)

https://www.c-sharpcorner.com/article/different-types-of-action-results-in-asp-net-mvc/

------------------------

Task 1235023 SER 1177947: Remediate Investigate path forward and refine stories. (azure.com)

https://stackoverflow.com/questions/3708348/the-execute-permission-was-denied-on-the-object-xxxxxxx-database-zzzzzzz-s

SELECT CURRENT_USER; 

PACCAR-NA\Mohammad.Chowdhury

InnerException {"The EXECUTE permission was denied on the object 'Hose21mGetStations_SELECT', database 'DataApps', schema 'dbo'."}

System.Exception {System.Data.SqlClient.SqlException}


USE zzzzzzz;
GRANT EXEC ON dbo.xxxxxxx TO PUBLIC

------------------------


C:\Application Support All\feature-AppSupportWeb-PlatformVersionFilter\AppSupportWeb\Views\AppSupport\Application.cshtml

 <h3 id="modelName">@Model.Name</h3>

 <td>@Html.TextAreaFor(x => x.Note, new { @onkeyup = "LiveChange()", @rows = 2, @cols = 50, @class = "form-control" })</td>

C:\Application Support All\bug-AppSupportWeb-ApplicationNameNotSavedInCert\AppSupportWeb\wwwroot\js\site.js
function LiveChange() {
    
    $('#modelName').html($('#Note').val());
}
Load Project/ Delete files from IISExpress / EWI Assembly
C:\Users\mohammad.chowdhury\Documents\IISExpress\config

Insert Data
="('"&A1&"',"&B1&",'"&C1&"'),"





BOM বা Bill of Materials বাংলায় হলো:

উপাদান তালিকা বা উপাদান বিবরণী

এটি একটি ডকুমেন্ট বা তালিকা যা কোনও পণ্য তৈরি করতে ব্যবহৃত সব উপকরণ, অংশ, উপাদান এবং সাব-অ্যাসেম্বলি (অংশবিশেষ) এর নাম, পরিমাণ এবং অন্যান্য বিবরণ অন্তর্ভুক্ত করে। এটি পণ্য তৈরির জন্য প্রয়োজনীয় সবকিছু বিস্তারিতভাবে উল্লেখ করে।

সহজভাবে বলতে গেলে, BOM হলো একটি পূর্ণাঙ্গ তালিকা যা বলে দেয় কোন পণ্য তৈরি করতে কি কি কি উপাদান দরকার এবং সেগুলোর পরিমাণ কত




In SAP ECC, a manufacturing BOM (Bill of Materials) lists all the components and quantities needed to produce a finished product or assembly, and it's crucial for production planning and procurement. 

In SAP ECC, an Engineering Bill of Materials (eBOM) is a structured list of components and materials needed to build a product, primarily from an engineering perspective. It focuses on the technical details and design aspects of the product, rather than production or manufacturing processes. The eBOM is typically developed during the product design phase, often using CAD or EDA tools. 



Truck Chassis BOM originates from the truck plant.  It will say they want a truck that has generic callouts of items to go on the truck. 
VOG - (View Only Graphics) Tool used by the shop floor to view engineering drawings.
Dynacraft BOM - Similar to the Truck Chassis BOM with the specific part numbers and subassemblies that Dynacraft will sell the truck plant
AspectTruck Chassis BOMVOG (View Only Graphics) ToolDynacraft BOM
OriginOriginates from the truck plant.Used on the shop floor as a viewing tool.Created by Dynacraft to specify exact parts to sell to the truck plant.
PurposeDefines a truck with generic callouts of items to be included on the truck.Allows shop floor personnel to view engineering drawings for reference.Lists specific part numbers and subassemblies Dynacraft will supply to the truck plant.
ContentGeneric item descriptions and callouts without detailed part numbers.Engineering drawings and graphics in a read-only format.Detailed BOM with exact part numbers and subassemblies tailored for Dynacraft’s products.
UsersTruck plant engineering and planning teams.Shop floor operators, assemblers, technicians.Dynacraft’s manufacturing, sales, and supply chain teams, as well as the truck plant receiving Dynacraft parts.
FunctionalityProvides a high-level specification of truck requirements.Provides visual reference to assist assembly and quality checks.Provides detailed instructions for ordering, manufacturing, and supplying parts and assemblies.
ModificationMay be more conceptual and subject to updates from truck plant.View-only; no editing capability.Detailed and controlled document updated as per Dynacraft’s product changes.
Example“Include suspension system,” “Add frame rails,” without specific part numbers.Viewing CAD drawings showing how parts fit together on the chassis.Specific part numbers for suspension components, fasteners, and subassemblies sold by Dynacraft.

Summary

  • Truck Chassis BOM: A generic, high-level list from the truck plant defining what items should be on the truck, often without detailed part numbers.
  • VOG Tool: A shop floor visualization tool used to view engineering drawings for assembly guidance, with no part listing or editing abilities.
  • Dynacraft BOM: A detailed and specific BOM from Dynacraft containing exact part numbers and subassemblies that Dynacraft supplies to the truck plant.

This distinction helps ensure clear communication between the truck plant and Dynacraft, with the VOG tool supporting the shop floor during assembly


Ben 

  • Truck Chassis BOM originates from the truck plant.  It will say they want a truck that has generic callouts of items to go on the truck. 
  • VOG - (View Only Graphics) Tool used by the shop floor to view engineering drawings.
  • Dynacraft BOM - Similar to the Truck Chassis BOM with the specific part numbers and subassemblies that Dynacraft will sell the truck plant

--------------------------------------------------------------------------


  • Below are Excel template samples and a detailed SOP document draft you can use and customize for your teams.


    1. Excel Template Samples

    A. Truck Chassis BOM Template

    Item NoDescriptionGeneric CalloutQuantityRemarks
    001Frame RailStructural Frame Part2Standard frame rails
    002Suspension SystemLeaf Springs4Generic suspension
    003Brake SystemAir Brake Assembly1Callout only, no part#
    004Steering ComponentsTie Rods, Knuckles2Basic steering parts

    B. Dynacraft BOM Template

    Item NoPart NumberDescriptionQuantitySupplierSubassemblyRemarks
    001DC-1001Frame Rail - Dynacraft2DynacraftChassisMatches Truck Chassis BOM
    002DC-2005Leaf Spring Assembly4DynacraftSuspensionComplete assembly
    003DC-3003Air Brake Assembly1DynacraftBrakesSpecific to Dynacraft product
    004DC-4007Steering Knuckle2DynacraftSteeringCustom part

    C. Change Log Template

    Change IDDateDescriptionAffected Document(s)InitiatorApproval StatusRemarks
    CHG-0012024-06-01Updated Leaf Spring part numberDynacraft BOM, VOG DrawingsEngineeringApprovedImplemented 2024-06-05
    CHG-0022024-06-10Added new suspension subassemblyTruck Chassis BOMTruck PlantPendingUnder review

    2. SOP Draft: Using VOG Tool & Managing BOMs


    Title: Standard Operating Procedure for Managing Truck Chassis BOM, Dynacraft BOM, and Using VOG Tool

    Purpose:
    To establish a clear process for managing BOMs and effectively using the VOG tool on the shop floor for assembly accuracy.

    Scope:
    This procedure applies to engineering, manufacturing, procurement, and shop floor personnel involved in truck chassis assembly projects.


    Procedure:

    Step 1: Truck Chassis BOM Preparation

    • Truck Plant Engineering creates the Truck Chassis BOM with generic callouts.
    • This BOM is shared with Dynacraft for detailed part specification.

    Step 2: Dynacraft BOM Development

    • Dynacraft Engineering develops a detailed BOM with specific part numbers and subassemblies.
    • Dynacraft BOM is reviewed and shared with the truck plant procurement and manufacturing teams.

    Step 3: Shop Floor Usage of VOG Tool

    • Shop floor personnel log into the VOG tool daily.
    • Select relevant vehicle model or assembly line drawings.
    • Use the tool to view exploded views, assembly instructions, and part fitment during production.
    • Report discrepancies immediately to engineering or quality teams.

    Step 4: Change Management

    • Any changes initiated by truck plant or Dynacraft are documented and communicated.
    • Update Truck Chassis BOM, Dynacraft BOM, and VOG drawings accordingly.
    • Communicate updates to all relevant parties promptly.
    • Log all changes in the Change Log document.

    Responsibilities:

    RoleResponsibility
    Truck Plant EngineeringCreate and update Truck Chassis BOM
    Dynacraft EngineeringDevelop and maintain Dynacraft BOM
    Shop Floor OperatorsUse VOG tool for assembly guidance
    Quality TeamVerify assembly accuracy and report issues
    Change Control TeamManage and communicate BOM and drawing changes

    Revision History

    RevisionDateDescriptionAuthor
    1.02024-06-15Initial SOP ReleaseYour Name

    Next Steps

    • Customize these templates with your actual parts and data.
    • Distribute SOP to all relevant teams and conduct training sessions.
    • Set up regular review meetings to monitor BOM accuracy and VOG tool usage.
 






 




No comments:

Post a Comment

TWIN MODULE - Dyncraft

eBom vs mBom  SELECT distinct * FROM [DataStage].[dbo].[CUMEBOM_LOADING] as CL where CL.LineSeqNbr='T0890F0' and CL.ChassisNbr='...