public bool Add(DateTime datetime, out string strResult) { bool result = false; strResult = string.Empty; var checkBillMaster = CheckBillMasterRepository.GetQueryable().Where(i => i.BillDate <= datetime); var checkBillDetail = CheckBillDetailRepository.GetQueryable().Where(i => i.CheckBillMaster.BillDate <= datetime); if (checkBillMaster.Any()) { #region 主表移入历史表 try { foreach (var item in checkBillMaster.ToArray()) { CheckBillMasterHistory history = new CheckBillMasterHistory(); 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; CheckBillMasterHistoryRepository.Add(history); } result = true; } catch (Exception e) { strResult = "主库单:" + e.InnerException.ToString(); result = false; } #endregion if (checkBillDetail.Any()) { #region 细表移入历史表 try { foreach (var item in checkBillDetail.ToArray()) { CheckBillDetailHistory history = new CheckBillDetailHistory(); history.BillNo = item.BillNo; history.CellCode = item.CellCode; history.StorageCode = item.StorageCode; history.ProductCode = item.ProductCode; history.UnitCode = item.UnitCode; history.Quantity = item.Quantity; history.RealProductCode = item.ProductCode; history.RealUnitCode = item.RealUnitCode; history.RealQuantity = item.Quantity; history.Status = item.Status; CheckBillDetailHistoryRepository.Add(history); } result = true; } catch (Exception e) { strResult = "细库单:" + e.InnerException.ToString();; } #endregion } if (result == true) { #region 除主细分配表 try { foreach (var item in checkBillMaster.ToList()) { Del(CheckBillDetailRepository, item.CheckBillDetails); CheckBillMasterRepository.Delete(item); result = true; } } catch (Exception e) { strResult = "删除情况:" + e.InnerException.ToString(); } CheckBillMasterHistoryRepository.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" }); }