private void tsbShare_Click(object sender, EventArgs e) { if (SelectedRodCode != Guid.Empty) { if (Atend.Base.Equipment.EContainerPackage.ShareOnServer(Convert.ToInt32(Atend.Control.Enum.ProductType.Rod), SelectedRodCode)) { Atend.Base.Equipment.ERod Rod = Atend.Base.Equipment.ERod.SelectByXCode(SelectedRodCode); Code = Rod.Code; MessageBox.Show("به اشتراک گذاری با موفقیت انجام شد"); } else { MessageBox.Show("خطا در به اشتراک گذاری ."); } } else { MessageBox.Show("لطفا تجهیز مورد نظر را انتخاب کنید"); } //if (SelectedRodCode != Guid.Empty) //{ // if (Atend.Base.Equipment.ERod.ShareOnServer(SelectedRodCode)) // { // Atend.Base.Equipment.ERod r1 = Atend.Base.Equipment.ERod.SelectByXCode(SelectedRodCode); // Code = r1.Code; // MessageBox.Show("به اشتراک گذاری با موفقیت انجام شد"); // } // else // MessageBox.Show("خطا در به اشتراک گذاری . لطفاً دوباره سعی کنید"); //} //else // MessageBox.Show("لطفا تجهیز مورد نظر را انتخاب کنید"); }
public void BindDataToOwnControl(Guid Codee) { Editor ed = Autodesk.AutoCAD.ApplicationServices.Application.DocumentManager.MdiActiveDocument.Editor; SelectedRodCode = Codee; Atend.Base.Equipment.ERod Rod = Atend.Base.Equipment.ERod.SelectByXCode(Codee); //Atend.Base.Base.BProduct product = Atend.Base.Base.BProduct.Select_ByCode(Rod.ProductCode); Atend.Control.Common.selectedProductCode = Rod.ProductCode; SelectProduct(); txtAmper.Text = Convert.ToString(Math.Round(Rod.Amper, 4)); cboVol.Text = Convert.ToString(Rod.Vol); txtComment.Text = Rod.Comment; txtName.Text = Rod.Name; cboType.SelectedText = Rod.Type.ToString(); tsbIsDefault.Checked = Rod.IsDefault; Code = Rod.Code; //ed.WriteMessage("Code :=" + Code + "\n"); BindTreeViwAndGridEquipment(); }
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 (SelectedRodCode == Guid.Empty && IsDefault) { MessageBox.Show("کاربر گرامی شما اجازه ثبت تجهیز به صورت پیش فرض ندارید", "خطا"); return(false); } else { Atend.Base.Equipment.ERod Rod = Atend.Base.Equipment.ERod.SelectByXCode(SelectedRodCode); if (Rod.IsDefault || IsDefault) { MessageBox.Show("کاربر گرامی شما اجازه ویرایش تجهیز به صورت پیش فرض ندارید", "خطا"); return(false); } } } return(true); }
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 bool Validation() { //if (Atend.Control.Common.selectedProductCode == -1) //{ // MessageBox.Show("لطفا ابتدا یک کالا را از پشتیبان انتخاب کنید", "خطا"); // return false; //} if (string.IsNullOrEmpty(txtName.Text)) { MessageBox.Show("لطفا نام را مشخص نمایید", "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading); txtName.Focus(); txtName.Select(0, txtName.Text.Length); return(false); } if (Atend.Base.Equipment.ERod.SearchByName(txtName.Text) == true && SelectedRodCode == Guid.Empty) { MessageBox.Show("نام قبلا استفاده شده است"); txtName.Focus(); return(false); } if (string.IsNullOrEmpty(txtAmper.Text)) { MessageBox.Show("لطفا آمپر را مشخص نمایید", "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading); txtAmper.Focus(); txtAmper.Select(0, txtAmper.Text.Length); return(false); } if (!Atend.Control.NumericValidation.DoubleConverter(txtAmper.Text)) { MessageBox.Show("لطفاً آمپر را با فرمت مناسب وارد نمایید", "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading); txtAmper.Focus(); txtAmper.Select(0, txtAmper.Text.Length); return(false); } if (string.IsNullOrEmpty(cboVol.Text)) { MessageBox.Show("لطفا ولتاژ را مشخص نمایید", "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading); cboVol.Focus(); return(false); } if (!Atend.Control.NumericValidation.DoubleConverter(cboVol.Text)) { MessageBox.Show("لطفاً ولتاژ را با فرمت مناسب وارد نمایید", "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading); cboVol.Focus(); //txtVol.Select(0, txtVol.Text.Length); return(false); } //if (string.IsNullOrEmpty(cboType.Text)) //{ // MessageBox.Show("لطفا نوع را مشخص نمایید", "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading); // cboVol.Focus(); // return false; //} //if (!Atend.Control.NumericValidation.Int16Converter(cboType.Text)) //{ // MessageBox.Show("لطفاً نوع را با فرمت مناسب وارد نمایید", "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading); // cboType.Focus(); // //txtVol.Select(0, txtVol.Text.Length); // return false; //} Atend.Base.Equipment.ERod rod = Atend.Base.Equipment.ERod.CheckForExist(Convert.ToDouble(cboVol.Text), Convert.ToDouble(txtAmper.Text)); if (rod.Code != -1 && SelectedRodCode == Guid.Empty) { if (MessageBox.Show("برقگیر با مشخصات داده شده موجود میباشد\n\n برقگیر با مشخصات فوق: " + rod.Name + "\n\n" + "آیا مایل به ادامه ثبت می باشید؟", "خطا", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No) { cboVol.Focus(); return(false); } } if (!Atend.Global.Utility.UBinding.CheckGridValidation(gvOperation, 3)) { MessageBox.Show("لطفا تعداد آماده سازی را با فرمت مناسب وارد نمایید", "خطا"); gvOperation.Focus(); return(false); } if (!Atend.Global.Utility.UBinding.CheckGridValidation(gvSelectedEquipment, 2)) { MessageBox.Show("لطفا تعداد تجهیزات جانبی را با فرمت مناسب وارد نمایید", "خطا"); gvSelectedEquipment.Focus(); 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(SelectedRodCode, Convert.ToInt32(Atend.Control.Enum.ProductType.Rod), _EProductPackage.XCode, _EProductPackage.TableType)) { MessageBox.Show(string.Format("تجهیز '{0}' در زیر تجهیزات موجود می باشد", txtName.Text), "خطا"); gvSelectedEquipment.Focus(); return(false); } } return(true); }
private void Save() { Editor ed = Autodesk.AutoCAD.ApplicationServices.Application.DocumentManager.MdiActiveDocument.Editor; txtName.Focus(); Atend.Base.Equipment.ERod Rod = new Atend.Base.Equipment.ERod(); Rod.ProductCode = Atend.Control.Common.selectedProductCode; Rod.Amper = Convert.ToDouble(txtAmper.Text); Rod.Vol = Convert.ToDouble(cboVol.Text); Rod.Comment = txtComment.Text; Rod.Type = Convert.ToByte(cboType.SelectedValue); Rod.Name = txtName.Text; Rod.IsDefault = IsDefault; Rod.Code = Code; //ed.WriteMessage("Code :=" + Code +"\n"); //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); } Rod.EquipmentList = EPackageProduct; //Operation ArrayList EOperation = new ArrayList(); for (int i = 0; i < gvOperation.Rows.Count; i++) { Atend.Base.Equipment.EOperation _EOperation = new Atend.Base.Equipment.EOperation(); _EOperation.ProductID = Convert.ToInt32(gvOperation.Rows[i].Cells[0].Value); _EOperation.Count = Convert.ToDouble(gvOperation.Rows[i].Cells[3].Value); EOperation.Add(_EOperation); } Rod.OperationList = EOperation; if (SelectedRodCode == Guid.Empty) { if (Rod.InsertX()) { Reset(); } else { MessageBox.Show("امکان ثبت کردن اطلاعات نمی باشد", "خطا"); } } else { Rod.XCode = SelectedRodCode; if (Rod.UpdateX()) { Reset(); } else { MessageBox.Show("امکان به روز رسانی اطلاعات نمی باشد", "خطا"); } } }
//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); }