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" }); }
public bool Add(DateTime datetime, out string strResult) { bool result = false; strResult = string.Empty; var profitLossBillMaster = ProfitLossBillMasterRepository.GetQueryable().Where(i => i.BillDate <= datetime); var profitLossBillDetail = ProfitLossBillDetailRepository.GetQueryable().Where(i => i.ProfitLossBillMaster.BillDate <= datetime); if (profitLossBillMaster.Any()) { #region 主表移入历史表 try { foreach (var item in profitLossBillMaster.ToArray()) { ProfitLossBillMasterHistory history = new ProfitLossBillMasterHistory(); history.BillNo = item.BillNo; history.BillDate = item.BillDate; history.BillTypeCode = item.BillTypeCode; history.CheckBillNo = ""; history.WarehouseCode = item.WarehouseCode; 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.OperatePersonID = item.OperatePersonID; history.LockTag = item.LockTag; history.RowVersion = item.RowVersion; ProfitLossBillMasterHistoryRepository.Add(history); } result = true; } catch (Exception e) { strResult = "主库单:" + e.InnerException.ToString(); result = false; } #endregion if (profitLossBillDetail.Any()) { #region 细表移入历史表 try { foreach (var item in profitLossBillDetail.ToArray()) { ProfitLossBillDetailHistory history = new ProfitLossBillDetailHistory(); history.BillNo = item.BillNo; history.CellCode = item.CellCode; history.StorageCode = item.StorageCode; history.ProductCode = item.ProductCode; history.UnitCode = item.UnitCode; history.Price = item.Price; history.Quantity = item.Quantity; history.Description = item.Description; ProfitLossBillDetailHistoryRepository.Add(history); } result = true; } catch (Exception e) { strResult = "细库单:" + e.InnerException.ToString();; } #endregion } if (result == true) { #region 除主细分配表 try { foreach (var item in profitLossBillMaster.ToList()) { Del(ProfitLossBillDetailRepository, item.ProfitLossBillDetails); ProfitLossBillMasterRepository.Delete(item); result = true; } } catch (Exception e) { strResult = "删除情况:" + e.InnerException.ToString(); } ProfitLossBillMasterHistoryRepository.SaveChanges(); #endregion } } else { strResult = "数据不存在!"; } return(result); }