| | |
| | | return GetObjectJson(ds); |
| | | } |
| | | |
| | | #region 工艺路线 |
| | | |
| | | #region 工艺路线列表 |
| | | /// <summary> |
| | | /// 返回工艺路线列表 |
| | | ///参数:string sql。 |
| | |
| | | } |
| | | return GetObjectJson(ds); |
| | | } |
| | | |
| | | #endregion |
| | | |
| | | #region 工艺路线 删除 |
| | | /// <summary> |
| | | /// 工艺路线删除功能 |
| | | /// </summary> |
| | |
| | | return objJsonResult; |
| | | } |
| | | oCN.BeginTran();//开始事务 |
| | | ds = oCN.RunProcReturn("select * from Gy_RoutingBillSub where HInterID=" + lngBillKey, "Gy_RoutingBillSub"); |
| | | ds = oCN.RunProcReturn("select * from Gy_RoutingBillmain where HInterID=" + lngBillKey, "Gy_RoutingBillmain"); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | |
| | | objJsonResult.data = null; |
| | | return objJsonResult; ; |
| | | } |
| | | //string HChecker = Convert.ToString(ds.Tables[0].Rows[0]["HChecker"]); |
| | | //if (HChecker != " ") |
| | | string HChecker = Convert.ToString(ds.Tables[0].Rows[0]["HChecker"]); |
| | | //string hdeleteman = Convert.ToString(ds.Tables[0].Rows[0]["hdeleteman"]); |
| | | if (HChecker != "") |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "单据已经审核,不能删除!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | //if (hdeleteman != "") |
| | | //{ |
| | | // objJsonResult.code = "0"; |
| | | // objJsonResult.count = 0; |
| | | // objJsonResult.Message = "单据已经审核,不能删除!"; |
| | | // objJsonResult.Message = "单据已经作废,不能删除!"; |
| | | // objJsonResult.data = null; |
| | | // return objJsonResult; |
| | | //} |
| | |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #endregion |
| | | |
| | | /// <summary> |
| | | /// 返回生产任务单列表 |