protected override object GetEditObject(GridRecord row) { if (facade == null) { facade = new BaseModelFacadeFactory(base.DataProvider).Create(); } Route2Operation route2Operation = this.facade.CreateNewRoute2Operation(); route2Operation.RouteCode = txtRouteCodeQuery.Text; route2Operation.OPCode = row.Items.FindItemByKey("OPCode").Text; route2Operation.OPControl = row.Items.FindItemByKey("OPControl").Text; route2Operation.MaintainUser = this.GetUserCode(); return(route2Operation); }
protected override object GetEditObject() { if (facade == null) { facade = new BaseModelFacadeFactory(base.DataProvider).Create(); } Route2Operation relation = this.facade.CreateNewRoute2Operation(); relation.RouteCode = FormatHelper.CleanString(this.txtRouteCodeQuery.Text.Trim(), 40); relation.OPCode = FormatHelper.CleanString(this.txtOperationCodeEdit.Text, 40); relation.OPSequence = System.Int32.Parse(this.txtOperationSequenceEdit.Text); relation.OPControl = (new OperationListFactory()).CreateOperationList(this.chklstOPControlEdit, this.chklstOPAttributeEdit); relation.MaintainUser = this.GetUserCode(); return(relation); }
public void TestModelFacade_AddModel2Route() { this.persistBroker.Execute(String.Format("delete from tblroutealt2route where routealtcode='{0}' and routecode='{1}'", routeAltCode, routeCode)); object[] routes = this.baseModelFacade.GetUnselectedRouteByRouteAltCode(routeAltCode, string.Empty, int.MinValue, int.MaxValue); Assert.IsNotNull(routes); RouteAlt2Route routeAlt2Route = this.baseModelFacade.CreateNewRouteAlt2Route(); routeAlt2Route.RouteAltCode = routeAltCode; routeAlt2Route.RouteCode = routeCode; routeAlt2Route.RouteSequence = 0; routeAlt2Route.MaintainUser = "******"; this.baseModelFacade.AddRouteAlt2Route(routeAlt2Route); routeCode = ((Route)routes[0]).RouteCode; Assert.AreEqual(this.baseModelFacade.GetSelectedRouteByRouteAltCodeCount(routeAltCode, routeCode), 1); object[] operations = this.baseModelFacade.GetUnselectedOperationByRouteCode(routeCode, string.Empty, int.MinValue, int.MaxValue); Assert.IsNotNull(operations); Route2Operation route2Operation = this.baseModelFacade.CreateNewRoute2Operation(); route2Operation.OPCode = ((Operation)operations[0]).OPCode; route2Operation.MaintainUser = "******"; route2Operation.OPSequence = 0; route2Operation.RouteCode = routeCode; this.baseModelFacade.AddRoute2Operation(route2Operation); Assert.AreEqual(this.baseModelFacade.GetSelectedOperationByRouteCodeCount(routeCode, ((Operation)operations[0]).OPCode), 1); Model2Route model2Route = this.modelFacade.CreateNewModel2Route(); model2Route.RouteCode = routeCode; // model2Route.RouteAltCode = routeAltCode; model2Route.ModelCode = modelCode; model2Route.MaintainUser = "******"; this.modelFacade.AddModelRoute(model2Route); Assert.AreEqual(this.modelFacade.GetModel2RoutesCounts(modelCode, routeCode), 1); object[] model2ops = this.modelFacade.GetModel2Operations(modelCode, routeCode); Assert.IsNotNull(model2ops); Model2OP model2OP = (Model2OP)this.modelFacade.GetModel2Operation(((Model2OP)model2ops[0]).OPID); model2OP.OPControl = "000000000"; this.modelFacade.UpdateModel2Operation(model2OP); Assert.AreEqual(((Model2OP)modelFacade.GetModel2Operation(((Model2OP)model2ops[0]).OPID)).OPControl, "000000000"); }
protected void cmdSaveTotal_ServerClick(object sender, EventArgs e) { #region Check seq before batch save string seqList = ","; string seq = string.Empty; for (int i = 0; i < this.gridWebGrid.Rows.Count; i++) { seq = int.Parse(this.gridWebGrid.Rows[i].Items.FindItemByKey("OPSequence").Value.ToString()).ToString(); if (seqList.IndexOf("," + seq + ",") >= 0) { ExceptionManager.Raise(this.GetType(), "$Error_Route2Operation_Sequence_Cannot_Repeat"); break; } else { seqList += seq + ","; } } #endregion if (facade == null) { facade = new BaseModelFacadeFactory(base.DataProvider).Create(); } for (int i = 0; i < this.gridWebGrid.Rows.Count; i++) { Route2Operation obj = (Route2Operation)this.facade.GetRoute2Operation(this.txtRouteCodeQuery.Text.Trim(), gridWebGrid.Rows[i].Items.FindItemByKey("OPCode").Value.ToString()); if (obj != null) { obj.OPSequence = int.Parse(this.gridWebGrid.Rows[i].Items.FindItemByKey("OPSequence").Value.ToString()); facade.UpdateRoute2Operation(obj, false); } } this.gridHelper.RequestData(); }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; JavaScriptSerializer jss = new JavaScriptSerializer(); //OracleDbHelper oracleHelper = new OracleDbHelper("Mes64"); IDomainDataProvider dataProvider = DomainDataProviderManager.DomainDataProvider(); BaseModelFacade facade = new BaseModelFacade(dataProvider); string action = context.Request["action"]; string routecode = context.Request["routecode"]; if (action == "getRouteByCode") { Route route = facade.GetRoute(routecode) as Route; string strJson = jss.Serialize(route); context.Response.Write(strJson); } else if (action == "getOpByRoute") { OperationOfRoute[] opList = facade.GetOpByRouteCode(routecode) as OperationOfRoute[]; string strJson = jss.Serialize(opList); context.Response.Write(strJson); } else if (action == "getOtherOp") { string opcode = context.Request["opcode"]; if (opcode == null) { opcode = string.Empty; } Operation[] opList = facade.GetOtherOpByRouteCode(routecode, opcode) as Operation[]; string strJson = jss.Serialize(opList); context.Response.Write(strJson); } else if (action == "save") { string opJson = context.Request["opJson"]; Op[] opList = jss.Deserialize <Op[]>(opJson); //List<Op> opList = opArray.ToList<Op>(); //context.Response.Write(jss.Serialize(opList)); try { dataProvider.BeginTransaction(); foreach (Op op in opList) { Route2Operation opNew = new Route2Operation(); opNew.RouteCode = routecode; opNew.OPCode = op.OpCode; opNew.OPSequence = op.OpSeq; opNew.OPControl = op.OpControl + "0000000000"; opNew.MaintainUser = "******"; opNew.MaintainDate = Convert.ToInt32(DateTime.Now.ToString("yyyyMMdd")); opNew.MaintainTime = Convert.ToInt32(DateTime.Now.ToString("HHmmss")); if (op.DataType == 0) { facade.AddRoute2Operation(opNew); } else if (op.DataType == 1) { facade.UpdateRoute2Operation(opNew); } else if (op.DataType == 2) { facade.DeleteRoute2Operation(opNew); } } dataProvider.CommitTransaction(); } catch (Exception ex) { dataProvider.RollbackTransaction(); context.Response.StatusCode = 500; context.Response.Write(ex.Message); context.Response.End(); } } }
protected void Page_Load(object sender, EventArgs e) { Response.ClearContent(); Response.Clear(); Response.ContentType = "text/plain"; JavaScriptSerializer jss = new JavaScriptSerializer(); //OracleDbHelper oracleHelper = new OracleDbHelper("Mes64"); //IDomainDataProvider dataProvider = DomainDataProviderManager.DomainDataProvider(); BaseModelFacade facade = new BaseModelFacade(this.DataProvider); string action = Request["action"]; string routecode = Request["routecode"]; if (action == "getRouteByCode") { Route route = facade.GetRoute(routecode) as Route; string strJson = jss.Serialize(route); Response.Write(strJson); } else if (action == "getOpByRoute") { object[] opList = facade.GetOpByRouteCode(routecode); string strJson = jss.Serialize(opList); Response.Write(strJson); } else if (action == "getOtherOp") { string opcode = Request["opcode"]; if (opcode == null) { opcode = string.Empty; } object[] opList = facade.GetOtherOpByRouteCode(routecode, opcode); string strJson = jss.Serialize(opList); Response.Write(strJson); } else if (action == "save") { string opJson = Request["opJson"]; Op[] opList = jss.Deserialize <Op[]>(opJson); //List<Op> opList = opArray.ToList<Op>(); //context.Response.Write(jss.Serialize(opList)); try { this.DataProvider.BeginTransaction(); foreach (Op op in opList) { Route2Operation opNew = new Route2Operation(); opNew.RouteCode = routecode; opNew.OPCode = op.OpCode; opNew.OPSequence = op.OpSeq; opNew.OPControl = op.OpControl; opNew.MaintainUser = this.GetUserCode(); opNew.MaintainDate = Convert.ToInt32(DateTime.Now.ToString("yyyyMMdd")); opNew.MaintainTime = Convert.ToInt32(DateTime.Now.ToString("HHmmss")); if (op.DataType == 0) { facade.AddRoute2Operation(opNew); } else if (op.DataType == 1) { facade.UpdateRoute2Operation(opNew, false); } else if (op.DataType == 2) { facade.DeleteRoute2Operation(opNew); } } this.DataProvider.CommitTransaction(); } catch (Exception ex) { this.DataProvider.RollbackTransaction(); Response.StatusCode = 500; Response.Write(ex.Message); Response.End(); } } Response.End(); }