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 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(); }