frmwarehouse.cs

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

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

namespace YYJXC
{
    public partial class frmWareHouse : Form
    {
        public frmWareHouse()
        {
            InitializeComponent();
        }

        private SqlDataAdapter warehouse_da = null;
        private DataView gongyingshang_dv = null;
        private BindingSource gongyingshang_bind = new BindingSource();
        private DataView medicine_dv = null;
        private BindingSource medicine_bind = new BindingSource();
        private DataSet ds = new DataSet();
        private void frmWareHouse_Load(object sender, EventArgs e)
        {
            this.WindowState = FormWindowState.Maximized;
            FillData();
            init();
        }
        public void FillData()
        {
            SqlConnection Conn = new SqlConnection("server=" + CLoad.ReadServer() + ";pwd=" + CLoad.ReadPwd() + ";uid=sa;database=YYJXC");
            warehouse_da = new SqlDataAdapter("select * from tb_warehouse_dateiled", Conn);
            SqlCommandBuilder warehouse_cb = new SqlCommandBuilder(warehouse_da);
            warehouse_da.Fill(ds, "tb_warehouse_dateiled");
            SqlDataAdapter gongyingshang_da = new SqlDataAdapter("select 供应商编号,供应商名称,拼音码,供应商地址,邮政编码,传真,联系电话 from tb_gongyingshang", Conn);
            gongyingshang_da.Fill(ds, "tb_gongyingshang");
            SqlDataAdapter medicine_da = new SqlDataAdapter("select * from tb_medicine",Conn);
            medicine_da.Fill(ds, "tb_medicine");
        }
        /// <summary>
        /// 初始化
        /// </summary>
        public void init()
        {
            tbRuKuDanHao.Clear();
            tbLuDanTime.Clear();
            tbGongYingShang.Clear();
            tbGongYingShangId.Clear();
            tbJingShouRen.Clear();
            listView1.Items.Clear();
            tbYaoName.Clear();
            tbShuLiang.Clear();
            tbRuKuPinZhong.Text = "0";
            tbHeJiShuLiang.Text = "0";
            tbHeJiMoney.Text = "0";
            DataView dv = new DataView(ds.Tables["tb_warehouse_dateiled"]);
            dv.Sort = "进贷单据号";
            if (dv.Count < 1)
                tbRuKuDanHao.Text = "RK" + DateTime.Now.ToString("yyyyMMdd") + "0001";
            else
            {
                string newStr = dv[dv.Count - 1]["进贷单据号"].ToString().Substring(2);
                tbRuKuDanHao.Text = "RK" + (long.Parse(newStr) + 1).ToString();
            }
            tbLuDanTime.Text = DateTime.Now.ToShortDateString();
            tbGongYingShang.Focus();
        }

        private void tbGongYingShang_TextChanged(object sender, EventArgs e)
        {
            try
            {
                tbGongYingShangId.Clear();
                gongyingshang_dv = new DataView(ds.Tables["tb_gongyingshang"]);
                gongyingshang_dv.RowFilter = "供应商名称 like '*" + tbGongYingShang.Text.Trim() + "*' or 拼音码 like '*" + tbGongYingShang.Text.Trim() + "*'";
                gongyingshang_bind.DataSource = gongyingshang_dv;
                dataGridView1.DataSource = null;
                dataGridView1.DataSource = gongyingshang_bind;
                if (tbGongYingShang.Text.Trim() != "" && gongyingshang_bind.Count > 0)
                {
                    dataGridView1.Columns[2].Visible = false;
                    dataGridView1.Visible = true;
                }
                else
                    dataGridView1.Visible = false;
            }
            catch { dataGridView1.Visible = false; }
        }

