private void btnOk_Click(object sender, EventArgs e)
{
Atend.Global.Acad.DrawEquips.AcDrawDisConnector DrawDisConnector = new Atend.Global.Acad.DrawEquips.AcDrawDisConnector();
Atend.Base.Design.DKeyStatus keystatus = Atend.Base.Design.DKeyStatus.SelectByNodeCode(NodeCode);
if (Validation())
{
if (Convert.ToBoolean(gvDisconnector.Rows[gvDisconnector.CurrentRow.Index].Cells[2].Value) == false)
{
DrawDisConnector.UseAccess = true;
DrawDisConnector.eDisConnector = Atend.Base.Equipment.EDisconnector.AccessSelectByCode(Convert.ToInt32(gvDisconnector.Rows[gvDisconnector.CurrentRow.Index].Cells[1].Value.ToString()));
}
else if (Convert.ToBoolean(gvDisconnector.Rows[gvDisconnector.CurrentRow.Index].Cells[2].Value))
{
DrawDisConnector.UseAccess = false;
DrawDisConnector.eDisConnector = Atend.Base.Equipment.EDisconnector.SelectByXCode(new Guid(gvDisconnector.Rows[gvDisconnector.CurrentRow.Index].Cells[0].Value.ToString()));
}
Atend.Base.Base.BEquipStatus status = Atend.Base.Base.BEquipStatus.SelectByCode(Convert.ToInt32(cboIsExist.SelectedValue));
DrawDisConnector.Existance = status.ACode;
if (rdbClose.Checked)
{
keystatus.IsClosed = true;
}
else
{
keystatus.IsClosed = false;
}
DrawDisConnector.DKeyStatus = keystatus;
if (cboProjCode.Items.Count == 0)
{
DrawDisConnector.ProjectCode = 0;
}
else
{
DrawDisConnector.ProjectCode = Convert.ToInt32(cboProjCode.SelectedValue);
}
DrawDisConnector.SelectedObjectId = ObjID;
Atend.Base.Design.DPackage dpack = Atend.Base.Design.DPackage.AccessSelectByCode(NodeCode);
//DrawDisConnector.EXCode = dpack.Code;
if (DrawDisConnector.UpdateDisConnectorData(dpack.Code))
{
ed.WriteMessage("Update DisConnector Success \n");
AllowToclose = true;
this.Close();
}
else
{
AllowToclose = false;
}
}
else
{
AllowToclose = false;
}
}
private void frmEditDrawDB02_Load(object sender, EventArgs e)
{
if (ForceToClose)
{
this.Close();
}
dtMerge = Atend.Base.Equipment.EDB.SelectAllAndMerge();
Atend.Base.Design.DPackage dpack = Atend.Base.Design.DPackage.AccessSelectByCode(NodeCode);
selectedProductCode = dpack.ProductCode;
gvStreetBox.AutoGenerateColumns = false;
gvStreetBox.DataSource = dtMerge;
Atend.Global.Utility.UBinding.SetGridToCurrentSelectedEquip("Code,XCode", new object[2] {
dpack.ProductCode, "00000000-0000-0000-0000-000000000000"
}, dtMerge, gvStreetBox, this);
ChangeColor();
for (int i = 0; i < gvStreetBox.Rows.Count; i++)
{
if (Convert.ToInt32(gvStreetBox.Rows[i].Cells[0].Value.ToString()) == dpack.ProductCode && Convert.ToBoolean(gvStreetBox.Rows[i].Cells[5].Value.ToString()) == false)
{
gvStreetBox.Rows[i].DefaultCellStyle.BackColor = Color.Yellow;
}
}
BindDataToComboBoxIsExist();
//BindDataTocboProjCode();
cboIsExist.SelectedValue = Atend.Base.Base.BEquipStatus.SelectByACode(dpack.IsExistance).Code;
cboProjCode.SelectedValue = dpack.ProjectCode;
}
private void btnOk_Click(object sender, EventArgs e)
{
Editor ed = Autodesk.AutoCAD.ApplicationServices.Application.DocumentManager.MdiActiveDocument.Editor;
Atend.Global.Acad.DrawEquips.AcDrawCatOut DrawCatOut = new Atend.Global.Acad.DrawEquips.AcDrawCatOut();
if (Validation())
{
if (Convert.ToBoolean(gvCatOut.Rows[gvCatOut.CurrentRow.Index].Cells[2].Value) == false)
{
DrawCatOut.UseAccess = true;
DrawCatOut.ECatOut = Atend.Base.Equipment.ECatOut.AccessSelectByCode(Convert.ToInt32(gvCatOut.Rows[gvCatOut.CurrentRow.Index].Cells[1].Value.ToString()));
}
else if (Convert.ToBoolean(gvCatOut.Rows[gvCatOut.CurrentRow.Index].Cells[2].Value))
{
DrawCatOut.UseAccess = false;
DrawCatOut.ECatOut = Atend.Base.Equipment.ECatOut.SelectByXCode(new Guid(gvCatOut.Rows[gvCatOut.CurrentRow.Index].Cells[0].Value.ToString()));
}
DrawCatOut.Existance = Convert.ToByte(cboIsExist.SelectedValue);
DrawCatOut.ProjectCode = Convert.ToInt32(cboProjCode.SelectedValue);
DrawCatOut.SelectedObjectId = ObjID;
Atend.Base.Design.DPackage dpack = Atend.Base.Design.DPackage.AccessSelectByCode(NodeCode);
if (DrawCatOut.UpdateCatOutData(dpack.Code))
{
ed.WriteMessage("Update CatOut Success \n");
AllowClose = true;
this.Close();
}
}
}
public bool UpdateRodData(Guid EXCode)
{
Editor ed = Application.DocumentManager.MdiActiveDocument.Editor;
OleDbTransaction aTransaction;
OleDbConnection aConnection = new OleDbConnection(Atend.Control.ConnectionString.AccessCnString);
try
{
aConnection.Open();
aTransaction = aConnection.BeginTransaction();
try
{
RodPack = Atend.Base.Design.DPackage.AccessSelectByCode(EXCode);
//ed.WriteMessage("**RodPAck.Code={0}\n",RodPack.Code);
if (!UseAccess)
{
if (!ERod.AccessInsert(aTransaction, aConnection, true, true))
{
throw new System.Exception("eRod.AccessInsert failed");
}
}
RodPack.IsExistance = Existance;
RodPack.ProductCode = ERod.Code;
RodPack.ProjectCode = ProjectCode;
RodPack.Number = "";
if (RodPack.AccessUpdate(aTransaction, aConnection))
{
//ed.WriteMessage("ERod.Code={0},SelectedRod.ObjId={1}\n",ERod.Code,selectedObjectId);
Atend.Base.Acad.AT_INFO atinfo = Atend.Base.Acad.AT_INFO.SelectBySelectedObjectId(selectedObjectId);// id);
atinfo.ProductCode = ERod.Code;
atinfo.Insert();
ChangeComment(selectedObjectId, ERod.Comment);
}
else
{
throw new System.Exception("RodPack.AccessInsert2 failed");
}
}
catch (System.Exception ex1)
{
ed.WriteMessage("ERROR Updaterod 01(transaction) : {0} \n", ex1.Message);
aTransaction.Rollback();
aConnection.Close();
return(false);
}
}
catch (System.Exception ex)
{
ed.WriteMessage("ERROR UpdateRod 01 : {0} \n", ex.Message);
aConnection.Close();
return(false);
}
aTransaction.Commit();
aConnection.Close();
return(true);
}
private void btnOk_Click(object sender, EventArgs e)
{
Editor ed = Autodesk.AutoCAD.ApplicationServices.Application.DocumentManager.MdiActiveDocument.Editor;
if (Validation())
{
List <Atend.Base.Equipment.EDBPhuse> list = new List <Atend.Base.Equipment.EDBPhuse>();
System.Data.DataTable dt;
Atend.Global.Acad.DrawEquips.AcDrawDB DrawDB = new Atend.Global.Acad.DrawEquips.AcDrawDB();
if (Convert.ToBoolean(gvStreetBox.Rows[gvStreetBox.CurrentRow.Index].Cells[5].Value) == false)
{
DrawDB.UseAccess = true;
DrawDB.EDB = Atend.Base.Equipment.EDB.AccessSelectByCode(Convert.ToInt32(gvStreetBox.Rows[gvStreetBox.CurrentRow.Index].Cells[0].Value.ToString()));
dt = Atend.Base.Equipment.EDBPhuse.AccessSelectByDBCode(Convert.ToInt32(gvStreetBox.Rows[gvStreetBox.CurrentRow.Index].Cells[0].Value.ToString()));
foreach (DataRow dr in dt.Rows)
{
list.Add(Atend.Base.Equipment.EDBPhuse.AccessSelectByCode(Convert.ToInt32(dr["Code"].ToString())));
}
}
else if (Convert.ToBoolean(gvStreetBox.Rows[gvStreetBox.CurrentRow.Index].Cells[5].Value))
{
DrawDB.UseAccess = false;
DrawDB.EDB = Atend.Base.Equipment.EDB.SelectByXCode(new Guid(gvStreetBox.Rows[gvStreetBox.CurrentRow.Index].Cells[1].Value.ToString()));
dt = Atend.Base.Equipment.EDBPhuse.SelectByDBXCode(new Guid(gvStreetBox.Rows[gvStreetBox.CurrentRow.Index].Cells[1].Value.ToString()));
foreach (DataRow dr in dt.Rows)
{
list.Add(Atend.Base.Equipment.EDBPhuse.SelectByXCode(new Guid(dr["XCode"].ToString())));
}
}
DrawDB.eDBPhuse = list;
Atend.Base.Base.BEquipStatus status = Atend.Base.Base.BEquipStatus.SelectByCode(Convert.ToInt32(cboIsExist.SelectedValue));
DrawDB.Existance = status.ACode;
if (cboProjCode.Items.Count == 0)
{
DrawDB.ProjectCode = 0;
}
else
{
DrawDB.ProjectCode = Convert.ToInt32(cboProjCode.SelectedValue);
}
DrawDB.SelectedObjectId = ObjID;
Atend.Base.Design.DPackage dpack = Atend.Base.Design.DPackage.AccessSelectByCode(NodeCode);
if (DrawDB.UpdateDBData(dpack.Code))
{
ed.WriteMessage("Update DB Success \n");
AllowClose = true;
this.Close();
}
}
else
{
AllowClose = false;
}
}
private void btnOk_Click(object sender, EventArgs e)
{
if (gvBankKhazan.Rows.Count > 0)
{
Editor ed = Autodesk.AutoCAD.ApplicationServices.Application.DocumentManager.MdiActiveDocument.Editor;
//ed.WriteMessage(gvBankKhazan.SelectedRows[0].Cells["Column7"].Value.ToString() + "\n");
//ed.WriteMessage(gvBankKhazan.SelectedRows[0].Index.ToString() + "\n");
Atend.Base.Design.DPackage Pakage = Atend.Base.Design.DPackage.AccessSelectByCode(DpakageCode);// SelectByCode(DpakageCode);
//Pakage. ProductCode = new Guid(gvBankKhazan.SelectedRows[0].Cells["Column7"].Value.ToString());
//if (Pakage.Update())
{
ed.WriteMessage("update is comment");
//Atend.Base.Acad.AT_INFO
Code = Convert.ToInt32(gvBankKhazan.SelectedRows[0].Cells["Column7"].Value.ToString());
AllowClose = true;
this.Close();
}
//else
//MessageBox.Show("انجام ويرايش امكانپذير نيست");
}
//if (Validation())
//{
// //DataTable KhazanTipTable = Atend.Base.Equipment.EKhazanTip.SelectByCode(
// // Convert.ToInt32(gvBankKhazan.CurrentRow.Index));
// Atend.Base.Acad.AcadGlobal.dPackageForKhazanTip.Count = 1;
// Atend.Base.Acad.AcadGlobal.dPackageForKhazanTip.Type = (int)Atend.Control.Enum.ProductType.BankKhazan;
// Atend.Base.Acad.AcadGlobal.dPackageForKhazanTip.ProductCode = Convert.ToInt32(
// gvBankKhazan.Rows[gvBankKhazan.CurrentRow.Index].Cells["Column7"].Value);
// Atend.Base.Design.DPackage dPackge;
// DataTable dt = (DataTable)gvKhazan.DataSource;
// foreach (DataRow dr in dt.Rows)
// {
// dPackge = new Atend.Base.Design.DPackage();
// dPackge.Count = Convert.ToInt32(dr["Count"]);
// dPackge.Type=Convert.ToInt32(dr["Type"]);
// dPackge.ProductCode = Convert.ToInt32(Atend.Control.Enum.ProductType.Khazan);
// Atend.Base.Acad.AcadGlobal.dPackageForKhazan.Add(dPackge);
// }
// AllowClose = true;
//}
//else
//{
// AllowClose = false;
//}
}
public bool UpdateLightData(Guid EXCode)
{
Editor ed = Application.DocumentManager.MdiActiveDocument.Editor;
OleDbTransaction aTransaction;
OleDbConnection aConnection = new OleDbConnection(Atend.Control.ConnectionString.AccessCnString);
try
{
aConnection.Open();
aTransaction = aConnection.BeginTransaction();
try
{
LightPack = Atend.Base.Design.DPackage.AccessSelectByCode(EXCode);
if (!UseAccess)
{
if (!eLight.AccessInsert(aTransaction, aConnection, true, true))
{
throw new System.Exception("eLight.AccessInsert failed");
}
}
LightPack.IsExistance = Existance;
LightPack.ProjectCode = ProjectCode;
LightPack.ProductCode = eLight.Code;
LightPack.Number = "";
if (LightPack.AccessUpdate(aTransaction, aConnection))
{
Atend.Base.Acad.AT_INFO atinfo = Atend.Base.Acad.AT_INFO.SelectBySelectedObjectId(selectedObjectId);
atinfo.ProductCode = eLight.Code;
atinfo.Insert();
ChangeComment(Atend.Global.Acad.UAcad.GetEntityGroup(selectedObjectId), eLight.Comment);
}
else
{
throw new System.Exception("LightPack.AccessInsert2 failed");
}
}
catch (System.Exception ex1)
{
ed.WriteMessage("ERROR UpdateLight 01(transaction) : {0} \n", ex1.Message);
aTransaction.Rollback();
aConnection.Close();
return(false);
}
}
catch (System.Exception ex)
{
ed.WriteMessage("ERROR UpdateLight 01 : {0} \n", ex.Message);
aConnection.Close();
return(false);
}
aTransaction.Commit();
aConnection.Close();
return(true);
}
private void frmDrawKhazan_Load(object sender, EventArgs e)
{
if (ForceToClose)
{
this.Close();
}
dtMerge = Atend.Base.Equipment.EKhazanTip.SelectAllAndMerge();
Atend.Base.Design.DPackage dpack = Atend.Base.Design.DPackage.AccessSelectByCode(NodeCode);
selectedProductCode = dpack.ProductCode;
gvBankKhazan.AutoGenerateColumns = false;
gvBankKhazan.DataSource = dtMerge;
Atend.Global.Utility.UBinding.SetGridToCurrentSelectedEquip("Code,XCode", new object[2] {
selectedProductCode, "00000000-0000-0000-0000-000000000000"
}, dtMerge, gvBankKhazan, this);
ChangeColor();
for (int i = 0; i < gvBankKhazan.Rows.Count; i++)
{
if (Convert.ToInt32(gvBankKhazan.Rows[i].Cells[4].Value.ToString()) == dpack.ProductCode && Convert.ToBoolean(gvBankKhazan.Rows[i].Cells[3].Value.ToString()) == false)
{
gvBankKhazan.Rows[i].DefaultCellStyle.BackColor = Color.Yellow;
}
}
BindDataToComboBoxIsExist();
//BindDataTocboProjCode();
cboIsExist.SelectedValue = Atend.Base.Base.BEquipStatus.SelectByACode(dpack.IsExistance).Code;
cboProjCode.SelectedValue = dpack.ProjectCode;
//Atend.Base.Acad.AcadGlobal.dPackageForKhazanTip = new Atend.Base.Design.DPackage();
//Atend.Base.Acad.AcadGlobal.dPackageForKhazan.Clear();
//gvBankKhazan.AutoGenerateColumns = false;
//gvKhazan.AutoGenerateColumns = false;
//gvBankKhazan.DataSource = Atend.Base.Equipment.EKhazanTip.DrawSearch(txName.Text);
//gvKhazan.DataSource = null;
//for (int i = 0; i < gvBankKhazan.Rows.Count; i++)
//{
// if (new Guid(gvBankKhazan.Rows[i].Cells["Column2"].Value.ToString()) == Code)
// {
// gvBankKhazan.Rows[i].DefaultCellStyle.BackColor = Color.Yellow;
// }
//}
//ContainerPackageCode
//gvKhazan.DataSource = Atend.Base.Equipment.EKhazan.DrawSearch(
// Convert.ToInt32(gvBankKhazan.Rows[gvBankKhazan.CurrentRow.Index].Cells[0].Value));
//gvKhazan.DataSource = Atend.Base.Equipment.EKhazan.DrawSearch(
// new Guid(gvBankKhazan.Rows[gvBankKhazan.CurrentRow.Index].Cells[0].Value.ToString()));
}
private void frmEditConsol_Load(object sender, EventArgs e)
{
if (ForceToClose)
{
this.Close();
}
//BindDataToForm();
BindDataToComboBoxIsExist();
if (cboType.Items.Count > 0)
{
cboType.SelectedIndex = 0;
}
Dpack = Atend.Base.Design.DPackage.AccessSelectByCode(NodeCode);
//ed.WriteMessage("((={0}\n", Dpack.Code.ToString());
SelectedProductCode = Dpack.ProductCode;
Atend.Base.Equipment.EConsol Consol = Atend.Base.Equipment.EConsol.AccessSelectByCode(Dpack.ProductCode);
Volt = Consol.VoltageLevel;
txtCount.Text = Dpack.Count.ToString();
CboIsExist.SelectedValue = Atend.Base.Base.BEquipStatus.SelectByACode(Dpack.IsExistance).Code;
CboProjCode.SelectedValue = Dpack.ProjectCode;
//ed.WriteMessage("**Volt={0}\n", Volt);
dtMergeConsol = Atend.Base.Equipment.EConsol.SelectAllAndMerge();
dtMergeConsol.DefaultView.RowFilter = " VoltageLevel = '" + Volt + "'";
//DataView dv = new DataView();
//dv.Table = dtMergeConsol;
//dv.RowFilter = " VoltageLevel = '" + Volt + "'";
gvConsol.AutoGenerateColumns = false;
gvConsol.DataSource = dtMergeConsol;
ChangeColor();
for (int i = 0; i < gvConsol.Rows.Count; i++)
{
if (Convert.ToInt32(gvConsol.Rows[i].Cells[1].Value.ToString()) == Dpack.ProductCode)
{
gvConsol.Rows[i].DefaultCellStyle.BackColor = Color.Yellow;
}
}
Atend.Global.Utility.UBinding.SetGridToCurrentSelectedEquip("Code,Xcode", new object[2] {
SelectedProductCode, "00000000-0000-0000-0000-000000000000"
}, dtMergeConsol, gvConsol, this);
}
private void btnOk_Click(object sender, EventArgs e)
{
Editor ed = Autodesk.AutoCAD.ApplicationServices.Application.DocumentManager.MdiActiveDocument.Editor;
Atend.Global.Acad.DrawEquips.AcDrawBreaker DrawBreaker = new Atend.Global.Acad.DrawEquips.AcDrawBreaker();
Atend.Base.Design.DKeyStatus keystatus = Atend.Base.Design.DKeyStatus.SelectByNodeCode(NodeCode);
if (Validation())
{
if (Convert.ToBoolean(gvBreaker.Rows[gvBreaker.CurrentRow.Index].Cells[2].Value) == false)
{
DrawBreaker.UseAccess = true;
DrawBreaker.eBreaker = Atend.Base.Equipment.EBreaker.AccessSelectByCode(Convert.ToInt32(gvBreaker.Rows[gvBreaker.CurrentRow.Index].Cells[1].Value.ToString()));
}
else if (Convert.ToBoolean(gvBreaker.Rows[gvBreaker.CurrentRow.Index].Cells[2].Value))
{
DrawBreaker.UseAccess = false;
DrawBreaker.eBreaker = Atend.Base.Equipment.EBreaker.SelectByXCode(new Guid(gvBreaker.Rows[gvBreaker.CurrentRow.Index].Cells[0].Value.ToString()));
}
Atend.Base.Base.BEquipStatus status = Atend.Base.Base.BEquipStatus.SelectByCode(Convert.ToInt32(cboIsExist.SelectedValue));
DrawBreaker.Existance = status.ACode;
if (rdbClose.Checked)
{
keystatus.IsClosed = true;
}
else
{
keystatus.IsClosed = false;
}
DrawBreaker.DKeyStatus = keystatus;
if (cboProjCode.Items.Count == 0)
{
DrawBreaker.ProjectCode = 0;
}
else
{
DrawBreaker.ProjectCode = Convert.ToInt32(cboProjCode.SelectedValue);
}
DrawBreaker.SelectedObjectId = ObjID;
Atend.Base.Design.DPackage dpack = Atend.Base.Design.DPackage.AccessSelectByCode(NodeCode);
if (DrawBreaker.UpdatebreakerData(dpack.Code))
{
ed.WriteMessage("Update Breaker Success \n");
AllowClose = true;
this.Close();
}
}
}
public bool UpdateKalampData(Guid NodeCode)
{
Editor ed = Application.DocumentManager.MdiActiveDocument.Editor;
OleDbConnection aConnection = new OleDbConnection(Atend.Control.ConnectionString.AccessCnString);
OleDbTransaction aTransaction;
try
{
aConnection.Open();
aTransaction = aConnection.BeginTransaction();
try
{
ClampPack = Atend.Base.Design.DPackage.AccessSelectByCode(NodeCode);
if (!UseAccess)
{
if (!eClamp.AccessInsert(aTransaction, aConnection, true, true))//aTransaction, aConnection))??
{
throw new System.Exception("eClamp.AccessInsert failed");
}
}
ClampPack.IsExistance = Existance;
ClampPack.ProductCode = eClamp.Code;
ClampPack.ProjectCode = ProjectCode;
if (ClampPack.AccessUpdate())
{
Atend.Base.Acad.AT_INFO atinfo = Atend.Base.Acad.AT_INFO.SelectBySelectedObjectId(selectedObjectId);
atinfo.ProductCode = eClamp.Code;
atinfo.Insert();
}
else
{
throw new System.Exception("ClampPack.AccessInsert2 failed");
}
}
catch (System.Exception ex1)
{
ed.WriteMessage("ERROR UpdateKalampData 01 : {0} \n", ex1.Message);
aTransaction.Rollback();
aConnection.Close();
return(false);
}
}
catch (System.Exception ex)
{
ed.WriteMessage("ERROR UpdateKalampData 01 : {0} \n", ex.Message);
aConnection.Close();
return(false);
}
aTransaction.Commit();
aConnection.Close();
return(true);
}
private void btnSelect_Click(object sender, EventArgs e)
{
this.Hide();
Editor ed = Autodesk.AutoCAD.ApplicationServices.Application.DocumentManager.MdiActiveDocument.Editor;
PromptEntityOptions peo = new PromptEntityOptions("\nSelect Entity:");
PromptEntityResult per = ed.GetEntity(peo);
Atend.Base.Acad.AT_INFO atInfo = Atend.Base.Acad.AT_INFO.SelectBySelectedObjectId(per.ObjectId);
//ed.WriteMessage("NodeType={0}\n",atInfo.NodeType);
if ((atInfo.NodeType == Convert.ToInt32(Atend.Control.Enum.ProductType.Consol)) || (atInfo.NodeType == Convert.ToInt32(Atend.Control.Enum.ProductType.Kalamp)) || (atInfo.NodeType == Convert.ToInt32(Atend.Control.Enum.ProductType.HeaderCabel)))
{
CanDoCalculate = true;
consolobj = Convert.ToInt32(per.ObjectId.ToString().Substring(1, per.ObjectId.ToString().Length - 2));
Atend.Base.Design.DPackage dPack = Atend.Base.Design.DPackage.AccessSelectByCode(new Guid(atInfo.NodeCode));
if (dPack.Type == Convert.ToInt32(Atend.Control.Enum.ProductType.Kalamp))
{
Atend.Base.Equipment.EClamp eClamp = Atend.Base.Equipment.EClamp.AccessSelectByCode(dPack.ProductCode);
txtNamedVoltage.Text = eClamp.VoltageLevel.ToString();
txtVoltTev.Text = eClamp.VoltageLevel.ToString();
}
else if (dPack.Type == Convert.ToInt32(Atend.Control.Enum.ProductType.Consol))
{
Atend.Base.Equipment.EConsol eConsol = Atend.Base.Equipment.EConsol.AccessSelectByCode(dPack.ProductCode);
txtNamedVoltage.Text = eConsol.VoltageLevel.ToString();
txtVoltTev.Text = eConsol.VoltageLevel.ToString();
}
else if (dPack.Type == Convert.ToInt32(Atend.Control.Enum.ProductType.HeaderCabel))
{
Atend.Base.Equipment.EHeaderCabel eHeaderCabel = Atend.Base.Equipment.EHeaderCabel.AccessSelectByCode(dPack.ProductCode);
txtNamedVoltage.Text = eHeaderCabel.Voltage.ToString();
txtVoltTev.Text = eHeaderCabel.Voltage.ToString();
}
txtR.Text = "0";
txtX.Text = "0";
}
else
{
MessageBox.Show("لطفت جهت شروع محاسبات یک گره را انتخاب کنید");
CanDoCalculate = false;
}
//ed.WriteMessage("ca={0}\n",CanDoCalculate);
this.Show();
}
private void frmEditDrawBreaker02_Load(object sender, EventArgs e)
{
if (ForceToClose)
{
this.Close();
}
dtMerge = Atend.Base.Equipment.EBreaker.SelectAllAndMerge();
Atend.Base.Design.DPackage dpack = Atend.Base.Design.DPackage.AccessSelectByCode(NodeCode);
selecetedProductCode = dpack.ProductCode;
Atend.Base.Design.DKeyStatus keystatus = Atend.Base.Design.DKeyStatus.SelectByNodeCode(NodeCode);
ed.WriteMessage("keyStataus.IsClosed={0}\n", keystatus.IsClosed);
if (keystatus.IsClosed)
{
rdbClose.Checked = true;
}
else
{
rdbOpen.Checked = true;
}
gvBreaker.AutoGenerateColumns = false;
gvBreaker.DataSource = dtMerge;
Atend.Global.Utility.UBinding.SetGridToCurrentSelectedEquip("Code,XCode", new object[2] {
dpack.ProductCode, "00000000-0000-0000-0000-000000000000"
}, dtMerge, gvBreaker, this);
ChangeColor();
for (int i = 0; i < gvBreaker.Rows.Count; i++)
{
if (Convert.ToInt32(gvBreaker.Rows[i].Cells[1].Value.ToString()) == selecetedProductCode && Convert.ToBoolean(gvBreaker.Rows[i].Cells[2].Value.ToString()) == false)
{
gvBreaker.Rows[i].DefaultCellStyle.BackColor = Color.Yellow;
}
}
BindDataToCboIsExist();
//BindDataTocboProjCode();
cboIsExist.SelectedValue = Atend.Base.Base.BEquipStatus.SelectByACode(dpack.IsExistance).Code;
cboProjCode.SelectedValue = dpack.ProjectCode;
}
private void btnOk_Click_1(object sender, EventArgs e)
{
Editor ed = Autodesk.AutoCAD.ApplicationServices.Application.DocumentManager.MdiActiveDocument.Editor;
if (Validation())
{
Atend.Global.Acad.DrawEquips.AcDrawMeasuredJackPanel MeasuredJackPanel = new Atend.Global.Acad.DrawEquips.AcDrawMeasuredJackPanel();
if (Convert.ToBoolean(gvMeasuredJackPanel.Rows[gvMeasuredJackPanel.CurrentRow.Index].Cells[4].Value) == false)
{
MeasuredJackPanel.UseAccess = true;
MeasuredJackPanel.eMeasuredJackPanel = Atend.Base.Equipment.EMeasuredJackPanel.AccessSelectByCode(Convert.ToInt32(gvMeasuredJackPanel.Rows[gvMeasuredJackPanel.CurrentRow.Index].Cells[0].Value.ToString()));
}
else if (Convert.ToBoolean(gvMeasuredJackPanel.Rows[gvMeasuredJackPanel.CurrentRow.Index].Cells[4].Value))
{
MeasuredJackPanel.UseAccess = false;
MeasuredJackPanel.eMeasuredJackPanel = Atend.Base.Equipment.EMeasuredJackPanel.SelectByXCode(new Guid(gvMeasuredJackPanel.Rows[gvMeasuredJackPanel.CurrentRow.Index].Cells[1].Value.ToString()));
}
Atend.Base.Base.BEquipStatus status = Atend.Base.Base.BEquipStatus.SelectByCode(Convert.ToInt32(cboIsExist1.SelectedValue));
MeasuredJackPanel.Existance = status.ACode;
if (cboProjCode1.Items.Count == 0)
{
MeasuredJackPanel.ProjectCode = 0;
}
else
{
MeasuredJackPanel.ProjectCode = Convert.ToInt32(cboProjCode1.SelectedValue);
}
MeasuredJackPanel.SelectedObjectId = ObjID;
Atend.Base.Design.DPackage dpack = Atend.Base.Design.DPackage.AccessSelectByCode(NodeCode);
if (MeasuredJackPanel.UpdateMeasuredJackPanelData(dpack.Code))
{
ed.WriteMessage("Update MeasuredJackPanel Success \n");
AllowClose = true;
this.Close();
}
}
else
{
AllowClose = false;
}
}
private void frmEditDrawCatOut02_Load(object sender, EventArgs e)
{
if (ForceToClose)
{
this.Close();
}
BindDataTocboProjCode();
dtMerge = Atend.Base.Equipment.ECatOut.SelectAllAndMerge();
System.Data.DataColumn dcTypeName = new System.Data.DataColumn("TypeName");
dtMerge.Columns.Add(dcTypeName);
foreach (DataRow dr in dtMerge.Rows)
{
if (Convert.ToInt32(dr["Type"].ToString()) == 1)
{
dr["TypeName"] = "کات اوت نوع T";
}
if (Convert.ToInt32(dr["Type"].ToString()) == 2)
{
dr["TypeName"] = "کات اوت نوع K";
}
if (Convert.ToInt32(dr["Type"].ToString()) == 2)
{
dr["TypeName"] = "کات اوت نوع KT";
}
}
gvCatOut.AutoGenerateColumns = false;
gvCatOut.DataSource = dtMerge;
ChangeColor();
BindDataToComboBoxIsExist();
Atend.Base.Design.DPackage dpack = Atend.Base.Design.DPackage.AccessSelectByCode(NodeCode);
for (int i = 0; i < gvCatOut.Rows.Count; i++)
{
if (Convert.ToInt32(gvCatOut.Rows[i].Cells[0].Value.ToString()) == dpack.ProductCode && Convert.ToBoolean(gvCatOut.Rows[i].Cells[2].Value.ToString()) == false)
{
gvCatOut.Rows[i].DefaultCellStyle.BackColor = Color.Yellow;
}
}
}
private void btnOk_Click(object sender, EventArgs e)
{
if (Validation())
{
Atend.Global.Acad.DrawEquips.AcDrawGround ground = new Atend.Global.Acad.DrawEquips.AcDrawGround();
if (Convert.ToBoolean(gvGround.Rows[gvGround.CurrentRow.Index].Cells[3].Value) == false)
{
ground.UseAccess = true;
ground.eGround = Atend.Base.Equipment.EGround.AccessSelectByCode(Convert.ToInt32(gvGround.Rows[gvGround.CurrentRow.Index].Cells[0].Value.ToString()));
}
else if (Convert.ToBoolean(gvGround.Rows[gvGround.CurrentRow.Index].Cells[3].Value))
{
ground.UseAccess = false;
ground.eGround = Atend.Base.Equipment.EGround.SelectByXCode(new Guid(gvGround.Rows[gvGround.CurrentRow.Index].Cells[1].Value.ToString()));
}
Atend.Base.Base.BEquipStatus status = Atend.Base.Base.BEquipStatus.SelectByCode(Convert.ToInt32(cboIsExist1.SelectedValue));
ground.Existance = status.ACode;
if (cboProjCode1.Items.Count == 0)
{
ground.ProjectCode = 0;
}
else
{
ground.ProjectCode = Convert.ToInt32(cboProjCode1.SelectedValue);
}
ground.SelectedObjectId = ObjID;
Atend.Base.Design.DPackage dpack = Atend.Base.Design.DPackage.AccessSelectByCode(NodeCode);
if (ground.UpdateGroundData(dpack.Code))
{
ed.WriteMessage("Update Ground Success \n");
AllowClose = true;
this.Close();
}
}
else
{
AllowClose = false;
}
}
private void frmEditDrawClamp02_Load(object sender, EventArgs e)
{
if (ForceToClose)
{
this.Close();
}
Editor ed = Autodesk.AutoCAD.ApplicationServices.Application.DocumentManager.MdiActiveDocument.Editor;
dtMerge = Atend.Base.Equipment.EClamp.SelectAllAndMerge();
Atend.Base.Design.DPackage dpack = Atend.Base.Design.DPackage.AccessSelectByCode(NodeCode);
selectedProductCode = dpack.ProductCode;
gvClamp.AutoGenerateColumns = false;
gvClamp.DataSource = dtMerge;
Atend.Global.Utility.UBinding.SetGridToCurrentSelectedEquip("Code,XCode", new object[2] {
selectedProductCode, "00000000-0000-0000-0000-000000000000"
}, dtMerge, gvClamp, this);
ChangeColor();
for (int i = 0; i < gvClamp.Rows.Count; i++)
{
if (Convert.ToInt32(gvClamp.Rows[i].Cells[0].Value.ToString()) == dpack.ProductCode && Convert.ToBoolean(gvClamp.Rows[i].Cells[3].Value.ToString()) == false)
{
gvClamp.Rows[i].DefaultCellStyle.BackColor = Color.Yellow;
}
}
BindDataToComboBoxIsExist();
//BindDataTocboProjCode();
//int vol = -1;
//if (chkVol.Checked)
// vol = Convert.ToInt32(cboVol.SelectedValue);
//DataTable dt = Atend.Base.Equipment.EClamp.DrawSearch(vol);
//gvClamp.AutoGenerateColumns = false;
//gvClamp.DataSource = dt;
cboIsExist.SelectedValue = Atend.Base.Base.BEquipStatus.SelectByACode(dpack.IsExistance).Code;
cboProjCode.SelectedValue = dpack.ProjectCode;
}
private void BindDataToGridSection()
{
Editor ed = Autodesk.AutoCAD.ApplicationServices.Application.DocumentManager.MdiActiveDocument.Editor;
foreach (DataRow dr in dtSectionNumber.Rows)
{
ed.WriteMessage("SectionCode={0},SectionNumber={1}\n", new Guid(dr["SectionCode"].ToString()), dr["SectionNumber"].ToString());
Atend.Base.Calculating.CStartEnd startEnd = Atend.Base.Calculating.CStartEnd.AccessSelectBySectionCode(new Guid(dr["SectionCode"].ToString()));
ed.WriteMessage("*****Start={0},End={1}\n", startEnd.StartPole, startEnd.EndPole);
Atend.Base.Design.DPackage dPackStart = Atend.Base.Design.DPackage.AccessSelectByNodeCode(startEnd.StartPole);
Atend.Base.Design.DPackage dPackEnd = Atend.Base.Design.DPackage.AccessSelectByNodeCode(startEnd.EndPole);
dr["StartPole"] = dPackStart.Number;
dr["EndPole"] = dPackEnd.Number;
Atend.Base.Calculating.CSetDefaultMec cSetDefaultmec = Atend.Base.Calculating.CSetDefaultMec.AccessSelect();
System.Data.DataTable dtNetDefault = Atend.Base.Calculating.CNetWorkCross.AccessSelectAll();
Atend.Base.Calculating.CDefaultRudSurface defaultRudSurface = Atend.Base.Calculating.CDefaultRudSurface.AccessSelectBySectionCode(new Guid(dr["SectionCode"].ToString()));
if (defaultRudSurface.Code != 0)
{
dr["UTS"] = defaultRudSurface.UTS;
dr["NetCrossCode"] = defaultRudSurface.NetCross;
}
else
{
dr["UTS"] = cSetDefaultmec.Uts;
dr["NetCrossCode"] = Convert.ToInt32(dtNetDefault.Rows[0]["Code"].ToString());
}
}
ed.WriteMessage(" EXIT BindDataToGridSection\n");
gvSection.AutoGenerateColumns = false;
gvSection.DataSource = dtSectionNumber;
}
private void poleInsertionMenu_Click(object sender, EventArgs e)
{
Autodesk.AutoCAD.EditorInput.Editor ed = Autodesk.AutoCAD.ApplicationServices.Application.DocumentManager.MdiActiveDocument.Editor;
this.Cursor = Cursors.WaitCursor;
try
{
if (Validation() && gvBranches.Rows.Count > 0)
{
//foreach (Autodesk.AutoCAD.DatabaseServices.Entity ent in SelectdEntities)
for (int i = 0; i < gvBranches.Rows.Count; i++)
{
//SelectdEntities.Clear();
Atend.Global.Calculation.Mechanical.CAutoPoleInstallation _AutoPoleInstallation = new Atend.Global.Calculation.Mechanical.CAutoPoleInstallation();
//ed.WriteMessage("--$$--1\n");
_AutoPoleInstallation.Se = Convert.ToDouble(txtSe.Text);
//ed.WriteMessage("--$$--2\n");
_AutoPoleInstallation.ChangePercent = Convert.ToDouble(txtTolerance.Text);
//ed.WriteMessage("--$$--3\n");
_AutoPoleInstallation.UTS = Convert.ToDouble(txtUTS.Text);
//ed.WriteMessage("--$$--4\n");
_AutoPoleInstallation.NetCrossCode = Convert.ToInt32(cboConsolCross.SelectedValue);
//ed.WriteMessage("--$$--5\n");
_AutoPoleInstallation.Relibility = Convert.ToDouble(txtRelibility.Text);
//ed.WriteMessage("--$$--6\n");
_AutoPoleInstallation.MaxSectionLength = Convert.ToDouble(txtMaxSectionLength.Text);
//ed.WriteMessage("--$$--7\n");
_AutoPoleInstallation.SelectedBranch = Atend.Base.Design.DBranch.AccessSelectByCode(new Guid(gvBranches.Rows[i].Cells["BranchCode"].Value.ToString()));
//ed.WriteMessage("--$$--8\n");
Atend.Base.Design.DPackage PolePackage = Atend.Base.Design.DPackage.AccessSelectByNodeCode(new Guid(gvBranches.Rows[i].Cells["PoleCode"].Value.ToString()));
if (PolePackage.Type == (int)Atend.Control.Enum.ProductType.Pole)
{
_AutoPoleInstallation.SelectedPole = Atend.Base.Equipment.EPole.AccessSelectByCode(PolePackage.ProductCode);
}
else if (PolePackage.Type == (int)Atend.Control.Enum.ProductType.PoleTip)
{
Atend.Base.Equipment.EPoleTip PoleTip = Atend.Base.Equipment.EPoleTip.AccessSelectByCode(PolePackage.ProductCode);
if (PoleTip.Code != -1)
{
_AutoPoleInstallation.SelectedPole = Atend.Base.Equipment.EPole.AccessSelectByCode(PoleTip.PoleCode);
}
}
//ed.WriteMessage("--$$--9\n");
if (cboBranchType.SelectedIndex == 0)
{
DataRow[] drs = dtMergeConsol.Select("ROWNO=" + cboConsolCross.SelectedValue.ToString());
if (drs.Length > 0 && Convert.ToBoolean(drs[0]["IsSql"]) == true)
{
_AutoPoleInstallation.SelectedConsol = Atend.Base.Equipment.EConsol.SelectByXCodeForDesign(new Guid(drs[0]["XCode"].ToString()));
}
else
{
_AutoPoleInstallation.SelectedConsol = Atend.Base.Equipment.EConsol.AccessSelectByCode(Convert.ToInt32(drs[0]["Code"]));
}
drs = dtMergeConsol.Select("ROWNO=" + cboConsolTension.SelectedValue.ToString());
if (drs.Length > 0 && Convert.ToBoolean(drs[0]["IsSql"]) == true)
{
_AutoPoleInstallation.SelectedConsolTension = Atend.Base.Equipment.EConsol.SelectByXCodeForDesign(new Guid(drs[0]["XCode"].ToString()));
}
else
{
_AutoPoleInstallation.SelectedConsolTension = Atend.Base.Equipment.EConsol.AccessSelectByCode(Convert.ToInt32(drs[0]["Code"]));
}
_AutoPoleInstallation.SelectedClamp = null;
_AutoPoleInstallation.SelectedClampTension = null;
}
else
{
_AutoPoleInstallation.SelectedConsol = null;
_AutoPoleInstallation.SelectedConsolTension = null;
DataRow[] drs = dtMergeClamp.Select("ROWNO=" + cboClampCross.SelectedValue.ToString());
if (drs.Length > 0 && Convert.ToBoolean(drs[0]["IsSql"]) == true)
{
_AutoPoleInstallation.SelectedClamp = Atend.Base.Equipment.EClamp.SelectByXCodeForDesign(new Guid(drs[0]["XCode"].ToString()));
}
else
{
_AutoPoleInstallation.SelectedClamp = Atend.Base.Equipment.EClamp.AccessSelectByCode(Convert.ToInt32(drs[0]["Code"]));
}
drs = dtMergeClamp.Select("ROWNO=" + cboClampTension.SelectedValue.ToString());
if (drs.Length > 0 && Convert.ToBoolean(drs[0]["IsSql"]) == true)
{
_AutoPoleInstallation.SelectedClampTension = Atend.Base.Equipment.EClamp.SelectByXCodeForDesign(new Guid(drs[0]["XCode"].ToString()));
}
else
{
_AutoPoleInstallation.SelectedClampTension = Atend.Base.Equipment.EClamp.AccessSelectByCode(Convert.ToInt32(drs[0]["Code"]));
}
}
//ed.WriteMessage("CLAMP CROSS : {0} \n", _AutoPoleInstallation.SelectedClamp.Name);
//ed.WriteMessage("CLAMP CROSS TENSION : {0} \n", _AutoPoleInstallation.SelectedClampTension.Name);
_AutoPoleInstallation.BranchEntity = Atend.Global.Acad.UAcad.GetEntityByObjectID(new Autodesk.AutoCAD.DatabaseServices.ObjectId(new IntPtr(Convert.ToInt32(gvBranches.Rows[i].Cells["BranchOI"].Value)))) as Autodesk.AutoCAD.DatabaseServices.Line;
//_AutoPoleInstallation.BranchEntity = Atend.Global.Acad.UAcad.GetEntityByObjectID(BranchOi) as Autodesk.AutoCAD.DatabaseServices.Line;
if (_AutoPoleInstallation.PoleInstallationWithoutForbiddenArea(new Guid(gvBranches.Rows[i].Cells["PoleCode"].Value.ToString())))
//ed.WriteMessage("--$$--11\n");
//double answer = 0;
//int t = _AutoPoleInstallation.SpanCalculation(out answer);
//MessageBox.Show("answer:" + answer + "t:" + t);
{
DataGridViewImageCell _IC = gvBranches.Rows[i].Cells["StatusImage"] as DataGridViewImageCell;
if (_IC != null)
{
_IC.Value = new Bitmap(Atend.Control.Common.fullPath + @"\Icon\button_ok.png");
ed.WriteMessage("image assigned \n");
gvBranches.Refresh();
}
}
else
{
MessageBox.Show("خطا در زمان انجام پایه گذاری اتوماتیک");
}
}
}
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message);
}
this.Cursor = Cursors.Default;
}
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 پروندهToolStripMenuItem_Click(object sender, EventArgs e)
{
calcOptimalSagTension = new Atend.Global.Calculation.Mechanical.CalcOptimalSagTensionTest();
if (Validation())
{
Editor ed = Autodesk.AutoCAD.ApplicationServices.Application.DocumentManager.MdiActiveDocument.Editor;
calcOptimalSagTension.DtPoleSection = Atend.Base.Design.DPoleSection.AccessSelectBySectionCodeProductType(new Guid(cboSelectSection.SelectedValue.ToString()), Convert.ToInt32(Atend.Control.Enum.ProductType.Pole));
ed.WriteMessage("dtPoleSection1={0}\n", calcOptimalSagTension.DtPoleSection.Rows.Count);
System.Data.DataTable dtPole = Atend.Base.Design.DPoleSection.AccessSelectBySectionCodeProductType(new Guid(cboSelectSection.SelectedValue.ToString()), Convert.ToInt32(Atend.Control.Enum.ProductType.PoleTip));
ed.WriteMessage("dtPoleSection2={0}\n", calcOptimalSagTension.DtPoleSection.Rows.Count);
foreach (DataRow dr in dtPole.Rows)
{
DataRow drPole = calcOptimalSagTension.DtPoleSection.NewRow();
drPole["ProductType"] = dr["ProductType"].ToString();
drPole["ProductCode"] = dr["ProductCode"].ToString();
drPole["SectionCode"] = dr["SectionCode"].ToString();
calcOptimalSagTension.DtPoleSection.Rows.Add(drPole);
}
System.Data.DataColumn dc = new System.Data.DataColumn("PoleNumber");
calcOptimalSagTension.DtPoleSection.Columns.Add(dc);
foreach (DataRow dr in calcOptimalSagTension.DtPoleSection.Rows)
{
Atend.Base.Design.DPackage node = Atend.Base.Design.DPackage.AccessSelectByNodeCode(new Guid(dr["ProductCode"].ToString()));
dr["PoleNumber"] = node.Number.ToString();
}
calcOptimalSagTension.VTS = Convert.ToDouble(txtVTS.Text);
calcOptimalSagTension.Volt = Convert.ToDouble(cboVolt.Text);
calcOptimalSagTension.DtPoleCond = section.dtGlobal;
calcOptimalSagTension.dtBranchList = section.dtBranchList;
//ed.WriteMessage("Befor Read NetCross\n");
for (int i = 0; i < gvNetCross.Rows.Count; i++)
{
if (Convert.ToInt32(gvNetCross.Rows[i].Cells[0].Value) == Convert.ToInt32(cboSelectSection.Text))
{
DataGridViewComboBoxCell cboNetCross = (DataGridViewComboBoxCell)gvNetCross.Rows[i].Cells["Column2"];
NetCross = Atend.Base.Calculating.CNetWorkCross.AccessSelectByCode(Convert.ToInt32(cboNetCross.Value.ToString()));
}
}
if (cboVolt.Text == "400")
{
calcOptimalSagTension.Clearance = NetCross.V380;
}
if (cboVolt.Text == "11000")
{
calcOptimalSagTension.Clearance = NetCross.KV11;
}
if (cboVolt.Text == "20000")
{
calcOptimalSagTension.Clearance = NetCross.KV20;
}
if (cboVolt.Text == "33000")
{
calcOptimalSagTension.Clearance = NetCross.KV32;
}
//ed.WriteMessage("Create DtconductorSectionConsol={0}\n", cboSelectSection.SelectedValue.ToString());
calcOptimalSagTension.DtconductorSection = Atend.Base.Design.DPoleSection.AccessSelectBySectionCodeProductType(new Guid(cboSelectSection.SelectedValue.ToString()), Convert.ToInt32(Atend.Control.Enum.ProductType.Conductor));
if (calcOptimalSagTension.DtconductorSection.Rows.Count == 0)
{
//ed.WriteMessage("Create DtconductorSection={0}\n", cboSelectSection.SelectedValue.ToString());
calcOptimalSagTension.DtconductorSection = Atend.Base.Design.DPoleSection.AccessSelectBySectionCodeProductType(new Guid(cboSelectSection.SelectedValue.ToString()), Convert.ToInt32(Atend.Control.Enum.ProductType.SelfKeeper));
//ed.WriteMessage("Count={0}\n", calcOptimalSagTension.DtconductorSection.Rows.Count);
}
System.Data.DataColumn dc1 = new System.Data.DataColumn("Angle");
calcOptimalSagTension.DtconductorSection.Columns.Add(dc1);
calcOptimalSagTension.SectionCode = new Guid(cboSelectSection.SelectedValue.ToString());
calcOptimalSagTension.Start = Convert.ToInt32(txtStart.Text);
calcOptimalSagTension.End = Convert.ToInt32(txtEnd.Text);
calcOptimalSagTension.Distance = Convert.ToInt32(txtDistance.Text);
Atend.Base.Design.DBranch MyBranch = Atend.Base.Design.DBranch.AccessSelectByCode(new Guid(calcOptimalSagTension.DtconductorSection.Rows[0]["ProductCode"].ToString()));
//ed.WriteMessage("OOO\n");
dtSagTension.Rows.Clear();
dtPole.Rows.Clear();
dtConductorDay.Rows.Clear();
se = calcOptimalSagTension.ComputeSE();
SpanCount = calcOptimalSagTension.DtconductorSection.Rows.Count;
dtSagTension = calcOptimalSagTension.CalSagTension(MyBranch).Copy();
dtConductorDay = calcOptimalSagTension.CalcTempTable();
gvSagAndTension.AutoGenerateColumns = false;
gvPole.AutoGenerateColumns = false;
gvSagAndTension.DataSource = dtSagTension;
gvConductorDay.DataSource = dtConductorDay;
dtPole = calcOptimalSagTension.WindOnPole();
gvPole.DataSource = dtPole;
//calcOptimalSagTension.IsSagOk();
DataRow dr1 = dtRow.NewRow();
dr1["ProjectName"] = "";
dr1["NumSection"] = cboSelectSection.Text;
dr1["FirstPole"] = "";
dr1["LastPole"] = "";
dr1["UTS"] = txtVTS.Text;
dr1["SE"] = se.ToString();
dr1["SpanCount"] = SpanCount;
dr1["SpanLenght"] = "";
dr1["CondName"] = gvSagAndTension.Rows[0].Cells[0].Value;
dtRow.Rows.Add(dr1);
}
}
private void btnOk_Click(object sender, EventArgs e)
{
Editor ed = Autodesk.AutoCAD.ApplicationServices.Application.DocumentManager.MdiActiveDocument.Editor;
Atend.Global.Acad.DrawEquips.AcDrawKhazan DrawKhazan = new Atend.Global.Acad.DrawEquips.AcDrawKhazan();
if (Validation())
{
if (Convert.ToBoolean(gvBankKhazan.Rows[gvBankKhazan.CurrentRow.Index].Cells[3].Value) == false)
{
DrawKhazan.UseAccess = true;
DrawKhazan.eKhazanTip = Atend.Base.Equipment.EKhazanTip.AccessSelectByCode(Convert.ToInt32(gvBankKhazan.Rows[gvBankKhazan.CurrentRow.Index].Cells[4].Value.ToString()));
}
else if (Convert.ToBoolean(gvBankKhazan.Rows[gvBankKhazan.CurrentRow.Index].Cells[3].Value))
{
DrawKhazan.UseAccess = false;
DrawKhazan.eKhazanTip = Atend.Base.Equipment.EKhazanTip.SelectByXCode(new Guid(gvBankKhazan.Rows[gvBankKhazan.CurrentRow.Index].Cells[0].Value.ToString()));
}
Atend.Base.Base.BEquipStatus status = Atend.Base.Base.BEquipStatus.SelectByCode(Convert.ToInt32(cboIsExist.SelectedValue));
DrawKhazan.Existance = status.ACode;
if (cboProjCode.Items.Count == 0)
{
DrawKhazan.ProjectCode = 0;
}
else
{
DrawKhazan.ProjectCode = Convert.ToInt32(cboProjCode.SelectedValue);
}
DrawKhazan.SelectedObjectId = ObjID;
Atend.Base.Design.DPackage dpack = Atend.Base.Design.DPackage.AccessSelectByCode(NodeCode);
if (DrawKhazan.UpdateKhazanData(dpack.Code))
{
ed.WriteMessage("Update Khazan Success \n");
AllowClose = true;
this.Close();
}
}
//Extra
//if (gvBankKhazan.Rows.Count > 0)
//{
// Editor ed = Autodesk.AutoCAD.ApplicationServices.Application.DocumentManager.MdiActiveDocument.Editor;
// //ed.WriteMessage(gvBankKhazan.SelectedRows[0].Cells["Column7"].Value.ToString() + "\n");
// //ed.WriteMessage(gvBankKhazan.SelectedRows[0].Index.ToString() + "\n");
// Atend.Base.Design.DPackage Pakage = Atend.Base.Design.DPackage.AccessSelectByCode(DpakageCode);
// //**EDIT**
// Pakage.ProductCode = Convert.ToInt32(gvBankKhazan.SelectedRows[0].Cells["Column7"].Value.ToString());
// //Pakage.ProductCode = new Guid(gvBankKhazan.SelectedRows[0].Cells["Column7"].Value.ToString());
// if (Pakage.AccessUpdate())
// {
// //ed.WriteMessage("OK");
// //Atend.Base.Acad.AT_INFO
// //Code = Convert.ToInt32(gvBankKhazan.SelectedRows[0].Cells["Column7"].Value.ToString());
// Code = new Guid(gvBankKhazan.SelectedRows[0].Cells["Column7"].Value.ToString());
// AllowClose = true;
// this.Close();
// }
// else
// MessageBox.Show("انجام ويرايش امكانپذير نيست");
//}
//if (Validation())
//{
// //DataTable KhazanTipTable = Atend.Base.Equipment.EKhazanTip.SelectByCode(
// // Convert.ToInt32(gvBankKhazan.CurrentRow.Index));
// Atend.Base.Acad.AcadGlobal.dPackageForKhazanTip.Count = 1;
// Atend.Base.Acad.AcadGlobal.dPackageForKhazanTip.Type = (int)Atend.Control.Enum.ProductType.BankKhazan;
// Atend.Base.Acad.AcadGlobal.dPackageForKhazanTip.ProductCode = Convert.ToInt32(
// gvBankKhazan.Rows[gvBankKhazan.CurrentRow.Index].Cells["Column7"].Value);
// Atend.Base.Design.DPackage dPackge;
// DataTable dt = (DataTable)gvKhazan.DataSource;
// foreach (DataRow dr in dt.Rows)
// {
// dPackge = new Atend.Base.Design.DPackage();
// dPackge.Count = Convert.ToInt32(dr["Count"]);
// dPackge.Type=Convert.ToInt32(dr["Type"]);
// dPackge.ProductCode = Convert.ToInt32(Atend.Control.Enum.ProductType.Khazan);
// Atend.Base.Acad.AcadGlobal.dPackageForKhazan.Add(dPackge);
// }
// AllowClose = true;
//}
//else
//{
// AllowClose = false;
//}
}
private void frmDrawPoleTip02_Load(object sender, EventArgs e)
{
if (ForceToClose)
{
this.Close();
}
BindDataToComboBoxIsExist();
BindDataToCboInGridView();
AddProjectCodeColumn();
dtMergePoleTip = Atend.Base.Equipment.EPoleTip.SelectAllAndMerge();
Atend.Base.Design.DPackage dPack = Atend.Base.Design.DPackage.AccessSelectByNodeCode(NodeCode);
selectedProductCode = dPack.ProductCode;
gvPoleTip.AutoGenerateColumns = false;
gvPoleTip.DataSource = dtMergePoleTip;
Atend.Global.Utility.UBinding.SetGridToCurrentSelectedEquip("Code,XCode", new object[2] {
selectedProductCode, "00000000-0000-0000-0000-000000000000"
}, dtMergePoleTip, gvPoleTip, this);
ChangeColor();
for (int i = 0; i < gvPoleTip.Rows.Count; i++)
{
if (Convert.ToInt32(gvPoleTip.Rows[i].Cells[1].Value) == dPack.ProductCode && Convert.ToBoolean(gvPoleTip.Rows[i].Cells[2].Value) == false)
{
gvPoleTip.Rows[i].DefaultCellStyle.BackColor = Color.Yellow;
//gvPoleTip.Rows[i].Selected = true;
}
}
Atend.Base.Design.DNode node = Atend.Base.Design.DNode.AccessSelectByCode(NodeCode);
txtHeight.Text = Convert.ToString(Math.Round(node.Height, 2));
dtgvPoleConsol = Atend.Base.Design.DPackage.AccessSelectByParentCodeForConsol(dPack.Code, (int)Atend.Control.Enum.ProductType.Consol);
dtHalt = Atend.Base.Design.DPackage.AccessSelectByParentCodeAndType(dPack.Code, Convert.ToInt32(Atend.Control.Enum.ProductType.Halter));
if (dtHalt.Rows.Count > 0)
{
Atend.Base.Equipment.EHalter Halter = Atend.Base.Equipment.EHalter.AccessSelectByCode(Convert.ToInt32(dtHalt.Rows[0]["ProductCode"].ToString()));
txtHalter.Text = Halter.Name;
}
System.Data.DataColumn dcIsSql = new System.Data.DataColumn("IsSql");
dtgvPoleConsol.Columns.Add(dcIsSql);
System.Data.DataColumn dcAccessCode = new System.Data.DataColumn("AccessCode");
dtgvPoleConsol.Columns.Add(dcAccessCode);
System.Data.DataColumn dcXCode = new System.Data.DataColumn("XCode");
dtgvPoleConsol.Columns.Add(dcXCode);
foreach (DataRow dr in dtgvPoleConsol.Rows)
{
dr["IsExistance"] = Atend.Base.Base.BEquipStatus.SelectByACode(Convert.ToInt32(dr["IsExistance"].ToString())).Code;
dr["IsSql"] = false;
dr["XCode"] = "_";
dr["AccessCode"] = dr["ProductCode"].ToString();
}
gvConsol.AutoGenerateColumns = false;
gvConsol.DataSource = dtgvPoleConsol;
dtLastConsol = dtgvPoleConsol.Copy();
//for (int i = 0; i < gvPoleTip.Rows.Count; i++)
//{
// gvPoleTip.Rows[i].Selected = false;
//}
Atend.Base.Equipment.EPoleTip EPolT = Atend.Base.Equipment.EPoleTip.AccessSelectByCode(dPack.ProductCode);
if (EPolT.Code != -1)
{
txtHalterCount.Text = EPolT.HalterCount.ToString();
}
//BindDataTocboProjCode();
cboIsExist.SelectedValue = Atend.Base.Base.BEquipStatus.SelectByACode(dPack.IsExistance).Code;
cboProjCode.SelectedValue = dPack.ProjectCode;
if (dtHalt.Rows.Count > 0)
{
cboHIsExistance.SelectedValue = Atend.Base.Base.BEquipStatus.SelectByACode(Convert.ToInt32(dtHalt.Rows[0]["IsExistance"].ToString())).Code;
cboHProjectCode.SelectedValue = Convert.ToInt32(dtHalt.Rows[0]["ProjectCode"].ToString());
}
dtCurrent = dtgvPoleConsol.Copy();
}
private void btnSelect_Click(object sender, EventArgs e)
{
Editor ed = Autodesk.AutoCAD.ApplicationServices.Application.DocumentManager.MdiActiveDocument.Editor;
#region Select
this.Hide();
PromptEntityOptions peo = new PromptEntityOptions("\nSelect MiddleJackPanel:\n");
PromptEntityResult per = ed.GetEntity(peo);
if (per.Status == PromptStatus.OK)
{
ObjectId GroupOI = Atend.Global.Acad.Global.GetEntityGroup(per.ObjectId);
if (GroupOI != ObjectId.Null)
{
Atend.Base.Acad.AT_INFO GroupInfo = Atend.Base.Acad.AT_INFO.SelectBySelectedObjectId(GroupOI);
if (GroupInfo.ParentCode != "NONE" && GroupInfo.NodeType == (int)Atend.Control.Enum.ProductType.MiddleJackPanel)
{
ObjectIdCollection OIC = Atend.Global.Acad.UAcad.GetGroupSubEntities(GroupOI);
foreach (ObjectId oi in OIC)
{
Atend.Base.Acad.AT_INFO SubInfo = Atend.Base.Acad.AT_INFO.SelectBySelectedObjectId(oi);
if (SubInfo.ParentCode != "NONE" && SubInfo.NodeType == (int)Atend.Control.Enum.ProductType.Cell)
{
//ed.WriteMessage("NodeCode:{0} , CellOI:{1}\n", SubInfo.NodeCode, oi);
//MyDic.Add(new Guid(SubInfo.NodeCode), oi);
System.Data.DataRow NewRow1 = CellAndKey.NewRow();
NewRow1["CellGuid"] = new Guid(SubInfo.NodeCode);
NewRow1["CellObjectId"] = oi.ToString().Substring(1, oi.ToString().Length - 2);
Atend.Base.Acad.AT_SUB CellSub = Atend.Base.Acad.AT_SUB.SelectBySelectedObjectId(oi);
foreach (ObjectId oii in CellSub.SubIdCollection)
{
Atend.Base.Acad.AT_INFO KeyInfo = Atend.Base.Acad.AT_INFO.SelectBySelectedObjectId(oii);
if (KeyInfo.ParentCode != "NONE" && KeyInfo.NodeType == (int)Atend.Control.Enum.ProductType.Key)
{
NewRow1["KeyObjectId"] = oii.ToString().Substring(1, oii.ToString().Length - 2);
}
}
CellAndKey.Rows.Add(NewRow1);
}
}
//foreach (System.Data.DataRow dr in CellAndKey.Rows)
//{
// ed.WriteMessage("CG:{0},\nCOI:{1},\nKOI:{2}\n", dr["CellGuid"], dr["CellObjectId"], dr["KeyObjectId"]);
//}
NodeCode = new Guid(GroupInfo.NodeCode);
dtCell = Atend.Base.Design.DCellStatus.AccessSelectByJackPanelCode(NodeCode);
System.Data.DataColumn dcName = new System.Data.DataColumn("Name");
dtCell.Columns.Add(dcName);
foreach (DataRow dr in dtCell.Rows)
{
//ed.WriteMessage("CellCode:{0}\n", dr["CellCode"]);
Atend.Base.Design.DPackage package = Atend.Base.Design.DPackage.AccessSelectByCode(new Guid(dr["CellCode"].ToString()));// SelectByCode(new Guid(dr["CellCode"].ToString()));
Atend.Base.Equipment.ECell cell = Atend.Base.Equipment.ECell.AccessSelectByCode(package.ProductCode);
dr["Name"] = cell.Name;
}
gvCellJAckPAnel.AutoGenerateColumns = false;
gvCellJAckPAnel.DataSource = dtCell;
//Atend.Calculating.frmTest t = new Atend.Calculating.frmTest();
//t.dataGridView5.DataSource = dtCell;
//t.ShowDialog();
}
}
}
this.Show();
#endregion
}
public bool UpdatebreakerData(Guid EXCode)
{
Editor ed = Application.DocumentManager.MdiActiveDocument.Editor;
OleDbTransaction aTransaction;
OleDbConnection aConnection = new OleDbConnection(Atend.Control.ConnectionString.AccessCnString);
try
{
aConnection.Open();
aTransaction = aConnection.BeginTransaction();
try
{
BreakerPack = Atend.Base.Design.DPackage.AccessSelectByCode(EXCode);
if (!UseAccess)
{
if (!eBreaker.AccessInsert(aTransaction, aConnection, true, true))
{
throw new System.Exception("eBreaker.AccessInsert failed");
}
//if (!Atend.Base.Equipment.EOperation.SentFromLocalToAccess(eBreaker.XCode, (int)Atend.Control.Enum.ProductType.Breaker, eBreaker.Code, aTransaction, aConnection))
//{
// throw new System.Exception("operation failed");
//}
}
BreakerPack.IsExistance = Existance;
BreakerPack.ProductCode = eBreaker.Code;
BreakerPack.ProjectCode = ProjectCode;
BreakerPack.Number = "";
if (BreakerPack.AccessUpdate(aTransaction, aConnection))
{
Atend.Base.Acad.AT_INFO atinfo = Atend.Base.Acad.AT_INFO.SelectBySelectedObjectId(selectedObjectId);// id);
atinfo.ProductCode = eBreaker.Code;
atinfo.Insert();
ChangeComment(Atend.Global.Acad.UAcad.GetEntityGroup(selectedObjectId), eBreaker.Comment);
}
else
{
throw new System.Exception("BreakerPack.AccessInsert2 failed");
}
if (!DKeyStatus.Update(aTransaction, aConnection))
{
throw new System.Exception("dKeyStatus.AccessUpdate Failed");
}
if (!UseAccess)
{
//if (Br.Code == -1)
//{
//WENT TO
//if (!Atend.Base.Equipment.EContainerPackage.SentFromLocalToAccess(eBreaker.XCode, (int)Atend.Control.Enum.ProductType.Breaker, eBreaker.Code, aTransaction, aConnection))
//{
// throw new System.Exception("SentFromLocalToAccess failed");
//}
//}
}
}
catch (System.Exception ex1)
{
ed.WriteMessage("ERROR UpdateBreaker 01(transaction) : {0} \n", ex1.Message);
aTransaction.Rollback();
aConnection.Close();
return(false);
}
}
catch (System.Exception ex)
{
ed.WriteMessage("ERROR UpdateBreaker 01 : {0} \n", ex.Message);
aConnection.Close();
return(false);
}
aTransaction.Commit();
aConnection.Close();
return(true);
}
private bool SaveBreakerData()
{
Editor ed = Application.DocumentManager.MdiActiveDocument.Editor;
OleDbConnection aConnection = new OleDbConnection(Atend.Control.ConnectionString.AccessCnString);
OleDbTransaction aTransaction;
try
{
aConnection.Open();
aTransaction = aConnection.BeginTransaction();
try
{
if (!UseAccess)
{
if (!eBreaker.AccessInsert(aTransaction, aConnection, true, true))
{
throw new System.Exception("eBreaker.AccessInsert failed");
}
}
BreakerPack = new Atend.Base.Design.DPackage();
BreakerPack.Count = 1;
BreakerPack.IsExistance = Existance;
BreakerPack.ProductCode = eBreaker.Code;
BreakerPack.Type = (int)Atend.Control.Enum.ProductType.Breaker;
BreakerPack.ParentCode = Guid.Empty;
BreakerPack.NodeCode = Guid.Empty;
BreakerPack.LoadCode = 0;
BreakerPack.Number = "";
BreakerPack.ProjectCode = ProjectCode;
if (!BreakerPack.AccessInsert(aTransaction, aConnection))
{
throw new System.Exception("dPack.AccessInsert failed");
}
DKeyStatus = new Atend.Base.Design.DKeyStatus();
DKeyStatus.NodeCode = BreakerPack.Code;
DKeyStatus.Type = (int)Atend.Control.Enum.ProductType.Breaker;;
DKeyStatus.IsClosed = false;
if (!DKeyStatus.Insert(aTransaction, aConnection))
{
throw new System.Exception("DKeyStatus.AccessInsert failed");
}
}
catch (System.Exception ex1)
{
ed.WriteMessage("ERROR SaveBreakerData 02 :{0} \n", ex1.Message);
aTransaction.Rollback();
aConnection.Close();
return(false);
}
}
catch (System.Exception ex)
{
ed.WriteMessage("ERROR SaveBreakerData 01 :{0} \n", ex.Message);
aConnection.Close();
return(false);
}
aTransaction.Commit();
aConnection.Close();
#region Not to Get Green
Atend.Base.Acad.AcadGlobal.BreakerData.UseAccess = true;
//UseAccess = true;
#endregion
return(true);
}
//~~~~~~~~~~~~~~~~~~~~ METHODS ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~//
public AcDrawBreaker()
{
BreakerPack = new Atend.Base.Design.DPackage();
DKeyStatus = new Atend.Base.Design.DKeyStatus();
}
private void frmEditDrawDisconnector02_Load(object sender, EventArgs e)
{
if (ForceToClose)
{
this.Close();
}
dtMerge = Atend.Base.Equipment.EDisconnector.SelectAllAndMerge();
System.Data.DataColumn dcTypeName = new System.Data.DataColumn("TypeName");
dtMerge.Columns.Add(dcTypeName);
foreach (DataRow dr in dtMerge.Rows)
{
if (Convert.ToInt32(dr["Type"].ToString()) == 1)
{
dr["TypeName"] = "سکسیونر هوایی غیر قابل قطع زیر بار";
}
if (Convert.ToInt32(dr["Type"].ToString()) == 2)
{
dr["TypeName"] = "سکسیونر هوایی قابل قطع زیر بار";
}
if (Convert.ToInt32(dr["Type"].ToString()) == 3)
{
dr["TypeName"] = "سکسیونر SF6 قابل قطع زیر بار";
}
}
Atend.Base.Design.DPackage dpack = Atend.Base.Design.DPackage.AccessSelectByCode(NodeCode);
selecetdProductCode = dpack.ProductCode;
Atend.Base.Design.DKeyStatus keyStatus = Atend.Base.Design.DKeyStatus.SelectByNodeCode(NodeCode);
if (keyStatus.IsClosed)
{
rdbClose.Checked = true;
}
else
{
rdbOpen.Checked = true;
}
gvDisconnector.AutoGenerateColumns = false;
gvDisconnector.DataSource = dtMerge;
Atend.Global.Utility.UBinding.SetGridToCurrentSelectedEquip("Code,XCode", new object[2] {
selecetdProductCode, "00000000-0000-0000-0000-000000000000"
}, dtMerge, gvDisconnector, this);
ChangeColor();
for (int i = 0; i < gvDisconnector.Rows.Count; i++)
{
if (Convert.ToInt32(gvDisconnector.Rows[i].Cells[1].Value.ToString()) == selecetdProductCode && Convert.ToBoolean(gvDisconnector.Rows[i].Cells[2].Value.ToString()) == false)
{
gvDisconnector.Rows[i].DefaultCellStyle.BackColor = Color.Yellow;
}
}
BindDataToComboBoxIsExist();
//BindDataTocboProjCode();
cboIsExist.SelectedValue = Atend.Base.Base.BEquipStatus.SelectByACode(dpack.IsExistance).Code;
cboProjCode.SelectedValue = dpack.ProjectCode;
}
private bool SaveGroundData(string NodeCode)
{
Editor ed = Application.DocumentManager.MdiActiveDocument.Editor;
OleDbConnection aConnection = new OleDbConnection(Atend.Control.ConnectionString.AccessCnString);
OleDbTransaction aTransaction;
try
{
aConnection.Open();
aTransaction = aConnection.BeginTransaction();
try
{
if (!UseAccess)
{
if (!eGround.AccessInsert(aTransaction, aConnection, true, true))
{
throw new System.Exception("eGround.AccessInsert failed");
}
}
//ed.WriteMessage("--->>>>----1\n");
GroundPack.Count = 1;
GroundPack.IsExistance = Existance;
GroundPack.LoadCode = 0;
GroundPack.NodeCode = new Guid();
GroundPack.Number = "GROUND";
ed.WriteMessage("NodeCode:{0}\n", NodeCode);
Atend.Base.Design.DPackage TempPackage = Atend.Base.Design.DPackage.AccessSelectByNodeCode(new Guid(NodeCode), aTransaction, aConnection);
if (TempPackage.Code == Guid.Empty)
{
TempPackage = Atend.Base.Design.DPackage.AccessSelectByCode(new Guid(NodeCode), aTransaction, aConnection);
if (TempPackage.Code == Guid.Empty)
{
throw new System.Exception("GroundPack.AccessSelectByNodeCode failed");
}
}
GroundPack.ParentCode = TempPackage.Code;
GroundPack.ProductCode = eGround.Code;
GroundPack.ProjectCode = projectCode;
GroundPack.Type = (int)Atend.Control.Enum.ProductType.Ground;
if (!GroundPack.AccessInsert(aTransaction, aConnection))
{
throw new System.Exception("GroundPack.AccessInsert failed");
}
//ed.WriteMessage("--->>>>----2\n");
}
catch (System.Exception ex1)
{
ed.WriteMessage("ERROR SaveGroundData 02 : {0}\n", ex1.Message);
aTransaction.Rollback();
aConnection.Close();
return(false);
}
}
catch (System.Exception ex)
{
ed.WriteMessage("ERROR SaveGroundData 01 : {0}\n", ex.Message);
aConnection.Close();
return(false);
}
aTransaction.Commit();
aConnection.Close();
#region Not to Get Green
Atend.Base.Acad.AcadGlobal.GroundData.UseAccess = true;
//UseAccess = true;
#endregion
return(true);
}
//MOUSAVI->drawing delete
public static bool AccessDelete(Guid Code, OleDbTransaction _Transaction, OleDbConnection _Connection)
{
Editor ed = Application.DocumentManager.MdiActiveDocument.Editor;
OleDbConnection connection = _Connection;
OleDbCommand command = new OleDbCommand("D_Package_Delete", connection);
command.Transaction = _Transaction;
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new OleDbParameter("iCode", Code));
try
{
//ed.WriteMessage("DpackageCode:{0}\n", Code);
Atend.Base.Design.DPackage _DPackage = Atend.Base.Design.DPackage.AccessSelectByCode(Code, _Transaction, _Connection);
if (_DPackage.Code != Guid.Empty)
{
switch (((Atend.Control.Enum.ProductType)_DPackage.Type))
{
case Atend.Control.Enum.ProductType.Pole:
//ed.WriteMessage("~~~~~~~~~~~ pole found ~~~~~~~~~~~~~~~\n");
if (!Atend.Base.Design.DPoleInfo.AccessDeleteByNodeCode(_DPackage.NodeCode, _Transaction, _Connection))
{
throw new System.Exception("~~~***~~~DPoleInfo.AccessDelete failed");
}
if (!Atend.Base.Design.DNode.AccessDelete(_DPackage.NodeCode, _Transaction, _Connection))
{
throw new System.Exception("~~~***~~~DNode.AccessDelete failed");
}
break;
case Atend.Control.Enum.ProductType.Consol:
//ed.WriteMessage("~~~~~~~~~~~ CONSOL found ~~~~~~~~~~~~~~~\n");
if (!Atend.Base.Design.DConsol.AccessDelete(_DPackage.Code, _Transaction, _Connection))
{
throw new System.Exception("~~~***~~~DConsol.AccessDelete failed");
}
break;
case Atend.Control.Enum.ProductType.GroundPost:
//ed.WriteMessage("~~~~~~~~~~~ GROUND POST found ~~~~~~~~~~~~~~~\n");
if (!Atend.Base.Design.DPost.AccessDelete(_DPackage.NodeCode, _Transaction, _Connection))
{
throw new System.Exception("~~~***~~~DPost.AccessDelete failed");
}
break;
case Atend.Control.Enum.ProductType.AirPost:
//ed.WriteMessage("~~~~~~~~~~~ AIRPOST found ~~~~~~~~~~~~~~~\n");
if (!Atend.Base.Design.DPost.AccessDelete(_DPackage.NodeCode, _Transaction, _Connection))
{
throw new System.Exception("~~~***~~~DPost.AccessDelete failed");
}
break;
case Atend.Control.Enum.ProductType.MiddleJackPanel:
//ed.WriteMessage("~~~~~~~~~~~ MJ found ~~~~~~~~~~~~~~~\n");
if (!Atend.Base.Design.DCellStatus.AccessDeleteByJackPanelCode(_DPackage.Code, _Transaction, _Connection))
{
throw new System.Exception("~~~***~~~DCellStatus.AccessDeleteByJackPanelCode failed");
}
break;
case Atend.Control.Enum.ProductType.PoleTip:
//ed.WriteMessage("~~~~~~~~~~~ poleTIP found ~~~~~~~~~~~~~~~\n");
if (!Atend.Base.Design.DPoleInfo.AccessDeleteByNodeCode(_DPackage.NodeCode, _Transaction, _Connection))
{
throw new System.Exception("~~~***~~~DPoleInfo.AccessDeleteTip failed");
}
if (!Atend.Base.Design.DNode.AccessDelete(_DPackage.NodeCode, _Transaction, _Connection))
{
throw new System.Exception("~~~***~~~DNode.AccessDeleteTip failed");
}
break;
}
}
command.ExecuteNonQuery();
}
catch (System.Exception ex1)
{
ed.WriteMessage(string.Format("Error DPackage.AccessDelete : {0} \n", ex1.Message));
return(false);
}
return(true);
}
