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("امکان به روز رسانی اطلاعات نمی باشد", "خطا");
}
}
}
