杭氧

pengmn

2025-06-23 f398a14e78be869dbe96746bada7be3fc2b0b223

 HH.WCS.Mobox3.HangYang/wms/WMSHelper.cs

@@ -544,6 +544,50 @@

        #region 杭氧WMS帮助方法
        /// <summary>
        /// 新增物料主数据
        /// </summary>
        /// <param name="materials"></param>
        /// <returns></returns>
        internal static bool CreateMaterialData(List<TN_Material> materials)
        {
            try
            {
                bool res = false;
                var db = new SqlHelper<object>().GetInstance();
                db.BeginTran();
                foreach (var material in materials)
                {
                    var _Material = db.Queryable<TN_Material>().Where(c => c.S_ITEM_CODE == material.S_ITEM_CODE).First();
                    if (_Material != null)
                    {
                        db.Updateable<TN_Material>(material).UpdateColumns(a => new { a.S_ITEM_NAME, a.S_ITEM_TYPE, a.S_ITEM_SPEC, a.S_MATERIAL, a.S_UOM, a.C_CLEAN, a.T_MODIFY }).ExecuteCommand();
                    }
                    else
                    {
                        db.Insertable(material).ExecuteCommand();
                    }
                }
                db.CommitTran();
                res = true;
                return res;
            }
            catch (Exception ex)
            {
                var sugarEx = ex as SqlSugar.SqlSugarException;
                if (sugarEx != null)
                {
                    LogHelper.Error($"创建入库单SQL错误: {sugarEx.Sql}", sugarEx, "杭氧");
                }
                else
                {
                    LogHelper.Error($"创建入库单失败:{ex.Message}", ex, "杭氧");
                }
                return false;
            }

        }

        /// <summary>
        /// 新增入库单
        /// </summary>
        /// <param name="order"></param>
@@ -557,8 +601,24 @@
                db.BeginTran();
                foreach (var orderItem in order)
                {
                    var _order = db.Queryable<InOrder>().Where(c => c.S_NO == orderItem.S_NO).First();
                    if (_order != null)
                    {
                        if (_order.N_B_STATE == 0)
                        {
                            db.Updateable<InOrder>(orderItem).UpdateColumns(a => new { a.S_OP_TYPE, a.S_BS_TYPE, a.S_NOTE, a.T_MODIFY }).ExecuteCommand();
                            foreach (var item in orderItem.InOrderDetail)
                            {
                                db.Updateable<InOrderDetail>(item).UpdateColumns(a => new { a.S_ITEM_CODE, a.S_ITEM_NAME, a.F_QTY }).ExecuteCommand();
                            }
                        }
                    }
                    else
                    {
                    db.Insertable(orderItem).ExecuteCommand();
                    db.Insertable(orderItem.InOrderDetail).ExecuteCommand();
                    }

                }
                db.CommitTran();
                res = true;
@@ -594,8 +654,26 @@
                db.BeginTran();
                foreach (var orderItem in order)
                {

                    var _order = db.Queryable<OutOrder>().Where(c => c.S_NO == orderItem.S_NO).First();
                    if (_order != null)
                    {
                        if (_order.N_B_STATE == 0)
                        {
                            db.Updateable<OutOrder>(orderItem).UpdateColumns(a => new { a.S_OP_TYPE, a.S_BS_TYPE, a.S_NOTE, a.T_MODIFY }).ExecuteCommand();
                            foreach (var item in orderItem.OutOrderDetail)
                            {
                                db.Updateable<InOrderDetail>(item).UpdateColumns(a => new { a.S_ITEM_CODE, a.S_ITEM_NAME, a.F_QTY }).ExecuteCommand();
                            }
                        }
                    }
                    else
                    {
                    db.Insertable(orderItem).ExecuteCommand();
                    db.Insertable(orderItem.OutOrderDetail).ExecuteCommand();
                    }


                }
                db.CommitTran();
                res = true;
@@ -608,6 +686,105 @@
            }

        }

        /// <summary>
        /// 入库单取消
        /// </summary>
        /// <param name="order"></param>
        /// <returns></returns>
        internal static bool CancelOrderIn(InOrder order)
        {
            try
            {
                bool res = false;
                var db = new SqlHelper<object>().GetInstance();
                db.BeginTran();

                var _order = db.Queryable<InOrder>().Where(c => c.S_NO == order.S_NO).First();
                if (_order != null)
                {
                    if (_order.N_B_STATE == 0)
                    {
                        foreach (var item in order.OrderDetail)
                        {
                            db.Deleteable<InOrderDetail>().Where(it => it.S_ITEM_CODE.Trim() == item.S_ITEM_CODE && it.S_BS_NO == orderItem.S_BS_NO).ExecuteCommand();
                        }
                    }
                }
                var _orderItem = db.Queryable<InOrderDetail>().Where(c => c.S_BS_NO == order.S_BS_NO).First();
                if (_orderItem == null)
                {
                    db.Deleteable<InOrder>().Where(it => it.S_BS_NO == order.S_BS_NO).ExecuteCommand();
                }
                db.CommitTran();
                res = true;
                return res;
            }
            catch (Exception ex)
            {
                var sugarEx = ex as SqlSugar.SqlSugarException;
                if (sugarEx != null)
                {
                    LogHelper.Error($"取消入库单SQL错误: {sugarEx.Sql}", sugarEx, "杭氧");
                }
                else
                {
                    LogHelper.Error($"取消入库单失败:{ex.Message}", ex, "杭氧");
                }
                return false;
            }

        }

        /// <summary>
        /// 出库单取消
        /// </summary>
        /// <param name="order"></param>
        /// <returns></returns>
        internal static bool CancelOrderOut(OutOrder order)
        {
            try
            {
                bool res = false;
                var db = new SqlHelper<object>().GetInstance();
                db.BeginTran();

                var _order = db.Queryable<OutOrder>().Where(c => c.S_NO == order.S_NO).First();
                if (_order != null)
                {
                    if (_order.N_B_STATE == 0)
                    {
                        foreach (var item in order.OrderDetail)
                        {
                            db.Deleteable<OutOrderDetail>().Where(it => it.S_ITEM_CODE.Trim() == item.S_ITEM_CODE && it.S_BS_NO == orderItem.S_BS_NO).ExecuteCommand();
                        }
                    }
                }
                var _orderItem = db.Queryable<OutOrderDetail>().Where(c => c.S_BS_NO == order.S_BS_NO).First();
                if (_orderItem == null)
                {
                    db.Deleteable<OutOrder>().Where(it => it.S_BS_NO == order.S_BS_NO).ExecuteCommand();
                }
                db.CommitTran();
                res = true;
                return res;
            }
            catch (Exception ex)
            {
                var sugarEx = ex as SqlSugar.SqlSugarException;
                if (sugarEx != null)
                {
                    LogHelper.Error($"取消出库单SQL错误: {sugarEx.Sql}", sugarEx, "杭氧");
                }
                else
                {
                    LogHelper.Error($"取消出库单失败:{ex.Message}", ex, "杭氧");
                }
                return false;
            }

        }

        #endregion

        #region 杭氧特殊帮助方法