public static int Add(MoveReport b)
{
WarehouseEntities entity = new WarehouseEntities();
entity.MoveReport.Add(b);
return(entity.SaveChanges());
}
//修改审核状态
public ActionResult UpdtStatus(MoveReport i, string status)
{
var ss = moveReport.GetByWhere(item => item.Id == i.Id).SingleOrDefault();
i.MoveNum = ss.MoveNum;
i.MoveTypeId = ss.MoveTypeId;
i.DetailNum = ss.DetailNum;
i.Num = ss.Num;
i.Status = status;
i.AuditUser = ss.AuditUser;
i.AuditTime = ss.AuditTime;
i.IsDelete = ss.IsDelete;
i.Remark = ss.Remark;
var moveReports = new MoveReportManager();
var s = moveReports.Update(i);
if (status.Equals("审核通过"))
{
var d = moveReportDetail.GetByWhere(item => item.MoveId == ss.MoveNum);
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.LocationId = Convert.ToInt32(item.MoveLocationId);
var pdu = product.Update(pdu1);
}
}
var result = new
{
ActionResult = s
};
return(Json(result, JsonRequestBehavior.AllowGet));
}
//全选单选删除
public ActionResult DeleteOther(List <MoveReport> list)
{
string msg = "";
foreach (var item in list)
{
MoveReport ins = moveReport.GetByWhere(i => i.Id == item.Id).SingleOrDefault();
List <MoveReportDetail> listDetail = moveReportDetail.GetByWhere(i => i.MoveId == ins.MoveNum);
bool val = true;
foreach (var listd in listDetail)
{
listd.IsDelete = 1;
val = moveReportDetail.Update(listd);
}
if (val)
{
ins.IsDelete = 1;
bool vall = moveReport.Update(ins);
if (vall)
{
msg = "删除成功";
}
else
{
msg = "删除失败";
}
}
}
return(Json(msg, JsonRequestBehavior.AllowGet));
}
public ActionResult QueryByIdMinXiInfo(int id)
{
MoveReport ins = moveReport.GetByWhere(i => i.Id == id).SingleOrDefault();
var mx = moveReportDetail.GetByWhere(i => i.MoveId == ins.MoveNum && i.IsDelete == 0);
return(Json(mx, JsonRequestBehavior.AllowGet));
}
public static int MoveReportEdit(MoveReport p)
{
WarehouseEntities entity = new WarehouseEntities();
//先修改主表数据
var obj = entity.MoveReport.Find(p.Id);
obj.MoveTypeId = p.MoveTypeId;
obj.ProductId = p.ProductId;
obj.Num = p.Num;
obj.Status = p.Status;
obj.AuditUser = p.AuditUser;
obj.AuditTime = p.AuditTime;
return(entity.SaveChanges());
}
public ActionResult Add3(MoveReport b)
{
b.DetailNum = "1";
b.IsDelete = 0;
return(Json(MoveReportManager.Add3(b), JsonRequestBehavior.AllowGet));
}
}//移库修改
public ActionResult MoveReportEdit(MoveReport bad)
{
return(Json(MoveReportManager.MoveReportEdit(bad), JsonRequestBehavior.AllowGet));
}
public static int Add3(MoveReport b)
{
return(MoveReportService.Add(b));
}
public static int MoveReportEdit(MoveReport p)
{
return(MoveReportService.MoveReportEdit(p));
}
public ActionResult Insert(List <MoveReportDetail> detail, int MoveTypeId, string Remark, string AuditUser)
{
string detailNum = "";
//获取明细表最大编号
string detailNumBig = moveReportDetail.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 moveNum = "";
//获取出库表最大编号
string moveNumBig = moveReport.GetByWhere(i => true).OrderByDescending(i => i.MoveNum).Take(1).Select(i => i.MoveNum).FirstOrDefault();
if (moveNumBig == null)
{
moveNum = "000001";
}
else
{
moveNum = "00000" + (int.Parse(moveNumBig) + 1);
int num_2 = int.Parse(moveNumBig);
if (num_2 >= 9)
{
moveNum = "0000" + (int.Parse(moveNumBig) + 1);
}
if (num_2 >= 99)
{
moveNum = "000" + (int.Parse(moveNumBig) + 1);
}
}
bool val = true;
string msg = "";
foreach (var item in detail)
{
item.CreateTime = DateTime.Now;
item.DetailNum = detailNum;
item.MoveId = moveNum;
val = moveReportDetail.Add(item);
}
if (val)
{
var num = moveReportDetail.GetByWhere(i => i.MoveId == moveNum).Sum(i => i.Quantity); //获取总出货数
MoveReport mov = new MoveReport();
mov.MoveNum = moveNum;
mov.MoveTypeId = MoveTypeId;
mov.DetailNum = detailNum;
mov.Num = Convert.ToInt32(num);;
mov.Status = "待审核";
mov.AuditTime = DateTime.Now;
mov.AuditUser = AuditUser;
mov.Remark = Remark;
mov.IsDelete = 0;
bool val1 = moveReport.Add(mov);
if (val1)
{
msg = "新增成功";
}
else
{
msg = "新增失败";
}
msg = "新增成功";
}
else
{
msg = "新增失败";
}
return(Json(msg, JsonRequestBehavior.AllowGet));
}
