| | |
|---|
| | | { |
|---|
| | | if (defectcode != "" && defectcode != null) |
|---|
| | | { |
|---|
| | | search += "and A.code=@defectcode "; |
|---|
| | | search += "and A.code like '%'+@defectcode+'%' "; |
|---|
| | | dynamicParams.Add("@defectcode", defectcode); |
|---|
| | | } |
|---|
| | | if (defectname != "" && defectname != null) |
|---|
| | |
|---|
| | | { |
|---|
| | | if (stanedcode != "" && stanedcode != null) |
|---|
| | | { |
|---|
| | | search += "and A.code=@stanedcode "; |
|---|
| | | search += "and A.code like '%'+@stanedcode+'%' "; |
|---|
| | | dynamicParams.Add("@stanedcode", stanedcode); |
|---|
| | | } |
|---|
| | | if (stanedname != "" && stanedname != null) |
|---|
| | |
|---|
| | | if (opertype == "Update") |
|---|
| | | { |
|---|
| | | //删除工序检验标准子表 |
|---|
| | | sql = @"delete from TStepCheckStandard where code=@stepstaned_code"; |
|---|
| | | sql = @"delete from TStepCheckStandardSub where stepstaned_code=@stepstaned_code"; |
|---|
| | | list.Add(new { str = sql, parm = new { stepstaned_code = json.code} }); |
|---|
| | | //修改工序检验标准主表 |
|---|
| | | sql = @"update TStepCheckStandard set name=@stepstaned_name,descr=@stepstaned_desc where code=@stepstaned_code"; |
|---|
| | |
|---|
| | | { |
|---|
| | | if (itemcode != "" && itemcode != null) |
|---|
| | | { |
|---|
| | | search += "and A.code=@itemcode "; |
|---|
| | | search += "and A.code like '%'+@itemcode+'%' "; |
|---|
| | | dynamicParams.Add("@itemcode", itemcode); |
|---|
| | | } |
|---|
| | | if (itemname != "" && itemname != null) |
|---|
