示例#1
0
        //更新服务器的版本
        private void UpdateServerVersion()
        {
            if (txtSourceDIR.Text.Trim() == String.Empty ||
                txtTargetDIR.Text.Trim() == String.Empty)
            {
                return;
            }
            object obj = getServerVersion();

            if (lblNewVersion.Text.IndexOf("无需更新") < 0)
            {
                string sql = String.Empty;
                if (obj == null)
                {
                    sql = "insert into TBLCSUPDATER (CSVERSION,LOCATION,ISAVIABLE) values ('"
                          + lblNewVersion.Text.Trim() + "','"
                          + txtTargetDIR.Text.Trim() + "',1)";
                }
                else
                {
                    sql = "update TBLCSUPDATER set CSVERSION = '" + lblNewVersion.Text.Trim()
                          + "',LOCATION ='" + txtTargetDIR.Text.Trim() + "',ISAVIABLE=1 where ISAVIABLE = 1";
                }

                _domainDataProvider.BeginTransaction();
                try
                {
                    _domainDataProvider.CustomExecute(
                        new SQLCondition(sql));

                    _domainDataProvider.CommitTransaction();

                    FileLog.FileLogOut(lblNewVersion.Text + "\tOK");
                }
                catch (Exception ex)
                {
                    Log.Error(ex.Message);
                    _domainDataProvider.RollbackTransaction();
                    throw ex;
                }
                finally
                {
                    (_domainDataProvider as SQLDomainDataProvider).PersistBroker.CloseConnection();
                }
            }
        }
