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();
}
