Du lieu quy trinh san pham

Thong tin co ban

Truong phan hoi

HEADER Header quy trinh (SFT_BOMME)

LINE Chi tiet quy trinh (SFT_BOMMF)

Vi du phan hoi

{
  "process_data": [
    {
      "process_item": "ITEM-001",
      "process_code": "RT001",
      "process_name": "Quy trinh lap rap tieu chuan",
      "description": "Quy trinh tieu chuan lap rap san pham",
      "process_detail": [
        {
          "process_seq": "10",
          "operation_no": "OP001",
          "workstation_no": "WS001",
          "std_time": "30"
        },
        {
          "process_seq": "20",
          "operation_no": "OP002",
          "workstation_no": "WS002",
          "std_time": "45"
        }
      ],
      "modify_no": "USER001"
    }
  ]
}

SQL cap nhat co so du lieu

Header quy trinh SFT_BOMME (xoa truoc them moi)

-- Xoa du lieu cu
DELETE FROM SFT_BOMME WHERE ME001 = :ME001 AND ME002 = :ME002

-- Them moi header
INSERT INTO SFT_BOMME (
    ME001, ME002, ME003, ME004, ME007,
    MES001, MES004, CREATER, CREATE_DATE, FLAG
) VALUES (
    :ME001, :ME002, :ME003, :ME004, :ME007,
    'N', 'N', :userid, N'{thoi gian hien tai}', 0
)

Chi tiet quy trinh SFT_BOMMF (xoa truoc them moi)

-- Xoa chi tiet cu
DELETE FROM SFT_BOMMF WHERE MF001 = :MF001 AND MF002 = :MF002

-- Them moi chi tiet (moi buoc quy trinh)
INSERT INTO SFT_BOMMF (
    MF001, MF002, MF003, MF004, MF005, MF006, MF007, MF008,
    MF009, MF010, MF011, MF012, MF013, MF014, MF015, MF016,
    MF017, MF018, MF019, MF020, MF021, MF022, MF023, MF024,
    MF025, MF026, MF027, MF029, CONVERTUNIT, ITEM004, ITEM005
) VALUES (
    :MF001, :MF002, :MF003, :MF004, :MF005, :MF006, :MF007, :MF008,
    {MF009}, {MF010}, :MF011, :MF012, :MF013, :MF014, :MF015, 1,
    :MF017, :MF018, :MF019, :MF020, 'N', :MF022, :MF023, {MF024},
    {MF025}, :MF026, :MF027, :MF029, :CONVERTUNIT, :ITEM004, :ITEM005
)

Them moi lien dong OPERATION

-- Kiem tra quy trinh da ton tai chua
SELECT COUNT(*) FROM OPERATION
WHERE ERP_OPID = N'{MF004}' AND ERP_WSID = N'{MF006}'

-- Neu chua ton tai thi tu dong them moi
INSERT INTO OPERATION (
    ID, NAME, DESCRIPTION, COMPLEXION,
    ERP_OPID, WORKSTATIONID, ERP_WSID,
    LASTMAINTAINUSER, LASTMAINTAINDATETIME, FLAG
) VALUES (
    :MF004---:MF006,
    :OpName,
    :OpDESCRIPTION,
    :MF005,
    :MF004,
    :MF006,
    :MF006,
    :userid,
    N'{thoi gian hien tai}',
    0
)