示例#2
0
        public void ImportWorkPlan(bool isRollBack)
        {
            ShiftModelFacade shiftModelFacade = new ShiftModelFacade(this._DataProvider);
            DBDateTime       now = FormatHelper.GetNowDBDateTime(this._DataProvider);

            object[] objs  = ConvertArrayListToObjectArray(_ImportDataTable);
            object[] objDt = ConvertArrayListToObjectArray(_ImportDataTable);

            try
            {
                _DataProvider.BeginTransaction();

                if (objs != null && objDt != null)
                {
                    for (int i = 0; i < objs.Length; i++)
                    {
                        try
                        {
                            GridRecord row = _ImportGridRow[i] as GridRecord;
                            WorkPlan   workPlanFromExcel = objs[i] as WorkPlan;
                            int        shiftDay          = shiftModelFacade.GetShiftDayByBigSSCode(workPlanFromExcel.BigSSCode, now.DateTime);
                            if (_MaterialFacade == null)
                            {
                                _MaterialFacade = new MaterialFacade(_DataProvider);
                            }

                            WorkPlan objWorkPlanFromDB = (WorkPlan)_MaterialFacade.GetWorkPlan(workPlanFromExcel.BigSSCode, workPlanFromExcel.PlanDate,
                                                                                               workPlanFromExcel.MoCode, workPlanFromExcel.MoSeq);

                            if (objWorkPlanFromDB != null)
                            {
                                ((WorkPlan)objs[i]).MaterialQty      = objWorkPlanFromDB.MaterialQty;
                                ((WorkPlan)objs[i]).ActQty           = objWorkPlanFromDB.ActQty;
                                ((WorkPlan)objs[i]).MaterialStatus   = objWorkPlanFromDB.MaterialStatus;
                                ((WorkPlan)objs[i]).ActionStatus     = objWorkPlanFromDB.ActionStatus;
                                ((WorkPlan)objs[i]).ItemCode         = objWorkPlanFromDB.ItemCode;
                                ((WorkPlan)objs[i]).PromiseTime      = objWorkPlanFromDB.PromiseTime;
                                ((WorkPlan)objs[i]).LastReqTime      = objWorkPlanFromDB.LastReqTime;
                                ((WorkPlan)objs[i]).LastReceiveTime  = objWorkPlanFromDB.LastReceiveTime;
                                ((WorkPlan)objs[i]).PlanEndTime      = objWorkPlanFromDB.PlanEndTime;
                                ((WorkPlan)objDt[i]).MaterialQty     = objWorkPlanFromDB.MaterialQty;
                                ((WorkPlan)objDt[i]).ActQty          = objWorkPlanFromDB.ActQty;
                                ((WorkPlan)objDt[i]).MaterialStatus  = objWorkPlanFromDB.MaterialStatus;
                                ((WorkPlan)objDt[i]).ActionStatus    = objWorkPlanFromDB.ActionStatus;
                                ((WorkPlan)objDt[i]).ItemCode        = objWorkPlanFromDB.ItemCode;
                                ((WorkPlan)objDt[i]).PromiseTime     = objWorkPlanFromDB.PromiseTime;
                                ((WorkPlan)objDt[i]).LastReqTime     = objWorkPlanFromDB.LastReqTime;
                                ((WorkPlan)objDt[i]).LastReceiveTime = objWorkPlanFromDB.LastReceiveTime;
                                ((WorkPlan)objDt[i]).PlanEndTime     = objWorkPlanFromDB.PlanEndTime;

                                _DataProvider.Update(objs[i]);
                                _DataProvider.Update(objDt[i]);
                                row.Items.FindItemByKey("ImportResult").Text     = _LanguageComponent1.GetString("$CycleImport_Success");
                                row.Items.FindItemByKey("ImportResult").CssClass = "LinkColorBlue";
                            }
                            else
                            {
                                if ((workPlanFromExcel.PlanDate) >= shiftDay)
                                {
                                    _DataProvider.Insert(objDt[i]);
                                    row.Items.FindItemByKey("ImportResult").Text     = _LanguageComponent1.GetString("$CycleImport_Success");
                                    row.Items.FindItemByKey("ImportResult").CssClass = "LinkColorBlue";
                                }
                            }
                        }
                        catch (Exception ex)
                        {
                            GridRecord row = _ImportGridRow[i] as GridRecord;
                            row.Items.FindItemByKey("ImportResult").Text     = _LanguageComponent1.GetString("$CycleImport_Error");
                            row.Items.FindItemByKey("ImportResult").CssClass = "ForeColorRed";
                            this.ErrorArray.Add(ex);
                        }
                    }
                }

                _DataProvider.CommitTransaction();
            }
            catch (Exception ex)
            {
                _DataProvider.RollbackTransaction();
                this.ErrorArray.Add(ex);
            }
        }
        /// <summary>
        ///
        /// </summary>
        /// <param name="isRollBack">true:出错就回滚;false:出错skip到下一个</param>
        public void Import(bool isRollBack)
        {
            ShiftModelFacade shiftModelFacade = new ShiftModelFacade(this._dataProvider);
            DBDateTime       dbDateTime       = FormatHelper.GetNowDBDateTime(this._dataProvider);

            object[] objDt = null;
            if (string.Compare(ImportType, "IndirectManCount", true) == 0)
            {
                objDt = ConvertArrayListToObjectArray(ImportDatatable, "IndirectManCount");
            }

            if (string.Compare(ImportType, "Line2Crew", true) == 0)
            {
                objDt = ConvertArrayListToObjectArray(ImportDatatable, "Line2Crew");
            }

            try
            {
                _dataProvider.BeginTransaction();

                if (string.Compare(ImportType, "IndirectManCount", true) == 0)
                {
                    if (objDt != null)
                    {
                        for (int i = 0; i < objDt.Length; i++)
                        {
                            try
                            {
                                GridRecord       row = ImportGridRow[i] as GridRecord;
                                IndirectManCount IndirectManCountExcel = objDt[i] as IndirectManCount;

                                if (_Facade == null)
                                {
                                    _Facade = new PerformanceFacade(_dataProvider);
                                }

                                IndirectManCount getWorkPlanFromDB = (IndirectManCount)_Facade.GetIndirectManCount(IndirectManCountExcel.ShiftDate,
                                                                                                                   IndirectManCountExcel.ShiftCode,
                                                                                                                   IndirectManCountExcel.CrewCode,
                                                                                                                   IndirectManCountExcel.FactoryCode,
                                                                                                                   IndirectManCountExcel.FirstClass);

                                if (getWorkPlanFromDB != null)
                                {
                                    ((IndirectManCount)objDt[i]).FactoryCode = IndirectManCountExcel.FactoryCode;
                                    ((IndirectManCount)objDt[i]).FirstClass  = IndirectManCountExcel.FirstClass;

                                    _dataProvider.Update(objDt[i]);
                                    row.Items.FindItemByKey("ImportResult").Text     = _languageComponent1.GetString("$CycleImport_Success");
                                    row.Items.FindItemByKey("ImportResult").CssClass = "LinkColorBlue";
                                }
                                else
                                {
                                    _dataProvider.Insert(objDt[i]);
                                    row.Items.FindItemByKey("ImportResult").Text     = _languageComponent1.GetString("$CycleImport_Success");
                                    row.Items.FindItemByKey("ImportResult").CssClass = "LinkColorBlue";
                                }
                            }
                            catch (Exception ex)
                            {
                                GridRecord row = ImportGridRow[i] as GridRecord;
                                row.Items.FindItemByKey("ImportResult").Text     = _languageComponent1.GetString("$CycleImport_Error");
                                row.Items.FindItemByKey("ImportResult").CssClass = "ForeColorRed";
                                this.ErrorArray.Add(ex);
                            }
                        }
                    }
                }

                if (string.Compare(ImportType, "Line2Crew", true) == 0)
                {
                    if (objDt != null)
                    {
                        for (int i = 0; i < objDt.Length; i++)
                        {
                            try
                            {
                                GridRecord row            = ImportGridRow[i] as GridRecord;
                                Line2Crew  Line2CrewExcel = objDt[i] as Line2Crew;

                                if (_Facade == null)
                                {
                                    _Facade = new PerformanceFacade(_dataProvider);
                                }

                                Line2Crew getLine2CrewFromDB = (Line2Crew)_Facade.GetLine2Crew(Convert.ToInt32(Line2CrewExcel.ShiftDate), Line2CrewExcel.SSCode.ToString(), Line2CrewExcel.ShiftCode);

                                if (getLine2CrewFromDB != null)
                                {
                                    getLine2CrewFromDB.CrewCode = Line2CrewExcel.CrewCode;

                                    _dataProvider.Update(getLine2CrewFromDB);
                                    row.Items.FindItemByKey("ImportResult").Text     = _languageComponent1.GetString("$CycleImport_Success");
                                    row.Items.FindItemByKey("ImportResult").CssClass = "LinkColorBlue";
                                }
                                else
                                {
                                    _dataProvider.Insert(objDt[i]);
                                    row.Items.FindItemByKey("ImportResult").Text     = _languageComponent1.GetString("$CycleImport_Success");
                                    row.Items.FindItemByKey("ImportResult").CssClass = "LinkColorBlue";
                                }
                            }
                            catch (Exception ex)
                            {
                                GridRecord row = ImportGridRow[i] as GridRecord;
                                row.Items.FindItemByKey("ImportResult").Text     = _languageComponent1.GetString("$CycleImport_Error");
                                row.Items.FindItemByKey("ImportResult").CssClass = "ForeColorRed";
                                this.ErrorArray.Add(ex);
                            }
                        }
                    }
                }

                _dataProvider.CommitTransaction();
            }
            catch (Exception ex)
            {
                _dataProvider.RollbackTransaction();
                this.ErrorArray.Add(ex);
            }
        }
