ucdictzgxx.cs

基于C/S的医疗卫生管理系统

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Drawing;
using System.Data;
using System.Text;
using System.Windows.Forms;

using Sybase.DataWindow;

using Qeb.Support;
using Qeb.Support.Common;
using Qeb.DBProxy;
using Qeb.Control;

namespace Qeb.GY
{
    public partial class UCDictZgXx : Qeb.GY.UCDictBase
    {
        private string ZgId = "";
        private int rowId = 0;

        public UCDictZgXx()
        {
            InitializeComponent();
        }

        private void UCDictZgXx_Load(object sender, EventArgs e)
        {
            this.LookUpPromptText = "请输入职工ID或职工名称";

            //初始化数据窗口
            this.dwZgXx.LibraryList = PBL.GyPbl;
            this.dwZgxxWh.LibraryList = PBL.GyPbl;
            this.dwZgXx.DataWindowObject = GyDataObjects.D_Gy_ZgXx_Xx;
            this.dwZgxxWh.DataWindowObject = GyDataObjects.D_Gy_ZgXxWh;
            this.dwZgXx.InitUI();
            try
            {
                dwZgXx.SetProperty("DataWindow.ReadOnly", "Yes");
                dwZgXx.Visible = true;
                dwZgxxWh.Visible = false;
            }
            catch (Exception ex)
            {
                MessageBox.Show("设置数据窗口只读属性发生异常：" + ex.Message);
            }
            RetrieveData();
            //初始化按钮
            btnAdd.Enabled = true;//增加
            btnStop.Text = "停用";
            btnStop.Enabled = true;//删除
            btnModify.Enabled = false;//修改
            btnSave.Enabled = false;//保存
            btnRefresh.Enabled = true;//刷新、取消

            btnPrint.Enabled = false;//打印
            btnExport.Enabled = false;//导出
            btnClose.Enabled = true;//关闭
            //订阅消息         
            //this.SubscribeEvent(MsgEventDefine.Dict_RefreshWithParam);
        }

        //#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 != "UCDictZgXx")
        //                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 == "*")
        //            {
        //                btnAdd.Enabled = true;//增加
        //                btnStop.Enabled = true;//删除
        //                btnModify.Enabled = false;//修改
        //                btnSave.Enabled = false;//保存
        //                btnRefresh.Enabled = true;//刷新、取消

        //                btnPrint.Enabled = false;//打印
        //                btnExport.Enabled = false;//导出
        //                btnClose.Enabled = true;//关闭
        //            }
        //            else
        //            {
        //                btnAdd.Enabled = true;//增加
        //                btnStop.Enabled = true;//删除
        //                btnModify.Enabled = false;//修改
        //                btnSave.Enabled = false;//保存
        //                btnRefresh.Enabled = true;//刷新、取消

        //                btnPrint.Enabled = false;//打印
        //                btnExport.Enabled = false;//导出
        //                btnClose.Enabled = true;//关闭
        //            }
        //        }
        //    }
        //}
        //#endregion

        //判断是否需要保存
       // private DialogResult needSave()
        //{
        //    DialogResult result = DialogResult.No;
        //    if (this.m_IsModified)
        //    {
        //        result = MessageBox.Show(this, "数据已修改，是否需要保存？", MsgTitle.Prompt, MessageBoxButtons.YesNo, MessageBoxIcon.Question);
        //    }
        //    return result;
        //}

        //检索数据

        private void RetrieveData()
        {
            try
            {
                DbProxyClient proxy = App.DbProxy;
                proxy.Clear();
                proxy.Retrieve(this.dwZgXx);
            }
            catch (Exception ex)
            {
                MessageBox.Show("检索数据出错：" + ex.Message, MsgTitle.Error);
            }
            this.dwZgXx.SetSort("zgid");
            this.dwZgXx.Sort();
        }

        private void RetrieveData_Xx()
        {
            try
            {
                DbProxyClient proxy = App.DbProxy;
                proxy.Clear();
                proxy.AddRetrieveParam("zgid", ZgId);
                proxy.Retrieve(this.dwZgxxWh);
            }
            catch (Exception ex)
            {
                MessageBox.Show("检索数据出错：" + ex.Message, MsgTitle.Error);
            }
            btnAdd.Enabled = true;//增加
            btnStop.Enabled = true;//删除
        }

        #region 在数据窗口中查找记录
        public override void FindInDw(string value)
        {
            if (value == null)
                value = "";

            int findRow = dwZgXx.FindRow("zgid='" + value + "'or gh='" + value + "' or zgxm='" + value + "'", 1, dwZgXx.RowCount);
            if (findRow > 0)
            {
                dwZgXx.ScrollToRow(findRow);
                dwZgXx.SetRow(findRow);
            }
        }
        #endregion

