智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
yusijie
2024-05-06 686133fb6f4929b9806a1548c6625d706fd1e335 
 WebAPI/Controllers/²Ö´æ¹ÜÀí/ÁìÁÏ·¢»õ/Kf_StepFoldOutBillController.cs


@@ -258,6 +258,27 @@


                }


                else if (OperationType == 3 || ds.Tables[0].Rows.Count != 0)


                { //修改




                    DataSet dss;


                    dss = oCn.RunProcReturn("select * from h_v_IF_StepFoldOutBillList where hmainid=" + HInterID + " and å•æ®å·='" + HBillNo + "'", "h_v_IF_StepFoldOutBillList");


                    //判断是否可编辑


                    if (dss.Tables[0].Rows[0]["审核人"].ToString() != "" && dss.Tables[0].Rows[0]["审核人"] != null)


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "此单据已经被审核，不允许修改！";


                        objJsonResult.data = 1;


                        return objJsonResult;


                    }


                    if (dss.Tables[0].Rows[0]["状态"].ToString() != "创建")


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "此单据处于不可编辑状态，不允许修改！";


                        objJsonResult.data = 1;


                        return objJsonResult;


                    }




                    String sql="update Kf_ICStockBillMain   set " +


                                    "HRemark='" + HRemark + "', HUpDater='" + HMaker + "', HUpDateDate=getdate()" +


                                 ",HSupID=" + HSupID + ",HWHID=" + HWHID + ",HSCWHID=" + HSCWHID + ", HEmpID=" + HEmpID + ",HManagerID=" + HManagerID + ",HSecManagerID = " + HSecManagerID