ucdictzgxx.cs

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

                    value = false;
                }
            }
            catch
            {
                value = false;
            }
            
            return value;
        }

        //保存
        private void btnSave_Click(object sender, EventArgs e)
        {
            if (!dwZgxxWh.AcceptText())
                return;
            //dwZgxxWh.AcceptText();
             if (CheckIntegrality())
             {
                 DbProxyClient proxy = App.DbProxy;
                 proxy.Clear();
                 StringBuilder qx = new StringBuilder();
                 string[] colNames = new string[] { "cfq", "mzq", "jsq", "dpq", "ssq", "hyq", "tjq", "hlq", "jcq", "yhq", "hxgr" };
                 string temp = "";
                 for (int i = 0; i < colNames.Length; i++)
                 {
                     if (dwZgxxWh.IsItemNull(1, colNames[i]))
                         qx.Append("0");
                     else
                     {
                         temp = dwZgxxWh.GetItemString(1, colNames[i]);
                         if (temp == "1")
                             qx.Append("1");
                         else
                             qx.Append("0");
                     }
                 }
                 temp = qx.ToString();
                 if (temp.Length < 20)
                 {
                     temp = temp.PadRight(20, '0');
                 }
                 dwZgxxWh.SetItemString(1, "qx", temp);
                 try
                 {
                     proxy.AddDataWindow(this.dwZgxxWh);
                     proxy.Update();
                     RetrieveData_Xx();
                     this.m_IsModified = false;
                     this.btnSave.Enabled = false;//保存
                     this.btnRefresh.Text = "返回";//刷新、取消
                     ShowdwZgxx();
                     MessageBox.Show("职工信息保存成功！");
                 }
                 catch (Exception ex)
                 {
                     MessageBox.Show("保存职工信息发生异常：" + ex.Message, MsgTitle.Error);
                 }
             }
             else
             {
                 MessageBox.Show("请确认职工工号和姓名或所属科室病区已经输入！");
                 return;
             }
        }

        //刷新、取消
        private void btnRefresh_Click(object sender, EventArgs e)
        {
            if (dwZgXx.Visible == true)
            {
                this.RetrieveData();
            }
            else
            {
                ShowdwZgxx();
            }
            btnAdd.Enabled = true;//增加
            btnStop.Enabled = true;//删除
        }

        private void btnPrint_Click(object sender, EventArgs e)
        {

        }

        private void btnExport_Click(object sender, EventArgs e)
        {

        }

        //关闭
        private void btnClose_Click(object sender, EventArgs e)
        {
            if (this.m_IsModified)
            {
                DialogResult result = MessageBox.Show(this, "数据已修改，是否需要保存？", MsgTitle.Prompt, MessageBoxButtons.YesNo, MessageBoxIcon.Question);
                if (result == DialogResult.Yes)
                {
                    return;
                }
                else
                {
                    this.ParentForm.Close();
                }
            }
            else
            {
                this.ParentForm.Close();
            }
        }

        private void dwZgXx_ItemError(object sender, Sybase.DataWindow.ItemErrorEventArgs e)
        {
            e.Action = ItemErrorAction.RejectWithNoMessage;
        }

        private void dwZgXx_ItemChanged(object sender, Sybase.DataWindow.ItemChangedEventArgs e)
        {
            //switch (e.ColumnName)
            //{
            //    case "zgid":
            //        if (e.Data == null || e.Data == "")
            //        {
            //            MessageBox.Show("职工ID不允许为空，请输入！");
            //            e.Action = ItemChangedAction.Reject;
            //        }
            //        break;
            //    case "gh":
            //        if (e.Data == null || e.Data == "")
            //        {
            //            MessageBox.Show("职工工号不允许为空，请输入！");
            //            e.Action = ItemChangedAction.Reject;
            //        }
            //        break;
            //    case "zhxm":
            //        if (e.Data == null || e.Data == "")
            //        {
            //            MessageBox.Show("职工名称不允许为空，请输入！");
            //            e.Action = ItemChangedAction.Reject;
            //        }
            //        break;
            //    case "sxksmc":
            //        if (e.Data == null || e.Data.Trim() == "")
            //        {
            //            dwZgXx.SetItemNull(e.RowNumber, "ylzid");
            //            return;
            //        }

            //        FSelect fSelect2 = null;
            //        try
            //        {
            //            fSelect2 = new FSelect();
            //            fSelect2.SetTitle("科室信息");
            //            string sql = "SELECT * FROM GY_KSXX WHERE ZFBZ=0 AND YQID='1' AND (KSID LIKE '" + e.Data + "%' OR " + App.mrSrm + " LIKE '" + e.Data + "%')";
            //            fSelect2.SetDataSource(sql, true);
            //            fSelect2.AddShowColumn("KSID", "科室ID", 200);
            //            fSelect2.AddShowColumn("KSMC", "科室名称", 400);
            //            fSelect2.AddMultiReturnColumn("KSID,KSMC");

            //            DialogResult dResult = fSelect2.ShowDialog(this);
            //            if (dResult == DialogResult.OK)
            //            {
            //                string[] retValue = fSelect2.ReturnValue;

            //                //科室ID
            //                dwZgXx.SetItemString(e.RowNumber, "szksid", retValue[0]);
            //                dwZgXx.SetItemString(e.RowNumber, "sxksmc", retValue[1]);
            //                e.Action = ItemChangedAction.RejectAndAllowFocusChange;
            //            }
            //            else
            //            {
            //                e.Action = ItemChangedAction.Reject;
            //                dwZgXx.SetItemNull(e.RowNumber, "szksid");
            //                dwZgXx.SetItemNull(e.RowNumber, "sxksmc");
            //            }
            //        }
            //        catch (Exception ex)
            //        {
            //            MessageBox.Show("取科室信息发生异常：" + ex.Message, MsgTitle.Error);
            //            e.Action = ItemChangedAction.Reject;
            //            dwZgXx.SetItemNull(e.RowNumber, "szksid");
            //            dwZgXx.SetItemNull(e.RowNumber, "sxksmc");
            //        }
            //        finally
            //        {
            //            if (fSelect2 != null)
            //                fSelect2.Dispose();
            //        }

            //        break;
            //}
            //this.m_IsModified = true;
            //this.btnSave.Enabled = true;
        }

        private void dwZgXx_EditChanged(object sender, Sybase.DataWindow.EditChangedEventArgs e)
        {
            if (!this.m_IsModified)
            {
                this.m_IsModified = true;
                this.btnSave.Enabled = true;
            }
        }

        private void dwZgXx_Click(object sender, EventArgs e)
        {
        }

        private void dwZgXx_DoubleClick(object seder, EventArgs e)
        {
            string zgid = "";
            int rowNum = dwZgXx.ObjectUnderMouse.RowNumber;
            if (rowNum > 0)
            {
                zgid = dwZgXx.GetItemString(rowNum, "zgid").ToString();
                ShowdwZgxxWh(zgid);
            }
        }
        #region DWZgXxEdit 事件
        #endregion
        //显示职工信息列表，stamp＝0 不用刷新数据，否则刷新。
        private void ShowdwZgxx(int stamp)
        {
            dwZgXx.Visible = true;
            dwZgxxWh.Visible = false;
            if (stamp != 0)
            {
            }
            else
            {
                DbProxyClient proxy = App.DbProxy;
                proxy.Clear();
                proxy.Retrieve(dwZgxxWh);
                dwZgXx.Refresh();
            }
            btnRefresh.Text = "取消";
        }

        private void dwZgxxWh_ItemChanged(object sender, Sybase.DataWindow.ItemChangedEventArgs e)
        {
            switch(e.ColumnName)
            {
                case "ksmc":
                    if (e.Data == null || e.Data.Trim() == "")
                    {
                        return;
                    }

                    FSelect fSelect2 = null;
                    try
                    {
                        fSelect2 = new FSelect();
                        fSelect2.SetTitle("科室信息");
                        string sql = "SELECT * FROM GY_KSXX WHERE ZFBZ=0 AND YQID='1' AND (KSID LIKE '" + e.Data + "%' OR " + App.mrSrm + " LIKE '" + e.Data + "%')";
                        fSelect2.SetDataSource(sql, true);
                        fSelect2.AddShowColumn("KSID", "科室ID", 200);
                        fSelect2.AddShowColumn("KSMC", "科室名称", 400);
                        fSelect2.AddMultiReturnColumn("KSID,KSMC");

                        DialogResult dResult = fSelect2.ShowDialog(this);
                        if (dResult == DialogResult.OK)
                        {
                            string[] retValue = fSelect2.ReturnValue;

                            //科室ID
                            dwZgxxWh.SetItemString(e.RowNumber, "szksid", retValue[0]);
                            dwZgxxWh.SetItemString(e.RowNumber, "ksmc", retValue[1]);
                            e.Action = ItemChangedAction.RejectAndAllowFocusChange;
                        }
                        else
                        {
                            e.Action = ItemChangedAction.Reject;
                            dwZgxxWh.SetItemNull(e.RowNumber, "szksid");
                            dwZgxxWh.SetItemNull(e.RowNumber, "ksmc");
                        }
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show("取科室信息发生异常：" + ex.Message, MsgTitle.Error);
                        e.Action = ItemChangedAction.Reject;
                        dwZgxxWh.SetItemNull(e.RowNumber, "szksid");
                        dwZgxxWh.SetItemNull(e.RowNumber, "ksmc");
                    }
                    finally
                    {
                        if (fSelect2 != null)
                            fSelect2.Dispose();
                    }
                break;
            }
            btnSave.Enabled = true;
            this.m_IsModified = true;
        }

        private void dwZgxxWh_ItemError(object sender, ItemErrorEventArgs e)
        {
            e.Action = ItemErrorAction.RejectWithNoMessage;
        }

        private void dwZgxxWh_EditChanged(object sender, EditChangedEventArgs e)
        {
            if (!this.m_IsModified)
            {
                this.m_IsModified = true;
                this.btnSave.Enabled = true;
            }
        }

        private void dwZgXx_ItemFocusChanged(object sender, ItemFocusChangedEventArgs e)
        {
            if (!dwZgXx.CurrentEdit.Empty)
                dwZgXx.CurrentEdit.SelectText(0, 60);
        }

        private void dwZgxxWh_ItemFocusChanged(object sender, ItemFocusChangedEventArgs e)
        {
            if (!dwZgxxWh.CurrentEdit.Empty)
                dwZgxxWh.CurrentEdit.SelectText(0, 60);
        }
    }
}