| | |
|---|
| | | } |
|---|
| | | if (partcode != "" && partcode != null) |
|---|
| | | { |
|---|
| | | search += "and A.partcode like '%'+@stanedname+'%' "; |
|---|
| | | search += "and A.partcode like '%'+@partcode+'%' "; |
|---|
| | | dynamicParams.Add("@partcode", partcode); |
|---|
| | | } |
|---|
| | | if (partname != "" && partname != null) |
|---|
| | |
|---|
| | | search = search.Substring(3);//截取索引2后面的字符 |
|---|
| | | // --------------查询指定数据-------------- |
|---|
| | | var total = 0; //总条数 |
|---|
| | | var sql = @"select A.wo_code,A.partcode,B.partname,B.partspec,A.step_code,S.stepname,A.checkstaned_code,T.name as checkstaned_name,A.check_user, |
|---|
| | | var sql = @"select A.id,A.wo_code,A.partcode,B.partname,B.partspec,A.step_code,S.stepname,A.checkstaned_code,T.name as checkstaned_name,A.check_user, |
|---|
| | | A.check_type,A.check_result,A.check_descr,A.check_qty,U.username as lm_user,A.lm_date |
|---|
| | | from TStepCheckRecord A |
|---|
| | | left join TMateriel_Info B on A.partcode=B.partcode |
|---|
