| | |
|---|
| | | } |
|---|
| | | // --------------查询指定数据-------------- |
|---|
| | | var total = 0; //总条数 |
|---|
| | | var sql = @"select A.id, A.status,A.wotype,A.wo_code,A.materiel_code as partcode,B.partname,B.partspec,A.route_code,R.name as route_name,A.plan_qty,A.wkshp_code,C.torg_name as wkshp_name, |
|---|
| | | var sql = @"select A.id, A.status,A.wotype,A.wo_code,A.materiel_code as partcode,B.partname,B.partspec,A.route_code,B.default_route,R.name as route_name,A.plan_qty,A.wkshp_code,C.torg_name as wkshp_name, |
|---|
| | | A.stck_code,D.name as stck_name,A.plan_startdate,A.plan_enddate,A.piroque,A.sourceid,A.m_po,A.saleOrderDeliveryDate,W.saleOrderCode,U.username as lm_user,A.lm_date,A.data_sources,A.isstep,A.clerkuser, |
|---|
| | | B.priuserdefnvc1,B.priuserdefnvc2,B.priuserdefnvc3,B.priuserdefnvc4,B.priuserdefnvc5,B.priuserdefnvc6 |
|---|
| | | B.priuserdefnvc1,B.priuserdefnvc2,B.priuserdefnvc3,B.priuserdefnvc4,B.priuserdefnvc5,B.priuserdefnvc6,A.printcount |
|---|
| | | from TK_Wrk_Man A |
|---|
| | | left join TKimp_Ewo W on A.m_po=W.wo and A.materiel_code=W.materiel_code and A.sbid=W.sbid |
|---|
| | | left join TMateriel_Info B on A.materiel_code=B.partcode |
|---|
| | |
|---|
| | | { |
|---|
| | | for (int i = 0; i < json.Count; i++) |
|---|
| | | { |
|---|
| | | route_code = json[i].routecode; |
|---|
| | | //修改工单表 |
|---|
| | | sql = @"update TK_Wrk_Man set wotype=@wotype,wkshp_code=@wkshp_code,plan_qty=@plan_qty,lm_user=@lm_user,lm_date=@lm_date, |
|---|
| | | materiel_code=@materiel_code,route_code=@route_code,sourceid=@sourceid,m_po=@m_po,saleOrderDeliveryDate=@saleOrderDeliveryDate,plan_startdate=@plan_startdate,plan_enddate=@plan_enddate,isstep=@isstep |
|---|
| | |
|---|
| | | } |
|---|
| | | #endregion |
|---|
| | | |
|---|
| | | #region[MES工单打印更新打印次数] |
|---|
| | | public static ToMessage UpdateMesOrderPrintCount(string wo_code) |
|---|
| | | { |
|---|
| | | var sql = ""; |
|---|
| | | List<object> list = new List<object>(); |
|---|
| | | var dynamicParams = new DynamicParameters(); |
|---|
| | | try |
|---|
| | | { |
|---|
| | | //更新工单打印次数 |
|---|
| | | sql = @"update TK_Wrk_Man set printcount=printcount+1 where wo_code=@wo_code"; |
|---|
| | | list.Add(new { str = sql, parm = new { wo_code = wo_code } }); |
|---|
| | | |
|---|
| | | bool aa = DapperHelper.DoTransaction(list); |
|---|
| | | if (aa) |
|---|
| | | { |
|---|
| | | mes.code = "200"; |
|---|
| | | mes.count = 0; |
|---|
| | | mes.message = "更新成功!"; |
|---|
| | | mes.data = null; |
|---|
| | | } |
|---|
| | | else |
|---|
| | | { |
|---|
| | | mes.code = "300"; |
|---|
| | | mes.count = 0; |
|---|
| | | mes.message = "更新失败!"; |
|---|
| | | mes.data = null; |
|---|
| | | } |
|---|
| | | } |
|---|
| | | catch (Exception e) |
|---|
| | | { |
|---|
| | | mes.code = "300"; |
|---|
| | | mes.count = 0; |
|---|
| | | mes.message = e.Message; |
|---|
| | | mes.data = null; |
|---|
| | | } |
|---|
| | | return mes; |
|---|
| | | } |
|---|
| | | #endregion |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | #region[MES工单删除] |
|---|
| | |
|---|
| | | if (route) //工艺路线版 |
|---|
| | | { |
|---|
| | | //MES工单查找历史引用最新工序信息 |
|---|
| | | sql = @"select S.wo_code,S.seq,S.step_code,S.stepprice,isbott,isend |
|---|
| | | sql = @"select S.wo_code,S.seq,S.step_code,T.stepname as step_name,S.stepprice,isbott,isend |
|---|
| | | from TK_Wrk_Step S |
|---|
| | | inner join ( |
|---|
| | | select top 1 A.wo_code,A.route_code from TK_Wrk_Man A |
|---|
| | |
|---|
| | | else |
|---|
| | | { |
|---|
| | | //MES工单查找历史引用最新工序信息 |
|---|
| | | sql = @"select S.wo_code,S.seq,S.step_code,S.stepprice,isbott,isend |
|---|
| | | sql = @"select S.wo_code,S.seq,S.step_code,T.stepname as step_name,S.stepprice,isbott,isend |
|---|
| | | from TK_Wrk_Step S |
|---|
| | | inner join ( |
|---|
| | | select top 1 A.wo_code from TK_Wrk_Man A |
|---|
