Ejemplo n.º 1
0
        public List <FullPackagePlan> GetLoadedPackageByPallet(int palletId)
        {
            ShippmentEntities      db     = new ShippmentEntities();
            List <FullPackagePlan> list   = new List <FullPackagePlan>();
            PalletDefine           pallet = db.PalletDefines.FirstOrDefault(p => p.Id == palletId && !p.IsDeleted);

            if (pallet != null)
            {
                foreach (var pp in pallet.PackagePlans)
                {
                    FullPackagePlan plan = new FullPackagePlan();
                    plan.Id             = pp.PackageDefineId;
                    plan.pkgQty         = pp.Qty;
                    plan.palletDefineId = pp.PalletDefineId;
                    plan.Material       = pp.PackageDefine.Material;
                    plan.Length_mm      = pp.PackageDefine.Length_mm;
                    plan.Width_mm       = pp.PackageDefine.Width_mm;
                    plan.Height_mm      = pp.PackageDefine.Height_mm;
                    plan.NetWeight_kg   = pp.PackageDefine.NetWeight_kg;
                    plan.GrossWeight_kg = pp.PackageDefine.GrossWeight_kg;
                    plan.Note           = pp.PackageDefine.Note;
                    plan.PartNo         = pp.PackageDefine.PartNo;
                    plan.Qty            = pp.PackageDefine.Qty;
                    plan.Unit           = pp.PackageDefine.Unit;
                    list.Add(plan);
                }
            }
            return(list);
        }
Ejemplo n.º 2
0
        public ErrorInfo Edit(int id, PalletDefine palletDefine)
        {
            if (id != palletDefine.Id)
            {
                return(ErrorInfo.Err_Bad_Request_Information);
            }
            ShippmentEntities db     = new ShippmentEntities();
            PalletDefine      pallet = db.PalletDefines.FirstOrDefault(p => p.Id == id && !p.IsDeleted);

            if (pallet != null)
            {
                pallet.Material        = palletDefine.Material;
                pallet.Length_mm       = palletDefine.Length_mm;
                pallet.Width_mm        = palletDefine.Width_mm;
                pallet.Height_mm       = palletDefine.Height_mm;
                pallet.NetWeight_kg    = palletDefine.NetWeight_kg;
                pallet.GrossWeight_kg  = palletDefine.GrossWeight_kg;
                pallet.Note            = palletDefine.Note;
                pallet.IsDeleted       = palletDefine.IsDeleted;
                db.Entry(pallet).State = System.Data.Entity.EntityState.Modified;
                if (db.SaveChanges() > 0)
                {
                    return(ErrorInfo.Succeed);
                }
                else
                {
                    return(ErrorInfo.Err_Internal_Error);
                }
            }
            else
            {
                return(ErrorInfo.Err_Resource_NotExist);
            }
        }
Ejemplo n.º 3
0
        public PalletDefine Get(int id)
        {
            ShippmentEntities db     = new ShippmentEntities();
            PalletDefine      pallet = (from p in db.PalletDefines
                                        where p.Id == id && !p.IsDeleted
                                        select p).FirstOrDefault();

            return(pallet);
        }
Ejemplo n.º 4
0
        public ErrorInfo Add(PalletDefine palletDefine)
        {
            ShippmentEntities db = new ShippmentEntities();

            db.PalletDefines.Add(palletDefine);
            if (db.SaveChanges() > 0)
            {
                return(ErrorInfo.Succeed);
            }
            else
            {
                return(ErrorInfo.Err_Internal_Error);
            }
        }
Ejemplo n.º 5
0
        public ErrorInfo Delete(int id)
        {
            ShippmentEntities db     = new ShippmentEntities();
            PalletDefine      pallet = db.PalletDefines.FirstOrDefault(p => p.Id == id);

            if (pallet != null)
            {
                pallet.IsDeleted       = true;
                db.Entry(pallet).State = System.Data.Entity.EntityState.Modified;
                if (db.SaveChanges() > 0)
                {
                    return(ErrorInfo.Succeed);
                }
                else
                {
                    return(ErrorInfo.Err_Internal_Error);
                }
            }
            else
            {
                return(ErrorInfo.Err_Resource_NotExist);
            }
        }