| | |
|---|
| | | pars[1].Direction = System.Data.ParameterDirection.Output; |
|---|
| | | pars[2].Direction = System.Data.ParameterDirection.Output; |
|---|
| | | Biz.Db.Ado.UseStoredProcedure().ExecuteCommand("SP_MES_WO2CUST", pars); |
|---|
| | | //response.LocaleMsg = new(pars[2].Value.ToString()); |
|---|
| | | if (pars[1].Value.ToInt32() == 0) |
|---|
| | | { |
|---|
| | | Logger.Default.Info($"工单[{input.Wo.ORDER_NO}]下发完成后保存工艺路线数据到产品[{input.Wo.ITEM_CODE}]的客户[{input.Wo.CUST_CODE ?? ""}]的工艺路线中，{pars[2].Value.ToString()}"); |
|---|
| | |
|---|
| | | //如果查不到就去行为日志查 |
|---|
| | | if (labelPrint.IsNullOrEmpty() && input.ReqType == 1) |
|---|
| | | { |
|---|
| | | printParam = Biz.Db.Queryable<MES_WIP_ACT>().Where(q => q.CARTON_SN.Equals(woSn.OUTER_SN) && q.ACT_VALUE_4 == "Customer").First()?.ACT_VALUE_3 ?? ""; |
|---|
| | | printParam = Biz.Db.Queryable<MES_WIP_ACT>().Where(q => q.CARTON_SN.Equals(woSn.OUTER_SN) && q.ACT_VALUE_4 == "Customer" && !SqlFunc.IsNullOrEmpty(q.ACT_VALUE_3)).First()?.ACT_VALUE_3 ?? ""; |
|---|
| | | } |
|---|
| | | else if (labelPrint.IsNullOrEmpty() && input.ReqType == 2) |
|---|
| | | { |
|---|
| | |
|---|
| | | SALES_ORDER = wo.SALES_ORDER, |
|---|
| | | BATCH_NO = woSns[0].BATCH_NO, |
|---|
| | | ITEM_CODE = wo.ITEM_CODE, |
|---|
| | | SapCode = wo.ItemInfo?.ExtInfo?.SapCode, |
|---|
| | | ITEM_NAME = wo.ItemInfo?.ITEM_DESC, |
|---|
| | | PLAN_QTY = wo.PLAN_QTY, |
|---|
| | | SCAN_QTY = woSns.Count, |
|---|
