| | |
|---|
| | | } |
|---|
| | | else if (OperationType == 3 || ds.Tables[0].Rows.Count != 0) |
|---|
| | | { //修改 |
|---|
| | | |
|---|
| | | DataSet dss; |
|---|
| | | dss = oCN.RunProcReturn("select * from h_v_Kf_POStockInBillList where hmainid=" + HInterID + " and 单据号='" + HBillNo + "'", "h_v_Kf_POStockInBillList"); |
|---|
| | | //判断是否可编辑 |
|---|
| | | 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 + ",HCurID=" + HCurID + ",HSecManagerID=" + HSecManagerID + ", HSTOCKORGID=" + HSTOCKORGID + ",HKeeperID=" + HKeeperID + ",HWHID = " + HWHID |
|---|
