📄 ucdictgzzwh.cs
字号:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using Sybase.DataWindow;
using Qeb.Support;
using Qeb.Support.Common;
using Qeb.DBProxy;
namespace Qeb.GY
{
public partial class UCDictGzzWh : Qeb.GY.UCDictBase
{
//检索数据
private string m_RetrieveParam = "";
public UCDictGzzWh()
{
InitializeComponent();
}
private void UCDictGzzWh_Load(object sender, EventArgs e)
{
//初始化数据窗口
this.dwGzz.LibraryList = PBL.GyPbl;
this.dwGzz.DataWindowObject = GyDataObjects.D_Gy_GzzWh;
this.dwGzz.InitUI();
try
{
dwGzz.SetProperty("DataWindow.ReadOnly", "Yes");
}
catch (Exception ex)
{
MessageBox.Show("设置数据窗口只读属性发生异常:" + ex.Message);
}
//订阅消息
this.SubscribeEvent(MsgEventDefine.Dict_RefreshWithParam);
}
#region 函数
private DialogResult needSave()
{
DialogResult result = DialogResult.No;
if (this.m_IsModified)
{
result = MessageBox.Show(this, "数据已修改,是否需要保存?", MsgTitle.Prompt, MessageBoxButtons.YesNo, MessageBoxIcon.Question);
}
return result;
}
//是否重复输入数据验证函数
private int findWkdz(string wkdz, int editRow)
{
int findRow = dwGzz.FindRow("wkdz='" + wkdz + "'", 1, this.dwGzz.RowCount);
if (findRow == editRow)
{
if (editRow < dwGzz.RowCount)
{
findRow = dwGzz.FindRow("wkdz='" + wkdz + "'", editRow + 1, this.dwGzz.RowCount);
}
}
return findRow;
}
private void SetEnabled(bool ok)
{
if (ok)
{
this.btnModify.Enabled = true;
}
else
{
this.btnModify.Enabled = false;
btnAdd.Enabled = false;
btnStop.Enabled = false;
btnSave.Enabled = false;
}
}
#endregion
#region 消息处理
//消息处理
protected override void ProcessUIMessage(string messageId, UIMessageEventArgs e)
{
if (messageId == MsgEventDefine.Dict_RefreshWithParam)
{
FDictBase.TagInfo tagInfo;
try
{
tagInfo = (FDictBase.TagInfo)e.Values;
if (tagInfo.ControlName != "UCDictGzzWh")
return;
}
catch (Exception ex)
{
MessageBox.Show("处理刷新数据消息发生异常(转换参数出错):" + ex.Message, MsgTitle.Error);
return;
}
if (m_RetrieveParam != tagInfo.RefreshParam)
{
//检查是否需要保存
if (needSave() == DialogResult.Yes)
return;
m_RetrieveParam = tagInfo.RefreshParam;
this.RetrieveData(tagInfo.RefreshParam);
//如果是根目录,不允许修改
if (m_RetrieveParam == "*")
SetEnabled(false);
else
SetEnabled(true);
}
}
}
#endregion
//根据网卡地址或计算机名称查找记录
public override void FindInDw(string value)
{
if (value == null)
value = "";
int findRow = dwGzz.FindRow("wkdz like'" + value + "jsjmc like'"+value+"'", 1, dwGzz.RowCount);
if (findRow > 0)
{
dwGzz.ScrollToRow(findRow);
dwGzz.SetRow(findRow);
}
}
#region 数据完整性检查
private bool checkCsWh()
{
string colName = "";
string errorMsg = "";
int rowNum = 0;
int rowCount = 0;
DataBuffer buffer = DataBuffer.Primary;
find:
if (buffer == DataBuffer.Primary)
rowCount = dwGzz.RowCount;
else
rowCount = dwGzz.FilteredCount;
rowNum = 0;
do
{
rowNum = dwGzz.FindNextModifiedRow(rowNum, buffer);
if (rowNum > 0)
{
colName = "wkdz";
if (this.dwGzz.IsItemNull(rowNum, colName))
{
errorMsg = "网卡地址";
goto Error;
}
}
else
{
rowNum = rowCount;
}
}
while (rowNum < rowCount);
//处理过滤缓冲区
if (buffer == DataBuffer.Primary && dwGzz.FilteredCount > 0)
{
buffer = DataBuffer.Filter;
goto find;
}
Error:
if (errorMsg != "")
{
if (buffer == DataBuffer.Filter)
{
MessageBox.Show("数据输入不完整," + errorMsg + "没有输入,该记录已被过滤,重新设置过滤条件后可显示!", MsgTitle.Warning);
}
else
{
MessageBox.Show("数据输入不完整,第" + rowNum.ToString() + "行" + errorMsg + "没有输入!", MsgTitle.Warning);
this.dwGzz.ScrollToRow(rowNum);
this.dwGzz.Focus();
this.dwGzz.SetRow(rowNum);
this.dwGzz.SetColumn(colName);
}
return false;
}
return true;
}
#endregion
//检索数据
#region 检索数据
private void RetrieveData(string yyId)
{
try
{
DbProxyClient proxy = App.DbProxy;
proxy.Clear();
proxy.AddRetrieveParam("p_yyid", yyId);
proxy.Retrieve(this.dwGzz);
//检索子数据窗口 病区ID
DataWindowChild dwc = dwGzz.GetChild("yyid");
proxy.Clear();
proxy.Retrieve(dwc);
}
catch (Exception ex)
{
MessageBox.Show("检索数据出错:" + ex.Message, MsgTitle.Error);
}
finally
{
this.m_IsModified = false;
btnSave.Enabled = false;
}
}
#endregion
private void dwGzz_EditChanged(object sender, EditChangedEventArgs e)
{
if (!this.m_IsModified)
{
this.m_IsModified = true;
this.btnSave.Enabled = true;
}
}
private void dwGzz_ItemChanged(object sender, Sybase.DataWindow.ItemChangedEventArgs e)
{
switch (e.ColumnName)
{
case "wkdz":
if (e.Data == null || e.Data == "")
{
MessageBox.Show("不允许为空,请输入!");
e.Action = ItemChangedAction.Reject;
}
else
{
//检查是否存在重复参数ID
try
{
if (this.findWkdz(e.Data, e.RowNumber) > 0)
{
MessageBox.Show("网卡地址已存在,不允许重复!", MsgTitle.Prompt);
e.Action = ItemChangedAction.RejectAndAllowFocusChange;
}
}
catch (Exception ex)
{
MessageBox.Show("重复网卡地址是否已存在是发生异常:" + ex.Message, MsgTitle.Error);
e.Action = ItemChangedAction.Reject;
}
}
break;
}
}
private void dwGzz_ItemError(object sender, ItemErrorEventArgs e)
{
e.Action = ItemErrorAction.RejectWithNoMessage;
}
private void dwGzz_Click(object sender, EventArgs e)
{
}
#region buttons
//增加等...
//增加
private void btnAdd_Click(object sender, EventArgs e)
{
int row = dwGzz.InsertRow(0);
dwGzz.SetRow(row);
dwGzz.SetItemString(row, "yyid", m_RetrieveParam);
dwGzz.ScrollToRow(row);
dwGzz.Focus();
dwGzz.SetColumn("wkdz");
}
//删除
private void btnStop_Click(object sender, EventArgs e)
{
if (dwGzz.CurrentRow > 0)
{
//停用的记录如果是新增的,直接删除
RowStatus status = dwGzz.GetRowStatus(dwGzz.CurrentRow, DataBuffer.Primary);
if (status == RowStatus.New || status == RowStatus.NewAndModified)
{
dwGzz.DeleteRow(dwGzz.CurrentRow);
return;
}
//网卡地址
string wkdz = "";
if (!dwGzz.IsItemNull(dwGzz.CurrentRow, "wkdz"))
{
wkdz = dwGzz.GetItemString(dwGzz.CurrentRow, "wkdz");
}
DialogResult result = MessageBox.Show(this, "网卡地址为【" + wkdz + "】的信息将要被删除,您确定吗?", MsgTitle.Prompt, MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (result == DialogResult.OK)
{
this.dwGzz.DeleteRow(0);
this.m_IsModified = true;
this.btnSave.Enabled = true;
}
}
else
{
MessageBox.Show("请选择需要删除的网卡地址再单击删除按钮!", MsgTitle.Prompt);
}
//int rowNum = this.dwGzz.CurrentRow;
///if (rowNum > 0)
//{
// this.dwGzz.DeleteRow(0);
// this.m_IsModified = true;
// this.btnSave.Enabled = true;
// }
}
//修改
private void btnModify_Click(object sender, EventArgs e)
{
try
{
dwGzz.SetProperty("DataWindow.ReadOnly", "No");
}
catch (Exception ex)
{
MessageBox.Show("设置数据窗口只读属性发生异常:" + ex.Message);
return;
}
this.btnAdd.Enabled = true;
this.btnStop.Enabled = true;
}
//保存
private void btnSave_Click(object sender, EventArgs e)
{
dwGzz.AcceptText();
///检验数据完整性
if (!this.checkCsWh())
return;
try
{
DbProxyClient proxy = App.DbProxy;
proxy.Clear();
proxy.AddDataWindow(this.dwGzz);
proxy.Update();
this.m_IsModified = false;
btnSave.Enabled = false;
}
catch (Exception ex)
{
MessageBox.Show("保存参数发生异常:" + ex.Message, MsgTitle.Error);
}
}
//刷新
private void btnRefresh_Click(object sender, EventArgs e)
{
if (needSave() == DialogResult.Yes)
return;
this.RetrieveData(m_RetrieveParam);
}
//关闭
private void btnClose_Click(object sender, EventArgs e)
{
this.ParentForm.Close();
}
#endregion
private void UCDictGzzWh_Click(object sender, EventArgs e)
{
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -