Example #1
0
        private void UpdateZxbz()
        {
            var ssdw    = ComBox_SSDW.Text;
            var bzlx    = ComBox_BZLX.Text;
            var bzText  = TXT_BZNR.Text.Trim();
            var dysbfid = TXT_DYSBFID.Tag == null ? string.Empty : TXT_DYSBFID.Tag.ToString();

            if (string.IsNullOrEmpty(dysbfid))
            {
                MessageBox.Show("请选择杂项标注对应的父设备!", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                return;
            }
            if (string.IsNullOrEmpty(bzlx))
            {
                MessageBox.Show("标注类型不能为空!", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                return;
            }
            if (string.IsNullOrEmpty(bzText))
            {
                return;
            }
            if (entityArgs.ObjId == ObjectId.Null)
            {
                return;
            }
            if (!bzText.Equals(zxbzn.MIF_TEXT))
            {
                SymbolLabel.UpdateDBText(entityArgs.ObjId, bzText);
            }
            var result  = UpdateDBEntity.UpdateZXBZN(bzText, bzlx, ssdw, dysbfid, zxbzn);
            var message = result ? "修改成功!" : "修改失败!";

            PublicMethod.Instance.ShowMessage(message);
        }
Example #2
0
        /// <summary>
        /// 修改从属
        /// </summary>
        /// <param name="oldName"></param>
        /// <param name="newName"></param>
        private void ModifyDependence(string oldName, string newName)
        {
            if (oldName.Equals(newName))
            {
                return;
            }
            //获取自身公共属性
            var common = DBEntityFinder.Instance.GetCommonByG3e_FID(g3eObject.G3E_FID);

            if (common == null)
            {
                return;
            }
            //新名称
            common.SBMC = newName;
            //更新自身公共属性
            var result = UpdateDBEntity.UpdateCommon(common);

            if (result)
            {
                //更新电房标注
                UpdateDBText(g3eObject.G3E_FID, newName, oldName);
                //获取从属
                var coms = DBEntityFinder.Instance.GetCommonsByG3e_ID(common.G3E_ID);
                if (coms.Any())
                {
                    //更新从属
                    foreach (var com in coms)
                    {
                        if (string.IsNullOrEmpty(com.SBMC))
                        {
                            continue;
                        }
                        var oldTextString = com.SBMC;
                        if (!string.IsNullOrEmpty(oldName) && com.SBMC.Contains(oldName))
                        {
                            var newSBMC = com.SBMC.Replace(oldName, newName);
                            com.SBMC = newSBMC;
                            var bl = UpdateDBEntity.UpdateCommon(com);
                            if (bl)
                            {
                                //更新从属设备的标注
                                UpdateDBText(com.G3E_FID, newSBMC, oldTextString);
                            }
                        }
                    }
                }
                else
                {
                    PublicMethod.Instance.AlertDialog("无从属关系!");
                }
                textBox_DF_OLDNAME.Text = newName;
            }
        }
Example #3
0
        /// <summary>
        /// 更新受电馈线
        /// </summary>
        /// <param name="currentG3e_id"></param>
        /// <param name="bdz"></param>
        /// <param name="kx"></param>
        private void UpdateSDKXAC(string currentG3e_id, string bdz, string kx)
        {
            //更新
            var lg3e_id = long.Parse(currentG3e_id);
            //判断是否有修改
            var result = DBEntityFinder.Instance.HasSDKX(CurrentFid, bdz, kx);

            if (!result)
            {
                var isUpdate = UpdateDBEntity.UpdateSDKX_AC(lg3e_id, bdz, kx);
                if (isUpdate)
                {
                    UpdateSdkxList(currentRowKx, kx);
                }
                PublicMethod.Instance.ShowMessage(isUpdate ? "修改成功!" : "修改失败!");
            }
        }
Example #4
0
 /// <summary>
 /// 更新受电馈线
 /// </summary>
 /// <param name="bdz"></param>
 /// <param name="kxmc"></param>
 private void UpdateSDKX(string bdz, string kxmc)
 {
     if (_sdkxAcUnion != null && _sdkxAcUnion.Any())
     {
         var oldbdz = comboBox_sc_bdz.Text;
         var oldkx  = comboBox_sc_kxmc.Text;
         if (string.IsNullOrEmpty(oldbdz) && string.IsNullOrEmpty(oldkx))
         {
             return;
         }
         IList <long> errors = new List <long>();
         foreach (var sdkx in _sdkxAcUnion)
         {
             if (sdkx.GDBDZ.Equals(oldbdz) && sdkx.KXH.Equals(oldkx))
             {
                 var isUpdate = UpdateDBEntity.UpdateSDKX_AC(bdz, kxmc, sdkx);
                 if (!isUpdate)
                 {
                     errors.Add(sdkx.G3E_FID);
                 }
                 else
                 {
                     var duplicated = DBEntityFinder.Instance.DuplicatedSdkx(sdkx.G3E_FID, bdz, kxmc);
                     //判断同一个设备是否有重复的受电馈线
                     if (duplicated)
                     {
                         DeleteDBEntity.DeleteSDKX(sdkx.G3E_ID);
                     }
                 }
             }
         }
         if (errors.Any())
         {
             GetError("更新失败!", errors);
         }
         else
         {
             MessageBox.Show("更新成功!", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Question);
         }
         //重新绑定
         GetSymbolSDKXUnion();
     }
 }
Example #5
0
        private void DelSwitch_Click(object sender, EventArgs e)
        {
            if (lbSwitchCabinetcol.Items.Count <= 0)
            {
                return;
            }
            int index = lbSwitchCabinetcol.SelectedIndex;

            if (index < 0)
            {
                return;
            }
            if (!DBEntityFinder.Instance.VerifyLTTID(dfG3eFid))
            {
                PublicMethod.Instance.Editor.WriteMessage("\n电房未在工单锁定范围之内,禁止编辑!!!\n");
                return;
            }
            try
            {
                string prompt;
                g3eFid = dict[index];
                var entitys = DBEntityFinder.Instance.GetSSKGG(g3eFid);
                if (entitys != null)
                {
                    prompt = entitys.Any() ? "当前开关柜下已挂有开关,确定要删除该开关柜!" : "确定要删除该开关柜!";
                }
                else
                {
                    prompt = "确定要删除该开关柜!";
                }
                if (MessageBox.Show(prompt, "温馨提示", MessageBoxButtons.OKCancel) != DialogResult.OK)
                {
                    return;
                }
                var values = DevEventHandler.GetDevTables(198, g3eFid);
                if (values.ComObj != null)
                {
                    if (values.ComObj.EntityState == EntityState.None)
                    {
                        values.ComObj.EntityState = EntityState.Delete;
                    }
                    DBManager.Instance.Delete(values.ComObj);
                }
                if (values.SelfObj != null)
                {
                    if (values.SelfObj.EntityState == EntityState.None)
                    {
                        values.SelfObj.EntityState = EntityState.Delete;
                    }
                    DBManager.Instance.Delete(values.SelfObj);
                }
                if (values.GnwzObj != null)
                {
                    if (values.GnwzObj.EntityState == EntityState.None)
                    {
                        values.GnwzObj.EntityState = EntityState.Delete;
                    }
                    DBManager.Instance.Delete(values.GnwzObj);
                }
                int indexDel = dict.SingleOrDefault(o => o.Value == g3eFid).Key;
                for (int i = indexDel; i < dict.Count - 1; i++)
                {
                    dict[i] = dict[i + 1];
                }
                dict.Remove(dict.Count - 1);
                lbSwitchCabinetcol.Items.RemoveAt(indexDel);

                if (index != 0)
                {
                    lbSwitchCabinetcol.SetSelected(index - 1, true);
                    //var kgg = DevEventHandler.GetDevTables(198, dict[index - 1]);

                    //pgSwitchCabinet.SelectedObject = kgg.DevObj;
                }
                else if (index == 0 && lbSwitchCabinetcol.Items.Count > 0)
                {
                    lbSwitchCabinetcol.SetSelected(0, true);
                    //var kgg = DevEventHandler.GetDevTables(198, dict[0]);
                    //GenerateHelper.SetAllReadOnly(kgg.DevObj,true);
                    //pgSwitchCabinet.SelectedObject = kgg.DevObj;
                }
                else
                {
                    AddSwitch_Click(null, null);
                }
                pgSwitchCabinet.Refresh();
                //更新开关柜里的开关状态
                UpdateDBEntity.UpdateSSKGG(entitys);
            }
            catch (Exception ex)
            {
                LogManager.Instance.Error(ex);
            }
            //finally
            //{
            //    //删除完成后清空填写了所属开关柜字段为当前开关柜的设备字段值
            //    var entities = DBManager.Instance.GetEntities<Gg_pd_gnwzmc_n>(o=>o.GNWZ_SSKGG==deleteFid.ToString());
            //    if (entities.Any())
            //    {
            //        foreach (var item in entities)
            //        {
            //            item.GNWZ_SSKGG = null;
            //            if (item.EntityState == EntityState.None)
            //                item.EntityState = EntityState.Update;
            //            DBManager.Instance.Update(item);
            //        }
            //    }
            //}
        }
Example #6
0
        /// <summary>
        /// 修改级联设备
        /// </summary>
        /// <param name="oldName"></param>
        /// <param name="newName"></param>
        private void ModifyDependence(string oldName, string newName)
        {
            if (string.IsNullOrEmpty(newName))
            {
                return;
            }
            if (oldName.Equals(newName))
            {
                PublicMethod.Instance.AlertDialog("修改前后名称一样,修改失败!\n");
                return;
            }
            // 更新台架的功能位置
            if (tj_gnwz == null)
            {
                return;
            }
            tj_gnwz.MC = newName;
            var result = UpdateDBEntity.UpdateGNWZ(tj_gnwz);

            if (!result)
            {
                LogManager.Instance.Error("更新台架功能位置属性出错!\n");
            }
            //更新台架自身公共属性
            if (tj_comm == null)
            {
                return;
            }
            tj_comm.SBMC     = newName;       //新名称
            tj_comm.CD_SSDW  = cb_ssdw.Text;  // 所属单位
            tj_comm.CD_SSBDZ = cb_ssbdz.Text; // 所属变电站
            tj_comm.CD_SSXL  = cb_ssxl.Text;  // 所属线路
            tj_comm.CD_DYDJ  = cb_dydj.Text;  // 电压等级
            tj_comm.CD_SMZQ  = cb_smzq.Text;  // 生命周期
            //tj_comm.GNWZ_SSGDS = cb_ssgds.Text; // 所属供电所
            result = UpdateDBEntity.UpdateCommon(tj_comm);
            if (!result)
            {
                return;
            }
            //更新台架标注
            UpdateDBText(g3eObject.G3E_FID, newName, oldName);
            //更新级联设备公共属性
            if (tj_devs_comm.Any())
            {
                foreach (var com in tj_devs_comm)
                {
                    if (string.IsNullOrEmpty(com.SBMC))
                    {
                        continue;
                    }
                    var oldTextString = com.SBMC;
                    if (string.IsNullOrEmpty(oldName) || !com.SBMC.Contains(oldName))
                    {
                        continue;
                    }
                    var newSBMC = com.SBMC.Replace(oldName, newName);
                    com.SBMC = newSBMC;
                    if (com.G3E_FNO == 148)
                    {
                        com.CD_SSDW  = cb_ssdw.Text;  // 所属单位
                        com.CD_SSBDZ = cb_ssbdz.Text; // 所属变电站
                        com.CD_SSXL  = cb_ssxl.Text;  // 所属线路
                        if (!String.IsNullOrEmpty(cb_dydj.Text))
                        {
                            com.CD_DYDJ = cb_dydj.Text; // 电压等级
                        }
                        com.CD_SMZQ = cb_smzq.Text;     // 生命周期
                        //com.GNWZ_SSGDS = cb_ssgds.Text; // 所属供电所
                    }
                    var bl = UpdateDBEntity.UpdateCommon(com);
                    if (bl)
                    {
                        //更新从属设备的标注
                        UpdateDBText(com.G3E_FID, newSBMC, oldTextString);
                    }
                }
                //更新级联设备功能位置属性
                foreach (var gnwz in tj_devs_gnwz)
                {
                    if (string.IsNullOrEmpty(gnwz.MC))
                    {
                        continue;
                    }
                    if (string.IsNullOrEmpty(oldName) || !gnwz.MC.Contains(oldName))
                    {
                        continue;
                    }
                    var newSBMC = gnwz.MC.Replace(oldName, newName);
                    gnwz.MC = newSBMC;
                    UpdateDBEntity.UpdateGNWZ(gnwz);
                }
                PublicMethod.Instance.ShowMessage("修改成功!\n");
            }
            else
            {
                PublicMethod.Instance.AlertDialog("台架无级联设备!");
            }
            //textBox_DF_OLDNAME.Text = newName;
        }