public RouteBase(string RouteId, OleExec sfcdb)
{
try
{
T_C_ROUTE TC_ROUTE = new T_C_ROUTE(sfcdb, MESDataObject.DB_TYPE_ENUM.Oracle);
T_C_ROUTE_DETAIL TC_ROUTE_DETAIL = new T_C_ROUTE_DETAIL(sfcdb, MESDataObject.DB_TYPE_ENUM.Oracle);
C_ROUTE getRoute = new C_ROUTE();
List <C_ROUTE_DETAIL> getRouteDetail = new List <C_ROUTE_DETAIL>();
getRoute = TC_ROUTE.GetById(RouteId, sfcdb);
if (getRoute != null)
{
this._ID = getRoute.ID;
this._ROUTE_NAME = getRoute.ROUTE_NAME;
this._DEFAULT_SKUNO = getRoute.DEFAULT_SKUNO;
this._ROUTE_TYPE = getRoute.ROUTE_TYPE;
getRouteDetail = TC_ROUTE_DETAIL.GetByRouteIdOrderBySEQASC(getRoute.ID, sfcdb);
if (getRouteDetail != null && getRouteDetail.Count > 0)
{
this._DETAIL = new List <RouteDetail>();
for (int i = 0; i < getRouteDetail.Count; i++)
{
RouteDetail newRouteDetail = new RouteDetail(getRouteDetail[i].ID, sfcdb, MESDataObject.DB_TYPE_ENUM.Oracle);
this._DETAIL.Add(newRouteDetail);
}
}
else
{
throw new Exception(RouteId + " 工站不存在");
}
}
else
{
throw new Exception(RouteId + " 不存在");
}
}
catch (Exception ex)
{
throw ex;
}
}
private void getByIdOrRouteName(string parametName, string parametValue, OleExec sfcdb, MESDataObject.DB_TYPE_ENUM dbtype)
{
try
{
T_C_ROUTE TC_ROUTE = new T_C_ROUTE(sfcdb, dbtype);
T_C_ROUTE_DETAIL TC_ROUTE_DETAIL = new T_C_ROUTE_DETAIL(sfcdb, dbtype);
C_ROUTE getRoute = new C_ROUTE();
List <C_ROUTE_DETAIL> getRouteDetail = new List <C_ROUTE_DETAIL>();
// List<RouteDetail> RouteDetailList = new List<RouteDetail>();
//T_C_ROUTE_DETAIL_DIRECTLINK TC_ROUTE_DETAIL_DIRECTLINK = new T_C_ROUTE_DETAIL_DIRECTLINK(sfcdb, dbtype);
//T_C_ROUTE_DETAIL_RETURN TC_ROUTE_DETAIL_RETURN = new T_C_ROUTE_DETAIL_RETURN(sfcdb, dbtype);
//List<C_ROUTE_DETAIL_RETURN> getDetailReturn = new List<C_ROUTE_DETAIL_RETURN>();
//List<C_ROUTE_DETAIL_DIRECTLINK> getDetailDirectLink = new List<C_ROUTE_DETAIL_DIRECTLINK>();
if (parametName.Trim() == "ID")
{
getRoute = TC_ROUTE.GetById(parametValue.Trim(), sfcdb);
}
else if (parametName.Trim() == "ROUTENAME")
{
getRoute = TC_ROUTE.GetByRouteName(parametValue.Trim(), sfcdb);
}
else
{
throw new Exception(MESReturnMessage.GetMESReturnMessage("MES00000007", new string[] { "getByIdOrRouteName:" + parametName }));
}
if (getRoute != null)
{
this._ID = getRoute.ID;
this._ROUTE_NAME = getRoute.ROUTE_NAME;
this._DEFAULT_SKUNO = getRoute.DEFAULT_SKUNO;
this._ROUTE_TYPE = getRoute.ROUTE_TYPE;
getRouteDetail = TC_ROUTE_DETAIL.GetByRouteIdOrderBySEQASC(getRoute.ID, sfcdb);
if (getRouteDetail != null && getRouteDetail.Count > 0)
{
this._DETAIL = new List <RouteDetail>();
for (int i = 0; i < getRouteDetail.Count; i++)
{
RouteDetail newRouteDetail = new RouteDetail(getRouteDetail[i].ID, sfcdb, dbtype);
#region 寫法一
/*
* RouteDetail newRouteDetail = new RouteDetail();
* newRouteDetail.ID = getRouteDetail[i].ID;
* newRouteDetail.SEQ_NO = getRouteDetail[i].SEQ_NO;
* newRouteDetail.ROUTE_ID = getRouteDetail[i].ROUTE_ID;
* newRouteDetail.STATION_NAME = getRouteDetail[i].STATION_NAME;
* newRouteDetail.STATION_TYPE = getRouteDetail[i].STATION_TYPE;
* newRouteDetail.RETURN_FLAG = getRouteDetail[i].RETURN_FLAG;
* if (getRouteDetail[i].RETURN_FLAG == "Y")
* {
* getDetailReturn = TC_ROUTE_DETAIL_RETURN.GetByRoute_DetailId(newRouteDetail.ID, sfcdb);
* if (getDetailReturn != null && getDetailReturn.Count > 0)
* {
* List<C_ROUTE_DETAIL> newReturnList = new List<C_ROUTE_DETAIL>();
* for (int j = 0; j < getDetailReturn.Count; j++)
* {
* newReturnList.Add(TC_ROUTE_DETAIL.GetById(getDetailReturn[j].RETURN_ROUTE_DETAIL_ID, sfcdb));
* }
* newRouteDetail.RETURNLIST = newReturnList;
* }
* }
* else
* {
* newRouteDetail.RETURNLIST = null;
* }
* getDetailDirectLink = TC_ROUTE_DETAIL_DIRECTLINK.GetByDetailId(newRouteDetail.ID, sfcdb);
* if (getDetailDirectLink != null && getDetailDirectLink.Count > 0)
* {
* List<C_ROUTE_DETAIL> newDirectLinkList = new List<C_ROUTE_DETAIL>();
* for (int n = 0; n < getDetailDirectLink.Count; n++)
* {
* newDirectLinkList.Add(TC_ROUTE_DETAIL.GetById(getDetailDirectLink[n].DIRECTLINK_ROUTE_DETAIL_ID, sfcdb));
* }
* newRouteDetail.DIRECTLINKLIST = newDirectLinkList;
* }
* else
* {
* newRouteDetail.DIRECTLINKLIST = null;
* }
* if (this.DETAIL == null)
* {
* this.DETAIL = new List<RouteDetail>();
* }*/
#endregion 寫法一 end
this._DETAIL.Add(newRouteDetail);
}
}
else
{
this._DETAIL = null;
}
}
else
{
this._ID = "";
this._ROUTE_NAME = "";
this._DEFAULT_SKUNO = "";
this._ROUTE_TYPE = "";
this._DETAIL = null;
throw new Exception(MESReturnMessage.GetMESReturnMessage("MES00000007", new string[] { "Route_" + parametName + ":" + parametValue }));
}
}
catch (Exception ex)
{
throw ex;
}
}
