| | |
|---|
| | | } |
|---|
| | | #endregion |
|---|
| | | |
|---|
| | | #region[MES工单工序任务查看SOP,获取SOP文件下拉列表] |
|---|
| | | public static ToMessage SearchWorkStepSopList(string partcode, string routecode,string stepcode) |
|---|
| | | { |
|---|
| | | string sql = ""; |
|---|
| | | var dynamicParams = new DynamicParameters(); |
|---|
| | | try |
|---|
| | | { |
|---|
| | | //获取SOP文件信息 |
|---|
| | | sql = @"select id,define_name,file_path from TK_Sop_Matfile where materiel_code=@partcode and eqptype_code in( |
|---|
| | | select distinct T.code from TMateriel_Route A |
|---|
| | | inner join TFlw_Rtdt B on A.route_code=B.rout_code |
|---|
| | | inner join TFlw_Rteqp E on B.step_code=E.step_code |
|---|
| | | inner join TEqpInfo Q on E.eqp_code=Q.code |
|---|
| | | inner join TEqpType T on Q.eqptype_code=T.code |
|---|
| | | where A.materiel_code=@partcode and A.route_code=@routecode and B.step_code=@stepcode)"; |
|---|
| | | dynamicParams.Add("@partcode", partcode); |
|---|
| | | dynamicParams.Add("@routecode", routecode); |
|---|
| | | dynamicParams.Add("@stepcode", stepcode); |
|---|
| | | var data = DapperHelper.selectdata(sql, dynamicParams); |
|---|
| | | mes.code = "200"; |
|---|
| | | mes.Message = "查询成功!"; |
|---|
| | | mes.data = data; |
|---|
| | | } |
|---|
| | | catch (Exception e) |
|---|
| | | { |
|---|
| | | mes.code = "300"; |
|---|
| | | mes.count = 0; |
|---|
| | | mes.Message = e.Message; |
|---|
| | | mes.data = null; |
|---|
| | | } |
|---|
| | | return mes; |
|---|
| | | } |
|---|
| | | #endregion |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | #region[生产开报工扫码获取工单对应工序任务(自制)] |
|---|
| | |
|---|
| | | var total = 0; //总条数 |
|---|
| | | var sql = @"select * from( |
|---|
| | | select A.id,B.id as sbid,A.wo_code,A.materiel_code as partnumber,P.partname,P.partspec,A.task_qty,M.wkshp_code,G.org_name as wkshp_name,A.eqp_code,E.name as eqp_name, |
|---|
| | | M.route_code,R.name as route_name,A.step_code,S.stepname,S.flwtype,D.first_choke,D.last_choke,T.unprice,B.usergroup_code,O.group_name as usergroup_name,B.report_person as usercode,U.username, |
|---|
| | | M.route_code,R.name as route_name,A.step_seq,A.step_code,S.stepname,S.flwtype,D.first_choke,D.last_choke,T.unprice,B.report_person as usercode,U.username, |
|---|
| | | B.report_date,B.report_qty,B.ng_qty,B.bad_qty,B.verify,B.bad_money |
|---|
| | | from TK_Wrk_Record A |
|---|
| | | inner join TK_Wrk_RecordSub B on A.id=B.m_id |
|---|
| | |
|---|
| | | left join TFlw_Rout R on M.route_code=R.code |
|---|
| | | left join TFlw_Rtdt D on M.route_code=D.rout_code and A.step_code=D.step_code |
|---|
| | | left join TUser U on B.report_person=U.usercode |
|---|
| | | left join TGroup O on U.usergroup_code=O.group_code |
|---|
| | | where A.style='B' and B.style='B' and M.status<>'CLOSED' |
|---|
| | | ) as AA where" + search; |
|---|
| | | //union all |
|---|
| | |
|---|
| | | |
|---|
| | | } |
|---|
| | | //是否末道 |
|---|
| | | if (json[i].last_choke == "Y") |
|---|
| | | else if (json[i].last_choke == "Y") |
|---|
| | | { |
|---|
| | | decimal this_reportqty = decimal.Parse(json[i].report_qty.ToString()); //报工数量(合格) |
|---|
| | | decimal this_ngqty = decimal.Parse(json[i].ng_qty.ToString()); //不良数量 |
|---|
| | |
|---|
| | | first_choke=json[i].first_choke.ToString(), |
|---|
| | | last_choke=json[i].last_choke.ToString(), |
|---|
| | | unprice=json[i].unprice.ToString(), |
|---|
| | | usergroup_code=json[i].usergroup_code.ToString(), |
|---|
| | | usergroup_code="", |
|---|
| | | usercode=json[i].usercode.ToString(), |
|---|
| | | report_date=json[i].report_date.ToString(), |
|---|
| | | report_qty=json[i].report_qty.ToString(), |
|---|
| | |
|---|
| | | wo_code=json[i].wo_code.ToString(), |
|---|
| | | step_seq=json[i].step_seq.ToString(), |
|---|
| | | step_code=json[i].step_code.ToString(), |
|---|
| | | repair_qty = decimal.Parse(json[i].report_qty), |
|---|
| | | report_qty = decimal.Parse(json[i].report_qty), |
|---|
| | | ng_qty = decimal.Parse(json[i].ng_qty), |
|---|
| | | bad_qty = decimal.Parse(json[i].bad_qty), |
|---|
| | | } |
|---|
