C#药库管理系统

最新推荐文章于 2023-06-10 08:52:25 发布

zhanglong200211

最新推荐文章于 2023-06-10 08:52:25 发布

阅读量1k

点赞数

分类专栏： SQL server html java 文章标签： c# java mysql

本文链接：https://blog.csdn.net/zhanglong200211/article/details/124312719

版权

本文介绍了一个使用C#编程语言开发的药库管理系统。系统集成了数据库管理，可能包括药品入库、出库、库存查询等功能，有效地实现了药品信息的管理和跟踪。

摘要由CSDN通过智能技术生成

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

namespace FromYaoDB
{
    public partial class FrmAdmin : Form
    {
        public String pwd1 = string.Empty;
        public String User1 = string.Empty;
        public FrmAdmin()
        {
            InitializeComponent();
        }

        private void tsmiClose_Click(object sender, EventArgs e)
        {
            DialogResult result = MessageBox.Show("确认退出程序吗？", "操作提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
            if (result == DialogResult.Yes)
            {
                Application.Exit();
            }
        }

        private void tsmiGuanoY_Click(object sender, EventArgs e)
        {
            FrmGuanYU frmGuanYU = new FrmGuanYU();
            frmGuanYU.ShowDialog();
        }

        private void tsmiInsert_Click(object sender, EventArgs e)
        {
            FrmInsert frmInsert = new FrmInsert();
            frmInsert.MdiParent = this;
            frmInsert.Show();
        }

        private void tsmiRuku_Click(object sender, EventArgs e)
        {
            FrmRuku frmruku = new FrmRuku();
            frmruku.MdiParent = this;
            frmruku.Show();
        }

        private void tsmiChuku_Click(object sender, EventArgs e)
        {
            FrmChuku frmChuku = new FrmChuku();
            frmChuku.MdiParent = this;
            frmChuku.Show();
        }

        private void tsmiSelectRuKu_Click(object sender, EventArgs e)
        {
            FrmSelectRuKu frmSelectRuKu = new FrmSelectRuKu();
            frmSelectRuKu.MdiParent = this;
            frmSelectRuKu.Show();
        }

        private void tsmiSelectChuKu_Click(object sender, EventArgs e)
        {
            FrmSelectChuKu frmSelectChuKu = new FrmSelectChuKu();
            frmSelectChuKu.MdiParent = this;
            frmSelectChuKu.Show();
        }

        private void 修改密码ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            FrmUp frmup=new FrmUp();
            frmup.MdiParent = this;
            frmup.User = this.User1;
            frmup.pwd = this.pwd1;
            frmup.Show();
        }

        private void FrmAdmin_FormClosing(object sender, FormClosingEventArgs e)
        {
            Application.Exit();
        }

        private void FrmAdmin_Load(object sender, EventArgs e)
        {

        }
    }
}






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


namespace FromYaoDB
{
    public partial class FrmChuku : Form
    {
        DBHelper helper = new DBHelper();
        DataSet ds = new DataSet();
        SqlDataAdapter adapter = null;
        DataView dv = null;
        public FrmChuku()
        {
            InitializeComponent();
        }

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

        private void FrmChuku_Load(object sender, EventArgs e)
        {
            BandDgv();
        }

        #region 绑定dgv
        private void BandDgv()
        {
            String sql = @"SELECT [RuKu].[Id],[YaoKu].YName,[InDate]
                        FROM [RuKu] inner join [YaoKu] on [RuKu].YaoId=[YaoKu].YaoId";
            try
            {
                adapter = new SqlDataAdapter(sql, helper.Connection);
                if (ds.Tables["RuKu"] != null)
                {
                    ds.Tables["RuKu"].Clear();
                }
                adapter.Fill(ds, "RuKu");
                dv = new DataView(ds.Tables["RuKu"]);
                this.dgvCangku.DataSource = dv;
            }
            catch (Exception e)
            {
                MessageBox.Show(e.Message);
            }
        }
        #endregion

        private void btnChuku_Click(object sender, EventArgs e)
        {
            if (!DeleteRuku())
            {
                return;   
            }
            InsertChuku(SelectYaoid());
            BandDgv();
        }

        #region 新增一条出库记录 
        private void InsertChuku(int Yid)
        {
            try
            {
                String sql = String.Format(@"INSERT INTO [ChuKu] VALUES({0},'{1}')"
                                    , Yid, this.dtpDate.Value.ToShortDateString());
                helper.OpenConnection();
                SqlCommand comm = new SqlCommand(sql, helper.Connection);
                int iRet = comm.ExecuteNonQuery();
                if (iRet==1)
                {
                    MessageBox.Show("出库成功！","系统提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
                }
                else
                {
                    MessageBox.Show("出库成功！", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                }
            }
            catch (Exception e)
            {
                MessageBox.Show(e.Message);
            }
            finally
            {
                helper.CloseConnection();
            }
            

        }
        #endregion

        #region 删除选中的这一条已入库信息
        private Boolean DeleteRuku()
        {
            String sql = String.Format(@"DELETE FROM [RuKu] WHERE [Id]={0}",
                                        Convert.ToInt32(this.dgvCangku.CurrentRow.Cells[0].Value));
            try
            {
                helper.OpenConnection();
                SqlCommand comm = new SqlCommand(sql, helper.Connection);
                int iRet = comm.ExecuteNonQuery();
                if (iRet == 1)
                {
                    return true;
                }
                else
                {
                    MessageBox.Show("系统出现错误请稍后重试", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return false ;
                }
            }
            catch (Exception a)
            {
                MessageBox.Show(a.Message);
                return false;
            }
            finall