public ActionResult Add(BadReport b)
{
b.DetailNum = "1";
b.IsDelete = 0;
b.Operation = "电脑";
return(Json(BadReportManager.Add(b), JsonRequestBehavior.AllowGet));
}
//修改审核状态
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 GetAll()
{
return(Json(BadReportManager.GetAll(), JsonRequestBehavior.AllowGet));
}
public ActionResult GetBadReportId(string BadNum)
{
return(Json(BadReportManager.GetBadReportId(BadNum), JsonRequestBehavior.AllowGet));
}
//报损修改
public ActionResult Edit(BadReport bad)
{
return(Json(BadReportManager.Edit(bad), JsonRequestBehavior.AllowGet));
}
public ActionResult GetById(int pageIndex, int pageSize, string BadNum)
{
return(Json(BadReportManager.GetById(pageIndex, pageSize, BadNum), JsonRequestBehavior.AllowGet));
}
//报损加载
public ActionResult GetBadReport(int pageIndex, int pageSize, int Status)
{
return(Json(BadReportManager.GetBadReport(pageIndex, pageSize, Status), JsonRequestBehavior.AllowGet));
}
public ActionResult ProductID(int id1)
{
return(Json(BadReportManager.Product2(id1), JsonRequestBehavior.AllowGet));
}
public ActionResult Product1()
{
return(Json(BadReportManager.Product1(), JsonRequestBehavior.AllowGet));
}
// GET: Husongzhi
public ActionResult Product(string ProductName)
{
return(Json(BadReportManager.Product(ProductName), JsonRequestBehavior.AllowGet));
}
//修改出库单
public ActionResult UpdtInfo(List <BadReportDetail> detail, int BadTypeId, string Remark, string badSNum)
{
//先删除明细
bool val_1 = true;
var badReportDetails = new BadReportDetailManager();
var mx = badReportDetails.GetByWhere(i => i.BadId == badSNum);
foreach (var item in mx)
{
val_1 = badReportDetails.Delete(item);
}
//获取明细表最大编号
string detailNumBig = badReportDetail.GetByWhere(item => true).OrderByDescending(item => item.DetailNum).Take(1).Select(item => item.DetailNum).FirstOrDefault();
string detailNum = "";
if (detailNumBig == null)
{
detailNumBig = "000001";
}
else
{
detailNum = "00000" + (int.Parse(detailNumBig) + 1);
int num1 = int.Parse(detailNumBig);
if (num1 >= 9)
{
detailNumBig = "0000" + (int.Parse(detailNumBig) + 1);
}
else if (num1 >= 99)
{
detailNumBig = "000" + (int.Parse(detailNumBig) + 1);
}
}
string msg = "";
bool val = true;
foreach (var item in detail)
{
item.DetailNum = detailNum;
item.CreateTime = DateTime.Now;
item.BadId = badSNum;
val = badReportDetail.Add(item);
}
if (val)
{
var num = badReportDetail.GetByWhere(item => item.BadId == badSNum).Sum(item => item.Quantity);
var sumMoney = badReportDetail.GetByWhere(item => item.BadId == badSNum).Sum(item => item.SumMoney);
var badreport_1 = new BadReportManager();
var s = badreport_1.GetByWhere(i => i.BadNum == badSNum).SingleOrDefault();
s.DetailNum = detailNum;
s.BadTypeId = BadTypeId;
s.Remark = Remark;
s.Num = Convert.ToInt32(num);
s.SumMoney = Convert.ToDouble(sumMoney);
bool vall = badReport.Update(s);
if (vall)
{
msg = "修改成功";
}
else
{
msg = "修改失败";
}
msg = "修改成功";
}
else
{
msg = "修改失败";
}
return(Json(msg, JsonRequestBehavior.AllowGet));
}
