feat: 更新数据库连接配置和机器人任务处理逻辑

wanshenmean

昨天 05999b9c77f009ac9a7e98366bc3d23fbb8e83e7

 Code/WMS/WIDESEA_WMSServer/WIDESEA_StockService/StockSerivce.cs

@@ -209,6 +209,30 @@

                return await ExecuteWithinTransactionAsync(async () =>
                {
                    // 幂等写入：检查临时表是否已有该托盘记录，无则写入
                    var existingTemp = SqlSugarClient.Queryable<Dt_SplitTemp>()
                        .Where(t => t.PalletCode == stock.SourcePalletNo)
                        .First();
                    if (existingTemp == null)
                    {
                        // 查询该托盘当前所有电芯，存入临时表
                        var sourceStockForTemp = StockInfoService.Repository.QueryFirst(s => s.PalletCode == stock.SourcePalletNo);
                        if (sourceStockForTemp != null)
                        {
                            var allDetails = StockInfoDetailService.Repository.QueryData(d => d.StockId == sourceStockForTemp.Id);
                            if (allDetails != null && allDetails.Any())
                            {
                                var sfcListJson = JsonConvert.SerializeObject(allDetails.Select(d => d.SerialNumber).ToList());
                                await SqlSugarClient.Insertable(new Dt_SplitTemp
                                {
                                    PalletCode = stock.SourcePalletNo,
                                    SfcList = sfcListJson,
                                    CreateTime = DateTime.Now
                                }).ExecuteCommandAsync();
                            }
                        }
                    }

                    var sourceStock = await StockInfoService.Repository.QueryDataNavFirstAsync(s => s.PalletCode == stock.SourcePalletNo);
                    if (sourceStock == null) return content.Error("源托盘不存在");