private void tsbShare_Click(object sender, EventArgs e)
{
if (SelectedPoleCode != Guid.Empty)
{
if (Atend.Base.Equipment.EContainerPackage.ShareOnServer(Convert.ToInt32(Atend.Control.Enum.ProductType.Pole), SelectedPoleCode))
{
Atend.Base.Equipment.EPole Pole = Atend.Base.Equipment.EPole.SelectByXCode(SelectedPoleCode);
code = Pole.Code;
MessageBox.Show("به اشتراک گذاری با موفقیت انجام شد");
}
else
{
MessageBox.Show("خطا در به اشتراک گذاری .");
}
}
else
{
MessageBox.Show("لطفا تجهیز مورد نظر را انتخاب کنید");
}
//if (SelectedPoleCode != Guid.Empty)
//{
// if (Atend.Base.Equipment.EPole.ShareOnServer(SelectedPoleCode))
// {
// Atend.Base.Equipment.EPole p1 = Atend.Base.Equipment.EPole.SelectByXCode(SelectedPoleCode);
// code = p1.Code;
// MessageBox.Show("به اشتراک گذاری با موفقیت انجام شد");
// }
// else
// MessageBox.Show("خطا در به اشتراک گذاری . لطفاً دوباره سعی کنید");
//}
//else
// MessageBox.Show("لطفا تجهیز مورد نظر را انتخاب کنید");
}
//private void ReadEquipGroups(TreeView tvNames)
//{
// int i;
// string RootKey;
// XmlDocument _xmlDoc = new XmlDocument();
// _xmlDoc.Load("EquipmentName.xml");
// i = 1;
// foreach (XmlElement xElement in _xmlDoc.DocumentElement)
// {
// foreach (XmlNode xnode in xElement.ChildNodes)
// {
// RootKey = i.ToString();
// tvNames.Nodes.Add(RootKey, xnode.Attributes[2].Value);
// tvNames.Nodes[tvNames.Nodes.Count - 1].Tag = xnode.Attributes[1].Value;
// i++;
// }
// }
//}
//private void ReadContainGroups(TreeView tvNames)
//{
// int i;
// string RootKey;
// XmlDocument _xmlDoc = new XmlDocument();
// _xmlDoc.Load("ContainerName.xml");
// i = 1;
// foreach (XmlElement xElement in _xmlDoc.DocumentElement)
// {
// foreach (XmlNode xnode in xElement.ChildNodes)
// {
// RootKey = i.ToString();
// tvNames.Nodes.Add(RootKey, xnode.Attributes[2].Value);
// tvNames.Nodes[tvNames.Nodes.Count - 1].Tag = xnode.Attributes[1].Value;
// i++;
// }
// }
//}
public void BindDataToOwnControl(Guid XCode)
{
ClearCheckAndGrid(tvOperation, gvSelectedProduct);
ClearCheckAndGrid(tvOperation, gvSelectedProduct);
SelectedPoleCode = XCode;
Atend.Base.Equipment.EPole Pole = Atend.Base.Equipment.EPole.SelectByXCode(XCode);
//Atend.Base.Base.BProduct product = Atend.Base.Base.BProduct.Select_ById(Pole.ProductCode);
Atend.Control.Common.selectedProductCode = Pole.ProductCode;
SelectProduct();
txtName.Text = Pole.Name;
//ProductCode = product.ID;
txtHeight.Text = Convert.ToString(Math.Round(Pole.Height, 4));
txtPower.Text = Convert.ToString(Math.Round(Pole.Power, 4));
//txtWC.Text = Convert.ToString(Math.Round(Pole.Wc, 2));
txtTopCrossSectionArea.Text = Convert.ToString(Math.Round(Pole.TopCrossSectionArea, 4));
txtButtomCrossSectionArea.Text = Convert.ToString(Math.Round(Pole.ButtomCrossSectionArea, 4));
cboPoleType.SelectedIndex = Pole.Type;
cboShape.SelectedIndex = Pole.Shape;
txtComment.Text = Pole.Comment;
tsbIsDefault.Checked = Pole.IsDefault;
code = Pole.Code;
BindTreeViwAndGrid();
}
private void gvPole_Click(object sender, EventArgs e)
{
if (gvPole.Rows.Count > 0)
{
//Editor ed = Autodesk.AutoCAD.ApplicationServices.Application.DocumentManager.MdiActiveDocument.Editor;
Atend.Base.Equipment.EPole pole = Atend.Base.Equipment.EPole.SelectByCode(Convert.ToInt32(
gvPole.Rows[gvPole.CurrentRow.Index].Cells[0].Value));
//Extra
//Atend.Base.Equipment.EPoleType poleType = Atend.Base.Equipment.EPoleType.SelectByCode(pole.Type);
//Atend.Base.Acad.AcadGlobal.dPoleInfo.Factor = Convert.ToByte(txtCountPole.Text);
txtBottomCrossSectionArea.Text = pole.ButtomCrossSectionArea.ToString();
txtHeight.Text = pole.Height.ToString();
txtPower.Text = pole.Power.ToString();
txtTopCrossSectionArea.Text = pole.TopCrossSectionArea.ToString();
//Extra
//txtType.Text = poleType.Name;
//DataTable dtblock = Atend.Base.Base.BProductBlock.SelectByProductIdType(
// Convert.ToInt32(gvPole.Rows[gvPole.CurrentRow.Index].Cells[0].Value),
// (int)Atend.Control.Enum.ProductType.Pole);
//SelectProductBlock();
}
}
public Atend.Report.dsSagAndTension FillGisForm1()
{
Editor ed = Autodesk.AutoCAD.ApplicationServices.Application.DocumentManager.MdiActiveDocument.Editor;
Atend.Report.dsSagAndTension ds = new Atend.Report.dsSagAndTension();
//Atend.Report.dsSagAndTension.GISForm1DataTable _GISForm1DataTable = new Atend.Report.dsSagAndTension.GISForm1DataTable();
//System.Data.OleDb.OleDbConnection aconnection = new System.Data.OleDb.OleDbConnection(Atend.Control.ConnectionString.AccessCnString);
Atend.Control.ConnectionString _ConnectionString = new Atend.Control.ConnectionString();
_ConnectionString.OpenSingleConnectionAccess();
DataTable dtPoles = Atend.Base.Design.DNode.AccessSelectAll(_ConnectionString.SingleConnectionAccess);
foreach (DataRow dr in dtPoles.Rows)
{
Atend.Base.Equipment.EPole _EPole = Atend.Base.Equipment.EPole.AccessSelectByCode(Convert.ToInt32(dr["ProductCode"]), _ConnectionString.SingleConnectionAccess);
DataRow drGISForm1 = ds.Tables["GISForm1"].NewRow();
drGISForm1["PoleNum"] = dr["Number"].ToString();
drGISForm1["X"] = "QQQ";
drGISForm1["Y"] = "QQQ";
drGISForm1["High"] = _EPole.Height.ToString();
drGISForm1["Tension"] = "QQQ";
drGISForm1["Kind"] = "QQQ";
switch (_EPole.Type)
{
case 0:
drGISForm1["PoleType"] = "بتونی";
break;
case 1:
drGISForm1["PoleType"] = "فلزی";
break;
case 2:
drGISForm1["PoleType"] = "تلسکوپی";
break;
case 3:
drGISForm1["PoleType"] = "چوبی";
break;
}
drGISForm1["OrderType"] = "QQQ";
drGISForm1["InsulatorCount"] = "QQQ";
drGISForm1["CircuitCount"] = "QQQ";
drGISForm1["CrossSection"] = "QQQ";
drGISForm1["BranchType"] = "QQQ";
drGISForm1["ProductType"] = "QQQ";
drGISForm1["Constructor"] = "QQQ";
drGISForm1["I"] = "QQQ";
ds.Tables["GISForm1"].Rows.Add(drGISForm1);
}
_ConnectionString.CloseSingleConnectionAccess();
return(ds);
}
private void gvPole_Click(object sender, EventArgs e)
{
if (gvPole.Rows.Count > 0)
{
IsSelectPole = true;
Atend.Base.Equipment.EPole pole = Atend.Base.Equipment.EPole.SelectByXCode(new Guid(gvPole.Rows[gvPole.CurrentRow.Index].Cells[0].Value.ToString()));
txtPoleName.Text = pole.Name;
txtHeight.Text = Convert.ToString(Math.Round(pole.Height, 4));
txtPower.Text = Convert.ToString(Math.Round(pole.Power, 4));
}
else
{
IsSelectPole = false;
}
}
public void BindDataToGridCell(Guid XCode)
{
if (IsPowerWithHalter)
{
Atend.Base.Equipment.EPole Pole = Atend.Base.Equipment.EPole.SelectByXCode(XCode);
gvCommentPowerWithHalter.Rows[RowIndex].Cells[5].Value = Pole.Name;
gvCommentPowerWithHalter.Rows[RowIndex].Cells[2].Value = Pole.XCode;
}
else
{
Atend.Base.Equipment.EPole Pole = Atend.Base.Equipment.EPole.SelectByXCode(XCode);
gvCommentPower.Rows[RowIndex].Cells["CommentPole"].Value = Pole.Name;
gvCommentPower.Rows[RowIndex].Cells["Code"].Value = Pole.XCode;
}
}
public void BindDataToOwnControl(Guid XCode)
{
Editor ed = Autodesk.AutoCAD.ApplicationServices.Application.DocumentManager.MdiActiveDocument.Editor;
Atend.Base.Equipment.EPoleTip poletip = Atend.Base.Equipment.EPoleTip.SelectByXCode(XCode);
Atend.Base.Equipment.EPole pole = Atend.Base.Equipment.EPole.SelectByXCode(poletip.PoleXCode);
txtName.Text = poletip.Name;
txtComment.Text = poletip.Comment;
nudHalter.Value = poletip.HalterCount;
txtPoleName.Text = pole.Name;
txtHeight.Text = Convert.ToString(Math.Round(pole.Height, 2));
txtPower.Text = Convert.ToString(Math.Round(pole.Power, 2));
ed.WriteMessage("HalterID={0}\n", poletip.HalterXID);
cboHalterType.SelectedValue = poletip.HalterXID;
selectedPoleTip = XCode;
SelectedPoleTipCode = poletip.Code;
tsbIsDefault.Checked = poletip.IsDefault;
Byte[] byteBLOBData = new Byte[0];
byteBLOBData = (Byte[])(poletip.Image);
MemoryStream stmBLOBData = new MemoryStream(byteBLOBData);
image = poletip.Image;
pictureBox1.Image = Image.FromStream(stmBLOBData);
BindGridEquipment(gvPoleTip);
gvPole.AutoGenerateColumns = false;
gvPole.DataSource = Atend.Base.Equipment.EPole.DrawSearchLocal(-1, -1, -1);
for (int i = 0; i < gvPole.Rows.Count; i++)
{
gvPole.Rows[i].Selected = false;
}
for (int i = 0; i < gvPole.Rows.Count; i++)
{
//gvPole.Rows[i].Selected = false;
if (gvPole.Rows[i].Cells[0].Value.ToString() == poletip.PoleXCode.ToString())
{
ed.WriteMessage("Find\n");
gvPole.Rows[i].DefaultCellStyle.BackColor = Color.Yellow;
gvPole.Rows[i].Selected = true;
}
}
}
private bool CheckStatuseOfAccessChangeDefault()
{
Editor ed = Autodesk.AutoCAD.ApplicationServices.Application.DocumentManager.MdiActiveDocument.Editor;
ed.WriteMessage("AccessChangeDefault={0}\n", Atend.Control.Common.AccessChangeDefault);
if (!Atend.Control.Common.AccessChangeDefault)
{
if (SelectedPoleCode == Guid.Empty && IsDefault)
{
MessageBox.Show("کاربر گرامی شما اجازه ثبت تجهیز به صورت پیش فرض ندارید", "خطا");
return(false);
}
else
{
Atend.Base.Equipment.EPole Pole = Atend.Base.Equipment.EPole.SelectByXCode(SelectedPoleCode);
if (Pole.IsDefault || IsDefault)
{
MessageBox.Show("کاربر گرامی شما اجازه ویرایش تجهیز به صورت پیش فرض ندارید", "خطا");
return(false);
}
}
}
return(true);
}
public void BindDataToOwnControl()
{
// BindDataTofeathurePole
//ed.WriteMessage("DesignCode=" + Atend.Control.Common.SelectedDesignCode.ToString() + "\n");
Atend.Base.Design.DNode myNode = Atend.Base.Design.DNode.AccessSelectByCode(NodeCode);
//ed.WriteMessage("myNode.Code= " + myNode.Code.ToString() + "\n");
Atend.Base.Design.DPackage myPackage = Atend.Base.Design.DPackage.AccessSelectByNodeCodeType(myNode.Code, Convert.ToInt32(Atend.Control.Enum.ProductType.Pole));
//ed.WriteMessage("myPackage.ProductCode= " + myPackage.ProductCode.ToString() + "\n");
Atend.Base.Equipment.EPole myPole = Atend.Base.Equipment.EPole.AccessSelectByCode(myNode.ProductCode);
//Extra
//Atend.Base.Equipment.EPoleType myPoleType = Atend.Base.Equipment.EPoleType.SelectByCode(myPole.Type);
//ed.WriteMessage("myPole.Height.ToString()" + myPole.Height.ToString() + "\n");
gvPole.AutoGenerateColumns = false;
gvPole.DataSource = Atend.Base.Equipment.EPole.DrawSearch(-1, -1, -1);
for (int i = 0; i < gvPole.Rows.Count; i++)
{
if (Convert.ToInt32(gvPole.Rows[i].Cells[0].Value.ToString()) == myNode.ProductCode)
{
gvPole.Rows[i].DefaultCellStyle.BackColor = Color.Yellow;
}
}
//Extra
//txtType.Text = myPoleType.Name;
txtTopCrossSectionArea.Text = myPole.TopCrossSectionArea.ToString();
txtPower.Text = myPole.Power.ToString();
txtHeight.Text = myPole.Height.ToString();
txtBottomCrossSectionArea.Text = myPole.ButtomCrossSectionArea.ToString();
//ed.WriteMessage("Finish BindDataTofeathurePole\n");
//****************************
//BindDataToHalterAndPoleTypeAndConsolType
Atend.Base.Design.DPoleInfo myPoleInfo = Atend.Base.Design.DPoleInfo.AccessSelectByNodeCode(myNode.Code);
//ed.WriteMessage("myPoleInfo.HalterType:=" + myPoleInfo.HalterType.ToString() + "\n");
//ed.WriteMessage("myPoleInfo.HalterCount:=" + myPoleInfo.HalterCount.ToString());
cboHalterType.SelectedValue = myPoleInfo.HalterType;
nudHalter.Value = myPoleInfo.HalterCount;
//string poleType = myPoleInfo.PoleType.ToString();
//if (poleType.EndsWith("1"))
//{
// chkCross.Checked = true;
//}
//if (poleType.EndsWith("2"))
//{
// chkEnding.Checked = true;
//}
//if (poleType.EndsWith("4"))
//{
// chkPulling.Checked = true;
//}
//ed.WriteMessage("FinishBindDataToHalterAndPoleTypeAndConsolType\n");
//*****************************
//BindDataToConsol
DataTable dtPackage = Atend.Base.Design.DPackage.AccessSelectByParentCodeAndType(myPackage.Code, Convert.ToInt32(Atend.Control.Enum.ProductType.Consol));
foreach (DataRow drPackage in dtPackage.Rows)
{
//ed.WriteMessage("ProductCode= " + drPackage["ProductCode"].ToString() + "\n");
Atend.Base.Equipment.EConsol consol = Atend.Base.Equipment.EConsol.SelectByCodeForDesign(Convert.ToInt32(drPackage["ProductCode"]));
gvPoleConsol.Rows.Add();
//ed.WriteMessage("Code= "+consol.Code+"Name= "+consol.Name+"\n");
gvPoleConsol.Rows[gvPoleConsol.Rows.Count - 1].Cells[0].Value = consol.Code.ToString();
gvPoleConsol.Rows[gvPoleConsol.Rows.Count - 1].Cells[1].Value = consol.Name;
//ed.WriteMessage("as\n");
if (consol.ConsolType == 0)
{
gvPoleConsol.Rows[gvPoleConsol.Rows.Count - 1].Cells[2].Value = "کششی";
}
if (consol.ConsolType == 1)
{
gvPoleConsol.Rows[gvPoleConsol.Rows.Count - 1].Cells[2].Value = "انتهایی";
}
if (consol.ConsolType == 2)
{
gvPoleConsol.Rows[gvPoleConsol.Rows.Count - 1].Cells[2].Value = "عبوری";
}
if (consol.ConsolType == 3)
{
gvPoleConsol.Rows[gvPoleConsol.Rows.Count - 1].Cells[2].Value = "DP";
}
gvPoleConsol.Rows[gvPoleConsol.Rows.Count - 1].Cells[4].Value = drPackage["Code"].ToString();
}
//ed.WriteMessage("FinishBindDataToconsol\n");
//*****************************
}
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);
}
private void btnOk_Click(object sender, EventArgs e)
{
Editor ed = Autodesk.AutoCAD.ApplicationServices.Application.DocumentManager.MdiActiveDocument.Editor;
if (Validation())
{
bool useAccess = false;
int projectcode = 0;
List <Atend.Base.Equipment.EConsol> list = new List <Atend.Base.Equipment.EConsol>();
ArrayList consoluse = new ArrayList();
ArrayList consolexis = new ArrayList();
ArrayList consolcount = new ArrayList();
ArrayList ConsolProjCode = new ArrayList();
ArrayList DelConsol = new ArrayList();
Atend.Base.Equipment.EConsol eConsol = new Atend.Base.Equipment.EConsol();
int Existance = 0;
Atend.Base.Equipment.EPole ePole = new Atend.Base.Equipment.EPole();
Atend.Base.Equipment.EPoleTip ePoletip = new Atend.Base.Equipment.EPoleTip();
//ed.WriteMessage("IsSqlSelected={0}\n", gvPoleTip.SelectedRows[0].Cells[2].Value.ToString());
Atend.Base.Equipment.EHalter halt = new Atend.Base.Equipment.EHalter();
if (Convert.ToBoolean(gvPoleTip.Rows[gvPoleTip.CurrentRow.Index].Cells[2].Value) == true)
{
ePoletip = Atend.Base.Equipment.EPoleTip.SelectByXCode(new Guid(gvPoleTip.Rows[gvPoleTip.CurrentRow.Index].Cells[0].Value.ToString()));
ePole = Atend.Base.Equipment.EPole.SelectByXCode(ePoletip.PoleXCode);
useAccess = false;
if (ePoletip.HalterCount != 0)
{
halt = Atend.Base.Equipment.EHalter.SelectByXCode(ePoletip.HalterXID);
}
}
else
{
ePoletip = Atend.Base.Equipment.EPoleTip.AccessSelectByCode(Convert.ToInt32(gvPoleTip.Rows[gvPoleTip.CurrentRow.Index].Cells[1].Value.ToString()));//gvPoleTip.SelectedRows[0].Cells[1].Value
ePole = Atend.Base.Equipment.EPole.AccessSelectByCode(ePoletip.PoleCode);
useAccess = true;
if (ePoletip.HalterCount != 0)
{
halt = Atend.Base.Equipment.EHalter.AccessSelectByCode(ePoletip.HalterID);
}
}
foreach (DataRow dr in dtLastConsol.Rows)
{
DelConsol.Add(dr["Code"].ToString());
}
//if (ePole.Shape == 0)
//{
// ed.WriteMessage("**********I AM IN Shape=0\n");
// shape = 0;
// Atend.Global.Acad.DrawEquips.AcDrawCirclePole ACDCP = new Atend.Global.Acad.DrawEquips.AcDrawCirclePole();
// ACDCP.ePole = ePole;
// ACDCP.ePoleTip = ePoletip;
// ACDCP.UseAccess = useAccess;
// ACDCP.ProjectCode = Convert.ToInt32(cboProjCode.SelectedValue);
// ACDCP.Existance = Convert.ToByte(cboIsExist.SelectedValue);
// ACDCP.HalterExistance = Convert.ToByte(cboHIsExistance.SelectedValue);
// ACDCP.HalterProjectCode = Convert.ToInt32(cboHProjectCode.SelectedValue);
// ACDCP.Height = Convert.ToInt32(txtHeight.Text);
// ACDCP.eHalter = halt;
// //Atend.Base.Acad.AcadGlobal.CirclePoleData.eConsols.Clear();
// //Atend.Base.Acad.AcadGlobal.CirclePoleData.eConsolCount.Clear();
// //Atend.Base.Acad.AcadGlobal.CirclePoleData.eConsolExistance.Clear();
// ed.WriteMessage("oo\n");
// ACDCP.eConsols.Clear();
// //Atend.Base.Acad.AcadGlobal.CirclePoleData.eConsolUseAccess.Clear();
// //Atend.Base.Acad.AcadGlobal.CirclePoleData.eConsolProjectCode.Clear();
// //Atend.Base.Acad.AcadGlobal.CirclePoleData.dPoleInfo.HalterCount = ePoletip.HalterCount;
// //Atend.Base.Acad.AcadGlobal.CirclePoleData.dPoleInfo.HalterType = ePoletip.HalterID;
// //Atend.Base.Acad.AcadGlobal.CirclePoleData.dPoleInfo.Factor = ePoletip.Factor;
// //Atend.Base.Acad.AcadGlobal.CirclePoleData.Existance = Convert.ToByte(cboIsExist.SelectedValue);
// //Atend.Base.Acad.AcadGlobal.CirclePoleData.UseAccess = useAccess;
// //Atend.Base.Acad.AcadGlobal.CirclePoleData.ePole = ePole;
// //Atend.Base.Acad.AcadGlobal.CirclePoleData.ePoleTip = ePoletip;
// //Atend.Base.Acad.AcadGlobal.CirclePoleData.ProjectCode = Convert.ToInt32(cboProjCode.SelectedValue);
// foreach (DataRow dr in dtgvPoleConsol.Rows)
// {
// if (Convert.ToInt32(dr["Count"].ToString()) != 0)
// {
// //DataGridViewComboBoxCell c = (DataGridViewComboBoxCell)gvConsol.Rows[i].Cells[3];
// //Existance = Convert.ToInt32(c.Value);
// //DataGridViewComboBoxCell cPCode = (DataGridViewComboBoxCell)gvConsol.Rows[i].Cells[5];
// //projectcode = Convert.ToInt32(cPCode.Value);
// if (Convert.ToBoolean(dr["IsSql"].ToString()))
// {
// ed.WriteMessage("LocalConsolXCODE={0}\n", dr["XCode"].ToString());
// eConsol = Atend.Base.Equipment.EConsol.SelectByXCode(new Guid(
// dr["XCode"].ToString()));
// ed.WriteMessage("Consol.NAme={0}\n", eConsol.Name);
// ACDCP.eConsols.Add(eConsol);
// ed.WriteMessage("HH\n");
// ACDCP.eConsolUseAccess.Add(false);
// ed.WriteMessage("AA\n");
// ACDCP.eConsolCount.Add(Convert.ToInt32(dr["Count"].ToString()));
// ed.WriteMessage("Ab\n");
// ACDCP.eConsolExistance.Add(Convert.ToInt32(dr["IsExistance"].ToString()));
// ed.WriteMessage("Ac\n");
// ACDCP.eConsolProjectCode.Add(Convert.ToInt32(dr["ProjectCode"].ToString()));
// }
// else
// {
// ed.WriteMessage("Access Consol\n");
// eConsol = Atend.Base.Equipment.EConsol.AccessSelectByCode(Convert.ToInt32(
// dr["AccessCode"].ToString()));
// ACDCP.eConsols.Add(eConsol);
// ACDCP.eConsolUseAccess.Add(true);
// ACDCP.eConsolCount.Add(Convert.ToInt32(dr["Count"].ToString()));
// ed.WriteMessage("eConsolExistance={0}\n", Existance);
// ACDCP.eConsolExistance.Add(Convert.ToInt32(dr["IsExistance"].ToString()));
// ACDCP.eConsolProjectCode.Add(Convert.ToInt32(dr["ProjectCode"].ToString()));
// }
// }
// }
// ed.WriteMessage("Consol.Count={0}\n", Atend.Base.Acad.AcadGlobal.CirclePoleData.eConsols.Count);
// if (ACDCP.UpdatePoleDataTip(objID, DelConsol, NodeCode))
// {
// AllowClose = true;
// return;
// }
//}
//else
//{
// shape = 1;
// ed.WriteMessage("TYPE={0}\n", ePole.Type);
// if (ePole.Type == 2)
// {
// Atend.Global.Acad.DrawEquips.AcDrawPolygonPole ACDP = new Atend.Global.Acad.DrawEquips.AcDrawPolygonPole();
// ed.WriteMessage("***************Type=2\n");
// Type = 2;
// //Atend.Base.Acad.AcadGlobal.PolygonPoleData.eConsols.Clear();
// //Atend.Base.Acad.AcadGlobal.PolygonPoleData.eConsolCount.Clear();
// //Atend.Base.Acad.AcadGlobal.PolygonPoleData.eConsolExistance.Clear();
// //Atend.Base.Acad.AcadGlobal.PolygonPoleData.eConsols.Clear();
// //Atend.Base.Acad.AcadGlobal.PolygonPoleData.eConsolUseAccess.Clear();
// //Atend.Base.Acad.AcadGlobal.PolygonPoleData.eConsolProjectCode.Clear();
// //Atend.Base.Acad.AcadGlobal.PolygonPoleData.dPoleInfo.HalterCount = ePoletip.HalterCount;
// //Atend.Base.Acad.AcadGlobal.PolygonPoleData.dPoleInfo.HalterType = ePoletip.HalterID;
// //Atend.Base.Acad.AcadGlobal.PolygonPoleData.dPoleInfo.Factor = ePoletip.Factor;
// ACDP.Existance = Convert.ToByte(cboIsExist.SelectedValue);
// ACDP.UseAccess = useAccess;
// ACDP.ProjectCode = Convert.ToInt32(cboProjCode.SelectedValue);
// ACDP.ePole = ePole;
// ACDP.ePoleTip = ePoletip;
// ACDP.HalterExistance = Convert.ToByte(cboHIsExistance.SelectedValue);
// ACDP.HalterProjectCode = Convert.ToInt32(cboHProjectCode.SelectedValue);
// ACDP.Height = Convert.ToInt32(txtHeight.Text);
// ACDP.eHalter = halt;
// foreach (DataRow dr in dtgvPoleConsol.Rows)
// {
// if (Convert.ToInt32(dr["Count"].ToString()) != 0)
// {
// //DataGridViewComboBoxCell c = (DataGridViewComboBoxCell)gvConsol.Rows[i].Cells[3];
// //Existance = Convert.ToInt32(c.Value);
// //DataGridViewComboBoxCell cPCode = (DataGridViewComboBoxCell)gvConsol.Rows[i].Cells[5];
// //projectcode = Convert.ToInt32(cPCode.Value);
// ed.WriteMessage("***IsSQL={0}\n",dr["IsSql"].ToString());
// if (Convert.ToBoolean(dr["IsSql"].ToString()))
// {
// eConsol = Atend.Base.Equipment.EConsol.SelectByXCode(new Guid(
// dr["XCode"].ToString()));
// ACDP.eConsols.Add(eConsol);
// ACDP.eConsolUseAccess.Add(false);
// ACDP.eConsolCount.Add(Convert.ToInt32(dr["Count"].ToString()));
// ed.WriteMessage("eConsolExistance={0}\n", Existance);
// ACDP.eConsolExistance.Add(Convert.ToInt32(dr["IsExistance"].ToString()));
// ACDP.eConsolProjectCode.Add(Convert.ToInt32(dr["ProjectCode"].ToString()));
// }
// else
// {
// eConsol = Atend.Base.Equipment.EConsol.AccessSelectByCode(Convert.ToInt32(
// dr["AccessCode"].ToString()));
// ACDP.eConsols.Add(eConsol);
// ACDP.eConsolUseAccess.Add(true);
// ACDP.eConsolCount.Add(Convert.ToInt32(dr["Count"].ToString()));
// ed.WriteMessage("eConsolExistance={0}\n", Existance);
// ACDP.eConsolExistance.Add(Convert.ToInt32(dr["IsExistance"].ToString()));
// ACDP.eConsolProjectCode.Add(Convert.ToInt32(dr["ProjectCode"].ToString()));
// }
// }
// }
// if (ACDP.UpdatePoleDataTip(objID, DelConsol, NodeCode))
// {
// AllowClose = true;
// return;
// }
// //ed.WriteMessage("Consol.Count={0}\n", Atend.Base.Acad.AcadGlobal.PolygonPoleData.eConsols.Count);
// }
// //if (ePole.Type == 3)
// //{
//Type = 3;
Atend.Global.Acad.DrawEquips.AcDrawPole ADP = new Atend.Global.Acad.DrawEquips.AcDrawPole();
//Atend.Base.Acad.AcadGlobal.PoleData.eConsols.Clear();
//Atend.Base.Acad.AcadGlobal.PoleData.eConsolCount.Clear();
//Atend.Base.Acad.AcadGlobal.PoleData.eConsolExistance.Clear();
//Atend.Base.Acad.AcadGlobal.PoleData.eConsols.Clear();
//Atend.Base.Acad.AcadGlobal.PoleData.eConsolUseAccess.Clear();
//Atend.Base.Acad.AcadGlobal.PoleData.eConsolProjectCode.Clear();
//Atend.Base.Acad.AcadGlobal.PoleData.dPoleInfo.HalterCount = ePoletip.HalterCount;
//Atend.Base.Acad.AcadGlobal.PoleData.dPoleInfo.HalterType = ePoletip.HalterID;
//Atend.Base.Acad.AcadGlobal.PoleData.dPoleInfo.Factor = ePoletip.Factor;
Atend.Base.Base.BEquipStatus status = Atend.Base.Base.BEquipStatus.SelectByCode(Convert.ToInt32(cboIsExist.SelectedValue.ToString()));
ADP.Existance = status.ACode;
if (cboProjCode.Items.Count == 0)
{
ADP.ProjectCode = 0;
}
else
{
ADP.ProjectCode = Convert.ToInt32(cboProjCode.SelectedValue);
}
ADP.UseAccess = useAccess;
ADP.ePoleTip = ePoletip;
ADP.ePole = ePole;
Atend.Base.Base.BEquipStatus statusHalter = Atend.Base.Base.BEquipStatus.SelectByCode(Convert.ToInt32(cboHIsExistance.SelectedValue.ToString()));
ADP.HalterExist = statusHalter.ACode;
if (cboHProjectCode.Items.Count == 0)
{
ADP.HalterProjectCode = 0;
}
else
{
ADP.HalterProjectCode = Convert.ToInt32(cboHProjectCode.SelectedValue);
}
ADP.Height = Convert.ToInt32(txtHeight.Text);
ADP.eHalter = halt;
ADP.eHalterCount = Convert.ToInt32(txtHalterCount.Text);
foreach (DataRow dr in dtgvPoleConsol.Rows)
{
if (Convert.ToInt32(dr["Count"].ToString()) != 0)
{
//DataGridViewComboBoxCell c = (DataGridViewComboBoxCell)gvConsol.Rows[i].Cells[3];
//Existance = Convert.ToInt32(c.Value);
//DataGridViewComboBoxCell cPCode = (DataGridViewComboBoxCell)gvConsol.Rows[i].Cells[5];
//projectcode = Convert.ToInt32(cPCode.Value);
if (Convert.ToBoolean(dr["IsSql"].ToString()))
{
eConsol = Atend.Base.Equipment.EConsol.SelectByXCode(new Guid(
dr["XCode"].ToString()));
ADP.eConsols.Add(eConsol);
ADP.eConsolUseAccess.Add(false);
ADP.eConsolCount.Add(Convert.ToInt32(dr["Count"].ToString()));
Atend.Base.Base.BEquipStatus status2 = Atend.Base.Base.BEquipStatus.SelectByCode(Convert.ToInt32(dr["IsExistance"].ToString()));
ADP.eConsolExistance.Add(status2.ACode);
if (dr["ProjectCode"].ToString() == "")
{
ADP.eConsolProjectCode.Add(0);
}
else
{
ADP.eConsolProjectCode.Add(Convert.ToInt32(dr["ProjectCode"].ToString()));
}
}
else
{
eConsol = Atend.Base.Equipment.EConsol.AccessSelectByCode(Convert.ToInt32(
dr["AccessCode"].ToString()));
ADP.eConsols.Add(eConsol);
ADP.eConsolUseAccess.Add(true);
ADP.eConsolCount.Add(Convert.ToInt32(dr["Count"].ToString()));
Atend.Base.Base.BEquipStatus status2 = Atend.Base.Base.BEquipStatus.SelectByCode(Convert.ToInt32(dr["IsExistance"].ToString()));
ADP.eConsolExistance.Add(status2.ACode);
if (dr["ProjectCode"].ToString() == "")
{
ADP.eConsolProjectCode.Add(0);
}
else
{
ADP.eConsolProjectCode.Add(Convert.ToInt32(dr["ProjectCode"].ToString()));
}
}
}
}
if (ADP.UpdatePoleDataTip(objID, DelConsol, NodeCode))
{
AllowClose = true;
return;
}
//}
//}
//AllowClose = true;
}
else
{
AllowClose = false;
}
}
private void btnOk_Click(object sender, EventArgs e)
{
Editor ed = Autodesk.AutoCAD.ApplicationServices.Application.DocumentManager.MdiActiveDocument.Editor;
if (Validation())
{
//Atend.Base.Base.BEquipStatus statusaaaa = Atend.Base.Base.BEquipStatus.SelectByCode(Convert.ToInt32(cboIsExist.SelectedValue));
gvPoleTip.Focus();
bool useAccess = false;
int projectcode = 0;
Atend.Base.Equipment.EConsol eConsol = new Atend.Base.Equipment.EConsol();
int Existance = 0;
Atend.Base.Equipment.EPole ePole = new Atend.Base.Equipment.EPole();
Atend.Base.Equipment.EPoleTip ePoletip = new Atend.Base.Equipment.EPoleTip();
Atend.Base.Equipment.EHalter Halt = new Atend.Base.Equipment.EHalter();
if (Convert.ToBoolean(gvPoleTip.Rows[gvPoleTip.CurrentRow.Index].Cells[2].Value) == true)
{
ePoletip = Atend.Base.Equipment.EPoleTip.SelectByXCode(new Guid(gvPoleTip.Rows[gvPoleTip.CurrentRow.Index].Cells[0].Value.ToString()));
ePole = Atend.Base.Equipment.EPole.SelectByXCode(ePoletip.PoleXCode);
useAccess = false;
Halt = Atend.Base.Equipment.EHalter.SelectByXCode(ePoletip.HalterXID);
}
else
{
//ed.WriteMessage("Access\n");
ePoletip = Atend.Base.Equipment.EPoleTip.AccessSelectByCode(Convert.ToInt32(gvPoleTip.Rows[gvPoleTip.CurrentRow.Index].Cells[1].Value.ToString()));
ePole = Atend.Base.Equipment.EPole.AccessSelectByCode(ePoletip.PoleCode);
useAccess = true;
Halt = Atend.Base.Equipment.EHalter.AccessSelectByCode(ePoletip.HalterID);
}
if (ePole.Shape == 0)
{
shape = 0;
Atend.Base.Acad.AcadGlobal.CirclePoleData.eConsols.Clear();
Atend.Base.Acad.AcadGlobal.CirclePoleData.eConsolCount.Clear();
Atend.Base.Acad.AcadGlobal.CirclePoleData.eConsolExistance.Clear();
Atend.Base.Acad.AcadGlobal.CirclePoleData.eConsols.Clear();
Atend.Base.Acad.AcadGlobal.CirclePoleData.eConsolUseAccess.Clear();
Atend.Base.Acad.AcadGlobal.CirclePoleData.eConsolProjectCode.Clear();
Atend.Base.Acad.AcadGlobal.CirclePoleData.dPoleInfo.HalterCount = ePoletip.HalterCount;
//Atend.Base.Acad.AcadGlobal.CirclePoleData.dPoleInfo.HalterType = ePoletip.HalterID;
Atend.Base.Acad.AcadGlobal.CirclePoleData.dPoleInfo.Factor = ePoletip.Factor;
Atend.Base.Acad.AcadGlobal.CirclePoleData.UseAccess = useAccess;
Atend.Base.Base.BEquipStatus status = Atend.Base.Base.BEquipStatus.SelectByCode(Convert.ToInt32(cboIsExist.SelectedValue));
Atend.Base.Acad.AcadGlobal.CirclePoleData.Existance = status.ACode;
if (cboProjCode.Items.Count == 0)
{
Atend.Base.Acad.AcadGlobal.CirclePoleData.ProjectCode = 0;
}
else
{
Atend.Base.Acad.AcadGlobal.CirclePoleData.ProjectCode = Convert.ToInt32(cboProjCode.SelectedValue);
}
Atend.Base.Acad.AcadGlobal.CirclePoleData.ePole = ePole;
Atend.Base.Acad.AcadGlobal.CirclePoleData.ePoleTip = ePoletip;
Atend.Base.Acad.AcadGlobal.CirclePoleData.Height = Convert.ToDouble(txtHeight.Text);
Atend.Base.Base.BEquipStatus statusHalteer = Atend.Base.Base.BEquipStatus.SelectByCode(Convert.ToInt32(cboHIsExist.SelectedValue));
Atend.Base.Acad.AcadGlobal.CirclePoleData.HalterExistance = statusHalteer.ACode;
if (cboHProjectCode.Items.Count == 0)
{
Atend.Base.Acad.AcadGlobal.CirclePoleData.HalterProjectCode = 0;
}
else
{
Atend.Base.Acad.AcadGlobal.CirclePoleData.HalterProjectCode = Convert.ToInt32(cboHProjectCode.SelectedValue);
}
Atend.Base.Acad.AcadGlobal.CirclePoleData.eHalter = Halt;
Atend.Base.Acad.AcadGlobal.CirclePoleData.eHalterCount = ePoletip.HalterCount;
//for (int i = 0; i < gvConsol.Rows.Count; i++)
foreach (DataRow dr in dtgvPoleConsol.Rows)
{
if (Convert.ToInt32(dr["Count"].ToString()) != 0)
{
//DataGridViewComboBoxCell c = (DataGridViewComboBoxCell)gvConsol.Rows[i].Cells[3];
Atend.Base.Base.BEquipStatus statusPole = Atend.Base.Base.BEquipStatus.SelectByCode(Convert.ToInt32(dr["IsExistance"].ToString()));
Existance = statusPole.ACode;
if (dr["ProjectCode"].ToString() == "")
{
projectcode = 0;
}
else
{
projectcode = Convert.ToInt32(dr["ProjectCode"].ToString());
}
//DataGridViewComboBoxCell cPCode = (DataGridViewComboBoxCell)gvConsol.Rows[i].Cells[5];
if (!useAccess)
{
eConsol = Atend.Base.Equipment.EConsol.SelectByXCode(new Guid(dr["XCode"].ToString()));
Atend.Base.Acad.AcadGlobal.CirclePoleData.eConsols.Add(eConsol);
Atend.Base.Acad.AcadGlobal.CirclePoleData.eConsolUseAccess.Add(false);
Atend.Base.Acad.AcadGlobal.CirclePoleData.eConsolCount.Add(Convert.ToInt32(dr["Count"].ToString()));
Atend.Base.Acad.AcadGlobal.CirclePoleData.eConsolExistance.Add(Existance);
Atend.Base.Acad.AcadGlobal.CirclePoleData.eConsolProjectCode.Add(projectcode);
}
else
{
eConsol = Atend.Base.Equipment.EConsol.AccessSelectByCode(Convert.ToInt32(dr["Code"].ToString()));
Atend.Base.Acad.AcadGlobal.CirclePoleData.eConsols.Add(eConsol);
Atend.Base.Acad.AcadGlobal.CirclePoleData.eConsolUseAccess.Add(true);
Atend.Base.Acad.AcadGlobal.CirclePoleData.eConsolCount.Add(Convert.ToInt32(dr["Count"].ToString()));
Atend.Base.Acad.AcadGlobal.CirclePoleData.eConsolExistance.Add(Existance);
Atend.Base.Acad.AcadGlobal.CirclePoleData.eConsolProjectCode.Add(projectcode);
}
}
}
}
else
{
shape = 1;
//ed.WriteMessage("*******EPOLe.Type={0}\n", ePole.Type);
if (ePole.Type == 2)
{
//ed.WriteMessage("Type=2\n");
Type = 2;
Atend.Base.Acad.AcadGlobal.PolygonPoleData.eConsols.Clear();
Atend.Base.Acad.AcadGlobal.PolygonPoleData.eConsolCount.Clear();
Atend.Base.Acad.AcadGlobal.PolygonPoleData.eConsolExistance.Clear();
Atend.Base.Acad.AcadGlobal.PolygonPoleData.eConsols.Clear();
Atend.Base.Acad.AcadGlobal.PolygonPoleData.eConsolUseAccess.Clear();
Atend.Base.Acad.AcadGlobal.PolygonPoleData.eConsolProjectCode.Clear();
Atend.Base.Acad.AcadGlobal.PolygonPoleData.dPoleInfo.HalterCount = ePoletip.HalterCount;
//Atend.Base.Acad.AcadGlobal.PolygonPoleData.dPoleInfo.HalterType = ePoletip.HalterID;
Atend.Base.Acad.AcadGlobal.PolygonPoleData.dPoleInfo.Factor = ePoletip.Factor;
Atend.Base.Base.BEquipStatus status = Atend.Base.Base.BEquipStatus.SelectByCode(Convert.ToInt32(cboIsExist.SelectedValue));
Atend.Base.Acad.AcadGlobal.PolygonPoleData.Existance = status.ACode;
if (cboProjCode.Items.Count == 0)
{
Atend.Base.Acad.AcadGlobal.PolygonPoleData.ProjectCode = 0;
}
else
{
Atend.Base.Acad.AcadGlobal.PolygonPoleData.ProjectCode = Convert.ToInt32(cboProjCode.SelectedValue);
}
Atend.Base.Acad.AcadGlobal.PolygonPoleData.UseAccess = useAccess;
Atend.Base.Acad.AcadGlobal.PolygonPoleData.Height = Convert.ToDouble(txtHeight.Text);
Atend.Base.Acad.AcadGlobal.PolygonPoleData.ePole = ePole;
Atend.Base.Acad.AcadGlobal.PolygonPoleData.ePoleTip = ePoletip;
Atend.Base.Base.BEquipStatus statusHalteer = Atend.Base.Base.BEquipStatus.SelectByCode(Convert.ToInt32(cboHIsExist.SelectedValue));
Atend.Base.Acad.AcadGlobal.PolygonPoleData.HalterExistance = statusHalteer.ACode;
if (cboHProjectCode.Items.Count == 0)
{
Atend.Base.Acad.AcadGlobal.PolygonPoleData.HalterProjectCode = 0;
}
else
{
Atend.Base.Acad.AcadGlobal.PolygonPoleData.HalterProjectCode = Convert.ToInt32(cboHProjectCode.SelectedValue);
}
Atend.Base.Acad.AcadGlobal.PolygonPoleData.eHalter = Halt;
Atend.Base.Acad.AcadGlobal.PolygonPoleData.eHalterCount = ePoletip.HalterCount;
//for (int i = 0; i < gvConsol.Rows.Count; i++)
foreach (DataRow dr in dtgvPoleConsol.Rows)
{
if (Convert.ToInt32(dr["Count"].ToString()) != 0)
{
//DataGridViewComboBoxCell c = (DataGridViewComboBoxCell)gvConsol.Rows[i].Cells[3];
Atend.Base.Base.BEquipStatus statusPole = Atend.Base.Base.BEquipStatus.SelectByCode(Convert.ToInt32(dr["IsExistance"].ToString()));
Existance = statusPole.ACode;
if (dr["ProjectCode"].ToString() == "")
{
projectcode = 0;
}
else
{
projectcode = Convert.ToInt32(dr["ProjectCode"].ToString());
}
//DataGridViewComboBoxCell cPCode = (DataGridViewComboBoxCell)gvConsol.Rows[i].Cells[5];
if (!useAccess)
{
eConsol = Atend.Base.Equipment.EConsol.SelectByXCode(new Guid(
dr["XCode"].ToString()));
Atend.Base.Acad.AcadGlobal.PolygonPoleData.eConsols.Add(eConsol);
Atend.Base.Acad.AcadGlobal.PolygonPoleData.eConsolUseAccess.Add(false);
Atend.Base.Acad.AcadGlobal.PolygonPoleData.eConsolCount.Add(Convert.ToInt32(dr["Count"].ToString()));
//ed.WriteMessage("eConsolExistance={0}\n", Existance);
Atend.Base.Acad.AcadGlobal.PolygonPoleData.eConsolExistance.Add(Existance);
Atend.Base.Acad.AcadGlobal.PolygonPoleData.eConsolProjectCode.Add(projectcode);
}
else
{
eConsol = Atend.Base.Equipment.EConsol.AccessSelectByCode(Convert.ToInt32(
dr["Code"].ToString()));
Atend.Base.Acad.AcadGlobal.PolygonPoleData.eConsols.Add(eConsol);
Atend.Base.Acad.AcadGlobal.PolygonPoleData.eConsolUseAccess.Add(true);
Atend.Base.Acad.AcadGlobal.PolygonPoleData.eConsolCount.Add(Convert.ToInt32(dr["Count"].ToString()));
//ed.WriteMessage("eConsolExistance={0}\n", Existance);
Atend.Base.Acad.AcadGlobal.PolygonPoleData.eConsolExistance.Add(Existance);
Atend.Base.Acad.AcadGlobal.PolygonPoleData.eConsolProjectCode.Add(projectcode);
}
}
}
//ed.WriteMessage("Consol.Count={0}\n", Atend.Base.Acad.AcadGlobal.PolygonPoleData.eConsols.Count);
}
else //if (ePole.Type == 3)
{
Type = 3;
//ed.WriteMessage("Type=3\n");
Atend.Base.Acad.AcadGlobal.PoleData.eConsols.Clear();
Atend.Base.Acad.AcadGlobal.PoleData.eConsolCount.Clear();
Atend.Base.Acad.AcadGlobal.PoleData.eConsolExistance.Clear();
Atend.Base.Acad.AcadGlobal.PoleData.eConsols.Clear();
Atend.Base.Acad.AcadGlobal.PoleData.eConsolUseAccess.Clear();
Atend.Base.Acad.AcadGlobal.PoleData.eConsolProjectCode.Clear();
Atend.Base.Acad.AcadGlobal.PoleData.dPoleInfo.HalterCount = ePoletip.HalterCount;
//Atend.Base.Acad.AcadGlobal.PoleData.dPoleInfo.HalterType = ePoletip.HalterID;
Atend.Base.Acad.AcadGlobal.PoleData.dPoleInfo.Factor = ePoletip.Factor;
Atend.Base.Base.BEquipStatus status = Atend.Base.Base.BEquipStatus.SelectByCode(Convert.ToInt32(cboIsExist.SelectedValue));
Atend.Base.Acad.AcadGlobal.PoleData.Existance = status.ACode;
if (cboProjCode.Items.Count == 0)
{
Atend.Base.Acad.AcadGlobal.PoleData.ProjectCode = 0;
}
else
{
Atend.Base.Acad.AcadGlobal.PoleData.ProjectCode = Convert.ToInt32(cboProjCode.SelectedValue);
}
Atend.Base.Acad.AcadGlobal.PoleData.UseAccess = useAccess;
Atend.Base.Acad.AcadGlobal.PoleData.ePoleTip = ePoletip;
Atend.Base.Acad.AcadGlobal.PoleData.ePole = ePole;
Atend.Base.Acad.AcadGlobal.PoleData.Height = Convert.ToDouble(txtHeight.Text);
Atend.Base.Base.BEquipStatus statusHalteer = Atend.Base.Base.BEquipStatus.SelectByCode(Convert.ToInt32(cboHIsExist.SelectedValue));
Atend.Base.Acad.AcadGlobal.PoleData.HalterExistance = statusHalteer.ACode;
if (cboHProjectCode.Items.Count == 0)
{
Atend.Base.Acad.AcadGlobal.PoleData.HalterProjectCode = 0;
}
else
{
Atend.Base.Acad.AcadGlobal.PoleData.HalterProjectCode = Convert.ToInt32(cboHProjectCode.SelectedValue);
}
Atend.Base.Acad.AcadGlobal.PoleData.eHalter = Halt;
Atend.Base.Acad.AcadGlobal.PoleData.eHalterCount = ePoletip.HalterCount;
//for (int i = 0; i < gvConsol.Rows.Count; i++)
foreach (DataRow dr in dtgvPoleConsol.Rows)
{
if (Convert.ToInt32(dr["Count"].ToString()) != 0)
{
//DataGridViewComboBoxCell c = (DataGridViewComboBoxCell)gvConsol.Rows[i].Cells[3];
Atend.Base.Base.BEquipStatus statusPole = Atend.Base.Base.BEquipStatus.SelectByCode(Convert.ToInt32(dr["IsExistance"].ToString()));
Existance = statusPole.ACode;
if (dr["ProjectCode"].ToString() == "")
{
projectcode = 0;
}
else
{
projectcode = Convert.ToInt32(dr["ProjectCode"].ToString());
}
//DataGridViewComboBoxCell cPCode = (DataGridViewComboBoxCell)gvConsol.Rows[i].Cells[5];
if (!useAccess)
{
eConsol = Atend.Base.Equipment.EConsol.SelectByXCode(new Guid(dr["XCode"].ToString()));
Atend.Base.Acad.AcadGlobal.PoleData.eConsols.Add(eConsol);
Atend.Base.Acad.AcadGlobal.PoleData.eConsolUseAccess.Add(false);
Atend.Base.Acad.AcadGlobal.PoleData.eConsolCount.Add(Convert.ToInt32(dr["Count"].ToString()));
//ed.WriteMessage("eConsolExistance={0}\n", Existance);
Atend.Base.Acad.AcadGlobal.PoleData.eConsolExistance.Add(Existance);
Atend.Base.Acad.AcadGlobal.PoleData.eConsolProjectCode.Add(projectcode);
}
else
{
eConsol = Atend.Base.Equipment.EConsol.AccessSelectByCode(Convert.ToInt32(dr["Code"].ToString()));
Atend.Base.Acad.AcadGlobal.PoleData.eConsols.Add(eConsol);
Atend.Base.Acad.AcadGlobal.PoleData.eConsolUseAccess.Add(true);
Atend.Base.Acad.AcadGlobal.PoleData.eConsolCount.Add(Convert.ToInt32(dr["Count"].ToString()));
Atend.Base.Acad.AcadGlobal.PoleData.eConsolExistance.Add(Existance);
Atend.Base.Acad.AcadGlobal.PoleData.eConsolProjectCode.Add(projectcode);
}
}
}
//ed.WriteMessage("Consol.Count={0}\n", Atend.Base.Acad.AcadGlobal.PoleData.eConsols.Count);
}
}
Atend.Control.Common.IsExist = Convert.ToInt32(cboIsExist.SelectedValue.ToString());
if (cboProjCode.Items.Count != 0)
{
Atend.Control.Common.ProjectCode = Convert.ToInt32(cboProjCode.SelectedValue.ToString());
}
else
{
Atend.Control.Common.ProjectCode = -1;
}
AllowClose = true;
}
else
{
AllowClose = false;
}
}
private void btnChange_Click(object sender, EventArgs e)
{
Atend.Global.Calculation.Mechanical.CMechanicalChange MecChange = new Atend.Global.Calculation.Mechanical.CMechanicalChange();
if (IsPowerWithHalter)
{
for (int i = 0; i < gvCommentPowerWithHalter.Rows.Count; i++)
{
DataGridViewCheckBoxCell chk = (DataGridViewCheckBoxCell)gvCommentPowerWithHalter.Rows[i].Cells[11];
//ed.WriteMessage("");
if (chk.Value.ToString() == "True")
{
//ed.WriteMessage("CommentPole={0}\n",gvCommentPower.Rows[i].Cells[5].Value.ToString());
if (gvCommentPowerWithHalter.Rows[i].Cells[5].Value.ToString() != "")
{
ed.WriteMessage("Add dPack\n");
Atend.Base.Design.DPackage dPack = Atend.Base.Design.DPackage.AccessSelectByNodeCode(new Guid(gvCommentPowerWithHalter.Rows[i].Cells[1].Value.ToString()));
MecChange.DPackage.Add(dPack);
Atend.Base.Design.DPoleInfo dPoleInfo = Atend.Base.Design.DPoleInfo.AccessSelectByNodeCode(new Guid(gvCommentPowerWithHalter.Rows[i].Cells[1].Value.ToString()));
MecChange.PoleInfo.Add(dPoleInfo);
MecChange.Count.Add(Convert.ToInt32(gvCommentPowerWithHalter.Rows[i].Cells[7].Value.ToString()));
//ed.WriteMessage("###={0}\n", gvCommentPower.Rows[i].Cells[2].Value.ToString());
Atend.Base.Equipment.EPole Pole = Atend.Base.Equipment.EPole.SelectByXCode(new Guid(gvCommentPowerWithHalter.Rows[i].Cells[2].Value.ToString()));
MecChange.Pole.Add(Pole);
Atend.Base.Equipment.EHalter Halter = Atend.Base.Equipment.EHalter.SelectByXCode(new Guid(gvCommentPowerWithHalter.Rows[i].Cells[12].Value.ToString()));
MecChange.Halter.Add(Halter);
MecChange.HalterCount.Add(Convert.ToInt32(gvCommentPowerWithHalter.Rows[i].Cells[10].Value.ToString()));
}
}
}
if (!MecChange.ChangePoleInfoWithHalter())
{
ed.WriteMessage("Error in ChangePoleInfoWithHalter");
}
}
else
{
for (int i = 0; i < gvCommentPower.Rows.Count; i++)
{
DataGridViewCheckBoxCell chk = (DataGridViewCheckBoxCell)gvCommentPower.Rows[i].Cells[8];
//ed.WriteMessage("");
if (chk.Value.ToString() == "True")
{
if (gvCommentPower.Rows[i].Cells["CommentPole"].Value.ToString() != "")
{
ed.WriteMessage("Add dPack\n");
Atend.Base.Design.DPackage dPack = Atend.Base.Design.DPackage.AccessSelectByNodeCode(new Guid(gvCommentPower.Rows[i].Cells["DcPoleGuid"].Value.ToString()));
MecChange.DPackage.Add(dPack);
Atend.Base.Design.DPoleInfo dPoleInfo = Atend.Base.Design.DPoleInfo.AccessSelectByNodeCode(new Guid(gvCommentPower.Rows[i].Cells["DcPoleGuid"].Value.ToString()));
MecChange.PoleInfo.Add(dPoleInfo);
MecChange.Count.Add(Convert.ToInt32(gvCommentPower.Rows[i].Cells["Count"].Value.ToString()));
ed.WriteMessage("###={0}\n", gvCommentPower.Rows[i].Cells["Code"].Value.ToString());
Atend.Base.Equipment.EPole Pole = Atend.Base.Equipment.EPole.SelectByXCode(new Guid(gvCommentPower.Rows[i].Cells["Code"].Value.ToString()));
MecChange.Pole.Add(Pole);
}
}
}
if (!MecChange.ChangePoleInfo())
{
ed.WriteMessage("Error in ChangePoleInfo");
}
}
}
private string FindPoleName(Guid PoleGuid)
{
Atend.Base.Design.DPackage package = Atend.Base.Design.DPackage.AccessSelectByNodeCode(PoleGuid);
Atend.Base.Equipment.EPole Pole = Atend.Base.Equipment.EPole.AccessSelectByCode(package.ProductCode);
return(Pole.Name);
}
//***************WithHalter**************
public System.Data.DataTable CalcHalter(System.Data.DataTable dtForce, double X, double Y, double SaftyFactor, ArrayList _M, ArrayList _Count, int MaxHalterCount, out bool result, double SaftyFactorOburi)
{
System.Data.DataTable dtResult = new System.Data.DataTable();
dtResult = dtForce.Copy();
System.Data.DataColumn dcPower = new System.Data.DataColumn("Power");
System.Data.DataColumn dcCount = new System.Data.DataColumn("Count");
System.Data.DataColumn dcHalterPower = new System.Data.DataColumn("HalterPower");
System.Data.DataColumn dcHalterCount = new System.Data.DataColumn("HalterCount");
System.Data.DataColumn dcName = new System.Data.DataColumn("Name");
System.Data.DataColumn dcHalterXCode = new System.Data.DataColumn("HalterXCode");
dtResult.Columns.Add(dcPower);
dtResult.Columns.Add(dcCount);
dtResult.Columns.Add(dcHalterPower);
dtResult.Columns.Add(dcHalterCount);
dtResult.Columns.Add(dcName);
dtResult.Columns.Add(dcHalterXCode);
result = true;
bool chkEntehai = false;
bool chkKesheshi = false;
bool chkOburi = false;
bool chkDP = false;
int Polecount = 0;
double Distance = 0;
double Depth = 0;
double h1 = 0;
double h2 = 0;
double h3 = 0;
double T = 0;
double F = 0;
double M = 0;
//const double constValue = 60;
System.Data.DataTable dtHalter = Atend.Base.Equipment.EHalter.SelectAllX();
try
{
foreach (DataRow dr in dtResult.Rows)
{
chkEntehai = false;
chkKesheshi = false;
chkOburi = false;
chkDP = false;
Atend.Base.Design.DPackage dPack = Atend.Base.Design.DPackage.AccessSelectByNodeCode(new Guid(dr["DcPoleGuid"].ToString()));
Atend.Base.Equipment.EPole pole = Atend.Base.Equipment.EPole.AccessSelectByCode(dPack.ProductCode);
System.Data.DataTable dtConsol = Atend.Base.Design.DPackage.AccessSelectByParentCodeAndType(dPack.Code, Convert.ToInt32(Atend.Control.Enum.ProductType.Consol));
System.Data.DataTable dtCalamp = Atend.Base.Design.DPackage.AccessSelectByParentCodeAndType(dPack.Code, Convert.ToInt32(Atend.Control.Enum.ProductType.Kalamp));
if (dtConsol.Rows.Count > 0)
{
foreach (DataRow drConsol in dtConsol.Rows)
{
Atend.Base.Equipment.EConsol Consol = Atend.Base.Equipment.EConsol.AccessSelectByCode(Convert.ToInt32(drConsol["ProductCode"].ToString()));
if (Convert.ToByte(Consol.ConsolType) == Convert.ToByte(ConsolType.Entehai))
{
chkEntehai = true;
ed.WriteMessage("Entehai\n");
}
if (Convert.ToByte(Consol.ConsolType) == Convert.ToByte(ConsolType.Kesheshi))
{
chkKesheshi = true;
ed.WriteMessage("Kesheshi\n");
}
if (Convert.ToByte(Consol.ConsolType) == Convert.ToByte(ConsolType.Oburi))
{
chkOburi = true;
ed.WriteMessage("Oburi\n");
}
if (Convert.ToByte(Consol.ConsolType) == Convert.ToByte(ConsolType.DP))
{
chkDP = true;
ed.WriteMessage("DP\n");
}
Distance = Consol.DistanceCrossArm;
ed.WriteMessage("DistanceCrossArm={0}\n", Consol.DistanceCrossArm);
}
}
foreach (DataRow drCalamp in dtCalamp.Rows)
{
Atend.Base.Equipment.EClamp Calamp = Atend.Base.Equipment.EClamp.AccessSelectByCode(Convert.ToInt32(drCalamp["ProductCode"].ToString()));
switch (Calamp.Type)
{
case 1:
case 2:
case 3:
case 4:
case 6:
chkEntehai = true;
break;
case 5:
{
chkOburi = true;
break;
}
//default :
// {
// chkEntehai = true;
// }
}
Distance = Calamp.DistanceSupport;
}
if (chkEntehai)
{
M = Convert.ToDouble(_M[0].ToString()) * Convert.ToDouble(_Count[0].ToString());
Polecount = Convert.ToInt32(_Count[0].ToString());
M *= SaftyFactor;
}
else if (chkKesheshi)
{
M = Convert.ToDouble(_M[2].ToString()) * Convert.ToDouble(_Count[2].ToString());
Polecount = Convert.ToInt32(_Count[2].ToString());
M *= SaftyFactor;
}
else if (chkOburi)
{
ed.WriteMessage("_M[1]={0}\n", _M[1].ToString());
M = Convert.ToDouble(_M[1].ToString()) * Convert.ToDouble(_Count[1].ToString());
Polecount = Convert.ToInt32(_Count[1].ToString());
M *= SaftyFactorOburi;
}
else if (chkDP)
{
M = Convert.ToDouble(_M[3].ToString()) * Convert.ToDouble(_Count[3].ToString());
Polecount = Convert.ToInt32(_Count[3].ToString());
M *= SaftyFactorOburi;
}
//ed.WriteMessage("M={0},chk={1}\n",M,chkOburi);
//M *= SaftyFactor;
//ed.WriteMessage("M saftyFactor={0}\n",M);
ed.WriteMessage("M={0}\n", M);
F = GetForceOnPole(dr);
ed.WriteMessage("F={0}\n", F);
Depth = .1 * pole.Height + .6;
h1 = pole.Height - (Depth + Distance);
ed.WriteMessage("h1={0}\n", h1.ToString());
h2 = Y;
ed.WriteMessage("h2={0}\n", h2.ToString());
h3 = X;
ed.WriteMessage("h3={0},Power={1}\n", h3.ToString(), pole.Power);
//DataRow drHalter = dtTable.NewRow();
T = (((F * h1) / (h1)) - M) * ((h1) / (h2 * Math.Sin(Math.Atan(h3 / h2))));
bool Answer = true;
DataRow drResult = GetPowerPoleAndHalter(T, M, dr, dtHalter, 0, Polecount, MaxHalterCount, out Answer);
if (Answer)
{
ed.WriteMessage("***HalterPower={0}\n", drResult["HalterPower"].ToString());
dr["HalterPower"] = drResult["HalterPower"].ToString();
dr["HalterCount"] = drResult["HalterCount"].ToString();
dr["Power"] = Convert.ToDouble(drResult["Power"].ToString()) / SaftyFactor;
dr["Count"] = drResult["Count"].ToString();
dr["HalterXCode"] = drResult["HalterXCode"].ToString();
}
else
{
result = false;
}
//dtTable.Rows.Add(drHalter);
}
}
catch (System.Exception ex)
{
ed.WriteMessage("ERROOOOOOOOOOOOOOOOR:={0}\n", ex.Message);
}
return(dtResult);
}
private void Save()
{
Editor ed = Autodesk.AutoCAD.ApplicationServices.Application.DocumentManager.MdiActiveDocument.Editor;
btnInsert.Focus();
ed.WriteMessage("Start Save\n");
Atend.Base.Equipment.EPole Pole = new Atend.Base.Equipment.EPole();
ArrayList EOperation = new ArrayList();
//ArrayList EPackage = new ArrayList();
//ArrayList EContainer = new ArrayList();
Pole.ProductCode = Atend.Control.Common.selectedProductCode;
Pole.Height = double.Parse(txtHeight.Text);
Pole.Power = double.Parse(txtPower.Text);
//Pole.Wc = double.Parse(txtWC.Text);
ed.WriteMessage("~~~~~~~~~~~~~~~~~~~~~~PoleType={0}\n", cboPoleType.SelectedIndex.ToString());
Pole.Type = Convert.ToByte(cboPoleType.SelectedIndex);
Pole.TopCrossSectionArea = double.Parse(txtTopCrossSectionArea.Text);
Pole.ButtomCrossSectionArea = double.Parse(txtButtomCrossSectionArea.Text);
//Pole.ContainerCode = SelectedPoleCode;
Pole.Name = txtName.Text;
Pole.Comment = txtComment.Text;
Pole.Shape = Convert.ToByte(cboShape.SelectedIndex);
Pole.IsDefault = IsDefault;
Pole.Code = code;
//saveOperation
//Equipment
ArrayList EPackageProduct = new ArrayList();
for (int j = 0; j < gvSelectedEquipment.Rows.Count; j++)
{
Atend.Base.Equipment.EProductPackage _EProductPackage = new Atend.Base.Equipment.EProductPackage();
_EProductPackage.XCode = new Guid(gvSelectedEquipment.Rows[j].Cells[0].Value.ToString());
_EProductPackage.Count = Convert.ToInt32(gvSelectedEquipment.Rows[j].Cells[2].Value.ToString());
_EProductPackage.TableType = Convert.ToInt16(gvSelectedEquipment.Rows[j].Cells[3].Value.ToString());
EPackageProduct.Add(_EProductPackage);
}
Pole.EquipmentList = EPackageProduct;
//Operation
for (int i = 0; i < gvSelectedProduct.Rows.Count; i++)
{
Atend.Base.Equipment.EOperation _EOperation = new Atend.Base.Equipment.EOperation();
_EOperation.ProductID = Convert.ToInt32(gvSelectedProduct.Rows[i].Cells[0].Value);
_EOperation.Count = Convert.ToDouble(gvSelectedProduct.Rows[i].Cells[3].Value);
EOperation.Add(_EOperation);
}
Pole.OperationList = EOperation;
//if (Atend.Control.Common.selectedProductCode != -1)
//{
if (SelectedPoleCode == Guid.Empty)
{
if (Pole.InsertX())
{
Reset();
}
else
{
MessageBox.Show("امکان ثبت کردن اطلاعات نمی باشد", "خطا");
}
}
else
{
Pole.XCode = SelectedPoleCode;
//MessageBox.Show("go to update method : " + Pole.Code + "\n");
if (Pole.UpdateX())
{
ed.WriteMessage("Finish Updated\n");
Reset();
}
else
{
MessageBox.Show("امکان به روز رسانی اطلاعات نمی باشد", "خطا");
}
}
//}
//else
//{
// MessageBox.Show("لطفا ابتدا یک کالا را از پشتیبان انتخاب کنید", "خطا");
//}
}
private bool Validation()
{
//if (Atend.Control.Common.selectedProductCode == -1)
//{
// MessageBox.Show("لطفا ابتدا یک کالا را از پشتیبان انتخاب کنید", "خطا");
// return false;
//}
if (string.IsNullOrEmpty(txtName.Text))
{
MessageBox.Show("لطفا نام را مشخص نمایید", "خطا");
txtName.Focus();
return(false);
}
if (Atend.Base.Equipment.EPole.SearchByName(txtName.Text) == true && SelectedPoleCode == Guid.Empty)
{
MessageBox.Show("نام قبلا استفاده شده است", "خطا");
txtName.Focus();
return(false);
}
if (string.IsNullOrEmpty(txtHeight.Text))
{
MessageBox.Show("لطفا ارتفاع را مشخص نمایید", "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading);
txtHeight.Focus();
txtHeight.Select(0, txtHeight.Text.Length);
return(false);
}
if (!Atend.Control.NumericValidation.DoubleConverter(txtHeight.Text))
{
MessageBox.Show("لطفاً ارتفاع را با فرمت مناسب وارد نمایید", "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading);
txtHeight.Focus();
txtHeight.Select(0, txtHeight.Text.Length);
return(false);
}
if (string.IsNullOrEmpty(txtPower.Text))
{
MessageBox.Show("لطفا قدرت را مشخص نمایید", "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading);
txtPower.Focus();
txtPower.Select(0, txtPower.Text.Length);
return(false);
}
if (!Atend.Control.NumericValidation.DoubleConverter(txtPower.Text))
{
MessageBox.Show("لطفاً قدرت را با فرمت مناسب وارد نمایید", "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading);
txtPower.Focus();
txtPower.Select(0, txtPower.Text.Length);
return(false);
}
if (string.IsNullOrEmpty(txtButtomCrossSectionArea.Text))
{
MessageBox.Show("لطفا سطح مقطع بالایی را مشخص نمایید", "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading);
txtButtomCrossSectionArea.Focus();
txtButtomCrossSectionArea.Select(0, txtButtomCrossSectionArea.Text.Length);
return(false);
}
if (!Atend.Control.NumericValidation.DoubleConverter(txtTopCrossSectionArea.Text))
{
MessageBox.Show("لطفاً سطح مقطع بالایی را با فرمت مناسب وارد نمایید", "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading);
txtTopCrossSectionArea.Focus();
txtTopCrossSectionArea.Select(0, txtTopCrossSectionArea.Text.Length);
return(false);
}
if (string.IsNullOrEmpty(txtButtomCrossSectionArea.Text))
{
MessageBox.Show("لطفا سطح مقطع پایینی را مشخص نمایید", "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading);
txtButtomCrossSectionArea.Focus();
txtButtomCrossSectionArea.Select(0, txtButtomCrossSectionArea.Text.Length);
return(false);
}
if (!Atend.Control.NumericValidation.DoubleConverter(txtButtomCrossSectionArea.Text))
{
MessageBox.Show("لطفاً سطح مقطع پایینی را با فرمت مناسب وارد نمایید", "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading);
txtButtomCrossSectionArea.Focus();
txtButtomCrossSectionArea.Select(0, txtButtomCrossSectionArea.Text.Length);
return(false);
}
if (string.IsNullOrEmpty(cboShape.Text))
{
MessageBox.Show("لطفا نوع شکل را مشخص نمایید", "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading);
cboShape.Focus();
return(false);
}
Atend.Base.Equipment.EPole pole = Atend.Base.Equipment.EPole.CheckForExist(Convert.ToDouble(txtHeight.Text), Convert.ToDouble(txtPower.Text), Convert.ToDouble(txtTopCrossSectionArea.Text),
Convert.ToDouble(txtButtomCrossSectionArea.Text), Convert.ToByte(cboPoleType.SelectedIndex), Convert.ToByte(cboShape.SelectedIndex));
if (pole.Code != -1 && SelectedPoleCode == Guid.Empty)
{
if (MessageBox.Show("پایه با مشخصات داده شده موجود میباشد\n\n پایه با مشخصات فوق : " + pole.Name + "\n\n" + "آیا مایل به ادامه ثبت می باشید؟", "خطا", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
txtHeight.Focus();
return(false);
}
}
if (!Atend.Global.Utility.UBinding.CheckGridValidation(gvSelectedEquipment, 2))
{
MessageBox.Show("لطفا تعداد تجهیزات جانبی را با فرمت مناسب وارد نمایید", "خطا");
return(false);
}
if (!Atend.Global.Utility.UBinding.CheckGridValidation(gvSelectedProduct, 3))
{
MessageBox.Show("لطفا تعداد آماده سازی را با فرمت مناسب وارد نمایید", "خطا");
return(false);
}
for (int j = 0; j < gvSelectedEquipment.Rows.Count; j++)
{
Atend.Base.Equipment.EProductPackage _EProductPackage = new Atend.Base.Equipment.EProductPackage();
_EProductPackage.XCode = new Guid(gvSelectedEquipment.Rows[j].Cells[0].Value.ToString());
_EProductPackage.Count = Convert.ToInt32(gvSelectedEquipment.Rows[j].Cells[2].Value.ToString());
_EProductPackage.TableType = Convert.ToInt16(gvSelectedEquipment.Rows[j].Cells[3].Value.ToString());
if (Atend.Base.Equipment.EContainerPackage.FindLoopNode(SelectedPoleCode, Convert.ToInt32(Atend.Control.Enum.ProductType.Pole), _EProductPackage.XCode, _EProductPackage.TableType))
{
MessageBox.Show(string.Format("تجهیز '{0}' در زیر تجهیزات موجود می باشد", txtName.Text), "خطا");
gvSelectedEquipment.Focus();
return(false);
}
}
return(CheckStatuseOfAccessChangeDefault());
//return true;
}
