Du lieu co ban khach hang

Thong tin co ban

Truong phan hoi

Vi du phan hoi

{
  "customer_data": [
    {
      "customer_no": "CUST001",
      "customer_shortname": "Khach hang thu nghiem",
      "customer_name": "Cong ty co phan khach hang thu nghiem",
      "modify_no": "USER001",
      "tran_status": "AU"
    }
  ]
}

SQL cap nhat co so du lieu

Xac dinh them moi hoac cap nhat

SELECT COUNT(1) FROM CUSTOMER WHERE ID = N'{customer_no}'
-- count > 0 → UPDATE, count = 0 → INSERT

INSERT (Them moi khach hang)

INSERT INTO CUSTOMER (
    ID, SHOTNAME, NAME, TEL, FAX, EMAIL,
    AREA_ID, AREA_NAME, ADDRESS,
    CHECKMAINTAINNO, LASTMAINTAINUSER, LASTMAINTAINDATETIME
) VALUES (
    :CUSTOMERID,
    :SHOTNAME,
    :CUSTOMER_NAME,
    :TEL,
    :FAX,
    :EMAIL,
    :AREA_ID,
    :AREA_NAME,
    :ADDRESS,
    1,
    :Creator,
    GETDATE()
)

UPDATE (Cap nhat khach hang)

UPDATE CUSTOMER SET
    SHOTNAME = :SHOTNAME,
    NAME = :CUSTOMER_NAME,
    TEL = :TEL,
    FAX = :FAX,
    EMAIL = :EMAIL,
    AREA_ID = :AREA_ID,
    AREA_NAME = :AREA_NAME,
    ADDRESS = :ADDRESS
WHERE ID = :CUSTOMERID

Gia tri mac dinh MES