frmmedicine.cs

来自「关于医院进销存的系统」· CS 代码 · 共 597 行 · 第 1/2 页

        private void tbChangJia_KeyPress(object sender, KeyPressEventArgs e)
        {
            if ((Keys)e.KeyChar == Keys.Enter)
            {
                tbLingShouJia.Focus();
                tbLingShouJia.SelectAll();
                e.Handled = true;
            }
        }

        private void tbLingShouJia_KeyPress(object sender, KeyPressEventArgs e)
        {
            if ((Keys)e.KeyChar == Keys.Enter)
            {
                tbPiFaJia.Focus();
                tbPiFaJia.SelectAll();
                e.Handled = true;
            }
        }

        private void tbPiFaJia_KeyPress(object sender, KeyPressEventArgs e)
        {
            if ((Keys)e.KeyChar == Keys.Enter)
            {
                tbJinHuoJia.Focus();
                tbJinHuoJia.SelectAll();
                e.Handled = true;
            }
        }

        private void tbJinHuoJia_KeyPress(object sender, KeyPressEventArgs e)
        {
            if ((Keys)e.KeyChar == Keys.Enter)
            {
                cbLeiBie.Focus();
                cbLeiBie.SelectAll();
                e.Handled = true;
            }
        }

        private void cbLeiBie_KeyPress(object sender, KeyPressEventArgs e)
        {
            if ((Keys)e.KeyChar == Keys.Enter)
            {
                tbBaoXianHao.Focus();
                tbBaoXianHao.SelectAll();
                e.Handled = true;
            }
        }

        private void tbBaoXianHao_KeyPress(object sender, KeyPressEventArgs e)
        {
            if ((Keys)e.KeyChar == Keys.Enter)
            {
                tbGongYingShangId.Focus();
                tbGongYingShangId.SelectAll();
                e.Handled = true;
            }
        }

        private void tbGongYingShangId_KeyPress(object sender, KeyPressEventArgs e)
        {
            if ((Keys)e.KeyChar == Keys.Enter)
            {
                tbGongYingShangName.Focus();
                tbGongYingShangName.SelectAll();
                e.Handled = true;
            }
        }

        private void btFirst_Click(object sender, EventArgs e)
        {
            bindingSource1.MoveFirst();
        }

        private void btPro_Click(object sender, EventArgs e)
        {
            bindingSource1.MovePrevious();
        }

        private void tbNext_Click(object sender, EventArgs e)
        {
            bindingSource1.MoveNext();
        }

        private void tbLast_Click(object sender, EventArgs e)
        {
            bindingSource1.MoveLast();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            if (tbExpression.Text.Trim() == "")
            {
                MessageBox.Show("请输入查询条件值！","信息提示");
                tbExpression.Focus();
                return;
            }
            try
            {
                if (cbFields.SelectedIndex != 0)
                {
                    if (cbOperator.Text == "like")
                    {
                        DataView dv = new DataView(dataSet1.Tables[0]);
                        dv.RowFilter = cbFields.Text + " like '*" + tbExpression.Text.Trim() + "*'";
                        bindingSource1.DataSource = dv;
                    }
                    else
                    {
                        DataView dv = new DataView(dataSet1.Tables[0]);
                        dv.RowFilter = cbFields.Text + cbOperator.Text + "'" + tbExpression.Text.Trim() + "'";
                        bindingSource1.DataSource = dv;
                    }
                }
                else
                {
                    if (cbOperator.Text == "like")
                    {
                        MessageBox.Show("当查询字段为药品编号时，条件运算符不能为like！","信息提示",MessageBoxButtons.OK,MessageBoxIcon.Exclamation);
                        cbFields.Focus();
                        return;
                    }
                    else
                    {
                        DataView dv = new DataView(dataSet1.Tables[0]);
                        dv.RowFilter = cbFields.Text + cbOperator.Text + tbExpression.Text.Trim();
                        bindingSource1.DataSource = dv;
                    }
                }
            }
            catch (Exception err)
            {
                ControlButtonState(false);
                MessageBox.Show("操作出现错误：" + err.Message, "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                cbFields.Focus();
            }
            ControlButtonState(false);
        }

        private void btAdd_Click(object sender, EventArgs e)
        {
            DataView dv = new DataView(dataSet1.Tables[0]);
            dv.Sort = "药品编号";
            bindingSource1.AddNew();
            if (dv.Count > 0)
            {
                tbId.Text = (int.Parse(dv[dv.Count - 1][0].ToString()) + 1).ToString();
            }
            else
                tbId.Text = "1";
            tbShengCanTime.Text = DateTime.Now.ToShortDateString();
            tbDaBao.Text = "0";
            tbZhongBao.Text = "0";
            tbChangJia.Text = "0";
            tbLingShouJia.Text = "0";
            tbPiFaJia.Text = "0";
            tbJinHuoJia.Text = "0";
            tbId.Focus();
            ControlButtonState(true);
        }

        private void tbId_TextChanged(object sender, EventArgs e)
        {
            if (!btSave.Enabled && bindingSource1.Count > 0)
                ControlButtonState(true);
        }

        private void btSave_Click(object sender, EventArgs e)
        {
                if (tbId.Text.Trim() == "" || tbName.Text.Trim() == "" || tbTiaoMa.Text == "" || tbPiHao.Text == "")
                {
                    MessageBox.Show("系统要求药品编号，药品条码，药品名称，药品注册证号不能为空！","信息提示",MessageBoxButtons.OK,MessageBoxIcon.Asterisk);
                    tbId.Focus();
                    return;
                }
                try
                {
                    bindingSource1.EndEdit();
                    da.Update(dataSet1.Tables[0]);
                    dataSet1.Tables[0].AcceptChanges();
                    ControlButtonState(false);
                }
                catch (Exception err)
                {
                    MessageBox.Show("操作出现错误：" + err.Message,"信息提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }
        }

        private void tbId_Enter(object sender, EventArgs e)
        {
            if (sender.GetType()==tbId.GetType())
                ((TextBox)sender).BackColor = tbExpression.BackColor;
            else
                ((ComboBox)sender).BackColor = tbExpression.BackColor;
        }

        private void tbId_Leave(object sender, EventArgs e)
        {
            if (sender.GetType() == tbId.GetType())
                ((TextBox)sender).BackColor = panel1.BackColor;
            else
                ((ComboBox)sender).BackColor = panel1.BackColor;
        }

        private void btDelete_Click(object sender, EventArgs e)
        {
            if (bindingSource1.Count < 1)
            {
                MessageBox.Show("没有任何数据可以删除！","信息提示",MessageBoxButtons.OK,MessageBoxIcon.Exclamation);
                return;
            }
            if (MessageBox.Show("您确实要删除这条数据吗？", "信息提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
            {
                try
                {
                    dataSet1.Tables[0].Rows[bindingSource1.Position].Delete();
                    da.Update(dataSet1.Tables[0]);
                    dataSet1.Tables[0].AcceptChanges();
                    ControlButtonState(false);
                }
                catch (Exception err)
                {
                    MessageBox.Show("操作出现错误："+err.Message,"信息提示",MessageBoxButtons.OK,MessageBoxIcon.Error);
                }
            }
        }

        private void bindingSource1_PositionChanged(object sender, EventArgs e)
        {
                ControlButtonState(false);
        }

        private void tbCancel_Click(object sender, EventArgs e)
        {
            bindingSource1.EndEdit();
            dataSet1.Tables[0].RejectChanges();
            ControlButtonState(false);
        }

        private void btExit_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void frmMedicine_FormClosing(object sender, FormClosingEventArgs e)
        {
            if (btSave.Enabled)
            {
                if (MessageBox.Show("数据已经改变，你要保存吗？", "信息提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
                    btSave_Click(null,null);
            }
        }

        private void button2_Click(object sender, EventArgs e)
        {
            bindingSource1.DataSource = dataSet1.Tables[0];
            ControlButtonState(false);
        }

        private void tbExpression_KeyPress(object sender, KeyPressEventArgs e)
        {
            try
            {
                if ((Keys)e.KeyChar == Keys.Back)
                    return;
                int.Parse(e.KeyChar.ToString());
            }
            catch { e.Handled = true; }
        }

        private void cbFields_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (cbFields.SelectedIndex == 0)
            {
                tbExpression.Text = "0";
                tbExpression.KeyPress += new KeyPressEventHandler(tbExpression_KeyPress);
            }
            else
            {
                tbExpression.Clear();
                tbExpression.KeyPress -= new KeyPressEventHandler(tbExpression_KeyPress);
            }
        }

        private void tbShengCanTime_KeyPress(object sender, KeyPressEventArgs e)
        {
            if ((Keys)e.KeyChar == Keys.Enter)
            {
                tbCanDi.Focus();
                tbCanDi.SelectAll();
                e.Handled = true;
            }
        }
    }
}