public bool Add(DateTime datetime, out string strResult) { bool result = false; strResult = string.Empty; var moveBillMaster = MoveBillMasterRepository.GetQueryable().Where(i => i.BillDate <= datetime); var moveBillDetail = MoveBillDetailRepository.GetQueryable().Where(i => i.MoveBillMaster.BillDate <= datetime); if (moveBillMaster.Any()) { #region 主表移入历史表 try { foreach (var item in moveBillMaster.ToArray()) { MoveBillMasterHistory history = new MoveBillMasterHistory(); history.BillNo = item.BillNo; history.BillDate = item.BillDate; history.BillTypeCode = item.BillTypeCode; history.WarehouseCode = item.WarehouseCode; history.OperatePersonID = item.OperatePersonID; history.Status = item.Status; history.VerifyPersonID = item.VerifyPersonID; history.VerifyDate = item.VerifyDate; history.Description = item.Description; history.IsActive = item.IsActive; history.UpdateTime = item.UpdateTime; history.Origin = item.Origin; MoveBillMasterHistoryRepository.Add(history); } result = true; } catch (Exception e) { strResult = "主库单:" + e.InnerException.ToString(); result = false; } #endregion if (moveBillDetail.Any()) { #region 细表移入历史表 try { foreach (var item in moveBillDetail.ToArray()) { MoveBillDetailHistory history = new MoveBillDetailHistory(); history.BillNo = item.BillNo; history.ProductCode = item.ProductCode; history.OutCellCode = item.OutCellCode; history.OutStorageCode = item.OutStorageCode; history.InCellCode = item.InCellCode; history.InStorageCode = item.InStorageCode; history.UnitCode = item.UnitCode; history.RealQuantity = item.RealQuantity; history.OperatePersonID = item.OperatePersonID; history.StartTime = item.StartTime; history.FinishTime = item.FinishTime; history.Status = item.Status; history.Operator = item.Operator; history.CanRealOperate = item.CanRealOperate; history.PalletTag = item.PalletTag; MoveBillDetailHistoryRepository.Add(history); } result = true; } catch (Exception e) { strResult = "细库单:" + e.InnerException.ToString();; } #endregion } if (result == true) { #region 除主细分配表 try { foreach (var item in moveBillMaster.ToList()) { Del(MoveBillDetailRepository, item.MoveBillDetails); MoveBillMasterRepository.Delete(item); result = true; } } catch (Exception e) { strResult = "删除情况" + e.InnerException.ToString(); } MoveBillMasterHistoryRepository.SaveChanges(); #endregion } } else { strResult = "数据不存在!"; } return(result); }
public ActionResult MoveDataIsHistory(string dateTime, string billType) { string msg = string.Empty; bool bResult; string strResult = string.Empty; DateTime time = Convert.ToDateTime(dateTime); switch (billType) { case "1": //入库单据 bResult = InBillMasterHistory.Add(time, out strResult); if (!bResult) { msg = "入库操作:" + strResult; } break; case "2": //出库单据 bResult = OutBillMasterHistory.Add(time, out strResult); if (!bResult) { msg = "出库操作:" + strResult; } break; case "3": //移库单据 bResult = MoveBillMasterHistory.Add(time, out strResult); if (!bResult) { msg = "移库操作:" + strResult; } break; case "4": //盘点单据 bResult = CheckBillMasterHistory.Add(time, out strResult); if (!bResult) { msg = "盘点操作:" + strResult; } break; case "5": //损益单据 bResult = ProfitLossBillMasterHistory.Add(time, out strResult); if (!bResult) { msg = "损益操作:" + strResult; } break; case "6": //日结 bResult = DailyBalanceHistoryService.Add(time, out strResult); if (!bResult) { msg = "出库操作:" + strResult; } break; default: msg = "调用了未定义的方法!"; break; } return(new ContentResult() { Content = msg, ContentEncoding = Encoding.GetEncoding("GB2312"), ContentType = "text" }); }