/// <summary>
/// 通过察看有没有在工单选择该route如果有则不能删除
/// 没有则可以删除，删除也删除对应copy途程的详细的信息
/// </summary>
/// <param name="model2Route"></param>
private void DeleteModelRoute(Model2Route model2Route)
{
if (model2Route == null)
{
ExceptionManager.Raise(this.GetType(), "$Error_Null_Paramter");
// throw new RemotingException(ErrorCenter.GetErrorServerDescription(typeof(ModelFacade),String.Format(ErrorCenter.ERROR_ARGUMENT_NULL,"model2Route")));
}
MOFacade _moFacade = new MOFacade(this.DataProvider);
if (_moFacade.IsModelRouteUsed(model2Route.RouteCode))
{
ExceptionManager.Raise(this.GetType(), "$Error_ModelRoute_Used", String.Format("[$ModelCode='{0}']", model2Route.ModelCode), null);
// throw new RemotingException(ErrorCenter.GetErrorServerDescription(typeof(ModelFacade),string.Format(ErrorCenter.ERROR_MODELROUTEUSED,model2Route.ModelCode,model2Route.RouteCode)));
}
try
{
object[] modelOperations = GetModel2Operations(model2Route);
for (int i = 0; i < modelOperations.Length; i++)
{
this.DataProvider.Delete(modelOperations[i]);
}
this.DataProvider.Delete(model2Route);
}
catch (Exception ex)
{
//_log.Error(ex.Message);
ExceptionManager.Raise(this.GetType(), "$Error_DeleteModelRoute_Failure", String.Format("[$ModelCode='{0}',$RouteCode='{1}']", model2Route.ModelCode, model2Route.RouteCode), ex);
// throw new RemotingException(ErrorCenter.GetErrorServerDescription(typeof(ModelFacade),String.Format(ErrorCenter.ERROR_DELETEMODELROUTE,model2Route.ModelCode,model2Route.RouteCode)),ex);
}
}
public object[] GetModel2Operations(Model2Route model2Route)
{
if (model2Route == null)
{
ExceptionManager.Raise(this.GetType(), "$Error_Null_Paramter");
// throw new RemotingException(ErrorCenter.GetErrorServerDescription(typeof(ModelFacade),String.Format(ErrorCenter.ERROR_ARGUMENT_NULL,"model2Route")));
}
return(this.DataProvider.CustomQuery(typeof(Model2OP),
new SQLCondition(String.Format("select " + DomainObjectUtility.GetDomainObjectFieldsString(typeof(Model2OP)) + " from tblmodel2op where modelcode='{0}' and routecode='{1}' and orgid={2}", model2Route.ModelCode, model2Route.RouteCode, model2Route.OrganizationID))));
}
/// <summary>
/// 增加Model2Route,同时不Route下面所有的Operation复制过来
/// </summary>
/// <param name="model2Route"></param>
public void AddModelRoute(Model2Route model2Route)
{
BaseModelFacade _baseModelFacade = new BaseModelFacade(this.DataProvider);
try
{
//DataProvider.BeginTransaction();
//add item2route]
//Laws Lu,2006/11/13 uniform system collect date
DBDateTime dbDateTime;
dbDateTime = FormatHelper.GetNowDBDateTime(DataProvider);
model2Route.MaintainDate = dbDateTime.DBDate;
model2Route.MaintainTime = dbDateTime.DBTime;
this._helper.AddDomainObject(model2Route);
//this.DataProvider.Insert(model2Route);
//add item2op
object[] operations = _baseModelFacade.GetSelectedOperationByRouteCode(model2Route.RouteCode, string.Empty, int.MinValue, int.MaxValue);
if (operations == null)
{
ExceptionManager.Raise(this.GetType().BaseType, "$Error_RouteHasNoOperations", string.Format("[$RouteCode='{0}']", model2Route.RouteCode), null);
}
for (int i = 0; i < operations.Length; i++)
{
Model2OP model2Operation = new Model2OP();
model2Operation.RouteCode = model2Route.RouteCode;
model2Operation.ModelCode = model2Route.ModelCode;
model2Operation.OPCode = ((Operation)operations[i]).OPCode;
model2Operation.OPSequence = i;
model2Operation.OPControl = ((Operation)operations[i]).OPControl;
model2Operation.IDMergeType = IDMergeType.IDMERGETYPE_IDMERGE;
model2Operation.IDMergeRule = 1;
model2Operation.MaintainUser = model2Route.MaintainUser;
model2Operation.MaintainDate = model2Route.MaintainDate;
model2Operation.MaintainTime = model2Route.MaintainTime;
model2Operation.OPID = CreateOPID(model2Route.ModelCode, model2Route.RouteCode, ((Operation)operations[i]).OPCode);
model2Operation.OrganizationID = model2Route.OrganizationID;
this._helper.AddDomainObject(model2Operation);
//DataProvider.Insert(model2Operation);
}
//DataProvider.CommitTransaction();
}
catch (Exception ex)
{
//_log.Error(ex.Message);
//DataProvider.RollbackTransaction();
ExceptionManager.Raise(this.GetType(), "$Error_AddModelRoute_Failure", String.Format("[$ModelCode='{0}',$RouteCode='{1}' ]", model2Route.ModelCode, model2Route.RouteCode), ex);
// throw new RemotingException(ErrorCenter.GetErrorServerDescription(typeof(ModelFacade),String.Format(ErrorCenter.ERROR_ADDMODELROUTE,model2Route.ModelCode,model2Route.RouteCode)),ex);
}
}
private object GetEditObject(Infragistics.WebUI.UltraWebGrid.UltraGridRow row)
{
if (_modelFacade == null)
{
_modelFacade = new FacadeFactory(base.DataProvider).CreateModelFacade();
}
Model2Route model2Route = this._modelFacade.CreateNewModel2Route();
model2Route.ModelCode = ModelCode;
model2Route.RouteCode = row.Cells[1].Text;
model2Route.MaintainUser = this.GetUserCode();
model2Route.OrganizationID = GlobalVariables.CurrentOrganizations.First().OrganizationID;
return(model2Route);
}
public void TestModelFacade_DeleteModel2Route()
{
modelCode = "Model Code";
routeCode = "Route_DIP";
Model2Route model2Route = this.modelFacade.CreateNewModel2Route();
model2Route.RouteCode = routeCode;
model2Route.ModelCode = modelCode;
// model2Route.RouteAltCode = routeAltCode;
model2Route.MaintainUser = "******";
//Model2Route model2Route = (Model2Route) this.modelFacade.GetModel2Route(routeCode,modelCode);
Model2Route[] model2Routes = new Model2Route[1];
model2Routes[0] = model2Route;
this.modelFacade.DeleteModelRoute(model2Routes);
Assert.AreEqual(this.modelFacade.GetModel2RoutesCounts(modelCode, routeCode), 0);
}
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 cmdAdd_ServerClick(object sender, System.EventArgs e)
{
if (_modelFacade == null)
{
_modelFacade = new FacadeFactory(base.DataProvider).CreateModelFacade();
}
ArrayList array = this.gridHelper.GetCheckedRows();
Model2Route[] model2Routes = new Model2Route[array.Count];
for (int i = 0; i < array.Count; i++)
{
model2Routes[i] = (Model2Route)this.GetEditObject((UltraGridRow)array[i]);
}
this._modelFacade.AddModelRoute(model2Routes);
this.RequestData();
}
