| | |
| | | { |
| | | is_firststep = "Y"; |
| | | } |
| | | else if (Convert.ToInt32(json.Data.Rows[i]["SEQ"].ToString()) == json.Data.Rows.Count) //是否末道工序 |
| | | if (Convert.ToInt32(json.Data.Rows[i]["SEQ"].ToString()) == json.Data.Rows.Count) //是否末道工序 |
| | | { |
| | | is_laststep = "Y"; |
| | | } |
| | |
| | | var dynamicParams = new DynamicParameters(); |
| | | try |
| | | { |
| | | //判断工艺路路线是否被存货绑定 |
| | | sql = @"select * from TMateriel_Route where route_code=@routecode"; |
| | | dynamicParams.Add("@routecode", routecode); |
| | | var data_0 = DapperHelper.selectdata(sql, dynamicParams); |
| | | if (data_0.Rows.Count > 0) |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = "存货档案已关联工艺路线,不允许删除!"; |
| | | mes.data = null; |
| | | return mes; |
| | | } |
| | | //判断工艺路线是否被工单引用(被引用则不能删除) |
| | | sql = @"select * from TK_Wrk_Man where route_code=@routecode"; |
| | | dynamicParams.Add("@routecode", routecode); |