| | |
|---|
| | | try |
|---|
| | | { |
|---|
| | | //判断工单是否为未开始状态或者已派发状态(满足其中一种都可删除，否则不允许删除) |
|---|
| | | sql = @"select * from TK_Wrk_Man where wo_code=@wocode and status='NEW' or status='ALLO'"; |
|---|
| | | sql = @"select * from TK_Wrk_Man where wo_code=@wocode and status in('NEW','ALLO')"; |
|---|
| | | dynamicParams.Add("@wocode", wocode); |
|---|
| | | var data = DapperHelper.selectdata(sql, dynamicParams); |
|---|
| | | if (data.Rows.Count > 0) |
|---|
| | |
|---|
| | | left join TStep B on A.step_code=B.stepcode |
|---|
| | | left join TK_Wrk_Man M on A.wo_code=M.wo_code |
|---|
| | | left join TMateriel_Info P on M.materiel_code=P.partcode |
|---|
| | | where A.wo_code=@wo_code"; |
|---|
| | | where A.wo_code=@wo_code order by A.seq"; |
|---|
| | | dynamicParams.Add("@wo_code", wo_code); |
|---|
| | | var data = DapperHelper.selectdata(sql, dynamicParams); |
|---|
| | | mes.code = "200"; |
|---|
| | |
|---|
| | | } |
|---|
| | | } |
|---|
| | | //更新排产生产资源主表 |
|---|
| | | sql = @"update gn_wkm_capac_plan set wkshift_code=@wkshift_code,classtype=@classtype,lm_user=@lm_user,lm_time=@lm_time where id=@id"; |
|---|
| | | sql = @"update TWkm_capac_plan set wkshift_code=@wkshift_code,classtype=@classtype,lm_user=@lm_user,lm_date=@lm_time where id=@id"; |
|---|
| | | list.Add(new |
|---|
| | | { |
|---|
| | | str = sql, |
|---|
| | |
|---|
| | | //循环写入排产生产资源子表 |
|---|
| | | for (int i = 0; i < objs.Count; i++) |
|---|
| | | { |
|---|
| | | sql = @"insert into TWkm_capac_plan_sub(m_id,wkdate,wkshift_code) values()"; |
|---|
| | | sql = @"insert into TWkm_capac_plan_sub(m_id,wkdate,wkshift_code) values(@m_id,@wkdate,@wkshift_code)"; |
|---|
| | | list.Add(new |
|---|
| | | { |
|---|
| | | str = sql, |
|---|
