| | |
| | | break; |
| | | case "Update"://修改 |
| | | //判断是否生成检验记录(入厂检验(InCheck) 出厂检验(OutCheck) FirstCheck(首检) PatroCheck(巡检) EndCheck(完工检)) |
| | | sql = @"select * from TStepCheckRecord where checkstaned_code=@qualityinsptcode and check_type=@checktype"; |
| | | dynamicParams.Add("@qualityinsptcode", qualityinsptcode); |
| | | dynamicParams.Add("@checktype", checktype); |
| | | var data = DapperHelper.selectdata(sql, dynamicParams); |
| | | if (data.Rows.Count > 0) |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.message = "修改失败,当前质检方案已生成对应检验记录!"; |
| | | mes.data = null; |
| | | return mes; |
| | | } |
| | | //sql = @"select * from TStepCheckRecord where checkstaned_code=@qualityinsptcode and check_type=@checktype"; |
| | | //dynamicParams.Add("@qualityinsptcode", qualityinsptcode); |
| | | //dynamicParams.Add("@checktype", checktype); |
| | | //var data = DapperHelper.selectdata(sql, dynamicParams); |
| | | //if (data.Rows.Count > 0) |
| | | //{ |
| | | // mes.code = "300"; |
| | | // mes.count = 0; |
| | | // mes.message = "修改失败,当前质检方案已生成对应检验记录!"; |
| | | // mes.data = null; |
| | | // return mes; |
| | | //} |
| | | //删除质检方案子表 |
| | | sql = @"delete from TStepCheckStandardSub where stepstaned_code=@code"; |
| | | list.Add(new { str = sql, parm = new { code = qualityinsptcode } }); |