        //添加职工工号
        private void btnAdd_Click(object sender, EventArgs e)
        {
            ShowdwZgxxWh("");
            dwZgxxWh.Refresh();
        }

        //显示职工信息 ,zgid为空为新建，不为空为修改
        private void ShowdwZgxxWh(string zgid)
        {
            DbProxyClient proxy = App.DbProxy;
            dwZgXx.Visible = false;
            dwZgxxWh.Visible = true;
            if (zgid == "")
            {
                zgid = Sequence.GetXhByName("SEQ_GY_ZGXX_ZGID");
                proxy.Clear();
                proxy.AddRetrieveParam("p_zgid", "*");
                proxy.Retrieve(dwZgxxWh);
                int rowIndex = dwZgxxWh.InsertRow(0);
                rowId = rowIndex;
                dwZgxxWh.SetRow(rowIndex);
                dwZgxxWh.ScrollToRow(rowIndex);
                dwZgxxWh.SetItemString(rowIndex, "zgid", zgid);
                dwZgxxWh.SetItemString(rowIndex, "zt", "0");
            }
            else
            {
                proxy.Clear();
                proxy.AddRetrieveParam("zgid", zgid);
                proxy.Retrieve(dwZgxxWh);
                
            }
            ZgId = zgid;
            try
            {
                DataWindowChild dwBq = dwZgxxWh.GetChild("szbqid");
                proxy.Clear();
                proxy.Retrieve(dwBq);
            }
            catch (Exception ex)
            {
                MessageBox.Show("处理子数据窗口发生异常：" + ex.Message);
            }
            btnAdd.Enabled = false;//增加
            btnStop.Enabled = false;//删除
            btnModify.Enabled = false;//修改
            btnSave.Enabled = false;//保存
            btnRefresh.Enabled = true;//刷新、取消

            btnPrint.Enabled = false;//打印
            btnExport.Enabled = false;//导出
            btnClose.Enabled = true;//关闭
            btnRefresh.Text = "取消";
        }

        private void ShowdwZgxx()
        {
            btnRefresh.Text = "刷新";
            if (this.m_IsModified)
            {
                DialogResult result = MessageBox.Show(this, "数据已修改，是否需要保存？", MsgTitle.Prompt, MessageBoxButtons.YesNo, MessageBoxIcon.Question);
                if (result == DialogResult.Yes)
                {
                    btnRefresh.Text = "取消";
                    return;
                }
                else
                {
                    btnSave.Enabled = false;//保存
                    btnRefresh.Enabled = true;//刷新、取消
                    m_IsModified = false;
                }
            }
            dwZgXx.Visible = true;
            dwZgxxWh.Visible = false;
            this.RetrieveData();
        }

        //停用职工工号
        private void btnStop_Click(object sender, EventArgs e)
        {
            DbProxyClient proxy = App.DbProxy;
            
            if (dwZgXx.CurrentRow > 0)
            {
                //停用的记录如果是新增的，直接删除
                RowStatus status = dwZgXx.GetRowStatus(dwZgXx.CurrentRow, DataBuffer.Primary);
                if (status == RowStatus.New || status == RowStatus.NewAndModified)
                {
                    dwZgXx.DeleteRow(dwZgXx.CurrentRow);
                    return;
                }
                DialogResult result = MessageBox.Show(this, "职工工号只能停用，您确定要停用吗？", MsgTitle.Prompt, MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
                if (result == DialogResult.OK)
                {
                    dwZgXx.SetItemString(dwZgXx.CurrentRow, "zt", "1");
                    proxy.AddDataWindow(this.dwZgXx);
                    proxy.Update();
                    RetrieveData();
                }
            }
            else
            {
                MessageBox.Show("请选择需要删除的用户再单击删除按钮！", MsgTitle.Prompt);
            }
        }

        private void btnModify_Click(object sender, EventArgs e)
        {
            //try
            //{
            //    dwZgXx.SetProperty("DataWindow.ReadOnly", "No");
            //}
            //catch (Exception ex)
            //{
            //    MessageBox.Show("设置数据窗口只读属性发生异常：" + ex.Message);
            //    return;
            //}

            //this.btnAdd.Enabled = true;
            //this.btnStop.Enabled = true;
        }

        //检查数据完整性  未完成
        private bool CheckIntegrality()
        {
            bool value = true;
            string zgGh = "";//职工工号
            string zgXm = "";//职工姓名
            string szks = "";//所在科室
            string szbq = "";//所在病区
            try
            {
                zgGh = dwZgxxWh.GetItemString(rowId, "gh").ToString();
                zgXm = dwZgxxWh.GetItemString(rowId, "zgxm").ToString();
                szks = dwZgxxWh.GetItemString(rowId, "szksid").ToString();
                szbq = dwZgxxWh.GetItemString(rowId, "szbqid").ToString();
                if (zgGh == "")
                {
                    value = false;
                }
                if (zgXm == "")
                {