| | |
|---|
| | | { |
|---|
| | | if (search != "" && search != null) |
|---|
| | | { |
|---|
| | | sech += "and concat(isnull(AA.partcode,''),isnull(AA.partname,''),isnull(AA.partspec,''),isnull(AA.eqptype_name,''),isnull(AA.filetype_name,''),isnull(AA.file_name,''),isnull(AA.file_version,''),isnull(AA.username,'')) like '%@search%' "; |
|---|
| | | sech += "and concat(isnull(AA.partcode,''),isnull(AA.partname,''),isnull(AA.partspec,''),isnull(AA.eqptype_name,''),isnull(AA.filetype_name,''),isnull(AA.define_name,''),isnull(AA.file_version,''),isnull(AA.username,'')) like '%'+@search+'%' "; |
|---|
| | | dynamicParams.Add("@search", search); |
|---|
| | | } |
|---|
| | | if (check == "Y") |
|---|
| | |
|---|
| | | sech = sech.Substring(3);//截取索引2后面的字符 |
|---|
| | | // --------------查询指定数据-------------- |
|---|
| | | var total = 0; //总条数 |
|---|
| | | var sql = @"select AA.id,AA.partcode,AA.partname,AA.partspec,AA.eqptype_code,AA.eqptype_name,AA.filetype_code,AA.filetype_name,AA.file_name,AA.file_version,AA.file_path, |
|---|
| | | var sql = @"select AA.id,AA.partcode,AA.partname,AA.partspec,AA.eqptype_code,AA.eqptype_name,AA.filetype_code,AA.filetype_name,AA.file_name,AA.define_name,AA.file_version,AA.file_path, |
|---|
| | | AA.username,AA.lm_date,AA.rn from( |
|---|
| | | select top 100 A.id,M.partcode,M.partname,M.partspec,A.eqptype_code,T.name as eqptype_name,A.filetype_code, |
|---|
| | | (case when A.filetype_code='P001' then '作业指导书' when A.filetype_code='P002' then '检验指导书' when A.filetype_code='P003' then '图纸' end) as filetype_name, |
|---|
| | | A.file_name,A.file_version,A.file_path,U.username,A.lm_date, |
|---|
| | | A.file_name,A.define_name,A.file_version,A.file_path,U.username,A.lm_date, |
|---|
| | | row_number() over(partition by A.materiel_code,A.filetype_code order by replace(A.file_version,'V','') desc) rn |
|---|
| | | from TK_Sop_Matfile A |
|---|
| | | left join TMateriel_Info M on A.materiel_code=M.partcode |
|---|
