private void gvConsolsTip_Click(object sender, EventArgs e)
{
//tvConsolSubEquipment.Nodes.Clear();
//int Type = (int)Atend.Control.Enum.ProductType.Consol;
//int ContainerCode = Convert.ToInt32(gvConsolsTip.SelectedRows[0].Cells[0].Value);
//ed.WriteMessage("Row Code is : " + ContainerCode + "\n");
//Atend.Base.Equipment.EContainerPackage ContainerPackage = Atend.Base.Equipment.EContainerPackage.selectByContainerCodeAndType(ContainerCode, Type);
//ed.WriteMessage("Row Code in EContainerPackage is : " + ContainerPackage.Code + "\n");
//DataTable ProductPackageTable = Atend.Base.Equipment.EProductPackage.SelectByContainerPackageCode(ContainerPackage.Code);
//ed.WriteMessage(string.Format("RowCount in productPackage : {0} \n", ProductPackageTable.Rows.Count));
//foreach (DataRow row in ProductPackageTable.Rows)
//{
// #region find each row TableType
// byte TableType = Convert.ToByte(row["TableType"]);
// #endregion
// ed.WriteMessage(string.Format("TableType : {0} \n", TableType));
// #region search in XML for Table of TableType value
// string Table = DetermineTableValue(TableType);
// #endregion
// ed.WriteMessage(string.Format("Table : {0} \n", Table));
// if (Table == "Self")
// {
// switch ((Atend.Control.Enum.ProductType)TableType)
// {
// case Atend.Control.Enum.ProductType.Insulator:
// ed.WriteMessage("first productCode : " + Convert.ToInt32(row["ProductCode"]));
// Atend.Base.Equipment.EInsulator insulator = Atend.Base.Equipment.EInsulator.SelectByCode(Convert.ToInt32(row["ProductCode"]));
// tvConsolSubEquipment.Nodes.Add(insulator.Name);
// break;
// case Atend.Control.Enum.ProductType.InsulatorChain:
// break;
// case Atend.Control.Enum.ProductType.InsulatorPipe:
// break;
// }
// }
// else
// {
// ed.WriteMessage("second productCode : " + Convert.ToInt32(row["ProductCode"]).ToString());
// Atend.Base.Base.BProduct product = Atend.Base.Base.BProduct.Select_ByCode(Convert.ToInt32(row["ProductCode"]));
// tvConsolSubEquipment.Nodes.Add(product.Name);
// }
//}
/////////////////////////////////////////////////////////////////////
if (gvConsolsTip.Rows.Count > 0)
{
tvConsolSubEquipment.Nodes.Clear();
int Type = (int)Atend.Control.Enum.ProductType.Consol;
int ContainerCode = Convert.ToInt32(gvConsolsTip.SelectedRows[0].Cells[0].Value);
//ed.WriteMessage("Row Code is : " + ContainerCode + "\n");
//Atend.Base.Equipment.EContainerPackage ContainerPackage = Atend.Base.Equipment.EContainerPackage.selectByContainerCodeAndType(ContainerCode, Type);
//ed.WriteMessage("Row Code in EContainerPackage is : " + ContainerPackage.Code + "\n");
DataTable ProductPackageTable = Atend.Base.Equipment.EProductPackage.SelectByContainerCodeAndType(ContainerCode, Type);
//ed.WriteMessage(string.Format("RowCount in productPackage : {0} \n", ProductPackageTable.Rows.Count));
foreach (DataRow row in ProductPackageTable.Rows)
{
#region find each row TableType
byte TableType = Convert.ToByte(row["TableType"]);
#endregion
//ed.WriteMessage(string.Format("TableType : {0} \n", TableType));
#region search in XML for Table of TableType value
string Table = DetermineTableValue(TableType);
#endregion
//ed.WriteMessage(string.Format("Table : {0} \n", Table));
if (Table == "Self")
{
switch ((Atend.Control.Enum.ProductType)TableType)
{
case Atend.Control.Enum.ProductType.Insulator:
//ed.WriteMessage("first productCode : " + Convert.ToInt32(row["ProductCode"]));
Atend.Base.Equipment.EInsulator insulator = Atend.Base.Equipment.EInsulator.SelectByCode(Convert.ToInt32(row["ProductCode"]));
tvConsolSubEquipment.Nodes.Add(insulator.Name);
break;
case Atend.Control.Enum.ProductType.AirPost:
//ed.WriteMessage("first productCode : " + Convert.ToInt32(row["ProductCode"]));
Atend.Base.Equipment.EAirPost airPost = Atend.Base.Equipment.EAirPost.SelectByCode(Convert.ToInt32(row["ProductCode"]));
tvConsolSubEquipment.Nodes.Add(airPost.Name);
break;
//case Atend.Control.Enum.ProductType.AuoKey3p:
// //ed.WriteMessage("first productCode : " + Convert.ToInt32(row["ProductCode"]));
// Atend.Base.Equipment.EAutoKey_3p autokey3p = Atend.Base.Equipment.EAutoKey_3p.SelectByCode(Convert.ToInt32(row["ProductCode"]));
// tvConsolSubEquipment.Nodes.Add(autokey3p.Name);
// break;
case Atend.Control.Enum.ProductType.Breaker:
//ed.WriteMessage("first productCode : " + Convert.ToInt32(row["ProductCode"]));
Atend.Base.Equipment.EBreaker breaker = Atend.Base.Equipment.EBreaker.SelectByCode(Convert.ToInt32(row["ProductCode"]));
tvConsolSubEquipment.Nodes.Add(breaker.Name);
break;
//case Atend.Control.Enum.ProductType.Bus:
// ed.WriteMessage("first productCode : " + Convert.ToInt32(row["ProductCode"]));
// Atend.Base.Equipment.EBus bus = Atend.Base.Equipment.EBus.SelectByCode(Convert.ToInt32(row["ProductCode"]));
// tvConsolSubEquipment.Nodes.Add(conductor.Name);
// break;
case Atend.Control.Enum.ProductType.GroundCabel:
//ed.WriteMessage("first productCode : " + Convert.ToInt32(row["ProductCode"]));
Atend.Base.Equipment.EGroundCabel cabel = Atend.Base.Equipment.EGroundCabel.AccessSelectByCode(Convert.ToInt32(row["ProductCode"]));
tvConsolSubEquipment.Nodes.Add(cabel.Name);
break;
case Atend.Control.Enum.ProductType.CatOut:
//ed.WriteMessage("first productCode : " + Convert.ToInt32(row["ProductCode"]));
Atend.Base.Equipment.ECatOut catout = Atend.Base.Equipment.ECatOut.SelectByCode(Convert.ToInt32(row["ProductCode"]));
tvConsolSubEquipment.Nodes.Add(catout.Name);
break;
case Atend.Control.Enum.ProductType.Conductor:
//ed.WriteMessage("first productCode : " + Convert.ToInt32(row["ProductCode"]));
Atend.Base.Equipment.EConductor conductor = Atend.Base.Equipment.EConductor.SelectByCode(Convert.ToInt32(row["ProductCode"]));
tvConsolSubEquipment.Nodes.Add(conductor.Name);
break;
case Atend.Control.Enum.ProductType.Consol:
//ed.WriteMessage("first productCode : " + Convert.ToInt32(row["ProductCode"]));
Atend.Base.Equipment.EConsol consol = Atend.Base.Equipment.EConsol.SelectByCode(Convert.ToInt32(row["ProductCode"]));
tvConsolSubEquipment.Nodes.Add(consol.Name);
break;
//case Atend.Control.Enum.ProductType.Countor:
// ed.WriteMessage("first productCode : " + Convert.ToInt32(row["ProductCode"]));
// Atend.Base.Equipment.ECountor counter = Atend.Base.Equipment.ECountor.SelectByCode(Convert.ToInt32(row["ProductCode"]));
// tvConsolSubEquipment.Nodes.Add(counter.Name);
// break;
//case Atend.Control.Enum.ProductType.CT:
// ed.WriteMessage("first productCode : " + Convert.ToInt32(row["ProductCode"]));
// Atend.Base.Equipment.ECT ct = Atend.Base.Equipment.ECT.SelectByCode(Convert.ToInt32(row["ProductCode"]));
// tvConsolSubEquipment.Nodes.Add(ct.Name);
// break;
//case Atend.Control.Enum.ProductType.DB:
// ed.WriteMessage("first productCode : " + Convert.ToInt32(row["ProductCode"]));
// Atend.Base.Equipment.EDB db = Atend.Base.Equipment.EDB.SelectByCode(Convert.ToInt32(row["ProductCode"]));
// tvConsolSubEquipment.Nodes.Add(db.Name);
// break;
case Atend.Control.Enum.ProductType.Disconnector:
//ed.WriteMessage("first productCode : " + Convert.ToInt32(row["ProductCode"]));
Atend.Base.Equipment.EDisconnector disconnector = Atend.Base.Equipment.EDisconnector.SelectByCode(Convert.ToInt32(row["ProductCode"]));
tvConsolSubEquipment.Nodes.Add(disconnector.Name);
break;
case Atend.Control.Enum.ProductType.GroundPost:
//ed.WriteMessage("first productCode : " + Convert.ToInt32(row["ProductCode"]));
Atend.Base.Equipment.EGroundPost groundPost = Atend.Base.Equipment.EGroundPost.SelectByCode(Convert.ToInt32(row["ProductCode"]));
tvConsolSubEquipment.Nodes.Add(groundPost.Name);
break;
case Atend.Control.Enum.ProductType.HeaderCabel:
//ed.WriteMessage("first productCode : " + Convert.ToInt32(row["ProductCode"]));
Atend.Base.Equipment.EHeaderCabel headerCabel = Atend.Base.Equipment.EHeaderCabel.SelectByCode(Convert.ToInt32(row["ProductCode"]));
tvConsolSubEquipment.Nodes.Add(headerCabel.Name);
break;
case Atend.Control.Enum.ProductType.Jumper:
//Extra
////ed.WriteMessage("first productCode : " + Convert.ToInt32(row["ProductCode"]));
//Atend.Base.Equipment.EJumper jumper = Atend.Base.Equipment.EJumper.SelectByCode(Convert.ToInt32(row["ProductCode"]));
//tvConsolSubEquipment.Nodes.Add(jumper.Name);
//break;
case Atend.Control.Enum.ProductType.Khazan:
//ed.WriteMessage("first productCode : " + Convert.ToInt32(row["ProductCode"]));
Atend.Base.Equipment.EKhazan khzan = Atend.Base.Equipment.EKhazan.SelectByCode(Convert.ToInt32(row["ProductCode"]));
tvConsolSubEquipment.Nodes.Add(khzan.Name);
break;
case Atend.Control.Enum.ProductType.Mafsal:
//ed.WriteMessage("first productCode : " + Convert.ToInt32(row["ProductCode"]));
Atend.Base.Equipment.EMafsal mafsal = Atend.Base.Equipment.EMafsal.SelectByCode(Convert.ToInt32(row["ProductCode"]));
tvConsolSubEquipment.Nodes.Add(mafsal.Name);
break;
//case Atend.Control.Enum.ProductType.PhotoCell:
// ed.WriteMessage("first productCode : " + Convert.ToInt32(row["ProductCode"]));
// Atend.Base.Equipment.EPhotoCell phtoCell = Atend.Base.Equipment.EPhotoCell.SelectByCode(Convert.ToInt32(row["ProductCode"]));
// tvConsolSubEquipment.Nodes.Add(phtoCell.Name);
// break;
case Atend.Control.Enum.ProductType.Pole:
//ed.WriteMessage("first productCode : " + Convert.ToInt32(row["ProductCode"]));
Atend.Base.Equipment.EPole pole = Atend.Base.Equipment.EPole.SelectByCode(Convert.ToInt32(row["ProductCode"]));
tvConsolSubEquipment.Nodes.Add(pole.Name);
break;
//case Atend.Control.Enum.ProductType.PT:
// ed.WriteMessage("first productCode : " + Convert.ToInt32(row["ProductCode"]));
// Atend.Base.Equipment.EPT pt = Atend.Base.Equipment.EPT.SelectByCode(Convert.ToInt32(row["ProductCode"]));
// tvConsolSubEquipment.Nodes.Add(pt.Name);
// break;
//case Atend.Control.Enum.ProductType.ReCloser:
// ed.WriteMessage("first productCode : " + Convert.ToInt32(row["ProductCode"]));
// Atend.Base.Equipment.EReCloser recloser = Atend.Base.Equipment.EReCloser.SelectByCode(Convert.ToInt32(row["ProductCode"]));
// tvConsolSubEquipment.Nodes.Add(recloser.Name);
// break;
case Atend.Control.Enum.ProductType.Rod:
//ed.WriteMessage("first productCode : " + Convert.ToInt32(row["ProductCode"]));
Atend.Base.Equipment.ERod rod = Atend.Base.Equipment.ERod.SelectByCode(Convert.ToInt32(row["ProductCode"]));
tvConsolSubEquipment.Nodes.Add(rod.Name);
break;
//case Atend.Control.Enum.ProductType.SectionLizer:
// ed.WriteMessage("first productCode : " + Convert.ToInt32(row["ProductCode"]));
// Atend.Base.Equipment.ESectionLizer sectionLizer = Atend.Base.Equipment.ESectionLizer.SelectByCode(Convert.ToInt32(row["ProductCode"]));
// tvConsolSubEquipment.Nodes.Add(sectionLizer.Name);
// break;
case Atend.Control.Enum.ProductType.StreetBox:
//ed.WriteMessage("first productCode : " + Convert.ToInt32(row["ProductCode"]));
Atend.Base.Equipment.EStreetBox streetBox = Atend.Base.Equipment.EStreetBox.SelectByCode(Convert.ToInt32(row["ProductCode"]));
tvConsolSubEquipment.Nodes.Add(streetBox.Name);
break;
case Atend.Control.Enum.ProductType.Transformer:
//ed.WriteMessage("first productCode : " + Convert.ToInt32(row["ProductCode"]));
Atend.Base.Equipment.ETransformer transform = Atend.Base.Equipment.ETransformer.SelectByCode(Convert.ToInt32(row["ProductCode"]));
tvConsolSubEquipment.Nodes.Add(transform.Name);
break;
case Atend.Control.Enum.ProductType.InsulatorChain:
break;
case Atend.Control.Enum.ProductType.InsulatorPipe:
break;
}
}
else
{
//ed.WriteMessage("second productCode : " + Convert.ToInt32(row["ProductCode"]).ToString());
Atend.Base.Base.BProduct product = Atend.Base.Base.BProduct.Select_ByCode(Convert.ToInt32(row["ProductCode"]));
tvConsolSubEquipment.Nodes.Add(product.Name);
}
}
}
/////////////////////////////////////////////////////////////////////
}
//private string FindNameOperation(Guid Code)
//{
// string DBName = string.Empty;
// Atend.Base.Equipment.EOperation eOP = Atend.Base.Equipment.EOperation.SelectByCode(Code);
// Atend.Base.Base.BProduct BP = Atend.Base.Base.BProduct.Select_ById(eOP.ProductID);
// DBName = BP.Name;
// PID = BP.Code;
// return DBName;
//}
private string FindNameAndProductCode(int Type, int ProductCode)
{
//Atend.Base.Equipment.EPole. p = new Atend.Base.Equipment.EPole();
string DBName = string.Empty;
switch ((Atend.Control.Enum.ProductType)Type)
{
case Atend.Control.Enum.ProductType.Pole:
Atend.Base.Equipment.EPole ePole = Atend.Base.Equipment.EPole.SelectByCode(ProductCode);
DBName = ePole.Name;
PID = ePole.ProductCode;
break;
case Atend.Control.Enum.ProductType.Conductor:
Atend.Base.Equipment.EConductor eConductor = Atend.Base.Equipment.EConductor.SelectByCode(ProductCode);
DBName = eConductor.Name;
PID = eConductor.ProductCode;
break;
case Atend.Control.Enum.ProductType.AuoKey3p:
Atend.Base.Equipment.EAutoKey_3p eAuto = Atend.Base.Equipment.EAutoKey_3p.SelectByCode(ProductCode);
DBName = eAuto.Name;
PID = eAuto.ProductCode;
break;
case Atend.Control.Enum.ProductType.Breaker:
Atend.Base.Equipment.EBreaker eBreaker = Atend.Base.Equipment.EBreaker.SelectByCode(ProductCode);
DBName = eBreaker.Name;
PID = eBreaker.ProductCode;
break;
case Atend.Control.Enum.ProductType.Bus:
Atend.Base.Equipment.EBus eBus = Atend.Base.Equipment.EBus.SelectByCode(ProductCode);
DBName = eBus.Name;
PID = eBus.ProductCode;
break;
case Atend.Control.Enum.ProductType.CatOut:
Atend.Base.Equipment.ECatOut eCatOut = Atend.Base.Equipment.ECatOut.SelectByCode(ProductCode);
DBName = eCatOut.Name;
PID = eCatOut.ProductCode;
break;
case Atend.Control.Enum.ProductType.CT:
Atend.Base.Equipment.ECT eCT = Atend.Base.Equipment.ECT.SelectByCode(ProductCode);
DBName = eCT.Name;
PID = eCT.ProductCode;
break;
case Atend.Control.Enum.ProductType.DB:
Atend.Base.Equipment.EDB eDB = Atend.Base.Equipment.EDB.SelectByCode(ProductCode);
DBName = eDB.Name;
PID = eDB.ProductCode;
break;
case Atend.Control.Enum.ProductType.HeaderCabel:
Atend.Base.Equipment.EHeaderCabel eHeader = Atend.Base.Equipment.EHeaderCabel.SelectByCode(ProductCode);
DBName = eHeader.Name;
PID = eHeader.ProductCode;
break;
case Atend.Control.Enum.ProductType.Disconnector:
Atend.Base.Equipment.EDisconnector eDC = Atend.Base.Equipment.EDisconnector.SelectByCode(ProductCode);
DBName = eDC.Name;
PID = eDC.ProductCode;
break;
case Atend.Control.Enum.ProductType.Rod:
Atend.Base.Equipment.ERod eRod = Atend.Base.Equipment.ERod.SelectByCode(ProductCode);
DBName = eRod.Name;
PID = eRod.ProductCode;
break;
case Atend.Control.Enum.ProductType.Countor:
Atend.Base.Equipment.ECountor eCounter = Atend.Base.Equipment.ECountor.SelectByCode(ProductCode);
DBName = eCounter.Name;
PID = eCounter.ProductCode;
break;
//case Atend.Control.Enum.ProductType.JackPanel:
// Atend.Base.Equipment.EJAckPanel eJack = Atend.Base.Equipment.EJAckPanel.SelectByCode(ProductCode);
// break;
case Atend.Control.Enum.ProductType.PhotoCell:
Atend.Base.Equipment.EPhotoCell ePhotoCell = Atend.Base.Equipment.EPhotoCell.SelectByCode(ProductCode);
DBName = ePhotoCell.Name;
PID = ePhotoCell.ProductCode;
break;
case Atend.Control.Enum.ProductType.Phuse:
Atend.Base.Equipment.EPhuse ePhuse = Atend.Base.Equipment.EPhuse.SelectByCode(ProductCode);
DBName = ePhuse.Name;
PID = ePhuse.ProductCode;
break;
case Atend.Control.Enum.ProductType.StreetBox:
Atend.Base.Equipment.EStreetBox eStreet = Atend.Base.Equipment.EStreetBox.SelectByCode(ProductCode);
DBName = eStreet.Name;
PID = eStreet.ProductCode;
break;
case Atend.Control.Enum.ProductType.Transformer:
Atend.Base.Equipment.ETransformer eTrans = Atend.Base.Equipment.ETransformer.SelectByCode(ProductCode);
DBName = eTrans.Name;
PID = eTrans.ProductCode;
break;
case Atend.Control.Enum.ProductType.PT:
Atend.Base.Equipment.EPT ePT = Atend.Base.Equipment.EPT.SelectByCode(ProductCode);
DBName = ePT.Name;
PID = ePT.ProductCode;
break;
case Atend.Control.Enum.ProductType.Insulator:
Atend.Base.Equipment.EInsulator eInsulator = Atend.Base.Equipment.EInsulator.SelectByCode(ProductCode);
DBName = eInsulator.Name;
PID = eInsulator.ProductCode;
break;
case Atend.Control.Enum.ProductType.ReCloser:
Atend.Base.Equipment.EReCloser eRecloser = Atend.Base.Equipment.EReCloser.SelectByCode(ProductCode);
DBName = eRecloser.Name;
PID = eRecloser.ProductCode;
break;
case Atend.Control.Enum.ProductType.PhuseKey:
Atend.Base.Equipment.EPhuseKey ePhusekey = Atend.Base.Equipment.EPhuseKey.SelectByCode(ProductCode);
DBName = ePhusekey.Name;
PID = ePhusekey.ProductCode;
break;
case Atend.Control.Enum.ProductType.Consol:
Atend.Base.Equipment.EConsol eConsol = Atend.Base.Equipment.EConsol.SelectByCode(ProductCode);
DBName = eConsol.Name;
PID = eConsol.ProductCode;
break;
case Atend.Control.Enum.ProductType.PhusePole:
Atend.Base.Equipment.EPhusePole ePhusepole = Atend.Base.Equipment.EPhusePole.SelectByCode(ProductCode);
DBName = ePhusepole.Name;
PID = ePhusepole.ProductCode;
break;
case Atend.Control.Enum.ProductType.MiddleJackPanel:
Atend.Base.Equipment.EJAckPanel eJackP = Atend.Base.Equipment.EJAckPanel.SelectByCode(ProductCode);
DBName = eJackP.Name;
PID = eJackP.ProductCode;
break;
case Atend.Control.Enum.ProductType.Khazan:
Atend.Base.Equipment.EKhazan eKhazan = Atend.Base.Equipment.EKhazan.SelectByCode(ProductCode);
DBName = eKhazan.Name;
PID = eKhazan.ProductCode;
break;
case Atend.Control.Enum.ProductType.GroundPost:
Atend.Base.Equipment.EGroundPost ePost = Atend.Base.Equipment.EGroundPost.SelectByCode(ProductCode);
DBName = ePost.Name;
PID = ePost.ProductCode;
break;
case Atend.Control.Enum.ProductType.AirPost:
Atend.Base.Equipment.EAirPost eAirpost = Atend.Base.Equipment.EAirPost.SelectByCode(ProductCode);
DBName = eAirpost.Name;
PID = eAirpost.ProductCode;
break;
case Atend.Control.Enum.ProductType.WeekJackPanel:
Atend.Base.Equipment.EJackPanelWeek eJPW = Atend.Base.Equipment.EJackPanelWeek.SelectByCode(ProductCode);
DBName = eJPW.Name;
PID = eJPW.ProductCode;
break;
}
return(DBName);
}
