예제 #1
0
        public static int Add(BadReport b)
        {
            WarehouseEntities entity = new WarehouseEntities();

            entity.BadReport.Add(b);
            return(entity.SaveChanges());
        }
예제 #2
0
        //全选单选删除
        public ActionResult DeleteOther(List <BadReport> list)
        {
            string msg = "";

            foreach (var item in list)
            {
                BadReport ins = badReport.GetByWhere(i => i.Id == item.Id).SingleOrDefault();
                List <BadReportDetail> listDetail = badReportDetail.GetByWhere(i => i.BadId == ins.BadNum);
                bool val = true;
                foreach (var listd in listDetail)
                {
                    listd.IsDelete = 1;
                    val            = badReportDetail.Update(listd);
                }
                if (val)
                {
                    ins.IsDelete = 1;
                    bool vall = badReport.Update(ins);
                    if (vall)
                    {
                        msg = "删除成功";
                    }
                    else
                    {
                        msg = "删除失败";
                    }
                }
            }
            return(Json(msg, JsonRequestBehavior.AllowGet));
        }
예제 #3
0
        public ActionResult QueryByIdMinXiInfo(int id)
        {
            BadReport ins = badReport.GetByWhere(i => i.Id == id).SingleOrDefault();
            var       mx  = badReportDetail.GetByWhere(i => i.BadId == ins.BadNum && i.IsDelete == 0);

            return(Json(mx, JsonRequestBehavior.AllowGet));
        }
예제 #4
0
        public ActionResult Add(BadReport b)
        {
            b.DetailNum = "1";
            b.IsDelete  = 0;
            b.Operation = "电脑";

            return(Json(BadReportManager.Add(b), JsonRequestBehavior.AllowGet));
        }
예제 #5
0
        //public static int DelAll(List<T> li)
        //{
        //    WarehouseEntities entity = new WarehouseEntities();
        //    var obj = (from p in entity.BadReport where p.BadNum == BadNum select p).First();
        //    //修改
        //    obj.IsDelete = 1;
        //    return entity.SaveChanges();
        //}


        /// <summary>
        /// 修改
        /// </summary>
        /// <param name="p"></param>
        /// <returns></returns>
        public static int Edit(BadReport p)
        {
            WarehouseEntities entity = new WarehouseEntities();
            //先修改主表数据
            var obj = entity.BadReport.Find(p.Id);

            obj.BadTypeId = p.BadTypeId;
            obj.ProductId = p.ProductId;
            obj.Num       = p.Num;
            obj.SumMoney  = p.SumMoney;
            obj.Status    = p.Status;
            obj.Operation = p.Operation;
            obj.AuditUser = p.AuditUser;
            obj.AuditTime = p.AuditTime;
            return(entity.SaveChanges());
        }
예제 #6
0
        //修改审核状态
        public ActionResult UpdtStatus(BadReport i, string status)
        {
            var ss = badReport.GetByWhere(item => item.Id == i.Id).SingleOrDefault();

            i.BadNum    = ss.BadNum;
            i.BadTypeId = ss.BadTypeId;
            i.DetailNum = ss.DetailNum;
            i.Num       = ss.Num;
            i.SumMoney  = ss.SumMoney;
            i.Status    = status;
            i.AuditUser = ss.AuditUser;
            i.AuditTime = ss.AuditTime;
            i.IsDelete  = ss.IsDelete;
            i.Remark    = ss.Remark;
            var badReports = new BadReportManager();
            var s          = badReports.Update(i);

            if (status.Equals("审核通过"))
            {
                var d = badReportDetail.GetByWhere(item => item.BadId == ss.BadNum);
                foreach (var item in d)
                {
                    var pd = new ProductManager();
                    Expression <Func <Product, bool> > where = iss => iss.ProductNum == item.ProductNum;
                    var pdu1 = pd.GetByWhere(where).SingleOrDefault();
                    pdu1.StockNum = Convert.ToInt32(pdu1.StockNum - item.Quantity);
                    var pdu = product.Update(pdu1);
                }
            }
            var result = new
            {
                ActionResult = s
            };

            return(Json(result, JsonRequestBehavior.AllowGet));
        }
예제 #7
0
 //报损修改
 public ActionResult Edit(BadReport bad)
 {
     return(Json(BadReportManager.Edit(bad), JsonRequestBehavior.AllowGet));
 }
예제 #8
0
        public ActionResult Insert(List <BadReportDetail> detail, int BadTypeId, string Remark, string AuditUser)
        {
            string detailNum = "";
            //获取明细表最大编号
            string detailNumBig = badReportDetail.GetByWhere(i => true).OrderByDescending(i => i.DetailNum).Take(1).Select(i => i.DetailNum).FirstOrDefault();

            if (string.IsNullOrEmpty(detailNumBig))
            {
                detailNum = "000001";
            }
            else
            {
                detailNum = "00000" + (int.Parse(detailNumBig) + 1);
                int num_1 = int.Parse(detailNumBig);
                if (num_1 >= 9)
                {
                    detailNum = "0000" + (int.Parse(detailNumBig) + 1);
                }
                if (num_1 >= 99)
                {
                    detailNum = "000" + (int.Parse(detailNumBig) + 1);
                }
            }

            string badNum = "";
            //获取出库表最大编号
            string badNumBig = badReport.GetByWhere(i => true).OrderByDescending(i => i.BadNum).Take(1).Select(i => i.BadNum).FirstOrDefault();

            if (badNumBig == null)
            {
                badNum = "000001";
            }
            else
            {
                badNum = "00000" + (int.Parse(badNumBig) + 1);
                int num_2 = int.Parse(badNumBig);
                if (num_2 >= 9)
                {
                    badNum = "0000" + (int.Parse(badNumBig) + 1);
                }
                if (num_2 >= 99)
                {
                    badNum = "000" + (int.Parse(badNumBig) + 1);
                }
            }

            bool   val = true;
            string msg = "";

            foreach (var item in detail)
            {
                item.CreateTime = DateTime.Now;
                item.DetailNum  = detailNum;
                item.BadId      = badNum;
                val             = badReportDetail.Add(item);
            }
            if (val)
            {
                var       num      = badReportDetail.GetByWhere(i => i.BadId == badNum).Sum(i => i.Quantity); //获取总出货数
                var       sumMoney = badReportDetail.GetByWhere(i => i.BadId == badNum).Sum(i => i.SumMoney); //获取总价格
                BadReport ost      = new BadReport();
                ost.BadNum    = badNum;
                ost.BadTypeId = BadTypeId;
                ost.DetailNum = detailNum;
                ost.Num       = Convert.ToInt32(num);;
                ost.SumMoney  = Convert.ToDouble(sumMoney);
                ost.Status    = "待审核";
                ost.AuditTime = DateTime.Now;
                ost.AuditUser = AuditUser;
                ost.Remark    = Remark;
                ost.IsDelete  = 0;
                bool val1 = badReport.Add(ost);
                if (val1)
                {
                    msg = "新增成功";
                }
                else
                {
                    msg = "新增失败";
                }
                msg = "新增成功";
            }
            else
            {
                msg = "新增失败";
            }
            return(Json(msg, JsonRequestBehavior.AllowGet));
        }
예제 #9
0
 public static int Add(BadReport b)
 {
     return(BadReportService.Add(b));
 }
예제 #10
0
 public static int Edit(BadReport p)
 {
     return(BadReportService.Edit(p));
 }