| | |
|---|
| | | // --------------查询指定数据-------------- |
|---|
| | | var total = 0; //总条数 |
|---|
| | | var sql = @"select * from( |
|---|
| | | select code,name,status,checktype,sampmethod,sampscare,suitobject,descr,suitpart, |
|---|
| | | case when suitobject='P' then |
|---|
| | | select A.code,A.name,A.status,A.checktype,A.sampmethod,A.sampscare,A.suitobject,A.descr,A.suitpart,A.lm_date,U.username, |
|---|
| | | case when A.suitobject='P' then |
|---|
| | | STUFF(( SELECT ';' + partname |
|---|
| | | FROM TMateriel_Info |
|---|
| | | where PATINDEX('%;' + RTRIM(TMateriel_Info.partcode) + ';%',';' + TStepCheckStandard.suitpart + ';')>0 |
|---|
| | | where PATINDEX('%;' + RTRIM(TMateriel_Info.partcode) + ';%',';' + A.suitpart + ';')>0 |
|---|
| | | FOR XML PATH('')), 1, 1,'') |
|---|
| | | when suitobject='PY' |
|---|
| | | when A.suitobject='PY' |
|---|
| | | then |
|---|
| | | STUFF(( SELECT ';' + name |
|---|
| | | FROM T_Dict |
|---|
| | | where PATINDEX('%;' + RTRIM(T_Dict.code) + ';%',';' + TStepCheckStandard.suitpart + ';')>0 |
|---|
| | | where PATINDEX('%;' + RTRIM(T_Dict.code) + ';%',';' + A.suitpart + ';')>0 |
|---|
| | | FOR XML PATH('')), 1, 1,'') |
|---|
| | | end as suitpartname |
|---|
| | | from TStepCheckStandard |
|---|
| | | from TStepCheckStandard A |
|---|
| | | left join TUser U on A.lm_user=U.usercode |
|---|
| | | ) as AA |
|---|
| | | where " + search; |
|---|
| | | var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total); |
|---|
| | |
|---|
| | | try |
|---|
| | | { |
|---|
| | | sql = @"select A.stepcheckitem_seq,A.stepcheckitem_code,B.name as stepcheckitem_name,A.required, |
|---|
| | | A.numberjudge,A.unit,A.decimal,A.standvalue,A.uppervalue,A.lowervalue |
|---|
| | | A.numberjudge,A.unit,A.decimalnum,A.standvalue,A.uppervalue,A.lowervalue,A.stepcheckitem_desc |
|---|
| | | from TStepCheckStandardSub A |
|---|
| | | inner join TStepCheckItem B on A.stepcheckitem_code=B.code |
|---|
| | | where A.stepstaned_code=@qualityinsptcode"; |
|---|
| | |
|---|
| | | required = arra[i]["required"].ToString(), |
|---|
| | | numberjudge = arra[i]["numberjudge"].ToString(), |
|---|
| | | unit = arra[i]["unit"].ToString(), |
|---|
| | | decimalnum = Convert.ToInt32(arra[i]["decimalnum"].ToString()), |
|---|
| | | decimalnum = arra[i]["decimalnum"].ToString(), |
|---|
| | | standvalue = arra[i]["standvalue"].ToString(), |
|---|
| | | uppervalue = arra[i]["uppervalue"].ToString(), |
|---|
| | | lowervalue = arra[i]["lowervalue"].ToString(), |
|---|
| | |
|---|
| | | break; |
|---|
| | | case "Update"://修改 |
|---|
| | | //判断是否生成检验记录(入厂检验(InCheck) 出厂检验(OutCheck) FirstCheck（首检） PatroCheck(巡检) EndCheck(完工检)) |
|---|
| | | sql = @"select * from TStepCheckRecord where checkstaned_code=@qualityinsptcode and checktype=@checktype"; |
|---|
| | | sql = @"select * from TStepCheckRecord where checkstaned_code=@qualityinsptcode and check_type=@checktype"; |
|---|
| | | dynamicParams.Add("@qualityinsptcode", qualityinsptcode); |
|---|
| | | dynamicParams.Add("@checktype", checktype); |
|---|
| | | var data = DapperHelper.selectdata(sql, dynamicParams); |
|---|
| | |
|---|
| | | required = arra[i]["required"].ToString(), |
|---|
| | | numberjudge = arra[i]["numberjudge"].ToString(), |
|---|
| | | unit = arra[i]["unit"].ToString(), |
|---|
| | | decimalnum = Convert.ToInt32(arra[i]["decimalnum"].ToString()), |
|---|
| | | decimalnum = arra[i]["decimalnum"].ToString(), |
|---|
| | | standvalue = arra[i]["standvalue"].ToString(), |
|---|
| | | uppervalue = arra[i]["uppervalue"].ToString(), |
|---|
| | | lowervalue = arra[i]["lowervalue"].ToString(), |
|---|
