| | |
| | | { |
| | | string sql = ""; |
| | | string search = ""; |
| | | List<ShopTopLeft> list = new List<ShopTopLeft>(); |
| | | var dynamicParams = new DynamicParameters(); |
| | | try |
| | | { |
| | | if (json == null || json.Count <= 0) //产线编码不为空 |
| | | if (json == null || json.Count>0) //产线编码不为空 |
| | | { |
| | | List<ShopTopLeft> list = new List<ShopTopLeft>(); |
| | | //获取产线信息 |
| | | for (int i = 0; i < json.Count; i++) |
| | | { |
| | |
| | | from TK_Wrk_Step A |
| | | left join TStep T on A.step_code=T.stepcode |
| | | where A.wo_code=@wo_code"; |
| | | dynamicParams.Add("@linecode", wo_code); |
| | | dynamicParams.Add("@wo_code", wo_code); |
| | | var data1 = DapperHelper.selectdata(sql, dynamicParams); |
| | | for (int k = 0; k < data1.Rows.Count; k++) |
| | | { |
| | |
| | | mes.Message = e.Message; |
| | | mes.data = null; |
| | | } |
| | | mes.code = "200"; |
| | | mes.Message = "查询成功!"; |
| | | mes.data = list; |
| | | return mes; |
| | | } |
| | | #endregion\ |