1.工单添加打印次数接口

yl

2025-03-13 4bb9eb9998a66f9e3057ce8ff641e016a768a10d

1.工单添加打印次数接口

 VueWebCoreApi/Controllers/WorkOrderController.cs

@@ -299,6 +299,21 @@
        }
        #endregion

        #region[MES工单打印更新打印次数]
        /// <summary>
        /// MES工单打印更新打印次数
        /// </summary>
        /// <param name="wo_code">工单编号</param>
        /// <returns></returns>
        [Route(template: "UpdateMesOrderPrintCount")]
        [HttpPost]
        public JsonResult UpdateMesOrderPrintCount(string wo_code)
        {
            mes = WorkOrderBLL.UpdateMesOrderPrintCount(wo_code);
            return Json(mes);
        }
        #endregion


        #region[MES工单删除]
        /// <summary>

 VueWebCoreApi/DLL/BLL/WorkOrderBLL.cs

@@ -102,6 +102,13 @@
        }
        #endregion

        #region[MES工单打印更新打印次数]
        public static ToMessage UpdateMesOrderPrintCount(string wo_code)
        {
            return WorkOrderDAL.UpdateMesOrderPrintCount(wo_code);
        }
        #endregion


        #region[MES工单删除]
        public static ToMessage DeleteMesOrder(string souceid, string wocode, string m_po, string orderqty, User us)

 VueWebCoreApi/DLL/DAL/WorkOrderDAL.cs

@@ -627,7 +627,7 @@
                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,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
@@ -1355,6 +1355,45 @@
        }
        #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工单删除]