UPDATE plm_item
SET changeuserid=$userid$,
    changedate = current_time,
    unitid=$unitid$,
    isauxunit=$isauxunit$,
    unitgroupid=$unitgroupid$,
    itemname=$itemname$,
    model = $model$,
    spec=$spec$,
    orderminqty=$orderminqty$,
    orderaddqty=$orderaddqty$,
    orderminqty_auxunit= $orderminqty_auxunit$,
    orderaddqty_auxunit= $orderaddqty_auxunit$,
    remarks = $remarks$,
    barcode = $barcode$,
    skucontrol = $skucontrol$,
    batchcontrol = $batchcontrol$,
    grossweight = $grossweight$,
    weight = $weight$,
    height = $height$,
    width = $width$,
    length = $length$,
    delivery = $delivery$,
    istool = $istool$,
    marketprice = $marketprice$,
    standards = $standards$,
    stockstatus2 = $stockstatus2$,
    stockstatus1 = $stockstatus1$,
    warrantyday = $warrantyday$,
    iswuliao = $iswuliao$,
    ismodule = $ismodule$,
    color = $color$,
    cheek=$cheek$,
    delistingstatus=$delistingstatus$,
    packageqty = $packageqty$,
    iswoodproducts=$iswoodproducts$,
    isservice = $isservice$,
    sa_customschemeid=$sa_customschemeid$,
    financeclasstype=$financeclasstype$,
    stockno=$stockno$,
    marketingcategory=$marketingcategory$,
    volume=$volume$,
    widthschemeid=$widthschemeid$,
    lengthschemeid=$lengthschemeid$,
    iscustomsize=$iscustomsize$,
    customprice=$customprice$,
    pricingmetod=$pricingmetod$,
    cheekschemeid=$cheekschemeid$,
    colorschemeid=$colorschemeid$,
    materialschemeid=$materialschemeid$,
    cost=$cost$,
    grossprofit=$grossprofit$,
    saleprice=$saleprice$,
    grossprofitmargin=$grossprofitmargin$,
    soldbase=$soldbase$,
    byname=$byname$,
    rate=$rate$,
    grade=$grade$,
    custamount=$custamount$,
    safeqty=$safeqty$,
    icaddqty=$icaddqty$,
    icminqty=$icminqty$,
    iswriteoff=$iswriteoff$,
    isnegative=$isnegative$,
    ispartorderautocheck=$ispartorderautocheck$,
    islimitemparts=$islimitemparts$,
    itemname_print=$itemname_print$,
    applicablegassource=$applicablegassource$,
    hygienelicensenum=$hygienelicensenum$,
    departmentid=$departmentid$,
    executionstandards=$executionstandards$,
    itemclsnum=$itemclsnum$,
    outplace=$outplace$,
    repairattribute=$repairattribute$,
    shapesize=$shapesize$,
    topclassnum=$topclassnum$,
    aftersalesitemno=$aftersalesitemno$,
    kw=$kw$,
    gysmc=$gysmc$
WHERE itemid = $itemid$
  and siteid = $siteid$


