| | |
|---|
| | | //删除设备点检标准关联点检项目子表 |
|---|
| | | sql = @"delete TEqpchk_Deta where eqpchk_main_code=@checkstand_code"; |
|---|
| | | list.Add(new { str = sql, parm = new { checkstand_code = checkstand_code } }); |
|---|
| | | |
|---|
| | | //删除设备点检标准关联设备表 |
|---|
| | | sql = @"delete TEqpchk_Eqp where eqpchk_main_code=@checkstand_code"; |
|---|
| | | list.Add(new { str = sql, parm = new { checkstand_code = checkstand_code } }); |
|---|
| | | bool aa = DapperHelper.DoTransaction(list); |
|---|
| | | if (aa) |
|---|
| | | { |
|---|
| | |
|---|
| | | //删除设备保养标准关联保养项目子表 |
|---|
| | | sql = @"delete TEqpmai_Deta where eapmai_code=@repairstand_code"; |
|---|
| | | list.Add(new { str = sql, parm = new { repairstand_code = repairstand_code } }); |
|---|
| | | //删除设备保养标准关联设备表 |
|---|
| | | sql = @"delete TEqpmai_Eqp where eapmai_code=@repairstand_code"; |
|---|
| | | list.Add(new { str = sql, parm = new { repairstand_code = repairstand_code } }); |
|---|
| | | |
|---|
| | | bool aa = DapperHelper.DoTransaction(list); |
|---|
| | | if (aa) |
|---|
| | |
|---|
| | | //循环写入设备保养标准关联设备表 |
|---|
| | | for (int i = 0; i < json.Count; i++) |
|---|
| | | { |
|---|
| | | list.Add(new { str = sql, parm = new { eqp_code = json[i].code } }); |
|---|
| | | sql = @"insert into TEqpmai_Eqp(eapmai_code,eqp_code,lm_user,lm_date) values(@repairstand_code,@eqp_code,@lm_user,@lm_date)"; |
|---|
| | | list.Add(new |
|---|
| | | { |
|---|
