| | |
| | | try |
| | | { |
| | | //获取当前扫码设备是否申请维修记录 |
| | | sql = @"select * from TEqp_RepairRequest where eqp_code=@eqpcode and status='REPA' or status='COMP'"; |
| | | sql = @"select * from TEqp_RepairRequest where eqp_code=@eqpcode and status<>'CONFIR'"; |
| | | dynamicParams.Add("@eqpcode", eqpcode); |
| | | var data0 = DapperHelper.selectdata(sql, dynamicParams); |
| | | if (data0.Rows.Count > 0) |
| | |
| | | try |
| | | { |
| | | list.Clear(); |
| | | for (int i = 1; i <= json.Count; i++) |
| | | for (int i = 0; i <json.Count; i++) |
| | | { |
| | | string code = json[i].code.ToString(); |
| | | string name = json[i].name.ToString(); |