        private void tbGongYingShang_KeyPress(object sender, KeyPressEventArgs e)
        {
            if (listView1.Items.Count > 0)
            {
                MessageBox.Show("登记正在进行不能更换供应商！", "信息提示");
                e.Handled = true;
                tbYaoName.Focus();
                tbYaoName.SelectAll();
                return;
            }
            if ((Keys)e.KeyChar == Keys.Enter && dataGridView1.Visible)
            {
                tbGongYingShang.Text = gongyingshang_dv[gongyingshang_bind.Position]["供应商名称"].ToString();
                tbGongYingShangId.Text = gongyingshang_dv[gongyingshang_bind.Position]["供应商编号"].ToString();
                dataGridView1.Visible = false;
                tbJingShouRen.Focus();
                e.Handled = true;
            }
        }

        private void tbGongYingShang_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Up && dataGridView1.Visible)
            {
                gongyingshang_bind.Position -= 1;
                e.Handled = true;
            }
            if (e.KeyCode == Keys.Down && dataGridView1.Visible)
            {
                gongyingshang_bind.Position += 1;
                e.Handled = true;
            }
            if (e.KeyCode == Keys.PageDown && dataGridView1.Visible)
            {
                gongyingshang_dv.RowFilter = null;
                gongyingshang_bind.DataSource = gongyingshang_dv;
            }
        }

        private void tbGongYingShang_Leave(object sender, EventArgs e)
        {
            dataGridView1.Visible = false;
            if (gongyingshang_dv == null || gongyingshang_dv.Count < 1 || tbGongYingShang.Text.Trim() == "" )
            {
                tbGongYingShangId.Clear();
            }
        }

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

        private void tbYaoName_TextChanged(object sender, EventArgs e)
        {
            try
            {
                medicine_dv = new DataView(ds.Tables["tb_medicine"]);
                medicine_dv.RowFilter = "供贷商编号=" + tbGongYingShangId.Text + " and (药品名称 like '*" + tbYaoName.Text.Trim() + "*' or 拼音码 like '*" + tbYaoName.Text.Trim() + "*' or 通用名 like '*" + tbYaoName.Text.Trim() + "*')";
                medicine_bind.DataSource = medicine_dv;
                dataGridView1.DataSource = null;
                dataGridView1.DataSource = medicine_bind;
                if (tbYaoName.Text.Trim() != "" && medicine_bind.Count > 0)
                {
                    dataGridView1.Columns[0].Visible = false;
                    dataGridView1.Columns[1].Visible = false;
                    dataGridView1.Columns[3].Visible = false;
                    dataGridView1.Columns[4].Visible = false;
                    dataGridView1.Columns[5].Visible = false;
                    dataGridView1.Columns[7].Visible = false;
                    dataGridView1.Columns[9].Visible = false;
                    dataGridView1.Columns[10].Visible = false;
                    dataGridView1.Columns[11].Visible = false;
                    dataGridView1.Columns[12].Visible = false;
                    dataGridView1.Columns[13].Visible = false;
                    dataGridView1.Columns[16].Visible = false;
                    dataGridView1.Columns[17].Visible = false;
                    dataGridView1.Columns[21].Visible = false;
                    dataGridView1.Columns[22].Visible = false;
                    dataGridView1.Columns[23].Visible = false;
                    dataGridView1.Columns[24].Visible = false;
                    dataGridView1.Visible = true;
                }
                else
                    dataGridView1.Visible = false;
            }
            catch { dataGridView1.Visible = false; }
        }

        private void tbYaoName_KeyPress(object sender, KeyPressEventArgs e)
        {
            if (tbGongYingShangId.Text.Trim() == "")
            {
                e.Handled = true;
                MessageBox.Show("该供应商编号不存在！", "信息提示");
                tbGongYingShang.Focus();
                tbGongYingShang.SelectAll();
                return;
            }
            if ((Keys)e.KeyChar == Keys.Enter && dataGridView1.Visible)
            {
                tbYaoName.Text = medicine_dv[medicine_bind.Position]["药品名称"].ToString();
                dataGridView1.Visible = false;
                tbShuLiang.Text = "1";
                tbShuLiang.Focus();
                tbShuLiang.SelectAll();
                e.Handled = true;
            }
        }

        private void tbYaoName_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Up && dataGridView1.Visible)
            {