| | |
|---|
| | | select distinct route_code from TMateriel_Route where materiel_code=@partcode and is_delete<>'1' |
|---|
| | | ) B |
|---|
| | | on A.code=B.route_code |
|---|
| | | where A.is_delete='0'"; |
|---|
| | | where A.is_delete='0' and A.enable='Y'"; |
|---|
| | | dynamicParams.Add("@partcode", partcode); |
|---|
| | | var data = DapperHelper.selectdata(sql, dynamicParams); |
|---|
| | | for (int i = 0; i < data.Rows.Count; i++) |
|---|
| | |
|---|
| | | { |
|---|
| | | if (routecode != "" && routecode != null) |
|---|
| | | { |
|---|
| | | search += "and A.code like '%'+@partcode+'%' "; |
|---|
| | | search += "and A.code like '%'+@routecode+'%' "; |
|---|
| | | dynamicParams.Add("@routecode", routecode); |
|---|
| | | } |
|---|
| | | if (routename != "" && routename != null) |
|---|
| | |
|---|
| | | } |
|---|
| | | if (description != "" && description != null) |
|---|
| | | { |
|---|
| | | search += "and A.description=@description "; |
|---|
| | | search += "and A.description like '%'+@description+'%' "; |
|---|
| | | dynamicParams.Add("@description", description); |
|---|
| | | } |
|---|
| | | if (createuser != "" && createuser != null) |
|---|
| | | { |
|---|
| | | search += "and U.username=@createuser "; |
|---|
| | | search += "and U.username like '%'+@createuser+'%' "; |
|---|
| | | dynamicParams.Add("@createuser", createuser); |
|---|
| | | } |
|---|
| | | if (search == "") |
|---|
| | |
|---|
| | | try |
|---|
| | | { |
|---|
| | | //获取工序数据 |
|---|
| | | sql = @"select stepcode,stepname from TStep where is_delete<>'1' "; |
|---|
| | | sql = @"select stepcode,stepname from TStep where is_delete<>'1' and enable='Y'"; |
|---|
| | | var data = DapperHelper.selecttable(sql); |
|---|
| | | mes.code = "200"; |
|---|
| | | mes.Message = "查询成功!"; |
|---|
