//查询明细
public ActionResult QueryMinXi(int id)
{
Expression <Func <ReturnOrderStock, bool> > where = i => i.Id == id;
var s = returnOrderStock.GetByWhere(where).SingleOrDefault();
var d = returnOrderdetail.GetByWhere(i => i.ReturnId == s.ReturnNum);
var t = returnOrderType.GetByWhere(i => i.Id == s.ReturnTypeId).SingleOrDefault();
//主表显示
var info = new
{
id = s.Id,
ReturnNum = s.ReturnNum,
ReturnTypeId = t.ReturnTypeName,
Status = s.Status,
Num = s.Num,
AuditUser = s.AuditUser,
AuditTime = s.AuditTime.ToString("yyyy-MM-dd"),
Remark = s.Remark
};
//明细
var dd = d.Select(i => new { Id = i.Id, DetailNum = i.DetailNum, ReturnId = i.ReturnId, ProductNum = i.ProductNum, ProductName = i.ProductName, Size = i.Size, Sum = i.Sum, Location = i.Location });
var result = new
{
ReturnOrderStockInfo = info,
XiangXiInfo = dd
};
return(Json(result, JsonRequestBehavior.AllowGet));
}
//修改退货单
public ActionResult UpdtInfo(List <ReturnOrderDetail> detail, int ReturnTypeId, int SupplierId, string Remark, string ReturnNum)
{
//先删除明细
bool val_1 = true;
var returnOrderDetails = new ReturnOrderDetailManager();
var mx = returnOrderDetails.GetByWhere(i => i.ReturnId == ReturnNum);
foreach (var item in mx)
{
val_1 = returnOrderDetails.Delete(item);
}
//获取明细表最大编号
string detailNumBig = returnOrderdetail.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.CreateTime = DateTime.Now;
item.DetailNum = detailNum;
item.ReturnId = ReturnNum;
val = returnOrderdetail.Add(item);
}
if (val)
{
var num = returnOrderdetail.GetByWhere(item => item.ReturnId == ReturnNum).Sum(item => item.Sum);
var returnOrderStock_1 = new ReturnOrderStockManager();
var s = returnOrderStock_1.GetByWhere(i => i.ReturnNum == ReturnNum).SingleOrDefault();
s.DetailNum = detailNum;
s.ReturnTypeId = ReturnTypeId;
s.SupplierId = SupplierId;
s.Remark = Remark;
s.Num = Convert.ToInt32(num);
bool vall = returnOrderStock.Update(s);
if (vall)
{
msg = "修改成功";
}
else
{
msg = "修改失败";
}
msg = "修改成功";
}
else
{
msg = "修改失败";
}
return(Json(msg, JsonRequestBehavior.AllowGet));
}