示例#4
0
        public void ProcessRequest(HttpContext context)
        {
            context.Response.ContentType = "text/plain";
            JavaScriptSerializer jss = new JavaScriptSerializer();

            //OracleDbHelper oracleHelper = new OracleDbHelper("Mes64");
            IDomainDataProvider dataProvider = DomainDataProviderManager.DomainDataProvider();
            BaseModelFacade     facade       = new BaseModelFacade(dataProvider);

            string action    = context.Request["action"];
            string routecode = context.Request["routecode"];

            if (action == "getRouteByCode")
            {
                Route route = facade.GetRoute(routecode) as Route;

                string strJson = jss.Serialize(route);
                context.Response.Write(strJson);
            }
            else if (action == "getOpByRoute")
            {
                OperationOfRoute[] opList = facade.GetOpByRouteCode(routecode) as OperationOfRoute[];

                string strJson = jss.Serialize(opList);

                context.Response.Write(strJson);
            }
            else if (action == "getOtherOp")
            {
                string opcode = context.Request["opcode"];
                if (opcode == null)
                {
                    opcode = string.Empty;
                }

                Operation[] opList  = facade.GetOtherOpByRouteCode(routecode, opcode) as Operation[];
                string      strJson = jss.Serialize(opList);

                context.Response.Write(strJson);
            }
            else if (action == "save")
            {
                string opJson = context.Request["opJson"];
                Op[]   opList = jss.Deserialize <Op[]>(opJson);
                //List<Op> opList = opArray.ToList<Op>();
                //context.Response.Write(jss.Serialize(opList));

                try
                {
                    dataProvider.BeginTransaction();

                    foreach (Op op in opList)
                    {
                        Route2Operation opNew = new Route2Operation();
                        opNew.RouteCode    = routecode;
                        opNew.OPCode       = op.OpCode;
                        opNew.OPSequence   = op.OpSeq;
                        opNew.OPControl    = op.OpControl + "0000000000";
                        opNew.MaintainUser = "******";
                        opNew.MaintainDate = Convert.ToInt32(DateTime.Now.ToString("yyyyMMdd"));
                        opNew.MaintainTime = Convert.ToInt32(DateTime.Now.ToString("HHmmss"));

                        if (op.DataType == 0)
                        {
                            facade.AddRoute2Operation(opNew);
                        }
                        else if (op.DataType == 1)
                        {
                            facade.UpdateRoute2Operation(opNew);
                        }
                        else if (op.DataType == 2)
                        {
                            facade.DeleteRoute2Operation(opNew);
                        }
                    }
                    dataProvider.CommitTransaction();
                }
                catch (Exception ex)
                {
                    dataProvider.RollbackTransaction();
                    context.Response.StatusCode = 500;
                    context.Response.Write(ex.Message);
                    context.Response.End();
                }
            }
        }
