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); }
/// <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; } }
/// <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 ? "修改成功!" : "修改失败!"); } }
/// <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(); } }
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); // } // } //} }
/// <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; }