public override IModel CreateModel(SqlDataReader dr) { StockMove stockmove = new StockMove(); int indexStockMoveId = dr.GetOrdinal("StockMoveId"); stockmove.StockMoveId = Convert.ToInt32(dr[indexStockMoveId]); int indexStockMoveApplyId = dr.GetOrdinal("StockMoveApplyId"); stockmove.StockMoveApplyId = Convert.ToInt32(dr[indexStockMoveApplyId]); int indexMover = dr.GetOrdinal("Mover"); if (dr["Mover"] != DBNull.Value) { stockmove.Mover = Convert.ToInt32(dr[indexMover]); } int indexMoveTime = dr.GetOrdinal("MoveTime"); if (dr["MoveTime"] != DBNull.Value) { stockmove.MoveTime = Convert.ToDateTime(dr[indexMoveTime]); } int indexMoveStatus = dr.GetOrdinal("MoveStatus"); if (dr["MoveStatus"] != DBNull.Value) { stockmove.MoveStatus = (Common.StatusEnum)Convert.ToInt32(dr[indexMoveStatus]); } int indexMoveMemo = dr.GetOrdinal("MoveMemo"); if (dr["MoveMemo"] != DBNull.Value) { stockmove.MoveMemo = Convert.ToString(dr[indexMoveMemo]); } int indexCreatorId = dr.GetOrdinal("CreatorId"); if (dr["CreatorId"] != DBNull.Value) { stockmove.CreatorId = Convert.ToInt32(dr[indexCreatorId]); } int indexCreateTime = dr.GetOrdinal("CreateTime"); if (dr["CreateTime"] != DBNull.Value) { stockmove.CreateTime = Convert.ToDateTime(dr[indexCreateTime]); } int indexLastModifyId = dr.GetOrdinal("LastModifyId"); if (dr["LastModifyId"] != DBNull.Value) { stockmove.LastModifyId = Convert.ToInt32(dr[indexLastModifyId]); } int indexLastModifyTime = dr.GetOrdinal("LastModifyTime"); if (dr["LastModifyTime"] != DBNull.Value) { stockmove.LastModifyTime = Convert.ToDateTime(dr[indexLastModifyTime]); } return stockmove; }
public ResultModel StockMoveCreateHandle(UserModel user, int stockMoveApplyId, string memo) { ResultModel result = new ResultModel(); try { using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required)) { Model.StockMove stockMove = new StockMove() { StockMoveApplyId = stockMoveApplyId, Mover = user.EmpId, MoveTime = DateTime.Now, MoveMemo = memo, }; DAL.StockMoveDAL stockMoveDAL = new StockMoveDAL(); result = stockmoveDAL.Insert(user, stockMove); if (result.ResultStatus != 0) return result; int stockMoveId = (int)result.ReturnValue; DAL.StockMoveApplyDetailDAL stockMoveApplyDetailDAL = new StockMoveApplyDetailDAL(); result = stockMoveApplyDetailDAL.Load(user, stockMoveApplyId); if (result.ResultStatus != 0) return result; List<Model.StockMoveApplyDetail> details = result.ReturnValue as List<Model.StockMoveApplyDetail>; if (details == null || !details.Any()) { result.ResultStatus = -1; result.Message = "获取失败"; return result; } DAL.StockMoveDetailDAL stockMoveDetailDAL = new StockMoveDetailDAL(); foreach (Model.StockMoveApplyDetail stockMoveApplyDetail in details) { result = stockMoveDetailDAL.Insert(user, new StockMoveDetail() { StockMoveId = stockMoveId, MoveDetailStatus = StatusEnum.已生效, StockId = stockMoveApplyDetail.StockId, PaperNo = stockMoveApplyDetail.PaperNo, DeliverPlaceId = stockMoveApplyDetail.DeliverPlaceId }); if (result.ResultStatus != 0) return result; } scope.Complete(); } } catch (Exception ex) { result.Message = ex.Message; } finally { if (result.ResultStatus != 0) log.ErrorFormat("{0} {1},类型序号:{2}", user.EmpName, result.Message, result.ReturnValue); else if (log.IsInfoEnabled) log.InfoFormat("{0} {1},类型序号:{2}", user.EmpName, result.Message, result.ReturnValue); } return result; }