示例#5
0
        public string Submit(string transNo, string fromCartonNo, string qty, string sn, string locationCode, string rdoSelectType, string mUser, IDomainDataProvider DataProvider)
        {
            InventoryFacade _InventoryFacade = new InventoryFacade(DataProvider);
            WarehouseFacade _WarehouseFacade = new WarehouseFacade(DataProvider);
            DBDateTime      dbDateTime       = FormatHelper.GetNowDBDateTime(DataProvider);
            int             mDate            = dbDateTime.DBDate;
            int             mTime            = dbDateTime.DBTime;

            try
            {
                DataProvider.BeginTransaction();

                #region Check
                Storloctrans storloctrans = (Storloctrans)_WarehouseFacade.GetStorloctrans(transNo);


                if (storloctrans == null)
                {
                    DataProvider.RollbackTransaction();
                    return("无此转储单信息");
                }
                //原箱号:后台获取其库位和货位(TBLStorageDetail),查找条件:根据箱号到TBLStorageDetail中查找库存信息;
                //若库位和出库库位(TBLStorLocTrans. FromStorageCode)不符则报错。
                StorageDetail storageDetail = (StorageDetail)_InventoryFacade.GetStorageDetail(fromCartonNo);
                if (storageDetail == null)
                {
                    DataProvider.RollbackTransaction();
                    return("库存明细信息表里没有对应箱号的数据");
                }

                if (!storageDetail.StorageCode.Equals(storloctrans.FromstorageCode))
                {
                    DataProvider.RollbackTransaction();
                    return("库位和出库库位不符");
                }

                //一 根据箱号到TBLStorageDetail查找mcode,根据(转单号,mcode)查找TBLStorLocTransDetail 中数据,如果没有则报错:转储单中没有对应的SAP物料号
                StorloctransDetail storloctransDetail = _WarehouseFacade.GetStorloctransdetail(transNo, storageDetail.MCode)
                                                        as StorloctransDetail;
                if (storloctransDetail == null)
                {
                    DataProvider.RollbackTransaction();
                    return("转储单中没有对应的SAP物料号");
                }
                //二  判断(CartonNO对应的MCode),(TransNo)在TBLStorLocTransDetail中的状态是否为Close:完成,
                //如果是提示该料转储已经完成,如果是Release(初始化),更新状态为(Pick,拣料中) 。
                if (storloctransDetail.Status == "Close")
                {
                    DataProvider.RollbackTransaction();
                    return("该料转储已经完成");
                }

                decimal total   = _WarehouseFacade.GetStorloctransDetailDqmCodeQtySum(transNo, storageDetail.DQMCode);
                decimal smaller = _WarehouseFacade.GetStorloctransDetailCartonDqmCodeQtySum(transNo, storageDetail.DQMCode);

                if (rdoSelectType == "整箱")
                {
                    smaller += storageDetail.StorageQty;
                }
                else
                {
                    smaller += string.IsNullOrEmpty(sn) ? decimal.Parse(qty) : 1;
                }


                if (smaller > total)
                {
                    DataProvider.RollbackTransaction();
                    return("此物料的转储数量已经超过转储单" + transNo + "规定的数量!");
                }

                if (storloctransDetail.Status == "Release")
                {
                    storloctransDetail.Status       = "Pick";
                    storloctransDetail.MaintainUser = mUser;
                    storloctransDetail.MaintainDate = mDate;
                    storloctransDetail.MaintainTime = mTime;
                    _WarehouseFacade.UpdateStorloctransdetail(storloctransDetail);
                }



                #endregion
                if (rdoSelectType == "整箱")
                {
                    #region 整箱
                    //1,	检查TBLStorageDetail.FreezeQTY是否为零?不为零,检查是否TBLStorageDetail.FreezeQTY=
                    //TBLStorageDetail. STORAGEQTY?如果是:提示此箱在拣料中;如果不是提示此箱SN部分拣料中,请拆箱拣料。
                    #region TBLStorageDetail
                    if (storageDetail.FreezeQty != 0)
                    {
                        if (storageDetail.FreezeQty == storageDetail.StorageQty)
                        {
                            DataProvider.RollbackTransaction();
                            return("此箱在拣料中");
                        }
                        else
                        {
                            DataProvider.RollbackTransaction();
                            return("此箱SN部分拣料中,请拆箱拣料");
                        }
                    }

                    //2,	更新TBLStorageDetail. FreezeQTY= TBLStorageDetail. STORAGEQTY,TBLStorageDetail. AvailableQTY=0。
                    storageDetail.FreezeQty    = storageDetail.StorageQty;
                    storageDetail.AvailableQty = 0;
                    storageDetail.MaintainUser = mUser;
                    storageDetail.MaintainDate = mDate;
                    storageDetail.MaintainTime = mTime;
                    _InventoryFacade.UpdateStorageDetail(storageDetail);
                    #endregion

                    //3,	更新TBLStorageDetailSN. PICKBLOCK=Y。
                    //StorageDetail[] storageDetails = _WarehouseFacade.GetStorageDetailsFromCARTONNO(fromCartonNo);
                    Material mar = _WarehouseFacade.GetMaterialFromDQMCode(storageDetail.DQMCode);
                    if (mar == null)
                    {
                        DataProvider.RollbackTransaction();
                        return("原箱号物料信息不存在");
                    }
                    bool issn = false || mar.MCONTROLTYPE == SAP_CONTROLTYPE.SAP_ITEM_CONTROL_KEYPARTS;

                    //单件管控
                    List <string> snList = new List <string>();
                    #region storageDetailSN
                    if (issn)
                    {
                        object[] objs = _WarehouseFacade.GetStorageDetailSnbyCartonNo(fromCartonNo);
                        if (objs == null)
                        {
                            DataProvider.RollbackTransaction();
                            return("库存明细SN信息表里没有对应箱号的数据");
                        }

                        foreach (StorageDetailSN storageDetailSN in objs)
                        {
                            snList.Add(storageDetailSN.SN);//记sn号
                            storageDetailSN.PickBlock    = "Y";
                            storageDetailSN.MaintainUser = mUser;
                            storageDetailSN.MaintainDate = mDate;
                            storageDetailSN.MaintainTime = mTime;
                            _InventoryFacade.UpdateStorageDetailSN(storageDetailSN);
                        }
                    }
                    #endregion

                    #region StorloctransDetailCarton LocationCode为空


                    StorloctransDetailCarton storCarton = _WarehouseFacade.GetStorLocTransDetailCarton(transNo, fromCartonNo);
                    if (storCarton == null)
                    {
                        StorloctransDetailCarton storloctransDetailCarton = new StorloctransDetailCarton();
                        storloctransDetailCarton.Transno            = transNo;
                        storloctransDetailCarton.MCode              = storloctransDetail.MCode;
                        storloctransDetailCarton.DqmCode            = storageDetail.DQMCode;
                        storloctransDetailCarton.MDesc              = storageDetail.MDesc;
                        storloctransDetailCarton.Unit               = storageDetail.Unit;
                        storloctransDetailCarton.Supplier_lotno     = storageDetail.SupplierLotNo;
                        storloctransDetailCarton.Production_Date    = storageDetail.ProductionDate;
                        storloctransDetailCarton.StorageageDate     = storageDetail.StorageAgeDate;
                        storloctransDetailCarton.LaststorageageDate = storageDetail.LastStorageAgeDate;
                        storloctransDetailCarton.ValidStartDate     = storageDetail.ValidStartDate;
                        storloctransDetailCarton.FacCode            = storageDetail.FacCode;
                        storloctransDetailCarton.Qty              = storageDetail.StorageQty;
                        storloctransDetailCarton.LocationCode     = locationCode;
                        storloctransDetailCarton.Cartonno         = " ";
                        storloctransDetailCarton.FromlocationCode = storageDetail.LocationCode;
                        storloctransDetailCarton.Fromcartonno     = storageDetail.CartonNo;
                        storloctransDetailCarton.Lotno            = storageDetail.Lotno;
                        storloctransDetailCarton.CUser            = mUser;
                        storloctransDetailCarton.CDate            = mDate;
                        storloctransDetailCarton.CTime            = mTime;
                        storloctransDetailCarton.MaintainUser     = mUser;
                        storloctransDetailCarton.MaintainDate     = mDate;
                        storloctransDetailCarton.MaintainTime     = mTime;
                        _WarehouseFacade.AddStorloctransdetailcarton(storloctransDetailCarton);
                    }

                    #endregion

                    #region 6.如果原箱号在TBLStorageDetailSN有SN信息,将SN信息插入到TBLStorLocTransDetailSN表
                    if (issn)
                    {
                        if (snList.Count > 0)
                        {
                            StorloctransDetailSN storloctransDetailSN = new StorloctransDetailSN();
                            foreach (string storageDetailSn in snList)
                            {
                                storloctransDetailSN.Transno      = transNo;
                                storloctransDetailSN.Cartonno     = " ";
                                storloctransDetailSN.Fromcartonno = fromCartonNo;
                                storloctransDetailSN.Sn           = storageDetailSn;// storageDetailSN.SN;
                                storloctransDetailSN.MaintainUser = mUser;
                                storloctransDetailSN.MaintainDate = mDate;
                                storloctransDetailSN.MaintainTime = mTime;
                                _WarehouseFacade.AddStorloctransdetailsn(storloctransDetailSN);
                            }
                        }
                    }
                    #endregion

                    #endregion
                }
                else
                {
                    #region 拆箱
                    //1,	无论输入是【原箱号】,【SN】,首先判断管控类型,如果是单件管控,已输入SN为条件进行录入;
                    //如果是批管控或不管控则以【原箱号】和【数量】为录入条件。
                    StorageDetail[] storageDetails = _WarehouseFacade.GetStorageDetailsFromCARTONNO(fromCartonNo);
                    if (storageDetails == null)
                    {
                        DataProvider.RollbackTransaction();
                        return("原箱号无库存信息");
                    }

                    Material mar = _WarehouseFacade.GetMaterialFromDQMCode(storageDetails[0].DQMCode);
                    if (mar == null)
                    {
                        DataProvider.RollbackTransaction();
                        return("原箱号物料信息不存在");
                    }
                    bool issn = false || mar.MCONTROLTYPE == SAP_CONTROLTYPE.SAP_ITEM_CONTROL_KEYPARTS;

                    if (mar.MCONTROLTYPE == SAP_CONTROLTYPE.SAP_ITEM_CONTROL_KEYPARTS) //单件管控
                    {
                        #region 单件管控

                        if (string.IsNullOrEmpty(sn))
                        {
                            DataProvider.RollbackTransaction();
                            return("必须输入SN号码");
                        }
                        if (!string.IsNullOrEmpty(qty))
                        {
                            DataProvider.RollbackTransaction();
                            return("单件管控料不需要输入数量");
                        }
                        //A 根据SN在TBLStorageDetail查看是否TBLStorageDetail.FreezeQTY= TBLStorageDetail. STORAGEQTY?如果等于,提示:此箱在拣料中;如果不等于0,检查TBLStorageDetailSN. PICKBLOCK是否是Y,如果是提示:此SN正在拣料中。
                        StorageDetailSN storageDetailSN = _InventoryFacade.GetStorageDetailSN(sn) as StorageDetailSN;
                        if (storageDetailSN == null)
                        {
                            DataProvider.RollbackTransaction();
                            return("刷入SN条码不存在");
                        }
                        StorageDetail _storageDetail = _InventoryFacade.GetStorageDetail(storageDetailSN.CartonNo) as StorageDetail;
                        if (_storageDetail == null)
                        {
                            DataProvider.RollbackTransaction();
                            return("输入的SN找不到库存信息");
                        }
                        if (_storageDetail.FreezeQty == _storageDetail.StorageQty)
                        {
                            DataProvider.RollbackTransaction();
                            return("此箱在拣料中");
                        }
                        else
                        {
                            if (storageDetailSN.PickBlock == "Y")
                            {
                                DataProvider.RollbackTransaction();
                                return("此SN正在拣料中");
                            }
                        }

                        //B 根据SN在TBLStorageDetail中查找mcode信息,再根据(mcode+TransNo)信息在TBLStorLocTransDetail中是否有数据,如果没有则报错:转储单中没有对应的SAP物料号。
                        StorloctransDetail _storloctransDetail = _WarehouseFacade.GetStorloctransdetail(transNo,
                                                                                                        _storageDetail.MCode) as StorloctransDetail;
                        if (_storloctransDetail == null)
                        {
                            DataProvider.RollbackTransaction();
                            return("转储单中没有对应的SAP物料号");
                        }
                        //C 更新TBLStorageDetail. FreezeQTY= TBLStorageDetail. FreezeQTY+1,TBLStorageDetail. AvailableQTY= TBLStorageDetail.STORAGEQTY-TBLStorageDetail. FreezeQTY。
                        _storageDetail.FreezeQty   += 1;
                        _storageDetail.AvailableQty = _storageDetail.StorageQty - _storageDetail.FreezeQty;
                        _storageDetail.MaintainUser = mUser;
                        _storageDetail.MaintainDate = mDate;
                        _storageDetail.MaintainTime = mTime;
                        _InventoryFacade.UpdateStorageDetail(_storageDetail);

                        //D 更新TBLStorageDetailSN. PICKBLOCK=Y。
                        storageDetailSN.PickBlock    = "Y";
                        storageDetailSN.MaintainUser = mUser;
                        storageDetailSN.MaintainDate = mDate;
                        storageDetailSN.MaintainTime = mTime;
                        _InventoryFacade.UpdateStorageDetailSN(storageDetailSN);


                        //E  需要输入目标箱号,根据SN信息在TBLStorageDetailSN中查找原箱号信息;
                        //根据(目标箱号+TransNo+FromCARTONNO原箱号)在TBLStorLocTransDetailCarton是否有记录。
                        #region objStorLocTransDetailCarton
                        StorloctransDetailCarton storloctransDetailCarton = _WarehouseFacade.GetStorLocTransDetailCarton(transNo, storageDetailSN.CartonNo);

                        if (storloctransDetailCarton == null)
                        {
                            storloctransDetailCarton                    = new StorloctransDetailCarton();
                            storloctransDetailCarton.Transno            = transNo;
                            storloctransDetailCarton.MCode              = _storloctransDetail.MCode;
                            storloctransDetailCarton.DqmCode            = _storageDetail.DQMCode;
                            storloctransDetailCarton.MDesc              = _storageDetail.MDesc;
                            storloctransDetailCarton.Unit               = _storageDetail.Unit;
                            storloctransDetailCarton.Supplier_lotno     = _storageDetail.SupplierLotNo;
                            storloctransDetailCarton.Production_Date    = _storageDetail.ProductionDate;
                            storloctransDetailCarton.StorageageDate     = _storageDetail.StorageAgeDate;
                            storloctransDetailCarton.LaststorageageDate = _storageDetail.LastStorageAgeDate;
                            storloctransDetailCarton.ValidStartDate     = _storageDetail.ValidStartDate;
                            storloctransDetailCarton.FacCode            = _storageDetail.FacCode;
                            storloctransDetailCarton.Qty                = 1;
                            storloctransDetailCarton.LocationCode       = locationCode;
                            storloctransDetailCarton.Cartonno           = " ";
                            storloctransDetailCarton.FromlocationCode   = _storageDetail.LocationCode;
                            storloctransDetailCarton.Fromcartonno       = _storageDetail.CartonNo;
                            storloctransDetailCarton.Lotno              = _storageDetail.Lotno;
                            storloctransDetailCarton.CUser              = mUser;
                            storloctransDetailCarton.CDate              = mDate;
                            storloctransDetailCarton.CTime              = mTime;
                            storloctransDetailCarton.MaintainUser       = mUser;
                            storloctransDetailCarton.MaintainDate       = mDate;
                            storloctransDetailCarton.MaintainTime       = mTime;
                            _WarehouseFacade.AddStorloctransdetailcarton(storloctransDetailCarton);
                        }
                        else
                        {
                            //如果有记录,检查记录中的料号是否有与原箱的料号一致,如果不一致则提示:(目标箱号物料不一致)
                            object objStorageDetail = _InventoryFacade.GetStorageDetail(fromCartonNo);
                            if (!storloctransDetailCarton.MCode.Equals((objStorageDetail as StorageDetail).MCode))
                            {
                                DataProvider.RollbackTransaction();
                                return("目标箱号物料不一致");
                            }

                            //如果有: 更新TBLStorLocTransDetailCarton.QTY+1,MDate,MTime,MUser。
                            storloctransDetailCarton.Qty         += 1;
                            storloctransDetailCarton.MaintainUser = mUser;
                            storloctransDetailCarton.MaintainDate = mDate;
                            storloctransDetailCarton.MaintainTime = mTime;
                            _WarehouseFacade.UpdateStorloctransdetailcarton(storloctransDetailCarton);
                        }
                        #endregion

                        //F  向表TBLStorLocTransDetailSN插入一条数据。
                        StorloctransDetailSN storloctransDetailSN = new StorloctransDetailSN();
                        storloctransDetailSN.Transno      = transNo;
                        storloctransDetailSN.Cartonno     = " ";
                        storloctransDetailSN.Fromcartonno = fromCartonNo;
                        storloctransDetailSN.Sn           = storageDetailSN.SN;
                        storloctransDetailSN.MaintainUser = mUser;
                        storloctransDetailSN.MaintainDate = mDate;
                        storloctransDetailSN.MaintainTime = mTime;
                        _WarehouseFacade.AddStorloctransdetailsn(storloctransDetailSN);

                        #endregion
                    }
                    else
                    {
                        #region 非单件管控
                        if (string.IsNullOrEmpty(qty))
                        {
                            DataProvider.RollbackTransaction();
                            return("必须输入数量");
                        }
                        #region 判断数量是否是数字格式
                        try
                        {
                            decimal _qty = decimal.Parse(qty);
                            if (_qty <= 0)
                            {
                                DataProvider.RollbackTransaction();
                                return("数量必须为大于零的数字");
                            }
                        }
                        catch (Exception ex)
                        {
                            DataProvider.RollbackTransaction();
                            return("数量必须为大于零的数字");
                        }
                        #endregion

                        //B 检查TBLStorageDetail. AvailableQTY>PDA页面填的数量。如果否,提示:输入的数量大于库存可用数量。
                        StorageDetail _storageDetail = storageDetails[0] as StorageDetail;
                        if (_storageDetail.AvailableQty < decimal.Parse(qty))
                        {
                            DataProvider.RollbackTransaction();
                            return("输入的数量大于库存可用数量");
                        }

                        //C 更新TBLStorageDetail. FreezeQTY= TBLStorageDetail. FreezeQTY+ PDA页面填的数量,
                        //TBLStorageDetail. AvailableQTY= TBLStorageDetail.STORAGEQTY-TBLStorageDetail. FreezeQTY。
                        _storageDetail.FreezeQty   += int.Parse(qty);
                        _storageDetail.AvailableQty = _storageDetail.StorageQty - _storageDetail.FreezeQty;
                        _storageDetail.MaintainUser = mUser;
                        _storageDetail.MaintainDate = mDate;
                        _storageDetail.MaintainTime = mTime;
                        _InventoryFacade.UpdateStorageDetail(_storageDetail);


                        #region D需要输入目标箱号,根据(目标箱号+TransNo+FromCARTONNO原箱号)在TBLStorLocTransDetailCarton是否有记录。
                        StorloctransDetailCarton objStorLocTransDetailCarton = _WarehouseFacade.GetStorLocTransDetailCarton(transNo, _storageDetail.CartonNo);
                        if (objStorLocTransDetailCarton == null)
                        {
                            //    //如果没有:插入一条数据
                            //    if (!_WarehouseFacade.IsExistLocationCode(locationCode))
                            //    {
                            //        DataProvider.RollbackTransaction();
                            //       return"输入的目标货位不存在" ;
                            //    }
                            StorloctransDetailCarton storloctransDetailCarton = new StorloctransDetailCarton();
                            storloctransDetailCarton.Transno            = transNo;
                            storloctransDetailCarton.MCode              = storloctransDetail.MCode;
                            storloctransDetailCarton.DqmCode            = _storageDetail.DQMCode;
                            storloctransDetailCarton.MDesc              = _storageDetail.MDesc;
                            storloctransDetailCarton.Unit               = _storageDetail.Unit;
                            storloctransDetailCarton.Supplier_lotno     = _storageDetail.SupplierLotNo;
                            storloctransDetailCarton.Production_Date    = _storageDetail.ProductionDate;
                            storloctransDetailCarton.StorageageDate     = _storageDetail.StorageAgeDate;
                            storloctransDetailCarton.LaststorageageDate = _storageDetail.LastStorageAgeDate;
                            storloctransDetailCarton.ValidStartDate     = _storageDetail.ValidStartDate;
                            storloctransDetailCarton.FacCode            = _storageDetail.FacCode;
                            storloctransDetailCarton.Qty              = decimal.Parse(qty);
                            storloctransDetailCarton.LocationCode     = locationCode;
                            storloctransDetailCarton.Cartonno         = " ";
                            storloctransDetailCarton.FromlocationCode = _storageDetail.LocationCode;
                            storloctransDetailCarton.Fromcartonno     = _storageDetail.CartonNo;
                            storloctransDetailCarton.Lotno            = _storageDetail.Lotno;
                            storloctransDetailCarton.CUser            = mUser;
                            storloctransDetailCarton.CDate            = mDate;
                            storloctransDetailCarton.CTime            = mTime;
                            storloctransDetailCarton.MaintainUser     = mUser;
                            storloctransDetailCarton.MaintainDate     = mDate;
                            storloctransDetailCarton.MaintainTime     = mTime;
                            _WarehouseFacade.AddStorloctransdetailcarton(storloctransDetailCarton);
                        }
                        else
                        {
                            //如果有记录,检查记录中的料号是否有与原箱的料号一致,如果不一致则提示:(目标箱号物料不一致)
                            StorloctransDetailCarton storloctransDetailCarton = objStorLocTransDetailCarton as StorloctransDetailCarton;
                            object _objStorageDetail = _InventoryFacade.GetStorageDetail(fromCartonNo);
                            if (!storloctransDetailCarton.MCode.Equals((_objStorageDetail as StorageDetail).MCode))
                            {
                                DataProvider.RollbackTransaction();
                                return("目标箱号物料不一致");
                            }

                            //如果有: 更新TBLStorLocTransDetailCarton.QTY+ PDA页面填的数量,MDate,MTime,MUser。
                            storloctransDetailCarton.Qty         += decimal.Parse(qty);
                            storloctransDetailCarton.MaintainUser = mUser;
                            storloctransDetailCarton.MaintainDate = mDate;
                            storloctransDetailCarton.MaintainTime = mTime;
                            _WarehouseFacade.UpdateStorloctransdetailcarton(storloctransDetailCarton);
                        }
                        #endregion

                        #endregion
                    }

                    #endregion
                }

                ////三 判断条件TransNo,MCODE 下sum(TBLStorLocTransDetailCarton.QTY)是否等于需求数量TBLStorLocTransDetail.QTY。
                /////如果等于则更新装填TBLStorLocTransDetail.Status=Close:完成状态。
                //decimal sum = 0;
                //object[] _objs = _WarehouseFacade.GetStorloctransdetailcarton(transNo, storageDetail.MCode);
                //foreach (StorloctransDetailCarton storloctransDetailCarton in _objs)
                //{
                //    sum += storloctransDetailCarton.Qty;
                //}
                //if (sum == storloctransDetail.Qty)
                //{
                //    storloctransDetail.Status = "Close";
                //    storloctransDetail.MaintainUser = mUser;
                //    storloctransDetail.MaintainDate = mDate;
                //    storloctransDetail.MaintainTime = mTime;
                //    _WarehouseFacade.UpdateStorloctransdetail(storloctransDetail);
                //}
                //else if (sum > storloctransDetail.Qty)
                //{
                //    DataProvider.RollbackTransaction();
                //    return "拣料数量超出需求数量";
                //}

                DataProvider.CommitTransaction();
                return("提交成功");
            }
            catch (Exception ex)
            {
                DataProvider.RollbackTransaction();
                return("提交失败:" + ex.Message);
            }
        }