| | |
|---|
| | | } |
|---|
| | | else if (OperationType == 3 || ds.Tables[0].Rows.Count != 0) |
|---|
| | | { //修改 |
|---|
| | | |
|---|
| | | //修改 |
|---|
| | | DataSet dss; |
|---|
| | | dss = oCN.RunProcReturn("select * from Gy_RoutingBillMain where HInterID=" + HInterID + " and HBillNo='" + HBillNo + "'", "Gy_RoutingBillMain"); |
|---|
| | | //判断是否可编辑 |
|---|
| | | if (dss.Tables[0].Rows[0]["HChecker"].ToString() != "" && dss.Tables[0].Rows[0]["HChecker"] != null) |
|---|
| | | { |
|---|
| | | objJsonResult.code = "0"; |
|---|
| | | objJsonResult.count = 0; |
|---|
| | | objJsonResult.Message = "此单据已经被审核，不允许修改！"; |
|---|
| | | objJsonResult.data = 1; |
|---|
| | | return objJsonResult; |
|---|
| | | } |
|---|
| | | dss = oCN.RunProcReturn("select COUNT(*) as number from Sc_ProcessExchangeBillMain where HRoutingBillID = " + HInterID, "Gy_RoutingBillMain"); |
|---|
| | | //判断是否可编辑 |
|---|
| | | if (dss.Tables[0].Rows[0]["number"].ToString() != "0") |
|---|
| | | { |
|---|
| | | objJsonResult.code = "0"; |
|---|
| | | objJsonResult.count = 0; |
|---|
| | | objJsonResult.Message = "此单据已经被引用，不允许修改！"; |
|---|
| | | objJsonResult.data = 1; |
|---|
| | | return objJsonResult; |
|---|
| | | } |
|---|
| | | |
|---|
| | | oCN.RunProc("update Gy_RoutingBillMain set " + |
|---|
| | | "HDate='" + HDate + |
|---|
| | | "',HYear='" + HYear + "',HPeriod='" + HPeriod + "',HRemark='" + HRemark + "',hupdater='" + HMaker + |
|---|
