| | |
|---|
| | | { |
|---|
| | | if (search != "" && search != null) |
|---|
| | | { |
|---|
| | | sech += "and concat(isnull(AA.partcode,''),isnull(AA.partname,''),isnull(AA.partname,''),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") |
|---|
| | |
|---|
| | | dynamicParams.Add("@rn", 1); |
|---|
| | | } |
|---|
| | | |
|---|
| | | if (search == "") |
|---|
| | | if (sech == "") |
|---|
| | | { |
|---|
| | | sech = "and 1=1 "; |
|---|
| | | } |
|---|
| | | search = search.Substring(3);//截取索引2后面的字符 |
|---|
| | | 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 |
|---|
| | | left join TEqpType T on A.eqptype_code=T.code |
|---|
| | | left join TUser U on A.lm_user=U.usercode |
|---|
| | | ) as AA where " + sech + " order by AA.lm_date"; |
|---|
| | | ) as AA where " + sech + ""; |
|---|
| | | var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total); |
|---|
| | | mes.code = "200"; |
|---|
| | | mes.Message = "查询成功!"; |
|---|
| | |
|---|
| | | { |
|---|
| | | mes.code = "200"; |
|---|
| | | mes.Message = "获取版本号成功!"; |
|---|
| | | mes.data = "V" + data.Rows[0]["version"].ToString(); |
|---|
| | | mes.data = "V" + data.Rows[0]["file_version"].ToString(); |
|---|
| | | } |
|---|
| | | else |
|---|
| | | { |
|---|
| | |
|---|
| | | { |
|---|
| | | //写入SOP文件表 |
|---|
| | | sql = @"insert into TK_Sop_Matfile(materiel_code,eqptype_code,filetype_code,file_name,define_name,file_version,file_path,lm_user,lm_date) |
|---|
| | | values(@wksp_code,@title,@contents,@if_cancel,@cancel_date,@lm_user,@lm_date,@priority)"; |
|---|
| | | values(@materiel_code,@eqptype_code,@filetype_code,@file_name,@define_name,@file_version,@file_path,@lm_user,@lm_date)"; |
|---|
| | | list.Add(new |
|---|
| | | { |
|---|
| | | str = sql, |
|---|
