| | |
| | | try |
| | | { |
| | | //判断当前工单是否关闭 |
| | | sql = @"select * from TK_Wrk_Man where wo_code=@ordercode and wkshop_code=@stu_torgcode and status='CLOSED'"; |
| | | sql = @"select * from TK_Wrk_Man where wo_code=@ordercode and wkshp_code=@stu_torgcode and status='CLOSED'"; |
| | | dynamicParams.Add("@ordercode", ordercode); |
| | | dynamicParams.Add("@stu_torgcode", stu_torgcode); |
| | | var da0 = DapperHelper.selectdata(sql, dynamicParams); |
| | |
| | | } |
| | | |
| | | //0.判断当前工单所属车间是否为当前登录人员车间 |
| | | sql = @"select * from TK_Wrk_Man where wo_code=@ordercode and wkshop_code=@stu_torgcode"; |
| | | sql = @"select * from TK_Wrk_Man where wo_code=@ordercode and wkshp_code=@stu_torgcode"; |
| | | dynamicParams.Add("@ordercode", ordercode); |
| | | dynamicParams.Add("@stu_torgcode", stu_torgcode); |
| | | var da1 = DapperHelper.selectdata(sql, dynamicParams); |