智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
zrg
2024-12-17 5f80502131c90ebc2dfaa1b5b2d84ceca313b0c6 
 WebAPI/Controllers/ÌõÂë¹ÜÀí/WEBSController.cs


@@ -4497,6 +4497,8 @@


            string sJXCode = "";


            if (oSystemParameter.ShowBill(ref sErrMsg) == true)


            {


                LogService.Write("森楷扫码参数值，客户：" + oSystemParameter.omodel.WMS_CampanyName + " ,源单类型：" + HSourceBillType);




                if (oSystemParameter.omodel.WMS_CampanyName == "安瑞") //系统参数  å®¢æˆ·å®šåˆ¶åŒ–名称     ç©ºç™½ä¸ºé€šç”¨


                {


                    sJXCode = POStockInBillController.JX_Json(sBarCode, HInterID, HBillType, HStockOrgID, HBillNo, HMaker);


@@ -4504,6 +4506,7 @@


                }


                else if(oSystemParameter.omodel.WMS_CampanyName == "森楷" && HSourceBillType == "1241")


                {


                    LogService.Write("森楷其他入库扫码条码记录：" + sBarCode);


                    DataSet ds;


                    string sql = "select HBarCode,HSourceInterID,HSourceEntryID,HSourceBillNo from Gy_BarCodeBill with(nolock) where HBarCode = '" + sBarCode + "'";


                    string HDataBaseName = Util.GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "/Config/kdapi.config", "DataBaseName");//获取金蝶数据库名称


@@ -4514,6 +4517,7 @@


                    //判断条码信息是否在条码档案中


                    if (ds == null || ds.Tables[0].Rows.Count < 1)


                    {


                        LogService.Write("其他入库，条码档案中不存在此条码编号：" + sBarCode);


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "条码档案中不存在此条码编号：" + sBarCode;


@@ -4741,7 +4745,7 @@


                            }




                            //更新条码源单id信息


                            sql = string.Format($@"update a set HSourceInterID = b.FID,HSourceEntryID = c.FEntryID from Gy_BarCodeBill a left join AIS20220609121235..TFKO_t_Cust100009 b on a.HSourceBillNo = b.FBillNo left join AIS20220609121235..TFKO_t_Cust_Entry100065 c on b.FID = C.FID and a.HBarcodeNo = c.FSEQ where HSourceBillNo = '{HSourceBillNo_TB}'");


                            sql = string.Format($@"update a set HSourceInterID = isnull(b.FID,0),HSourceEntryID = isnull(c.FEntryID,0) from Gy_BarCodeBill a left join AIS20220609121235..TFKO_t_Cust100009 b on a.HSourceBillNo = b.FBillNo left join AIS20220609121235..TFKO_t_Cust_Entry100065 c on b.FID = C.FID and a.HBarcodeNo = c.FSEQ where HSourceBillNo = '{HSourceBillNo_TB}'");


                            //执行更新语句


                            oCn.RunProc(sql);