public ActionResult _InsertFlowRoute(GridCommand command, TransportFlowRoute flowRoute) { var dbFlowRoute = new TransportFlowRoute(); var maxSeq = this.genericMgr.FindAll<object>("select Max(tf.Sequence) from TransportFlowRoute tf where tf.Flow=?", flowRoute.Flow); if (maxSeq != null && maxSeq.Count > 0 && maxSeq.FirstOrDefault() != null) { dbFlowRoute.Sequence = ((int)maxSeq.FirstOrDefault())+1; } else { dbFlowRoute.Sequence = 1; } dbFlowRoute.ShipAddress = flowRoute.ShipAddress; dbFlowRoute.ShipAddressDescription = flowRoute.ShipAddressDescription; dbFlowRoute.Flow = flowRoute.Flow; this.genericMgr.Create(dbFlowRoute); GridModel<TransportFlowRoute> GridModel = new GridModel<TransportFlowRoute>(); GridModel.Total = (int)this.genericMgr.FindAll<long>("select count(*) from TransportFlowRoute tf where tf.Flow=?", dbFlowRoute.Flow)[0]; var result = this.genericMgr.FindAll<TransportFlowRoute>("from TransportFlowRoute tf where tf.Flow=? order by Sequence", dbFlowRoute.Flow); this.FillCodeDetailDescription<TransportFlowRoute>(result); GridModel.Data = result; return PartialView(GridModel); }
public ActionResult _UpdateFlowRoute(GridCommand command, TransportFlowRoute flowRoute) { var dbFlowRoute = this.genericMgr.FindById<TransportFlowRoute>(flowRoute.Id); dbFlowRoute.Sequence = flowRoute.Sequence; dbFlowRoute.ShipAddress = flowRoute.ShipAddress; dbFlowRoute.ShipAddressDescription = flowRoute.ShipAddressDescription; dbFlowRoute.Flow = flowRoute.Flow; this.genericMgr.Update(dbFlowRoute); GridModel<TransportFlowRoute> GridModel = new GridModel<TransportFlowRoute>(); GridModel.Total = (int)this.genericMgr.FindAll<long>("select count(*) from TransportFlowRoute tf where tf.Flow=?", dbFlowRoute.Flow)[0]; var result = this.genericMgr.FindAll<TransportFlowRoute>("from TransportFlowRoute tf where tf.Flow=? order by Sequence", dbFlowRoute.Flow); this.FillCodeDetailDescription<TransportFlowRoute>(result); GridModel.Data = result; return PartialView(GridModel); }