private void tsbShare_Click(object sender, EventArgs e) { if (selectedDBCode != Guid.Empty) { if (Atend.Base.Equipment.EContainerPackage.ShareOnServer(Convert.ToInt32(Atend.Control.Enum.ProductType.DB), selectedDBCode)) { Atend.Base.Equipment.EDB DB = Atend.Base.Equipment.EDB.SelectByXCode(selectedDBCode); Code = DB.Code; MessageBox.Show("به اشتراک گذاری با موفقیت انجام شد"); } else { MessageBox.Show("خطا در به اشتراک گذاری ."); } } else { MessageBox.Show("لطفا تجهیز مورد نظر را انتخاب کنید"); } //if (selectedDBCode != Guid.Empty) //{ // if (Atend.Base.Equipment.EDB.ShareOnServer(selectedDBCode)) // { // Atend.Base.Equipment.EDB d1 = Atend.Base.Equipment.EDB.SelectByXCode(selectedDBCode); // Code = d1.Code; // MessageBox.Show("به اشتراک گذاری با موفقیت انجام شد"); // } // else // MessageBox.Show("خطا در به اشتراک گذاری . لطفاً دوباره سعی کنید"); //} //else // MessageBox.Show("لطفا تجهیز مورد نظر را انتخاب کنید"); }
private bool CheckStatuseOfAccessChangeDefault() { Autodesk.AutoCAD.EditorInput.Editor ed = Autodesk.AutoCAD.ApplicationServices.Application.DocumentManager.MdiActiveDocument.Editor; //ed.WriteMessage("AccessChangeDefault={0}\n", Atend.Control.Common.AccessChangeDefault); if (!Atend.Control.Common.AccessChangeDefault) { if (selectedDBCode == Guid.Empty && IsDefault) { MessageBox.Show("کاربر گرامی شما اجازه ثبت تجهیز به صورت پیش فرض ندارید", "خطا"); return(false); } else { Atend.Base.Equipment.EDB Equip = Atend.Base.Equipment.EDB.SelectByXCode(selectedDBCode); if (Equip.IsDefault || IsDefault) { MessageBox.Show("کاربر گرامی شما اجازه ویرایش تجهیز به صورت پیش فرض ندارید", "خطا"); return(false); } } } return(true); }
//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); }
public void BindDataToOwnControl(Guid XCode) { //gvInputFeeder = new DataGridView(); for (int i = 0; i < gvInputFeeder.Rows.Count; i++) { gvInputFeeder.Rows.RemoveAt(i); } selectedDBCode = XCode; //ed.WriteMessage("AS\n"); Atend.Base.Equipment.EDB DB = Atend.Base.Equipment.EDB.SelectByXCode(XCode); //dtSemshNum.Clear(); DataTable dtDBPhuseInput = Atend.Base.Equipment.EDBPhuse.SelectByDBXCodeType(DB.XCode, 1); dtInputDB.Rows.Clear(); dtInputDB = dtDBPhuseInput.Copy(); dtInputFeeder = dtDBPhuseInput.Copy(); DataTable dtDBPhuseOutput = Atend.Base.Equipment.EDBPhuse.SelectByDBXCodeType(DB.XCode, 0); dtOutputDB.Rows.Clear(); dtOutputDB = dtDBPhuseOutput.Copy(); dtOutputFeeder = dtDBPhuseOutput.Copy(); //MessageBox.Show(dtDB.Rows.Count.ToString()); //for (int i = 0; i < DB.ShemshCount; i++) //{ // DataRow dr = dtSemshNum.NewRow(); // dr["ShemshNum"] = i + 1; // dtSemshNum.Rows.Add(dr); //} //ed.WriteMessage("AD\n"); Atend.Control.Common.selectedProductCode = DB.ProductCode; SelectProduct(); txtName.Text = DB.Name; txtComment.Text = DB.Comment; Atend.Control.Common.selectedProductCode = DB.ProductCode; nudOutputCount.Value = Convert.ToDecimal(DB.OutputCount); nudInputCount.Value = Convert.ToDecimal(DB.InputCount); Code = DB.Code; //ed.WriteMessage("AF\n"); //gvInputFeeder.Columns[1].DataPropertyName = "ShemshNum"; InputFeederNum = Convert.ToDecimal(DB.InputCount); OutputFeederNum = Convert.ToDecimal(DB.OutputCount); gvInputFeeder.AutoGenerateColumns = false; gvInputFeeder.DataSource = dtDBPhuseInput; gvInputFeeder.Refresh(); //MessageBox.Show(dtDB.Rows.Count.ToString()); //MessageBox.Show(dtDBPhuse.Rows.Count.ToString()); for (int i = 0; i < dtDBPhuseInput.Rows.Count; i++) { //MessageBox.Show(dtDBPhuse.Rows[i]["DBCode"].ToString() + " " + i.ToString()); if (gvInputFeeder.Rows[i].Cells[0].Value.ToString() == dtDBPhuseInput.Rows[i]["FeederNum"].ToString()) { gvInputFeeder.Rows[i].Cells[2].Value = dtDBPhuseInput.Rows[i]["PhuseXCode"].ToString(); } //DataGridViewComboBoxCell c = (DataGridViewComboBoxCell)gvInputFeeder.Rows[i].Cells[1]; //c.Value = dtDBPhuse.Rows[i]["ShemshNum"].ToString(); //MessageBox.Show("END " + i.ToString()); } gvOutputFeeder.AutoGenerateColumns = false; gvOutputFeeder.DataSource = dtDBPhuseOutput; gvOutputFeeder.Refresh(); tsbIsDefault.Checked = DB.IsDefault; //int counter = 1; //foreach (DataRow DrDBPhuse in dtDBPhuse.Rows) //{ // gvInputFeeder.Rows.Add(); // gvInputFeeder.Rows[gvInputFeeder.Rows.Count - 1].Cells[0].Value = Counter; // gvInputFeeder.Rows[gvInputFeeder.Rows.Count - 1].Cells[1].Value = DrDBPhuse["ShemshNum"].ToString(); // Atend.Base.Equipment.EPhuse Phuse = Atend.Base.Equipment.EPhuse.SelectByCode(Convert.ToInt32(DrDBPhuse["PhuseCode"].ToString())); // DataGridViewComboBoxCell c = (DataGridViewComboBoxCell)gvInputFeeder.Rows[gvInputFeeder.Rows.Count - 1].Cells[2]; // c.Value = Phuse.Code; // //gvInputFeeder.Rows[gvInputFeeder.Rows.Count - 1].Cells[2].Value = 1; // Counter++; //} //gvInputFeeder.DataSource = dtDB; //ed.WriteMessage("AG\n"); BindTreeandGrid(); dtInputDB.Clear(); dtInputDB.Rows.Clear(); dtInputDB = dtDBPhuseInput.Copy(); dtOutputDB.Clear(); dtOutputDB.Rows.Clear(); dtOutputDB = dtDBPhuseOutput.Copy(); }
private void Save() { txtName.Focus(); Atend.Base.Equipment.EDB DB = new Atend.Base.Equipment.EDB(); ArrayList EOperation = new ArrayList(); //DB.InputPhuse = -1;//Convert.ToInt32(cboInputPhuse.SelectedValue); DB.InputCount = Convert.ToInt32(nudInputCount.Value); DB.OutputCount = Convert.ToInt32(nudOutputCount.Value); DB.ProductCode = Atend.Control.Common.selectedProductCode; DB.Comment = txtComment.Text; DB.Name = txtName.Text; //DB.ShemshCount = -1;// Convert.ToInt32(nudInputCount.Value); DB.IsDefault = IsDefault; DB.Code = Code; txtComment.Focus(); int i; //Atend.Base.Equipment.EDBPhuse DBPhuse = new Atend.Base.Equipment.EDBPhuse(); //سه فاز if (!Atend.Base.Equipment.EDBPhuse.DeleteX(selectedDBCode)) { MessageBox.Show("ثبت کردن اطلاعات امکانپذیر نمیباشد", "خطا"); return; } dtInputFeeder = (DataTable)gvInputFeeder.DataSource; dtOutputFeeder = (DataTable)gvOutputFeeder.DataSource; foreach (DataRow dr in dtInputFeeder.Rows) { Atend.Base.Equipment.EDBPhuse DBPhuse = new Atend.Base.Equipment.EDBPhuse(); DBPhuse.FeederNum = Convert.ToInt32(dr["FeederNum"].ToString()); DBPhuse.ShemshNum = 0; DBPhuse.PhuseXCode = new Guid(dr["PhuseXCode"].ToString()); Atend.Base.Equipment.EPhuse phuse = Atend.Base.Equipment.EPhuse.SelectByXCode(DBPhuse.PhuseXCode); DBPhuse.PhuseType = 1; DBPhuse.IOType = true; DB.SubEquipment.Add(DBPhuse); } foreach (DataRow dr in dtOutputFeeder.Rows) { Atend.Base.Equipment.EDBPhuse DBPhuse = new Atend.Base.Equipment.EDBPhuse(); DBPhuse.FeederNum = Convert.ToInt32(dr["FeederNum"].ToString()); DBPhuse.ShemshNum = 0; DBPhuse.PhuseXCode = new Guid(dr["PhuseXCode"].ToString()); Atend.Base.Equipment.EPhuse phuse = Atend.Base.Equipment.EPhuse.SelectByXCode(DBPhuse.PhuseXCode); DBPhuse.PhuseType = 0; DBPhuse.IOType = false; DB.SubEquipment.Add(DBPhuse); } ////for (i = 0; i < gvInputFeeder.Rows.Count; i++) ////{ //// Atend.Base.Equipment.EDBPhuse DBPhuse = new Atend.Base.Equipment.EDBPhuse(); //// DBPhuse.FeederNum = Convert.ToInt32(gvInputFeeder.Rows[i].Cells[0].Value.ToString()); //// DBPhuse.ShemshNum = 0;// Convert.ToByte(gvInputFeeder.Rows[i].Cells[1].Value.ToString()); //// DataGridViewComboBoxCell c = (DataGridViewComboBoxCell)gvInputFeeder.Rows[i].Cells[2]; //// DBPhuse.PhuseXCode = new Guid(c.Value.ToString()); //// Atend.Base.Equipment.EPhuse phuse = Atend.Base.Equipment.EPhuse.SelectByXCode(DBPhuse.PhuseXCode); //// DBPhuse.PhuseType = 1; //// DBPhuse.IOType = true; //// ed.WriteMessage("@@ feedernum:{0},phusexcode:{1}\n", DBPhuse.FeederNum, DBPhuse.PhuseXCode); //// DB.SubEquipment.Add(DBPhuse); ////} ////for (i = 0; i < gvOutputFeeder.Rows.Count; i++) ////{ //// Atend.Base.Equipment.EDBPhuse DBPhuse = new Atend.Base.Equipment.EDBPhuse(); //// DBPhuse.FeederNum = Convert.ToInt32(gvOutputFeeder.Rows[i].Cells[0].Value.ToString()); //// DBPhuse.ShemshNum = 0;// Convert.ToByte(gvInputFeeder.Rows[i].Cells[1].Value.ToString()); //// DataGridViewComboBoxCell c = (DataGridViewComboBoxCell)gvOutputFeeder.Rows[i].Cells[2]; //// DBPhuse.PhuseXCode = new Guid(c.Value.ToString()); //// Atend.Base.Equipment.EPhuse phuse = Atend.Base.Equipment.EPhuse.SelectByXCode(DBPhuse.PhuseXCode); //// DBPhuse.PhuseType = 0; //// DBPhuse.IOType = false; //// DB.SubEquipment.Add(DBPhuse); ////} // تک فاز //for (int i = 0; i < gvFeeder1.Rows.Count; i++) //{ // DBPhuse.PhuseType = 1; // DBPhuse.FeederNum = Convert.ToInt32(gvFeeder1.Rows[i].Cells[0].Value.ToString()); // DataGridViewComboBoxCell cShemsh = (DataGridViewComboBoxCell)gvFeeder1.Rows[i].Cells[1]; // DBPhuse.ShemshNum = Convert.ToByte(cShemsh.Value); // DataGridViewComboBoxCell c = (DataGridViewComboBoxCell)gvFeeder1.Rows[i].Cells[1]; // DBPhuse.PhuseCode = Convert.ToInt32(c.Value); // DB.SubEquipment.Add(DBPhuse); // //ed.WriteMessage("aaa \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); } DB.EquipmentList = EPackageProduct; //Operation for (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); } DB.OperationList = EOperation; //********** //ed.WriteMessage("selectedDBCode" + selectedDBCode + "\n"); if (selectedDBCode == Guid.Empty) { if (DB.InsertX()) { Reset(); //ed.WriteMessage("طلاعات به درستی ثبت شد\n"); } else { MessageBox.Show("امکان ثبت کردن اطلاعات نمی باشد", "خطا"); } } else { DB.XCode = selectedDBCode; if (DB.UpdateX()) { Reset(); } else { MessageBox.Show("امکان به روز رسانی اطلاعات نمی باشد", "خطا"); } } }