public static int Add(BadReport b) { WarehouseEntities entity = new WarehouseEntities(); entity.BadReport.Add(b); return(entity.SaveChanges()); }
//全选单选删除 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)); }
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)); }
public ActionResult Add(BadReport b) { b.DetailNum = "1"; b.IsDelete = 0; b.Operation = "电脑"; return(Json(BadReportManager.Add(b), JsonRequestBehavior.AllowGet)); }
//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()); }
//修改审核状态 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)); }
//报损修改 public ActionResult Edit(BadReport bad) { return(Json(BadReportManager.Edit(bad), JsonRequestBehavior.AllowGet)); }
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)); }
public static int Add(BadReport b) { return(BadReportService.Add(b)); }
public static int Edit(BadReport p) { return(BadReportService.Edit(p)); }