public void BindDataToOwnControl(Guid XCode)
{
Atend.Base.Equipment.EPhuse phuse = Atend.Base.Equipment.EPhuse.SelectByXCode(XCode);
//Atend.Base.Base.BProduct product = Atend.Base.Base.BProduct.Select_ByCode(phuse.ProductCode);
//Atend.Base.Equipment.EPhuseKey phuseKey = Atend.Base.Equipment.EPhuseKey.SelectByCode(phuse.PhuseKeyCode);
Atend.Control.Common.selectedProductCode = Convert.ToInt32(phuse.ProductCode);
SelectProduct();
txtName.Text = phuse.Name;
txtAmper.Text = Convert.ToString(Math.Round(phuse.Amper, 2));
cboType.SelectedValue = Convert.ToInt16(phuse.Type);
selectedPhuseXCode = XCode;
cboPhusePole.SelectedValue = phuse.PhusePoleXCode.ToString();
txtComment.Text = phuse.Comment;
tsbIsDefault.Checked = phuse.IsDefault;
Code = phuse.Code;
BindTreeViwAndGrid();
//if (phuseKey.IsPhuseKey)
//{
// rbtnPhuseKey.Checked = true;
// cboPhuseKey.SelectedValue = phuse.PhuseKeyCode;
//}
//else
//{
// rbtnMiniatureKey.Checked = true;
// cboMiniatureKey.SelectedValue = phuse.PhuseKeyCode;
//}
}
private void tsbShare_Click(object sender, EventArgs e)
{
if (selectedPhuseXCode != Guid.Empty)
{
if (Atend.Base.Equipment.EContainerPackage.ShareOnServer(Convert.ToInt32(Atend.Control.Enum.ProductType.Phuse), selectedPhuseXCode))
{
Atend.Base.Equipment.EPhuse Phuse = Atend.Base.Equipment.EPhuse.SelectByXCode(selectedPhuseXCode);
Code = Phuse.Code;
MessageBox.Show("به اشتراک گذاری با موفقیت انجام شد");
}
else
{
MessageBox.Show("خطا در به اشتراک گذاری .");
}
}
else
{
MessageBox.Show("لطفا تجهیز مورد نظر را انتخاب کنید");
}
//if (selectedPhuseXCode != Guid.Empty)
//{
// if (Atend.Base.Equipment.EPhuse.ShareOnServer(selectedPhuseXCode))
// MessageBox.Show("به اشتراک گذاری با موفقیت انجام شد");
// else
// MessageBox.Show("خطا در به اشتراک گذاری . لطفاً دوباره سعی کنید");
//}
//else
// MessageBox.Show("لطفا تجهیز مورد نظر را انتخاب کنید");
}
private void Delete()
{
string name = string.Empty;
if (!Atend.Global.Utility.UBinding.ExistInSubEquip(selectedPhusePoleCode, out name))
{
MessageBox.Show(string.Format("حذف بدلیل وجود در تجهیزات جانبی امکانپذیر نمی باشد\n تجهیز موردنظر زیر تجهیز '{0}' میباشد ", name), "خطا");
return;
}
Atend.Base.Equipment.EPhuse phuse = Atend.Base.Equipment.EPhuse.SelectByPhusePoleXCode(selectedPhusePoleCode);
if (phuse.Code != -1)
{
MessageBox.Show(string.Format("حذف بدلیل وجود در فیوز:{0} امکانپذیر نمی باشد", phuse.Name), "خطا");
return;
}
//Atend.Base.Equipment.EProductPackage _ProductPackage = Atend.Base.Equipment.EProductPackage.SelectByXCode(selectedPhusePoleCode);
//if (_ProductPackage.Code != -1)
//{
// MessageBox.Show("حذف بدلیل وجود در تجهیزات جانبی امکانپذیر نمی باشد ", "خطا");
// return;
//}
if (MessageBox.Show("آیا مایل به حذف کردن اطلاعات می باشید؟", "خطا", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
if (selectedPhusePoleCode != Guid.Empty)
{
if (Atend.Base.Equipment.EPhusePole.DeleteX(selectedPhusePoleCode))
{
Reset();
}
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 (selectedPhuseXCode == Guid.Empty && IsDefault)
{
MessageBox.Show("کاربر گرامی شما اجازه ثبت تجهیز به صورت پیش فرض ندارید", "خطا");
return(false);
}
else
{
Atend.Base.Equipment.EPhuse phuse = Atend.Base.Equipment.EPhuse.SelectByXCode(selectedPhuseXCode);
if (phuse.IsDefault || IsDefault)
{
MessageBox.Show("کاربر گرامی شما اجازه ویرایش تجهیز به صورت پیش فرض ندارید", "خطا");
return(false);
}
}
}
return(true);
}
public bool UpdateStreetBoxData(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
{
StreetBoxPack = Atend.Base.Design.DPackage.AccessSelectByCode(EXCode);
if (!UseAccess)
{
if (!eStreetBox.AccessInsert(aTransaction, aConnection, true, true))
{
throw new System.Exception("eStreetBox.AccessInsert failed");
}
else
{
foreach (Atend.Base.Equipment.EStreetBoxPhuse sbPhuses in eStreetBoxPhuse)
{
if (!sbPhuses.AccessInsert(aTransaction, aConnection, true, true))
{
throw new System.Exception("eStreetBoxPhuse.AccessInsert failed");
}
}
}
foreach (Atend.Base.Equipment.EStreetBoxPhuse SelectedStreetBoxPhuse in eStreetBoxPhuse)
{
Atend.Base.Equipment.EPhuse phuse = Atend.Base.Equipment.EPhuse.SelectByXCode(SelectedStreetBoxPhuse.PhuseXCode);
if (phuse.Code != -1)
{
if (!phuse.AccessInsert(aTransaction, aConnection, true, true))
{
throw new System.Exception("ePhuse.AccesInsert failed");
}
SelectedStreetBoxPhuse.PhuseCode = phuse.Code;
SelectedStreetBoxPhuse.StreetBoxCode = eStreetBox.Code;
if (!SelectedStreetBoxPhuse.AccessInsert(aTransaction, aConnection, true, true))
{
throw new System.Exception("EStreetBoxPhuseInsert failed");
}
}
else
{
throw new System.Exception("EPhuse.SelectByXCode failed");
}
}
}
StreetBoxPack.IsExistance = Existance;
StreetBoxPack.ProductCode = eStreetBox.Code;
StreetBoxPack.ProjectCode = ProjectCode;
StreetBoxPack.Number = "";
if (StreetBoxPack.AccessUpdate(aTransaction, aConnection))
{
Atend.Base.Acad.AT_INFO atinfo = Atend.Base.Acad.AT_INFO.SelectBySelectedObjectId(selectedObjectId);
atinfo.ProductCode = eStreetBox.Code;
atinfo.Insert();
}
else
{
throw new System.Exception("StreetBoxPack.AccessInsert2 failed");
}
}
catch (System.Exception ex1)
{
ed.WriteMessage("ERROR UpdateStreetBox 01(transaction) : {0} \n", ex1.Message);
aTransaction.Rollback();
aConnection.Close();
return(false);
}
}
catch (System.Exception ex)
{
ed.WriteMessage("ERROR UpdateStreetBox 01 : {0} \n", ex.Message);
aConnection.Close();
return(false);
}
aTransaction.Commit();
DeleteStreetBox(selectedObjectId);
DrawStreetBoxUpdate();
aConnection.Close();
return(true);
}
private bool SaveStreetBoxData()
{
Editor ed = Application.DocumentManager.MdiActiveDocument.Editor;
OleDbConnection aConnection = new OleDbConnection(Atend.Control.ConnectionString.AccessCnString);
OleDbTransaction aTransaction;
try
{
aConnection.Open();
aTransaction = aConnection.BeginTransaction();
try
{
//Atend.Base.Equipment.EStreetBox sb = Atend.Base.Equipment.EStreetBox.AccessSelectByXCode(eStreetBox.XCode);
if (!UseAccess)
{
//if (sb.Code == -1)
{
if (!eStreetBox.AccessInsert(aTransaction, aConnection, true, true))
{
throw new System.Exception("eStreetBox.AccessInsert failed");
}
}
//}
//if (!UseAccess)
//{
foreach (Atend.Base.Equipment.EStreetBoxPhuse SelectedStreetBoxPhuse in eStreetBoxPhuse)
{
//ed.WriteMessage("@@{0}\n", SelectedStreetBoxPhuse.PhuseXCode);
//ed.WriteMessage("########## SelectedStreetBoxPhuse.PhuseXCode:{0}\n", SelectedStreetBoxPhuse.PhuseXCode);
Atend.Base.Equipment.EPhuse phuse = Atend.Base.Equipment.EPhuse.SelectByXCode(SelectedStreetBoxPhuse.PhuseXCode);
//ed.WriteMessage("########## phuse.Code:{0}\n", phuse.Code);
if (phuse.Code != -1)
{
Atend.Base.Equipment.EPhusePole _EPhusePole = Atend.Base.Equipment.EPhusePole.SelectByXCode(phuse.PhusePoleXCode);
if (_EPhusePole.Code != -1)
{
//ed.WriteMessage("112\n");
if (!_EPhusePole.AccessInsert(aTransaction, aConnection, true, true))
{
throw new System.Exception("AccessInsert failed PhusePole");
}
}
else
{
throw new System.Exception("Lack of data in StreetBox:Phuse:PhusePole");
}
phuse.PhusePoleCode = _EPhusePole.Code;
if (!phuse.AccessInsert(aTransaction, aConnection, true, true))
{
throw new System.Exception("ePhuse.AccesInsert failed");
}
SelectedStreetBoxPhuse.PhuseCode = phuse.Code;
SelectedStreetBoxPhuse.StreetBoxCode = eStreetBox.Code;
//if (sb.Code == -1)
// SelectedStreetBoxPhuse.StreetBoxCode = eStreetBox.Code;
//else
// SelectedStreetBoxPhuse.StreetBoxCode = sb.Code;
if (!SelectedStreetBoxPhuse.AccessInsert(aTransaction, aConnection, true, true))
{
throw new System.Exception("EStreetBoxPhuseInsert failed");
}
}
else
{
throw new System.Exception("EPhuse.SelectByXCode failed");
}
}
}
StreetBoxPack = new Atend.Base.Design.DPackage();
StreetBoxPack.Count = 1;
StreetBoxPack.IsExistance = Existance;
StreetBoxPack.NodeCode = Guid.Empty;
StreetBoxPack.Number = "0";
StreetBoxPack.ParentCode = Guid.Empty;
StreetBoxPack.ProjectCode = ProjectCode;
StreetBoxPack.ProductCode = eStreetBox.Code;
//if (sb.Code == -1)
// StreetBoxPack.ProductCode = eStreetBox.Code;
//else
// StreetBoxPack.ProductCode = sb.Code;
StreetBoxPack.Type = Convert.ToInt32(Atend.Control.Enum.ProductType.StreetBox);
if (!StreetBoxPack.AccessInsert(aTransaction, aConnection))
{
throw new System.Exception("StreetBoxPack.AccessInsert failed");
}
}
catch (System.Exception ex1)
{
ed.WriteMessage("ERROR SaveStreetBoxData 02 :{0} \n", ex1.Message);
aTransaction.Rollback();
aConnection.Close();
return(false);
}
}
catch (System.Exception ex)
{
ed.WriteMessage("ERROR SaveStreetBoxData 01 :{0} \n", ex.Message);
aConnection.Close();
return(false);
}
aTransaction.Commit();
aConnection.Close();
#region Not to Get Green
Atend.Base.Acad.AcadGlobal.StreetBoxData.UseAccess = true;
UseAccess = true;
#endregion
return(true);
}
private bool Validation()
{
//if (Atend.Control.Common.selectedProductCode == -1)
//{
// MessageBox.Show("لطفا ابتدا یک کالا را از پشتیبان انتخاب کنید", "خطا");
// return false;
//}
if (string.IsNullOrEmpty(txtAmper.Text))
{
MessageBox.Show("لطفا امپراژ را مشخص نمایید", "خطا");
txtAmper.Focus();
return(false);
}
if (Atend.Base.Equipment.EPhuse.SearchByName(txtName.Text) == true && selectedPhuseXCode == Guid.Empty)
{
MessageBox.Show("نام قبلا استفاده شده است", "خطا");
txtName.Focus();
return(false);
}
if (!Atend.Control.NumericValidation.DoubleConverter(txtAmper.Text))
{
MessageBox.Show("لطفاً آمپراژ را با فرمت مناسب مشخص نمایید", "خطا");
txtAmper.Focus();
txtAmper.Select(0, txtAmper.Text.Length);
return(false);
}
Atend.Base.Equipment.EPhuse phuse = Atend.Base.Equipment.EPhuse.CheckForExist(Convert.ToDouble(txtAmper.Text), Convert.ToByte(cboType.SelectedValue), new Guid(cboPhusePole.SelectedValue.ToString()));
if (phuse.Code != -1 && selectedPhuseXCode == Guid.Empty)
{
if (MessageBox.Show("فیوز با مشخصات داده شده موجود میباشد\n\n فیوز با مشخصات فوق: " + phuse.Name + "\n\n" + "آیا مایل به ادامه ثبت می باشید؟", "خطا", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
txtAmper.Focus();
return(false);
}
}
if (!Atend.Global.Utility.UBinding.CheckGridValidation(gvOperation, 3))
{
MessageBox.Show("لطفا تعداد در آماده سازی را با فرمت مناسب وارد نمایید", "خطا");
return(false);
}
if (!Atend.Global.Utility.UBinding.CheckGridValidation(gvSelectedEquipment, 2))
{
MessageBox.Show("لطفا تعداد در تجهیزات جانبی را با فرمت مناسب وارد نمایید", "خطا");
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(selectedPhuseXCode, Convert.ToInt32(Atend.Control.Enum.ProductType.Phuse), _EProductPackage.XCode, _EProductPackage.TableType))
{
MessageBox.Show(string.Format("تجهیز '{0}' در زیر تجهیزات موجود می باشد", txtName.Text), "خطا");
gvSelectedEquipment.Focus();
return(false);
}
}
return(CheckStatuseOfAccessChangeDefault());
//return true;
}
private void Save()
{
txtName.Focus();
Atend.Base.Equipment.EPhuse phuse = new Atend.Base.Equipment.EPhuse();
phuse.Amper = Convert.ToDouble(txtAmper.Text);
phuse.Name = txtName.Text;
phuse.ProductCode = Atend.Control.Common.selectedProductCode;
phuse.Type = Convert.ToByte(cboType.SelectedValue);
phuse.PhusePoleXCode = new Guid(cboPhusePole.SelectedValue.ToString());
phuse.Comment = txtComment.Text;
phuse.IsDefault = IsDefault;
phuse.Code = Code;
//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);
}
phuse.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);
}
phuse.OperationList = EOperation;
if (selectedPhuseXCode == Guid.Empty)
{
if (phuse.InsertX())
{
Reset();
}
else
{
MessageBox.Show("امکان ذخیره سازی اطلاعات نمی باشد", "خطا");
}
}
else
{
phuse.XCode = selectedPhuseXCode;
if (phuse.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);
}
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("امکان به روز رسانی اطلاعات نمی باشد", "خطا");
}
}
}
