From: XinqiBao <35754562+XinqiBao@users.noreply.github.com> Date: Thu, 8 Mar 2018 03:41:31 +0000 (-0500) Subject: All done X-Git-Url: https://git.xinqibao.xyz/HospitalManageSys.git/commitdiff_plain/e2b13d1a614e2ad5dd43019f31685e8a8c7cb5f2 All done --- e2b13d1a614e2ad5dd43019f31685e8a8c7cb5f2 diff --git a/.vs/HospitalManageSys/v15/.suo b/.vs/HospitalManageSys/v15/.suo new file mode 100644 index 0000000..fe4b6ca Binary files /dev/null and b/.vs/HospitalManageSys/v15/.suo differ diff --git a/HospitalManageSys.sln b/HospitalManageSys.sln new file mode 100644 index 0000000..bb1f8e4 --- /dev/null +++ b/HospitalManageSys.sln @@ -0,0 +1,20 @@ + +Microsoft Visual Studio Solution File, Format Version 11.00 +# Visual Studio 2010 +Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "HospitalManageSys", "HospitalManageSys\HospitalManageSys.csproj", "{EC5DF48B-BBEC-4678-939C-728E4FE1A2B9}" +EndProject +Global + GlobalSection(SolutionConfigurationPlatforms) = preSolution + Debug|x86 = Debug|x86 + Release|x86 = Release|x86 + EndGlobalSection + GlobalSection(ProjectConfigurationPlatforms) = postSolution + {EC5DF48B-BBEC-4678-939C-728E4FE1A2B9}.Debug|x86.ActiveCfg = Debug|x86 + {EC5DF48B-BBEC-4678-939C-728E4FE1A2B9}.Debug|x86.Build.0 = Debug|x86 + {EC5DF48B-BBEC-4678-939C-728E4FE1A2B9}.Release|x86.ActiveCfg = Release|x86 + {EC5DF48B-BBEC-4678-939C-728E4FE1A2B9}.Release|x86.Build.0 = Release|x86 + EndGlobalSection + GlobalSection(SolutionProperties) = preSolution + HideSolutionNode = FALSE + EndGlobalSection +EndGlobal diff --git a/HospitalManageSys.suo b/HospitalManageSys.suo new file mode 100644 index 0000000..f0ba8b4 Binary files /dev/null and b/HospitalManageSys.suo differ diff --git a/HospitalManageSys/Form_Adminisrtator.cs b/HospitalManageSys/Form_Adminisrtator.cs new file mode 100644 index 0000000..afe4b73 --- /dev/null +++ b/HospitalManageSys/Form_Adminisrtator.cs @@ -0,0 +1,354 @@ +using System; +using System.Collections.Generic; +using System.ComponentModel; +using System.Data; +using System.Drawing; +using System.Linq; +using System.Text; +using System.Windows.Forms; +using MySql.Data.MySqlClient; +using System.IO; + +namespace HospitalManageSys +{ + public partial class Form_Adminisrtator : Form + { + MySqlConnection conn; + MainForm mf; + + public Form_Adminisrtator(MySqlConnection connector, MainForm mainform) + { + InitializeComponent(); + + conn = connector; + mf = mainform; + } + +// string strcon = @"Data Source=localhost;Database=hospitalmanagesys;User Id=root; +// Password=123456;Allow User Variables=True"; + string FileNamePath = ""; + /// + /// 员工查询 + /// + /// + /// + private void button1_Click(object sender, EventArgs e) + { + if (tb_id.Text == "") + { + MessageBox.Show("请输入员工编号！"); + return; + } + //MySqlConnection conn = new MySqlConnection(strcon);//新建数据库连接对象 + string StrSelcet = @"SELECT Admin_name,Admin_password,Admin_sex,Admin_job,Admin_department,Admin_fee, +Admin_photo,Admin_comment,Admin_capability FROM Administrator WHERE Admin_ID='" + tb_id.Text + "'";//sql查找语句 + MySqlCommand cmd = new MySqlCommand(StrSelcet, conn); + try + { + conn.Open();//打开数据库 + MySqlDataReader sdr = cmd.ExecuteReader(); + MemoryStream memStream = null;//定义一个内存流 + if (sdr.HasRows)//如果有记录 + { + sdr.Read();//读取第一行记录 + tb_name.Text = sdr["Admin_name"].ToString();//读取姓名 + //tb_password.Text = sdr["Admin_password"].ToString();//读取密码 + cb_sex.Text = sdr["Admin_sex"].ToString();//读取性别 + cb_job.Text = sdr["Admin_job"].ToString();//读取职位 + cb_department.Text = sdr["Admin_department"].ToString();//读取科室 + tb_fee.Text = sdr["Admin_fee"].ToString();//读取挂号费 + tb_comment.Text = sdr["Admin_comment"].ToString();//读取备注 + if (this.pb_photo.Image != null)//原有图片销毁 + pb_photo.Image = null; + if (sdr["Admin_photo"] != System.DBNull.Value)//如果有照片 + { + byte[] images = (byte[])sdr["Admin_photo"]; + memStream = new MemoryStream(images);//字节流转化为内存流 + pb_photo.Image = Image.FromStream(memStream);//内存流转换为照片 + memStream.Close(); + } + int a = Convert.ToInt32(sdr["Admin_capability"].ToString());//读取职能转化为int类型 + if ((a & 1) != 0) + check_1.Checked = true; + else + check_1.Checked = false; + if ((a & 2) != 0) + check_2.Checked = true; + else + check_2.Checked = false; + if ((a & 4) != 0) + check_3.Checked = true; + else + check_3.Checked = false; + if ((a & 8) != 0) + check_4.Checked = true; + else + check_4.Checked = false; + if ((a & 16) != 0) + check_5.Checked = true; + else + check_5.Checked = false; + if ((a & 32) != 0) + check_6.Checked = true; + else + check_6.Checked = false; + } + else + MessageBox.Show("没有此员工！"); + + if (!sdr.IsClosed)//关闭sdr + sdr.Close(); + } + catch (Exception ex) + { + MessageBox.Show(ex.Message); + } + finally + { + if (conn.State == ConnectionState.Open)//如果数据处于连接状态，关闭连接 + conn.Close(); + } + } + /// + /// 员工添加 + /// + /// + /// + private void button2_Click(object sender, EventArgs e) + { + if (tb_id.Text == "" || tb_name.Text == "" || cb_job.Text == "" || cb_sex.Text == "") + { + MessageBox.Show("请输入完整信息"); + return; + } + string StrInsert; + //MySqlConnection conn = new MySqlConnection(strcon);//新建数据库连接对象 + if (FileNamePath != "") + { + StrInsert = @"INSERT INTO Administrator(Admin_ID,Admin_name,Admin_sex,Admin_job,Admin_department, +Admin_fee,Admin_photo,Admin_comment,Admin_capability,Admin_password) VALUES (@Admin_ID,@Admin_name,@Admin_sex,@Admin_job,@Admin_department, +@Admin_fee,@Admin_photo,@Admin_comment,@Admin_capability,@Admin_password)"; + } + else + { + StrInsert = @"INSERT INTO Administrator(Admin_ID,Admin_name,Admin_sex,Admin_job,Admin_department, +Admin_fee,Admin_comment,Admin_capability,Admin_password) VALUES (@Admin_ID,@Admin_name,@Admin_sex,@Admin_job,@Admin_department, +@Admin_fee,@Admin_comment,@Admin_capability,@Admin_password)"; + } + MySqlCommand cmd = new MySqlCommand(StrInsert, conn); + //添加参数 + cmd.Parameters.Add("@Admin_ID", MySqlDbType.VarChar, 11).Value = tb_id.Text; + cmd.Parameters.Add("@Admin_name", MySqlDbType.VarChar, 20).Value = tb_name.Text; + cmd.Parameters.Add("@Admin_password", MySqlDbType.Int32,11).Value = tb_password.Text.GetHashCode(); + cmd.Parameters.Add("@Admin_sex", MySqlDbType.VarChar, 2).Value = cb_sex.Text; + cmd.Parameters.Add("@Admin_job", MySqlDbType.VarChar, 20).Value = cb_job.Text; + cmd.Parameters.Add("@Admin_department", MySqlDbType.VarChar, 50).Value = cb_department.Text; + cmd.Parameters.Add("@Admin_fee", MySqlDbType.Decimal).Value = tb_fee.Text; + cmd.Parameters.Add("@Admin_comment", MySqlDbType.VarChar, 100).Value = tb_comment.Text; + if (FileNamePath != "")//如果照片不为空，添加照片 + { + FileStream fs = null;//以文件流方式读取照片 + fs = new FileStream(FileNamePath, FileMode.Open, FileAccess.Read); + byte[] imageBytes = new byte[Convert.ToInt32(fs.Length)];//定义照片长度数组 + BinaryReader br = new BinaryReader(fs); + imageBytes = br.ReadBytes(Convert.ToInt32(fs.Length));//图片转换成二进制流 + fs.Close(); + cmd.Parameters.Add("@Admin_photo", MySqlDbType.MediumBlob);//选择MediumBlob类型 + cmd.Parameters["@Admin_photo"].Value = imageBytes;//给@Admin_photo参数赋值 + } + int ability;//定义职能 + int a1 = check_1.Checked ? 1 : 0; + int a2 = check_2.Checked ? 2 : 0; + int a3 = check_3.Checked ? 4 : 0; + int a4 = check_4.Checked ? 8 : 0; + int a5 = check_5.Checked ? 16 : 0; + int a6 = check_6.Checked ? 32 : 0; + ability = a1 | a2 | a3 | a4 | a5 | a6; + cmd.Parameters.Add("@Admin_capability", MySqlDbType.Bit, 8); + cmd.Parameters["@Admin_capability"].Value = ability; + + try + { + conn.Open();//打开数据库连接 + cmd.ExecuteNonQuery();//执行sql语句 + MessageBox.Show("保存成功！"); + } + catch (Exception ex) + { + MessageBox.Show("出错！" + ex.Message); + } + finally + { + conn.Close();//关闭数据库连接 + FileNamePath = ""; + } + } + /// + /// 员工删除 + /// + /// + /// + private void button3_Click(object sender, EventArgs e) + { + if (tb_id.Text == "") + { + MessageBox.Show("请输入员工编号"); + return; + } + //MySqlConnection conn = new MySqlConnection(strcon);////新建数据库连接对象 + string StrDel = "DELETE FROM Administrator WHERE Admin_ID=@Admin_ID"; + MySqlCommand cmd = new MySqlCommand(StrDel, conn); + cmd.Parameters.Add("@Admin_ID", MySqlDbType.VarChar, 11).Value = tb_id.Text; + try + { + conn.Open();//打开数据库连接 + int a = cmd.ExecuteNonQuery();//执行sql语句 + if (a == 1)//如果受影响的行数为1，则删除成功 + MessageBox.Show("删除成功！"); + else + MessageBox.Show("数据库中没有此员工！"); + } + catch (Exception ex) + { + MessageBox.Show(ex.Message); + } + finally + { + conn.Close();//关闭数据库连接 + } + } + /// + /// 员工修改 + /// + /// + /// + private void button4_Click(object sender, EventArgs e) + { + if (tb_id.Text == "") + { + MessageBox.Show("请输入员工编号"); + return; + } + //MySqlConnection conn = new MySqlConnection(strcon); + string StrUpdate = "UPDATE Administrator SET "; + StrUpdate += "Admin_name='" + tb_name.Text + "',";//修改姓名 + //StrUpdate += "Admin_password='" + tb_password.Text + "',";//修改密码 + StrUpdate += "Admin_sex='" + cb_sex.Text + "',";//修改性别 + StrUpdate += "Admin_job='" + cb_job.Text + "',";//修改职位 + StrUpdate += "Admin_department='" + cb_department.Text + "',";//修改科室 + StrUpdate += "Admin_fee='" + tb_fee.Text + "',";//修改挂号费 + + if (FileNamePath != "")//如果选择了照片 + { + FileStream fs = null; + fs = new FileStream(FileNamePath, FileMode.Open, FileAccess.Read); + byte[] imageBytes = new byte[fs.Length]; + BinaryReader br = new BinaryReader(fs); + imageBytes = br.ReadBytes(Convert.ToInt32(fs.Length));//图片转换成二进制流 + fs.Close(); + StrUpdate += "Admin_photo='" + imageBytes + "',"; + } + int ability;//定义职能 + int a1 = check_1.Checked ? 1 : 0; + int a2 = check_2.Checked ? 2 : 0; + int a3 = check_3.Checked ? 4 : 0; + int a4 = check_4.Checked ? 8 : 0; + int a5 = check_5.Checked ? 16 : 0; + int a6 = check_6.Checked ? 32 : 0; + ability = a1 | a2 | a3 | a4 | a5 | a6; + StrUpdate += "Admin_capability='" + ability + "',";//修改职能 + StrUpdate += "Admin_comment='" + tb_comment.Text + "'";//修改备注 + StrUpdate += "WHERE Admin_ID='" + tb_id.Text + "'"; + MySqlCommand cmd = new MySqlCommand(StrUpdate, conn); + try + { + conn.Open(); + int b = cmd.ExecuteNonQuery(); + if (b == 1) + MessageBox.Show("修改成功！"); + else + MessageBox.Show("数据库中没有此员工！"); + } + catch (Exception ex) + { + MessageBox.Show("出错，没有完成修改！" + ex.Message); + } + finally + { + conn.Close(); + FileNamePath = ""; + } + + } + /// + /// 选择照片 + /// + /// + /// + private void pb_photo_Click(object sender, EventArgs e) + { + OpenFileDialog ofd = new OpenFileDialog();//实例化打开文件对话框 + ofd.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.Personal); + ofd.Filter = "jpg 图片|*.jpg|gif 图片|*.gif|所有文件(*.*)|*.*";//设置打开文件类型 + if (ofd.ShowDialog(this) == DialogResult.OK) + { + FileNamePath = ofd.FileName;//获取文件路径 + pb_photo.Image = Image.FromFile(FileNamePath);//将照片显示在pb_photo中 + } + } + /// + /// 清空操作 + /// + /// + /// + private void button5_Click(object sender, EventArgs e) + { + tb_id.Text = ""; + tb_name.Text = ""; + tb_password.Text = ""; + cb_department.Text = ""; + tb_fee.Text = ""; + tb_comment.Text = ""; + cb_sex.Text = ""; + cb_job.Text = ""; + pb_photo.Image = null; + check_1.Checked = false; + check_2.Checked = false; + check_3.Checked = false; + check_4.Checked = false; + check_5.Checked = false; + check_6.Checked = false; + } + /// + /// 显示所有员工信息 + /// + /// + /// + private void button6_Click(object sender, EventArgs e) + { + string StrSelcet = @"SELECT Admin_ID,Admin_name,Admin_sex,Admin_job,Admin_department,Admin_comment FROM Administrator";//sql查找语句 + //MySqlConnection conn = new MySqlConnection(strcon); + try + { + conn.Open(); + MySqlDataAdapter msda = new MySqlDataAdapter(StrSelcet, conn); + DataSet dataSet = new DataSet("Syxx"); + msda.Fill(dataSet); + dataGridView1.DataSource = dataSet.Tables[0]; + } + catch (Exception ex) + { + MessageBox.Show("出错" + ex.Message); + } + finally + { + conn.Close(); + } + } + + private void Form_Adminisrtator_Load(object sender, EventArgs e) + { + + } + } +} diff --git a/HospitalManageSys/Form_Adminisrtator.designer.cs b/HospitalManageSys/Form_Adminisrtator.designer.cs new file mode 100644 index 0000000..7f7dd71 --- /dev/null +++ b/HospitalManageSys/Form_Adminisrtator.designer.cs @@ -0,0 +1,505 @@ +namespace HospitalManageSys +{ + partial class Form_Adminisrtator + { + /// + /// 必需的设计器变量。 + /// + private System.ComponentModel.IContainer components = null; + + /// + /// 清理所有正在使用的资源。 + /// + /// 如果应释放托管资源，为 true；否则为 false。 + protected override void Dispose(bool disposing) + { + if (disposing && (components != null)) + { + components.Dispose(); + } + base.Dispose(disposing); + } + + #region Windows 窗体设计器生成的代码 + + /// + /// 设计器支持所需的方法 - 不要 + /// 使用代码编辑器修改此方法的内容。 + /// + private void InitializeComponent() + { + this.groupBox1 = new System.Windows.Forms.GroupBox(); + this.button5 = new System.Windows.Forms.Button(); + this.button4 = new System.Windows.Forms.Button(); + this.button3 = new System.Windows.Forms.Button(); + this.button2 = new System.Windows.Forms.Button(); + this.pb_photo = new System.Windows.Forms.PictureBox(); + this.cb_department = new System.Windows.Forms.ComboBox(); + this.cb_job = new System.Windows.Forms.ComboBox(); + this.cb_sex = new System.Windows.Forms.ComboBox(); + this.tb_fee = new System.Windows.Forms.TextBox(); + this.tb_comment = new System.Windows.Forms.TextBox(); + this.tb_password = new System.Windows.Forms.TextBox(); + this.tb_name = new System.Windows.Forms.TextBox(); + this.label6 = new System.Windows.Forms.Label(); + this.label7 = new System.Windows.Forms.Label(); + this.label5 = new System.Windows.Forms.Label(); + this.label4 = new System.Windows.Forms.Label(); + this.label8 = new System.Windows.Forms.Label(); + this.label3 = new System.Windows.Forms.Label(); + this.label2 = new System.Windows.Forms.Label(); + this.button1 = new System.Windows.Forms.Button(); + this.tb_id = new System.Windows.Forms.TextBox(); + this.label1 = new System.Windows.Forms.Label(); + this.groupBox2 = new System.Windows.Forms.GroupBox(); + this.button6 = new System.Windows.Forms.Button(); + this.所有员工信息 = new System.Windows.Forms.GroupBox(); + this.dataGridView1 = new System.Windows.Forms.DataGridView(); + this.groupBox3 = new System.Windows.Forms.GroupBox(); + this.check_4 = new System.Windows.Forms.CheckBox(); + this.check_5 = new System.Windows.Forms.CheckBox(); + this.check_1 = new System.Windows.Forms.CheckBox(); + this.check_6 = new System.Windows.Forms.CheckBox(); + this.check_2 = new System.Windows.Forms.CheckBox(); + this.check_3 = new System.Windows.Forms.CheckBox(); + this.groupBox1.SuspendLayout(); + ((System.ComponentModel.ISupportInitialize)(this.pb_photo)).BeginInit(); + this.groupBox2.SuspendLayout(); + this.所有员工信息.SuspendLayout(); + ((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).BeginInit(); + this.groupBox3.SuspendLayout(); + this.SuspendLayout(); + // + // groupBox1 + // + this.groupBox1.Controls.Add(this.button5); + this.groupBox1.Controls.Add(this.button4); + this.groupBox1.Controls.Add(this.button3); + this.groupBox1.Controls.Add(this.button2); + this.groupBox1.Controls.Add(this.pb_photo); + this.groupBox1.Controls.Add(this.cb_department); + this.groupBox1.Controls.Add(this.cb_job); + this.groupBox1.Controls.Add(this.cb_sex); + this.groupBox1.Controls.Add(this.tb_fee); + this.groupBox1.Controls.Add(this.tb_comment); + this.groupBox1.Controls.Add(this.tb_password); + this.groupBox1.Controls.Add(this.tb_name); + this.groupBox1.Controls.Add(this.label6); + this.groupBox1.Controls.Add(this.label7); + this.groupBox1.Controls.Add(this.label5); + this.groupBox1.Controls.Add(this.label4); + this.groupBox1.Controls.Add(this.label8); + this.groupBox1.Controls.Add(this.label3); + this.groupBox1.Controls.Add(this.label2); + this.groupBox1.Location = new System.Drawing.Point(8, 95); + this.groupBox1.Name = "groupBox1"; + this.groupBox1.Size = new System.Drawing.Size(469, 223); + this.groupBox1.TabIndex = 0; + this.groupBox1.TabStop = false; + this.groupBox1.Text = "员工详细信息"; + // + // button5 + // + this.button5.Location = new System.Drawing.Point(380, 160); + this.button5.Name = "button5"; + this.button5.Size = new System.Drawing.Size(75, 23); + this.button5.TabIndex = 5; + this.button5.Text = "清空(&C)"; + this.button5.UseVisualStyleBackColor = true; + this.button5.Click += new System.EventHandler(this.button5_Click); + // + // button4 + // + this.button4.Location = new System.Drawing.Point(380, 113); + this.button4.Name = "button4"; + this.button4.Size = new System.Drawing.Size(75, 23); + this.button4.TabIndex = 4; + this.button4.Text = "修改(&M)"; + this.button4.UseVisualStyleBackColor = true; + this.button4.Click += new System.EventHandler(this.button4_Click); + // + // button3 + // + this.button3.Location = new System.Drawing.Point(380, 73); + this.button3.Name = "button3"; + this.button3.Size = new System.Drawing.Size(75, 23); + this.button3.TabIndex = 4; + this.button3.Text = "删除(&D)"; + this.button3.UseVisualStyleBackColor = true; + this.button3.Click += new System.EventHandler(this.button3_Click); + // + // button2 + // + this.button2.Location = new System.Drawing.Point(380, 30); + this.button2.Name = "button2"; + this.button2.Size = new System.Drawing.Size(75, 23); + this.button2.TabIndex = 4; + this.button2.Text = "添加(&A)"; + this.button2.UseVisualStyleBackColor = true; + this.button2.Click += new System.EventHandler(this.button2_Click); + // + // pb_photo + // + this.pb_photo.BackColor = System.Drawing.SystemColors.ActiveBorder; + this.pb_photo.BackgroundImage = global::HospitalManageSys.Properties.Resources.QQ截图20161101204141; + this.pb_photo.BackgroundImageLayout = System.Windows.Forms.ImageLayout.Stretch; + this.pb_photo.ErrorImage = null; + this.pb_photo.Location = new System.Drawing.Point(243, 30); + this.pb_photo.Name = "pb_photo"; + this.pb_photo.Size = new System.Drawing.Size(119, 153); + this.pb_photo.SizeMode = System.Windows.Forms.PictureBoxSizeMode.StretchImage; + this.pb_photo.TabIndex = 3; + this.pb_photo.TabStop = false; + this.pb_photo.Click += new System.EventHandler(this.pb_photo_Click); + // + // cb_department + // + this.cb_department.FormattingEnabled = true; + this.cb_department.Items.AddRange(new object[] { + "办公室", + "财务科", + "护理科", + "后勤部", + "内科", + "外科", + "妇科", + "男科", + "儿科", + "五官科", + "肿瘤科", + "皮肤科", + "放射科", + "中医科"}); + this.cb_department.Location = new System.Drawing.Point(82, 136); + this.cb_department.Name = "cb_department"; + this.cb_department.Size = new System.Drawing.Size(135, 20); + this.cb_department.TabIndex = 2; + // + // cb_job + // + this.cb_job.FormattingEnabled = true; + this.cb_job.Items.AddRange(new object[] { + "院长", + "副院长", + "科室主任", + "护士长", + "财务主任", + "门诊医生", + "护士", + "药房会计", + "药房库管", + "挂号/收银员"}); + this.cb_job.Location = new System.Drawing.Point(82, 110); + this.cb_job.Name = "cb_job"; + this.cb_job.Size = new System.Drawing.Size(135, 20); + this.cb_job.TabIndex = 2; + // + // cb_sex + // + this.cb_sex.FormattingEnabled = true; + this.cb_sex.Items.AddRange(new object[] { + "男", + "女"}); + this.cb_sex.Location = new System.Drawing.Point(82, 84); + this.cb_sex.Name = "cb_sex"; + this.cb_sex.Size = new System.Drawing.Size(135, 20); + this.cb_sex.TabIndex = 2; + // + // tb_fee + // + this.tb_fee.Location = new System.Drawing.Point(82, 162); + this.tb_fee.Name = "tb_fee"; + this.tb_fee.Size = new System.Drawing.Size(137, 21); + this.tb_fee.TabIndex = 1; + // + // tb_comment + // + this.tb_comment.Location = new System.Drawing.Point(80, 189); + this.tb_comment.Name = "tb_comment"; + this.tb_comment.Size = new System.Drawing.Size(375, 21); + this.tb_comment.TabIndex = 1; + // + // tb_password + // + this.tb_password.Location = new System.Drawing.Point(82, 57); + this.tb_password.Name = "tb_password"; + this.tb_password.PasswordChar = '*'; + this.tb_password.Size = new System.Drawing.Size(135, 21); + this.tb_password.TabIndex = 1; + // + // tb_name + // + this.tb_name.Location = new System.Drawing.Point(82, 30); + this.tb_name.Name = "tb_name"; + this.tb_name.Size = new System.Drawing.Size(135, 21); + this.tb_name.TabIndex = 1; + // + // label6 + // + this.label6.AutoSize = true; + this.label6.Location = new System.Drawing.Point(8, 192); + this.label6.Name = "label6"; + this.label6.Size = new System.Drawing.Size(59, 12); + this.label6.TabIndex = 0; + this.label6.Text = "备 注:"; + // + // label7 + // + this.label7.AutoSize = true; + this.label7.Location = new System.Drawing.Point(12, 168); + this.label7.Name = "label7"; + this.label7.Size = new System.Drawing.Size(59, 12); + this.label7.TabIndex = 0; + this.label7.Text = "挂 号 费:"; + // + // label5 + // + this.label5.AutoSize = true; + this.label5.Location = new System.Drawing.Point(10, 139); + this.label5.Name = "label5"; + this.label5.Size = new System.Drawing.Size(59, 12); + this.label5.TabIndex = 0; + this.label5.Text = "科 室:"; + // + // label4 + // + this.label4.AutoSize = true; + this.label4.Location = new System.Drawing.Point(12, 113); + this.label4.Name = "label4"; + this.label4.Size = new System.Drawing.Size(59, 12); + this.label4.TabIndex = 0; + this.label4.Text = "职 位:"; + // + // label8 + // + this.label8.AutoSize = true; + this.label8.Location = new System.Drawing.Point(10, 60); + this.label8.Name = "label8"; + this.label8.Size = new System.Drawing.Size(65, 12); + this.label8.TabIndex = 0; + this.label8.Text = "密 码："; + // + // label3 + // + this.label3.AutoSize = true; + this.label3.Location = new System.Drawing.Point(10, 84); + this.label3.Name = "label3"; + this.label3.Size = new System.Drawing.Size(59, 12); + this.label3.TabIndex = 0; + this.label3.Text = "性 别:"; + // + // label2 + // + this.label2.AutoSize = true; + this.label2.Location = new System.Drawing.Point(10, 33); + this.label2.Name = "label2"; + this.label2.Size = new System.Drawing.Size(59, 12); + this.label2.TabIndex = 0; + this.label2.Text = "姓 名:"; + // + // button1 + // + this.button1.Location = new System.Drawing.Point(262, 41); + this.button1.Name = "button1"; + this.button1.Size = new System.Drawing.Size(75, 23); + this.button1.TabIndex = 4; + this.button1.Text = "查询(&F)"; + this.button1.UseVisualStyleBackColor = true; + this.button1.Click += new System.EventHandler(this.button1_Click); + // + // tb_id + // + this.tb_id.Location = new System.Drawing.Point(82, 43); + this.tb_id.Name = "tb_id"; + this.tb_id.Size = new System.Drawing.Size(135, 21); + this.tb_id.TabIndex = 1; + // + // label1 + // + this.label1.AutoSize = true; + this.label1.Location = new System.Drawing.Point(10, 46); + this.label1.Name = "label1"; + this.label1.Size = new System.Drawing.Size(59, 12); + this.label1.TabIndex = 0; + this.label1.Text = "编 号:"; + // + // groupBox2 + // + this.groupBox2.Controls.Add(this.button6); + this.groupBox2.Controls.Add(this.tb_id); + this.groupBox2.Controls.Add(this.label1); + this.groupBox2.Controls.Add(this.button1); + this.groupBox2.Location = new System.Drawing.Point(8, 13); + this.groupBox2.Name = "groupBox2"; + this.groupBox2.Size = new System.Drawing.Size(469, 82); + this.groupBox2.TabIndex = 6; + this.groupBox2.TabStop = false; + this.groupBox2.Text = "员工查询"; + // + // button6 + // + this.button6.Location = new System.Drawing.Point(364, 41); + this.button6.Name = "button6"; + this.button6.Size = new System.Drawing.Size(91, 23); + this.button6.TabIndex = 5; + this.button6.Text = "所有员工(&S)"; + this.button6.UseVisualStyleBackColor = true; + this.button6.Click += new System.EventHandler(this.button6_Click); + // + // 所有员工信息 + // + this.所有员工信息.Controls.Add(this.dataGridView1); + this.所有员工信息.Location = new System.Drawing.Point(485, 13); + this.所有员工信息.Name = "所有员工信息"; + this.所有员工信息.Size = new System.Drawing.Size(456, 407); + this.所有员工信息.TabIndex = 7; + this.所有员工信息.TabStop = false; + this.所有员工信息.Text = "所有员工信息"; + // + // dataGridView1 + // + this.dataGridView1.Location = new System.Drawing.Point(-2, 15); + this.dataGridView1.Name = "dataGridView1"; + this.dataGridView1.RowTemplate.Height = 23; + this.dataGridView1.Size = new System.Drawing.Size(449, 381); + this.dataGridView1.TabIndex = 1; + // + // groupBox3 + // + this.groupBox3.Controls.Add(this.check_4); + this.groupBox3.Controls.Add(this.check_5); + this.groupBox3.Controls.Add(this.check_1); + this.groupBox3.Controls.Add(this.check_6); + this.groupBox3.Controls.Add(this.check_2); + this.groupBox3.Controls.Add(this.check_3); + this.groupBox3.Location = new System.Drawing.Point(8, 324); + this.groupBox3.Name = "groupBox3"; + this.groupBox3.Size = new System.Drawing.Size(469, 96); + this.groupBox3.TabIndex = 8; + this.groupBox3.TabStop = false; + this.groupBox3.Text = "权限设置"; + // + // check_4 + // + this.check_4.AutoSize = true; + this.check_4.Location = new System.Drawing.Point(32, 59); + this.check_4.Name = "check_4"; + this.check_4.Size = new System.Drawing.Size(72, 16); + this.check_4.TabIndex = 0; + this.check_4.Text = "发药系统"; + this.check_4.UseVisualStyleBackColor = true; + // + // check_5 + // + this.check_5.AutoSize = true; + this.check_5.Location = new System.Drawing.Point(176, 59); + this.check_5.Name = "check_5"; + this.check_5.Size = new System.Drawing.Size(72, 16); + this.check_5.TabIndex = 0; + this.check_5.Text = "收费系统"; + this.check_5.UseVisualStyleBackColor = true; + // + // check_1 + // + this.check_1.AutoSize = true; + this.check_1.Location = new System.Drawing.Point(32, 28); + this.check_1.Name = "check_1"; + this.check_1.Size = new System.Drawing.Size(72, 16); + this.check_1.TabIndex = 0; + this.check_1.Text = "人事管理"; + this.check_1.UseVisualStyleBackColor = true; + // + // check_6 + // + this.check_6.AutoSize = true; + this.check_6.Location = new System.Drawing.Point(310, 59); + this.check_6.Name = "check_6"; + this.check_6.Size = new System.Drawing.Size(72, 16); + this.check_6.TabIndex = 0; + this.check_6.Text = "药品入库"; + this.check_6.UseVisualStyleBackColor = true; + // + // check_2 + // + this.check_2.AutoSize = true; + this.check_2.Location = new System.Drawing.Point(176, 28); + this.check_2.Name = "check_2"; + this.check_2.Size = new System.Drawing.Size(72, 16); + this.check_2.TabIndex = 0; + this.check_2.Text = "门诊挂号"; + this.check_2.UseVisualStyleBackColor = true; + // + // check_3 + // + this.check_3.AutoSize = true; + this.check_3.Location = new System.Drawing.Point(310, 28); + this.check_3.Name = "check_3"; + this.check_3.Size = new System.Drawing.Size(72, 16); + this.check_3.TabIndex = 0; + this.check_3.Text = "医生门诊"; + this.check_3.UseVisualStyleBackColor = true; + // + // Form_Adminisrtator + // + this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 12F); + this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; + this.ClientSize = new System.Drawing.Size(948, 421); + this.Controls.Add(this.groupBox3); + this.Controls.Add(this.所有员工信息); + this.Controls.Add(this.groupBox2); + this.Controls.Add(this.groupBox1); + this.Name = "Form_Adminisrtator"; + this.Text = "人事信息"; + this.Load += new System.EventHandler(this.Form_Adminisrtator_Load); + this.groupBox1.ResumeLayout(false); + this.groupBox1.PerformLayout(); + ((System.ComponentModel.ISupportInitialize)(this.pb_photo)).EndInit(); + this.groupBox2.ResumeLayout(false); + this.groupBox2.PerformLayout(); + this.所有员工信息.ResumeLayout(false); + ((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).EndInit(); + this.groupBox3.ResumeLayout(false); + this.groupBox3.PerformLayout(); + this.ResumeLayout(false); + + } + + #endregion + + private System.Windows.Forms.GroupBox groupBox1; + private System.Windows.Forms.Button button4; + private System.Windows.Forms.Button button3; + private System.Windows.Forms.Button button2; + private System.Windows.Forms.Button button1; + private System.Windows.Forms.PictureBox pb_photo; + private System.Windows.Forms.ComboBox cb_sex; + private System.Windows.Forms.TextBox tb_fee; + private System.Windows.Forms.TextBox tb_comment; + private System.Windows.Forms.TextBox tb_name; + private System.Windows.Forms.TextBox tb_id; + private System.Windows.Forms.Label label6; + private System.Windows.Forms.Label label7; + private System.Windows.Forms.Label label5; + private System.Windows.Forms.Label label4; + private System.Windows.Forms.Label label3; + private System.Windows.Forms.Label label2; + private System.Windows.Forms.Label label1; + private System.Windows.Forms.GroupBox groupBox2; + private System.Windows.Forms.Button button5; + private System.Windows.Forms.Button button6; + private System.Windows.Forms.GroupBox 所有员工信息; + private System.Windows.Forms.DataGridView dataGridView1; + private System.Windows.Forms.ComboBox cb_job; + private System.Windows.Forms.ComboBox cb_department; + private System.Windows.Forms.GroupBox groupBox3; + private System.Windows.Forms.CheckBox check_4; + private System.Windows.Forms.CheckBox check_5; + private System.Windows.Forms.CheckBox check_1; + private System.Windows.Forms.CheckBox check_6; + private System.Windows.Forms.CheckBox check_2; + private System.Windows.Forms.CheckBox check_3; + private System.Windows.Forms.TextBox tb_password; + private System.Windows.Forms.Label label8; + } +} + diff --git a/HospitalManageSys/Form_Adminisrtator.resx b/HospitalManageSys/Form_Adminisrtator.resx new file mode 100644 index 0000000..0284069 --- /dev/null +++ b/HospitalManageSys/Form_Adminisrtator.resx @@ -0,0 +1,123 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + text/microsoft-resx + + + 2.0 + + + System.Resources.ResXResourceReader, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 + + + System.Resources.ResXResourceWriter, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 + + + 25 + + \ No newline at end of file diff --git a/HospitalManageSys/Form_Charge.cs b/HospitalManageSys/Form_Charge.cs new file mode 100644 index 0000000..44d16f0 --- /dev/null +++ b/HospitalManageSys/Form_Charge.cs @@ -0,0 +1,177 @@ +using System; +using System.Collections.Generic; +using System.ComponentModel; +using System.Data; +using System.Drawing; +using System.Linq; +using System.Text; +using System.Windows.Forms; +using MySql.Data.MySqlClient; + +namespace HospitalManageSys +{ + public partial class Form_Charge : Form + { + MySqlConnection conne; + MainForm mf; + + public Form_Charge(MySqlConnection connector,MainForm mainform) + { + InitializeComponent(); + + conne = connector; + mf = mainform; + } + //string myconnect = "Server = localhost;Database=HospitalManageSys;User Id = barry;Password = zixue788634; "; + //保存按钮 + private void button1_Click(object sender, EventArgs e) + { + //MySqlConnection conne = new MySqlConnection(myconnect); + MySqlCommand cmd; + conne.Open(); + try + { + if(textBox1.Text.Trim().ToString().Length == 0) + { + MessageBox.Show("请输入单号"); + return; + }else if(comboBox1.Text.Trim().ToString().Length == 0){ + MessageBox.Show("收费人编号不能为空"); + return; + } + else if (textBox3.Text.Trim().ToString().Length == 0) { + MessageBox.Show("请输入中药费用，如果没有请输入0.00"); + return; + } + else if (textBox4.Text.Trim().ToString().Length == 0) { + MessageBox.Show("请输入西药费用，如果没有请输入0.00"); + return; + } + else if (textBox2.Text.Trim().ToString().Length == 0) { + MessageBox.Show("请输入相关中药名称与数量，没有输入“无”"); + return; + } + else if (textBox5.Text.Trim().ToString().Length == 0) { + MessageBox.Show("请输入相关中药名称与数量，没有输入“无”"); + return; + } + + + decimal tex = decimal.Parse(textBox3.Text) + decimal.Parse(textBox4.Text); + cmd = conne.CreateCommand(); + cmd.CommandText = "INSERT INTO charge(charge_count,charge_admin,charge_tcmname,charge_tcm,charge_twmname,charge_twm,charge_sum,charge_date)VALUES(@charge_count,@charge_admin,@charge_tcmname,@charge_tcm,@charge_twmname,@charge_twm,@charge_sum,@charge_date)"; + cmd.Parameters.AddWithValue("@charge_count", textBox1.Text); + cmd.Parameters.AddWithValue("@charge_admin", int.Parse(comboBox1.SelectedItem.ToString())); + cmd.Parameters.AddWithValue("@charge_tcm", textBox3.Text); + cmd.Parameters.AddWithValue("@charge_twm", textBox4.Text); + cmd.Parameters.AddWithValue("@charge_sum", tex); + cmd.Parameters.AddWithValue("@charge_date", System.DateTime.Now.ToString()); + cmd.Parameters.AddWithValue("@charge_tcmname", textBox2.Text); + cmd.Parameters.AddWithValue("@charge_twmname", textBox5.Text); + cmd.ExecuteNonQuery(); + + conne.Close(); + } + catch (Exception) + { + throw; + } + finally { + if (conne.State == ConnectionState.Open) + { + conne.Close(); + LoadData(); + } + } + } + private void LoadData() { + MySqlConnection connection = conne; + connection.Open(); + try + { + MySqlCommand cmd = connection.CreateCommand(); + cmd.CommandText = "SELECT * FROM charge"; + MySqlDataAdapter adap = new MySqlDataAdapter(cmd); + DataSet ds = new DataSet(); + adap.Fill(ds); + dataGridView1.DataSource = ds.Tables[0].DefaultView; + + } + catch (Exception) + { + throw; + } + finally { + if (connection.State == ConnectionState.Open) + { + connection.Close(); + } + } + } + + private void textBox2_TextChanged(object sender, EventArgs e) + { + + } + //查询按钮 + private void button2_Click(object sender, EventArgs e) + { + //MySqlConnection conne = new MySqlConnection(myconnect); + + MySqlCommand cmd; + conne.Open(); + try + { + + } + catch (Exception) + { + throw; + } + finally + { + if (conne.State == ConnectionState.Open) + { + conne.Close(); + ReLoadData(); + } + } + } + private void ReLoadData() + { + MySqlConnection connection = conne; + connection.Open(); + try + { + if (comboBox1.Text.Trim().ToString().Length == 0) + { + MessageBox.Show("请选择要查询的收费人编号"); + return; + } + MySqlCommand cmd = connection.CreateCommand(); + cmd.CommandText = string.Format("SELECT charge_count,charge_admin,charge_tcmname,charge_tcm,charge_twmname,charge_twm,charge_sum,charge_date FROM charge where charge_admin = {0} ", comboBox1.Text); ; + MySqlDataAdapter adap = new MySqlDataAdapter(cmd.CommandText, connection); + DataSet ds = new DataSet(); + adap.Fill(ds); + dataGridView1.DataSource = ds.Tables[0].DefaultView; + + } + catch (Exception) + { + throw; + } + finally + { + if (connection.State == ConnectionState.Open) + { + connection.Close(); + } + } + } + + private void Form_Charge_Load(object sender, EventArgs e) + { + + } + } +} diff --git a/HospitalManageSys/Form_Charge.designer.cs b/HospitalManageSys/Form_Charge.designer.cs new file mode 100644 index 0000000..2ec6a7e --- /dev/null +++ b/HospitalManageSys/Form_Charge.designer.cs @@ -0,0 +1,233 @@ +namespace HospitalManageSys +{ + partial class Form_Charge + { + /// + /// 必需的设计器变量。 + /// + private System.ComponentModel.IContainer components = null; + + /// + /// 清理所有正在使用的资源。 + /// + /// 如果应释放托管资源，为 true；否则为 false。 + protected override void Dispose(bool disposing) + { + if (disposing && (components != null)) + { + components.Dispose(); + } + base.Dispose(disposing); + } + + #region Windows 窗体设计器生成的代码 + + /// + /// 设计器支持所需的方法 - 不要 + /// 使用代码编辑器修改此方法的内容。 + /// + private void InitializeComponent() + { + this.button1 = new System.Windows.Forms.Button(); + this.dataGridView1 = new System.Windows.Forms.DataGridView(); + this.textBox1 = new System.Windows.Forms.TextBox(); + this.textBox3 = new System.Windows.Forms.TextBox(); + this.textBox4 = new System.Windows.Forms.TextBox(); + this.label1 = new System.Windows.Forms.Label(); + this.label2 = new System.Windows.Forms.Label(); + this.label3 = new System.Windows.Forms.Label(); + this.label4 = new System.Windows.Forms.Label(); + this.comboBox1 = new System.Windows.Forms.ComboBox(); + this.button2 = new System.Windows.Forms.Button(); + this.textBox2 = new System.Windows.Forms.TextBox(); + this.textBox5 = new System.Windows.Forms.TextBox(); + this.label5 = new System.Windows.Forms.Label(); + this.label6 = new System.Windows.Forms.Label(); + ((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).BeginInit(); + this.SuspendLayout(); + // + // button1 + // + this.button1.Location = new System.Drawing.Point(253, 115); + this.button1.Name = "button1"; + this.button1.Size = new System.Drawing.Size(75, 23); + this.button1.TabIndex = 0; + this.button1.Text = "保存"; + this.button1.UseVisualStyleBackColor = true; + this.button1.Click += new System.EventHandler(this.button1_Click); + // + // dataGridView1 + // + this.dataGridView1.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize; + this.dataGridView1.Location = new System.Drawing.Point(10, 145); + this.dataGridView1.Name = "dataGridView1"; + this.dataGridView1.RowTemplate.Height = 23; + this.dataGridView1.Size = new System.Drawing.Size(751, 258); + this.dataGridView1.TabIndex = 1; + // + // textBox1 + // + this.textBox1.Location = new System.Drawing.Point(87, 13); + this.textBox1.Name = "textBox1"; + this.textBox1.Size = new System.Drawing.Size(222, 21); + this.textBox1.TabIndex = 2; + // + // textBox3 + // + this.textBox3.Location = new System.Drawing.Point(494, 54); + this.textBox3.Name = "textBox3"; + this.textBox3.Size = new System.Drawing.Size(223, 21); + this.textBox3.TabIndex = 4; + // + // textBox4 + // + this.textBox4.Location = new System.Drawing.Point(495, 89); + this.textBox4.Name = "textBox4"; + this.textBox4.Size = new System.Drawing.Size(222, 21); + this.textBox4.TabIndex = 5; + // + // label1 + // + this.label1.AutoSize = true; + this.label1.Location = new System.Drawing.Point(26, 16); + this.label1.Name = "label1"; + this.label1.Size = new System.Drawing.Size(53, 12); + this.label1.TabIndex = 7; + this.label1.Text = "收费单号"; + // + // label2 + // + this.label2.AutoSize = true; + this.label2.Location = new System.Drawing.Point(413, 16); + this.label2.Name = "label2"; + this.label2.Size = new System.Drawing.Size(65, 12); + this.label2.TabIndex = 8; + this.label2.Text = "收费人编号"; + // + // label3 + // + this.label3.AutoSize = true; + this.label3.Location = new System.Drawing.Point(413, 54); + this.label3.Name = "label3"; + this.label3.Size = new System.Drawing.Size(65, 12); + this.label3.TabIndex = 9; + this.label3.Text = "中药费用￥"; + // + // label4 + // + this.label4.AutoSize = true; + this.label4.Location = new System.Drawing.Point(414, 89); + this.label4.Name = "label4"; + this.label4.Size = new System.Drawing.Size(65, 12); + this.label4.TabIndex = 10; + this.label4.Text = "西药费用￥"; + // + // comboBox1 + // + this.comboBox1.FormattingEnabled = true; + this.comboBox1.Items.AddRange(new object[] { + "111111", + "222222", + "333333", + "444444", + "555555", + "666666", + "777777", + "888888", + "999999"}); + this.comboBox1.Location = new System.Drawing.Point(494, 13); + this.comboBox1.Name = "comboBox1"; + this.comboBox1.Size = new System.Drawing.Size(223, 20); + this.comboBox1.TabIndex = 11; + // + // button2 + // + this.button2.Location = new System.Drawing.Point(416, 114); + this.button2.Name = "button2"; + this.button2.Size = new System.Drawing.Size(75, 23); + this.button2.TabIndex = 12; + this.button2.Text = "编号查询"; + this.button2.UseVisualStyleBackColor = true; + this.button2.Click += new System.EventHandler(this.button2_Click); + // + // textBox2 + // + this.textBox2.Location = new System.Drawing.Point(87, 51); + this.textBox2.Name = "textBox2"; + this.textBox2.Size = new System.Drawing.Size(222, 21); + this.textBox2.TabIndex = 13; + // + // textBox5 + // + this.textBox5.Location = new System.Drawing.Point(87, 89); + this.textBox5.Name = "textBox5"; + this.textBox5.Size = new System.Drawing.Size(222, 21); + this.textBox5.TabIndex = 14; + // + // label5 + // + this.label5.AutoSize = true; + this.label5.Location = new System.Drawing.Point(26, 54); + this.label5.Name = "label5"; + this.label5.Size = new System.Drawing.Size(53, 12); + this.label5.TabIndex = 15; + this.label5.Text = "中药名称"; + // + // label6 + // + this.label6.AutoSize = true; + this.label6.Location = new System.Drawing.Point(26, 92); + this.label6.Name = "label6"; + this.label6.Size = new System.Drawing.Size(53, 12); + this.label6.TabIndex = 16; + this.label6.Text = "西药名称"; + // + // Form_Charge + // + this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 12F); + this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; + this.ClientSize = new System.Drawing.Size(788, 415); + this.Controls.Add(this.label6); + this.Controls.Add(this.label5); + this.Controls.Add(this.textBox5); + this.Controls.Add(this.textBox2); + this.Controls.Add(this.button2); + this.Controls.Add(this.comboBox1); + this.Controls.Add(this.label4); + this.Controls.Add(this.label3); + this.Controls.Add(this.label2); + this.Controls.Add(this.label1); + this.Controls.Add(this.textBox4); + this.Controls.Add(this.textBox3); + this.Controls.Add(this.textBox1); + this.Controls.Add(this.dataGridView1); + this.Controls.Add(this.button1); + this.Name = "Form_Charge"; + this.Text = "Form1"; + this.Load += new System.EventHandler(this.Form_Charge_Load); + ((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).EndInit(); + this.ResumeLayout(false); + this.PerformLayout(); + + } + + #endregion + + private System.Windows.Forms.Button button1; + private System.Windows.Forms.DataGridView dataGridView1; + private System.Windows.Forms.TextBox textBox1; + private System.Windows.Forms.TextBox textBox3; + private System.Windows.Forms.TextBox textBox4; + private System.Windows.Forms.Label label1; + private System.Windows.Forms.Label label2; + private System.Windows.Forms.Label label3; + private System.Windows.Forms.Label label4; + private System.Windows.Forms.ComboBox comboBox1; + private System.Windows.Forms.Button button2; + private System.Windows.Forms.TextBox textBox2; + private System.Windows.Forms.TextBox textBox5; + private System.Windows.Forms.Label label5; + private System.Windows.Forms.Label label6; + } +} + diff --git a/HospitalManageSys/Form_Charge.resx b/HospitalManageSys/Form_Charge.resx new file mode 100644 index 0000000..1af7de1 --- /dev/null +++ b/HospitalManageSys/Form_Charge.resx @@ -0,0 +1,120 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + text/microsoft-resx + + + 2.0 + + + System.Resources.ResXResourceReader, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 + + + System.Resources.ResXResourceWriter, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 + + \ No newline at end of file diff --git a/HospitalManageSys/Form_DrugEx.cs b/HospitalManageSys/Form_DrugEx.cs new file mode 100644 index 0000000..97981cb --- /dev/null +++ b/HospitalManageSys/Form_DrugEx.cs @@ -0,0 +1,174 @@ +using System; +using System.Collections.Generic; +using System.ComponentModel; +using System.Data; +using System.Drawing; +using System.Linq; +using System.Text; +using System.Windows.Forms; +using MySql.Data.MySqlClient; + +namespace HospitalManageSys +{ + public partial class Form_DrugEx : Form + { + MainForm mf; + MySqlConnection conn; + + public Form_DrugEx(MySqlConnection connector, MainForm mainform) + { + InitializeComponent(); + + mf = mainform; + conn = connector; + } + + private void button1_Click(object sender, EventArgs e) + { + String strConn = "server=localhost;uid=root;pwd=dongyz1130 ;database=hospitalmanagesys"; + //MySqlConnection conn = new MySqlConnection(strConn); + String sqlId = "Select * from drugex where DrugEx_registration = '" + textBox1.Text + "'and Drug_state='未发' "; + conn.Open(); + MySqlCommand cmd = new MySqlCommand(sqlId, conn); + MySqlDataAdapter da = new MySqlDataAdapter(cmd); + DataSet ds = new DataSet(); + da.Fill(ds, "USER"); + dataGridView1.DataSource = ds.Tables[0]; + + + } + + private void button2_Click(object sender, EventArgs e) + { + String strConn = "server=localhost;uid=root;pwd=dongyz1130 ;database=hospitalmanagesys"; + //MySqlConnection conn = new MySqlConnection(); + conn.ConnectionString = strConn; + //2、准备新增sql命令 + string strcommand = "update drugex set Drug_state = '已发' where DrugEx_registration = '" + textBox1.Text + "' "; + //3、新建命令对象，并前告诉它走那条路，做什么事情 + MySqlCommand cmd = new MySqlCommand(strcommand, conn); + //4、打开通道 + conn.Open(); + //5、执行sql语句 + int intres = -1; + intres = cmd.ExecuteNonQuery(); + //6、关闭连接通道 + conn.Close(); + if (intres > 0) + { + Console.WriteLine("修改成功"); + } + else + { + Console.WriteLine("修改失败"); + } + + } + + + + private void button3_Click(object sender, EventArgs e) + { + String strConn = "server=localhost;uid=root;pwd=dongyz1130 ;database=hospitalmanagesys"; + //MySqlConnection conn = new MySqlConnection(strConn); + String sqlId = "Select * from drugex where DrugEx_date = '" + dateTimePicker1.Text + "'and Drug_state='已发' "; + conn.Open(); + MySqlCommand cmd = new MySqlCommand(sqlId, conn); + MySqlDataAdapter da = new MySqlDataAdapter(cmd); + DataSet ds = new DataSet(); + da.Fill(ds, "USER"); + dataGridView2.DataSource = ds.Tables[0]; + + conn.Close(); + + } + + private void button4_Click(object sender, EventArgs e) + { + String strConn = "server=localhost;uid=root;pwd=dongyz1130 ;database=hospitalmanagesys"; + //MySqlConnection conn = new MySqlConnection(strConn); + String sqlId = "Select * from drugex where DrugEx_date = '" + dateTimePicker1.Text + "'and Drug_state='未发' "; + conn.Open(); + MySqlCommand cmd = new MySqlCommand(sqlId, conn); + MySqlDataAdapter da = new MySqlDataAdapter(cmd); + DataSet ds = new DataSet(); + da.Fill(ds, "USER"); + dataGridView2.DataSource = ds.Tables[0]; + + conn.Close(); + + + } + + private void button5_Click(object sender, EventArgs e) + { + String strConn = "server=localhost;uid=root;pwd=dongyz1130 ;database=hospitalmanagesys"; + //MySqlConnection conn = new MySqlConnection(strConn); + String sqlId = "Select * from drugex where DrugEx_registration = '" + textBox2.Text + "' "; + conn.Open(); + MySqlCommand cmd = new MySqlCommand(sqlId, conn); + MySqlDataAdapter da = new MySqlDataAdapter(cmd); + DataSet ds = new DataSet(); + da.Fill(ds, "USER"); + dataGridView2.DataSource = ds.Tables[0]; + + } + + + + private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e) + { + String strConn = "server=localhost;uid=root;pwd=dongyz1130 ;database=hospitalmanagesys"; + //MySqlConnection conn = new MySqlConnection(); + conn.ConnectionString = strConn; + //2、准备新增sql命令 + String sqlId = "Select Drugex_quantity from drugex where Drug_name = '" + textBox3.Text + "'"; + MySqlCommand cmd = new MySqlCommand(sqlId, conn); + conn.Open(); + MySqlDataReader myReader = cmd.ExecuteReader(); + while (myReader.Read()) + { + textBox4.Text = myReader.GetValue(0).ToString(); + } + myReader.Close(); + conn.Close(); + } + + private void button6_Click(object sender, EventArgs e) + { + String strConn = "server=localhost;uid=root;pwd=dongyz1130 ;database=hospitalmanagesys"; + //MySqlConnection conn = new MySqlConnection(); + conn.ConnectionString = strConn; + //2、准备新增sql命令 + string strcommand = "update drug set Drug_remain = Drug_remain-'" + textBox4.Text + "' where Drug_name = '" + textBox3.Text + "' "; + //3、新建命令对象，并前告诉它走那条路，做什么事情 + MySqlCommand cmd = new MySqlCommand(strcommand, conn); + //4、打开通道 + conn.Open(); + //5、执行sql语句 + int intres = -1; + intres = cmd.ExecuteNonQuery(); + //6、关闭连接通道 + conn.Close(); + if (intres > 0) + { + Console.WriteLine("修改成功"); + } + else + { + Console.WriteLine("修改失败"); + } + } + + private void label1_Click(object sender, EventArgs e) + { + + } + + private void Form_DrugEx_Load(object sender, EventArgs e) + { + + } + } + } + diff --git a/HospitalManageSys/Form_DrugEx.designer.cs b/HospitalManageSys/Form_DrugEx.designer.cs new file mode 100644 index 0000000..aa456c4 --- /dev/null +++ b/HospitalManageSys/Form_DrugEx.designer.cs @@ -0,0 +1,289 @@ +namespace HospitalManageSys +{ + partial class Form_DrugEx + { + /// + /// 必需的设计器变量。 + /// + private System.ComponentModel.IContainer components = null; + + /// + /// 清理所有正在使用的资源。 + /// + /// 如果应释放托管资源，为 true；否则为 false。 + protected override void Dispose(bool disposing) + { + if (disposing && (components != null)) + { + components.Dispose(); + } + base.Dispose(disposing); + } + + #region Windows 窗体设计器生成的代码 + + /// + /// 设计器支持所需的方法 - 不要 + /// 使用代码编辑器修改此方法的内容。 + /// + private void InitializeComponent() + { + this.textBox1 = new System.Windows.Forms.TextBox(); + this.button1 = new System.Windows.Forms.Button(); + this.label3 = new System.Windows.Forms.Label(); + this.dataGridView1 = new System.Windows.Forms.DataGridView(); + this.dateTimePicker1 = new System.Windows.Forms.DateTimePicker(); + this.dataGridView2 = new System.Windows.Forms.DataGridView(); + this.button3 = new System.Windows.Forms.Button(); + this.button2 = new System.Windows.Forms.Button(); + this.button4 = new System.Windows.Forms.Button(); + this.label2 = new System.Windows.Forms.Label(); + this.textBox2 = new System.Windows.Forms.TextBox(); + this.button5 = new System.Windows.Forms.Button(); + this.label4 = new System.Windows.Forms.Label(); + this.button6 = new System.Windows.Forms.Button(); + this.textBox3 = new System.Windows.Forms.TextBox(); + this.textBox4 = new System.Windows.Forms.TextBox(); + this.label1 = new System.Windows.Forms.Label(); + this.linkLabel1 = new System.Windows.Forms.LinkLabel(); + ((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).BeginInit(); + ((System.ComponentModel.ISupportInitialize)(this.dataGridView2)).BeginInit(); + this.SuspendLayout(); + // + // textBox1 + // + this.textBox1.Location = new System.Drawing.Point(101, 30); + this.textBox1.Margin = new System.Windows.Forms.Padding(2, 2, 2, 2); + this.textBox1.Name = "textBox1"; + this.textBox1.Size = new System.Drawing.Size(271, 21); + this.textBox1.TabIndex = 0; + // + // button1 + // + this.button1.Location = new System.Drawing.Point(397, 24); + this.button1.Margin = new System.Windows.Forms.Padding(2, 2, 2, 2); + this.button1.Name = "button1"; + this.button1.Size = new System.Drawing.Size(111, 29); + this.button1.TabIndex = 5; + this.button1.Text = "搜索"; + this.button1.UseVisualStyleBackColor = true; + this.button1.Click += new System.EventHandler(this.button1_Click); + // + // label3 + // + this.label3.AutoSize = true; + this.label3.Location = new System.Drawing.Point(34, 35); + this.label3.Margin = new System.Windows.Forms.Padding(2, 0, 2, 0); + this.label3.Name = "label3"; + this.label3.Size = new System.Drawing.Size(65, 12); + this.label3.TabIndex = 10; + this.label3.Text = "未发药单号"; + // + // dataGridView1 + // + this.dataGridView1.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize; + this.dataGridView1.Location = new System.Drawing.Point(36, 130); + this.dataGridView1.Margin = new System.Windows.Forms.Padding(2, 2, 2, 2); + this.dataGridView1.Name = "dataGridView1"; + this.dataGridView1.ReadOnly = true; + this.dataGridView1.RowTemplate.Height = 27; + this.dataGridView1.Size = new System.Drawing.Size(714, 134); + this.dataGridView1.TabIndex = 19; + // + // dateTimePicker1 + // + this.dateTimePicker1.Location = new System.Drawing.Point(78, 340); + this.dateTimePicker1.Margin = new System.Windows.Forms.Padding(2, 2, 2, 2); + this.dateTimePicker1.Name = "dateTimePicker1"; + this.dateTimePicker1.Size = new System.Drawing.Size(152, 21); + this.dateTimePicker1.TabIndex = 23; + // + // dataGridView2 + // + this.dataGridView2.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize; + this.dataGridView2.Location = new System.Drawing.Point(36, 417); + this.dataGridView2.Margin = new System.Windows.Forms.Padding(2, 2, 2, 2); + this.dataGridView2.Name = "dataGridView2"; + this.dataGridView2.RowTemplate.Height = 27; + this.dataGridView2.Size = new System.Drawing.Size(714, 156); + this.dataGridView2.TabIndex = 24; + // + // button3 + // + this.button3.Location = new System.Drawing.Point(332, 342); + this.button3.Margin = new System.Windows.Forms.Padding(2, 2, 2, 2); + this.button3.Name = "button3"; + this.button3.Size = new System.Drawing.Size(106, 18); + this.button3.TabIndex = 25; + this.button3.Text = "查询已发药单"; + this.button3.UseVisualStyleBackColor = true; + this.button3.Click += new System.EventHandler(this.button3_Click); + // + // button2 + // + this.button2.Location = new System.Drawing.Point(533, 42); + this.button2.Margin = new System.Windows.Forms.Padding(2, 2, 2, 2); + this.button2.Name = "button2"; + this.button2.Size = new System.Drawing.Size(97, 42); + this.button2.TabIndex = 26; + this.button2.Text = "确认发药"; + this.button2.UseVisualStyleBackColor = true; + this.button2.Click += new System.EventHandler(this.button2_Click); + // + // button4 + // + this.button4.Location = new System.Drawing.Point(461, 342); + this.button4.Margin = new System.Windows.Forms.Padding(2, 2, 2, 2); + this.button4.Name = "button4"; + this.button4.Size = new System.Drawing.Size(106, 18); + this.button4.TabIndex = 27; + this.button4.Text = "查询未发药单"; + this.button4.UseVisualStyleBackColor = true; + this.button4.Click += new System.EventHandler(this.button4_Click); + // + // label2 + // + this.label2.AutoSize = true; + this.label2.Location = new System.Drawing.Point(43, 383); + this.label2.Margin = new System.Windows.Forms.Padding(2, 0, 2, 0); + this.label2.Name = "label2"; + this.label2.Size = new System.Drawing.Size(29, 12); + this.label2.TabIndex = 29; + this.label2.Text = "单号"; + // + // textBox2 + // + this.textBox2.Location = new System.Drawing.Point(78, 381); + this.textBox2.Margin = new System.Windows.Forms.Padding(2, 2, 2, 2); + this.textBox2.Name = "textBox2"; + this.textBox2.Size = new System.Drawing.Size(232, 21); + this.textBox2.TabIndex = 28; + // + // button5 + // + this.button5.Location = new System.Drawing.Point(332, 378); + this.button5.Margin = new System.Windows.Forms.Padding(2, 2, 2, 2); + this.button5.Name = "button5"; + this.button5.Size = new System.Drawing.Size(87, 22); + this.button5.TabIndex = 30; + this.button5.Text = "查询"; + this.button5.UseVisualStyleBackColor = true; + this.button5.Click += new System.EventHandler(this.button5_Click); + // + // label4 + // + this.label4.AutoSize = true; + this.label4.Location = new System.Drawing.Point(43, 346); + this.label4.Margin = new System.Windows.Forms.Padding(2, 0, 2, 0); + this.label4.Name = "label4"; + this.label4.Size = new System.Drawing.Size(29, 12); + this.label4.TabIndex = 31; + this.label4.Text = "日期"; + // + // button6 + // + this.button6.Location = new System.Drawing.Point(397, 73); + this.button6.Margin = new System.Windows.Forms.Padding(2, 2, 2, 2); + this.button6.Name = "button6"; + this.button6.Size = new System.Drawing.Size(111, 27); + this.button6.TabIndex = 32; + this.button6.Text = "发出该药"; + this.button6.UseVisualStyleBackColor = true; + this.button6.Click += new System.EventHandler(this.button6_Click); + // + // textBox3 + // + this.textBox3.Location = new System.Drawing.Point(109, 75); + this.textBox3.Margin = new System.Windows.Forms.Padding(2, 2, 2, 2); + this.textBox3.Name = "textBox3"; + this.textBox3.Size = new System.Drawing.Size(134, 21); + this.textBox3.TabIndex = 33; + // + // textBox4 + // + this.textBox4.Location = new System.Drawing.Point(296, 75); + this.textBox4.Margin = new System.Windows.Forms.Padding(2, 2, 2, 2); + this.textBox4.Name = "textBox4"; + this.textBox4.Size = new System.Drawing.Size(76, 21); + this.textBox4.TabIndex = 34; + // + // label1 + // + this.label1.AutoSize = true; + this.label1.Location = new System.Drawing.Point(43, 81); + this.label1.Margin = new System.Windows.Forms.Padding(2, 0, 2, 0); + this.label1.Name = "label1"; + this.label1.Size = new System.Drawing.Size(53, 12); + this.label1.TabIndex = 35; + this.label1.Text = "药品名称"; + this.label1.Click += new System.EventHandler(this.label1_Click); + // + // linkLabel1 + // + this.linkLabel1.AutoSize = true; + this.linkLabel1.Location = new System.Drawing.Point(254, 81); + this.linkLabel1.Margin = new System.Windows.Forms.Padding(2, 0, 2, 0); + this.linkLabel1.Name = "linkLabel1"; + this.linkLabel1.Size = new System.Drawing.Size(29, 12); + this.linkLabel1.TabIndex = 36; + this.linkLabel1.TabStop = true; + this.linkLabel1.Text = "数量"; + this.linkLabel1.LinkClicked += new System.Windows.Forms.LinkLabelLinkClickedEventHandler(this.linkLabel1_LinkClicked); + // + // Form_DrugEx + // + this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 12F); + this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; + this.ClientSize = new System.Drawing.Size(766, 698); + this.Controls.Add(this.linkLabel1); + this.Controls.Add(this.label1); + this.Controls.Add(this.textBox4); + this.Controls.Add(this.textBox3); + this.Controls.Add(this.button6); + this.Controls.Add(this.label4); + this.Controls.Add(this.button5); + this.Controls.Add(this.label2); + this.Controls.Add(this.textBox2); + this.Controls.Add(this.button4); + this.Controls.Add(this.button2); + this.Controls.Add(this.button3); + this.Controls.Add(this.dataGridView2); + this.Controls.Add(this.dateTimePicker1); + this.Controls.Add(this.dataGridView1); + this.Controls.Add(this.label3); + this.Controls.Add(this.button1); + this.Controls.Add(this.textBox1); + this.Margin = new System.Windows.Forms.Padding(2, 2, 2, 2); + this.Name = "Form_DrugEx"; + this.Text = " 发药窗口"; + this.Load += new System.EventHandler(this.Form_DrugEx_Load); + ((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).EndInit(); + ((System.ComponentModel.ISupportInitialize)(this.dataGridView2)).EndInit(); + this.ResumeLayout(false); + this.PerformLayout(); + + } + + #endregion + + private System.Windows.Forms.TextBox textBox1; + private System.Windows.Forms.Button button1; + private System.Windows.Forms.Label label3; + private System.Windows.Forms.DataGridView dataGridView1; + private System.Windows.Forms.DateTimePicker dateTimePicker1; + private System.Windows.Forms.DataGridView dataGridView2; + private System.Windows.Forms.Button button3; + private System.Windows.Forms.Button button2; + private System.Windows.Forms.Button button4; + private System.Windows.Forms.Label label2; + private System.Windows.Forms.TextBox textBox2; + private System.Windows.Forms.Button button5; + private System.Windows.Forms.Label label4; + private System.Windows.Forms.Button button6; + private System.Windows.Forms.TextBox textBox3; + private System.Windows.Forms.TextBox textBox4; + private System.Windows.Forms.Label label1; + private System.Windows.Forms.LinkLabel linkLabel1; + } +} + diff --git a/HospitalManageSys/Form_DrugEx.resx b/HospitalManageSys/Form_DrugEx.resx new file mode 100644 index 0000000..1af7de1 --- /dev/null +++ b/HospitalManageSys/Form_DrugEx.resx @@ -0,0 +1,120 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + text/microsoft-resx + + + 2.0 + + + System.Resources.ResXResourceReader, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 + + + System.Resources.ResXResourceWriter, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 + + \ No newline at end of file diff --git a/HospitalManageSys/Form_DrugIm.cs b/HospitalManageSys/Form_DrugIm.cs new file mode 100644 index 0000000..78a8a91 --- /dev/null +++ b/HospitalManageSys/Form_DrugIm.cs @@ -0,0 +1,257 @@ +using System; +using System.Collections.Generic; +using System.ComponentModel; +using System.Data; +using System.Drawing; +using System.Linq; +using System.Text; +using MySql.Data.MySqlClient; +using System.Windows.Forms; + +namespace HospitalManageSys +{ + public partial class Form_DrugIm : Form + { + MySqlConnection conn; + MainForm mf; + + public Form_DrugIm(MySqlConnection connector, MainForm mainform) + { + InitializeComponent(); + + conn = connector; + mf = mainform; + } + private void Form1_Load(object sender, EventArgs e) + { + textBox1.MaxLength = 20; + CreateHeaderandFillListView(); + + } + + + private void CreateHeaderandFillListView() + { + ColumnHeader colHead = new ColumnHeader(); + colHead.Text = "Pid"; + colHead.Width = 50; + lvitem.Columns.Add(colHead); + ColumnHeader col2 = new ColumnHeader(); + col2.Text = "Pname"; + col2.Width = 100; + lvitem.Columns.Add(col2); + ColumnHeader col3 = new ColumnHeader(); + col3.Text = "Pprize"; + col3.Width = 100; + lvitem.Columns.Add(col3); + ColumnHeader col4 = new ColumnHeader(); + col4.Text = "Pdetile"; + col4.Width = 100; + lvitem.Columns.Add(col4); + ColumnHeader col5 = new ColumnHeader(); + col5.Text = "Pamount"; + col5.Width = 100; + lvitem.Columns.Add(col5); + } + private static DataSet SelectRows(DataSet dataset, string connectionString, string queryString) + { + using (MySqlConnection connection = new MySqlConnection (connectionString)) + { + MySqlDataAdapter adapter = new MySqlDataAdapter(); + adapter.SelectCommand = new MySqlCommand(queryString,connection); + adapter.Fill(dataset); + return dataset; + } + } + + private void CreateItemView() + { + string a; + a = textBox5.Text; + ListViewItem lvi = new ListViewItem(textBox1.Text); + lvi.SubItems.Add(textBox2.Text); + lvi.SubItems.Add(textBox3.Text); + lvi.SubItems.Add(textBox4.Text); + lvi.SubItems.Add(textBox5.Text); + lvitem.Items.Add(lvi); + } + private void checkBox1_CheckedChanged(object sender, EventArgs e) + { + + } + + private void button1_Click(object sender, EventArgs e) + { + if (textBox1.Text == "") MessageBox.Show("please fill up the entering box"); + else if (textBox2.Text == "") MessageBox.Show("please fill up the entering box"); + else if (textBox3.Text == "") MessageBox.Show("please fill up the entering box"); + else if (textBox4.Text == "") MessageBox.Show("please fill up the entering box"); + else if (textBox5.Text == "") MessageBox.Show("please fill up the entering box"); + else + { + CreateItemView(); + MessageBox.Show("药品编号输入有误"); + textBox1.Text = ""; + textBox2.Text = ""; + textBox3.Text = ""; + textBox4.Text = ""; + textBox5.Text = ""; + textBox6.Text = ""; + textBox7.Text = ""; + + } + } + + private void textBox1_TextChanged(object sender, EventArgs e) + { + + } + + private void toolTip1_Popup(object sender, PopupEventArgs e) + { + + } + + private void button2_Click(object sender, EventArgs e) + { + MessageBox.Show("clear"); + textBox1.Text = ""; + textBox2.Text = ""; + textBox3.Text = ""; + textBox4.Text = ""; + textBox5.Text = ""; + lvitem.Columns.Clear(); + } + + private void label1_Click(object sender, EventArgs e) + { + + } + + private void button3_Click(object sender, EventArgs e) + { + + DataSet ds = new DataSet(); + string ConnectionString = HospitalManageSys.SqlCmd.strcon; + //MySqlConnection conn = new MySqlConnection(ConnectionString); + conn.Open(); + string a = "select*from dru"+"g"; + string sql = string.Format(a); + MySqlDataAdapter sda = new MySqlDataAdapter(sql, conn); + sda.Fill(ds); + DataView dv = ds.Tables[0].DefaultView; + listBox1.DataSource = ds.Tables[0]; + if (radioButton1.Checked) + listBox1.DisplayMember = "Drug_name"; + else if (radioButton2.Checked) + listBox1.DisplayMember = "Drug_supplier"; + else if (radioButton3.Checked) + listBox1.DisplayMember = "Drug_id"; + conn.Close(); + ttt(); + } + private void ttt() + { + + string ConnectionString = HospitalManageSys.SqlCmd.strcon; + //MySqlConnection conn = new MySqlConnection(ConnectionString); + try + { + conn.Open(); + label7.Text = "服务器名称:" + conn.DataSource + ";要使用的数据库：" + conn.Database; + string strcmd = "select*from drug"; + MySqlCommand cmd = new MySqlCommand(strcmd, conn); + MySqlDataAdapter ada = new MySqlDataAdapter(cmd); + DataSet ds = new DataSet(); + ada.Fill(ds);//查询结果填充数据集 + dataGridView1.DataSource = ds.Tables[0]; + conn.Dispose(); + conn.Close(); + } + catch (Exception) + { + label7.Text = "failed"; + } + + } + + private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) + { + + } + + private void button4_Click(object sender, EventArgs e) + { + if (textBox1.Text == "") MessageBox.Show("please fill up the entering box"); + else if (textBox2.Text == "") MessageBox.Show("please fill up the entering box"); + else if (textBox3.Text == "") MessageBox.Show("please fill up the entering box"); + else if (textBox4.Text == "") MessageBox.Show("please fill up the entering box"); + else if (textBox5.Text == "") MessageBox.Show("please fill up the entering box"); + else + { + DataSet ds = new DataSet(); + string connectionString = HospitalManageSys.SqlCmd.strcon;//"Data Source=localhost;Initial Catalog=hospitalmanagesys;User ID=root;Password=nnnbc4318"; + string t1, t2, t3, t4, t5, t6, t7; + t1 = textBox1.Text; + t2 = textBox2.Text; + t3 = textBox3.Text; t4 = textBox4.Text; t5 = textBox5.Text; t6 = textBox6.Text; t7 = textBox7.Text; + string query = "insert into hospitalmanagesys.drug value('" + t1 + "','" + t2 + "','" + t3 + "','" + t4 + "','" + t7 + "','" + t6 + "','" + t5 + "');"; + ds = SelectRows(ds, connectionString, query); + MessageBox.Show("添加成功"); + } + + } + + private void textBox2_TextChanged(object sender, EventArgs e) + { + + } + + private void textBox3_TextChanged(object sender, EventArgs e) + { + + } + + private void textBox4_TextChanged(object sender, EventArgs e) + { + + } + + private void textBox7_TextChanged(object sender, EventArgs e) + { + + } + + private void textBox6_TextChanged(object sender, EventArgs e) + { + + } + + private void textBox5_TextChanged(object sender, EventArgs e) + { + + } + + private void listBox1_SelectedIndexChanged(object sender, EventArgs e) + { + + } + + private void label8_Click(object sender, EventArgs e) + { + + } + + private void radioButton3_CheckedChanged(object sender, EventArgs e) + { + + } + + private void radioButton2_CheckedChanged(object sender, EventArgs e) + { + + } + + + } +} diff --git a/HospitalManageSys/Form_DrugIm.designer.cs b/HospitalManageSys/Form_DrugIm.designer.cs new file mode 100644 index 0000000..c6cebfb --- /dev/null +++ b/HospitalManageSys/Form_DrugIm.designer.cs @@ -0,0 +1,566 @@ +namespace HospitalManageSys +{ + partial class Form_DrugIm + { + /// + /// 必需的设计器变量。 + /// + private System.ComponentModel.IContainer components = null; + + /// + /// 清理所有正在使用的资源。 + /// + /// 如果应释放托管资源，为 true；否则为 false。 + protected override void Dispose(bool disposing) + { + if (disposing && (components != null)) + { + components.Dispose(); + } + base.Dispose(disposing); + } + + #region Windows 窗体设计器生成的代码 + + /// + /// 设计器支持所需的方法 - 不要 + /// 使用代码编辑器修改此方法的内容。 + /// + private void InitializeComponent() + { + this.button1 = new System.Windows.Forms.Button(); + this.textBox1 = new System.Windows.Forms.TextBox(); + this.label1 = new System.Windows.Forms.Label(); + this.button2 = new System.Windows.Forms.Button(); + this.textBox2 = new System.Windows.Forms.TextBox(); + this.lvitem = new System.Windows.Forms.ListView(); + this.textBox3 = new System.Windows.Forms.TextBox(); + this.textBox4 = new System.Windows.Forms.TextBox(); + this.textBox5 = new System.Windows.Forms.TextBox(); + this.label2 = new System.Windows.Forms.Label(); + this.label3 = new System.Windows.Forms.Label(); + this.label4 = new System.Windows.Forms.Label(); + this.label5 = new System.Windows.Forms.Label(); + this.label6 = new System.Windows.Forms.Label(); + this.groupBox1 = new System.Windows.Forms.GroupBox(); + this.label17 = new System.Windows.Forms.Label(); + this.label16 = new System.Windows.Forms.Label(); + this.label15 = new System.Windows.Forms.Label(); + this.label14 = new System.Windows.Forms.Label(); + this.label13 = new System.Windows.Forms.Label(); + this.label12 = new System.Windows.Forms.Label(); + this.label11 = new System.Windows.Forms.Label(); + this.label10 = new System.Windows.Forms.Label(); + this.label9 = new System.Windows.Forms.Label(); + this.label8 = new System.Windows.Forms.Label(); + this.textBox7 = new System.Windows.Forms.TextBox(); + this.listBox1 = new System.Windows.Forms.ListBox(); + this.textBox6 = new System.Windows.Forms.TextBox(); + this.dataGridView1 = new System.Windows.Forms.DataGridView(); + this.Column1 = new System.Windows.Forms.DataGridViewTextBoxColumn(); + this.Column3 = new System.Windows.Forms.DataGridViewTextBoxColumn(); + this.Column2 = new System.Windows.Forms.DataGridViewTextBoxColumn(); + this.Column4 = new System.Windows.Forms.DataGridViewTextBoxColumn(); + this.Column5 = new System.Windows.Forms.DataGridViewTextBoxColumn(); + this.Column6 = new System.Windows.Forms.DataGridViewTextBoxColumn(); + this.Column7 = new System.Windows.Forms.DataGridViewTextBoxColumn(); + this.button3 = new System.Windows.Forms.Button(); + this.label7 = new System.Windows.Forms.Label(); + this.comboBox1 = new System.Windows.Forms.ComboBox(); + this.button4 = new System.Windows.Forms.Button(); + this.radioButton1 = new System.Windows.Forms.RadioButton(); + this.radioButton2 = new System.Windows.Forms.RadioButton(); + this.radioButton3 = new System.Windows.Forms.RadioButton(); + this.groupBox1.SuspendLayout(); + ((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).BeginInit(); + this.SuspendLayout(); + // + // button1 + // + this.button1.Location = new System.Drawing.Point(91, 417); + this.button1.Name = "button1"; + this.button1.Size = new System.Drawing.Size(75, 23); + this.button1.TabIndex = 2; + this.button1.Text = "nope"; + this.button1.UseVisualStyleBackColor = true; + this.button1.Click += new System.EventHandler(this.button1_Click); + // + // textBox1 + // + this.textBox1.Location = new System.Drawing.Point(79, 34); + this.textBox1.Name = "textBox1"; + this.textBox1.Size = new System.Drawing.Size(310, 21); + this.textBox1.TabIndex = 0; + this.textBox1.TextChanged += new System.EventHandler(this.textBox1_TextChanged); + // + // label1 + // + this.label1.AutoSize = true; + this.label1.Location = new System.Drawing.Point(560, 320); + this.label1.Name = "label1"; + this.label1.Size = new System.Drawing.Size(65, 12); + this.label1.TabIndex = 3; + this.label1.Text = "check view"; + this.label1.Visible = false; + this.label1.Click += new System.EventHandler(this.label1_Click); + this.label1.DoubleClick += new System.EventHandler(this.button1_Click); + // + // button2 + // + this.button2.Location = new System.Drawing.Point(255, 416); + this.button2.Name = "button2"; + this.button2.Size = new System.Drawing.Size(75, 23); + this.button2.TabIndex = 5; + this.button2.Text = "clear"; + this.button2.UseVisualStyleBackColor = true; + this.button2.Click += new System.EventHandler(this.button2_Click); + // + // textBox2 + // + this.textBox2.Location = new System.Drawing.Point(79, 75); + this.textBox2.Name = "textBox2"; + this.textBox2.Size = new System.Drawing.Size(310, 21); + this.textBox2.TabIndex = 6; + this.textBox2.TextChanged += new System.EventHandler(this.textBox2_TextChanged); + // + // lvitem + // + this.lvitem.GridLines = true; + this.lvitem.HeaderStyle = System.Windows.Forms.ColumnHeaderStyle.Nonclickable; + this.lvitem.Location = new System.Drawing.Point(631, 320); + this.lvitem.Name = "lvitem"; + this.lvitem.Size = new System.Drawing.Size(517, 61); + this.lvitem.TabIndex = 7; + this.lvitem.UseCompatibleStateImageBehavior = false; + this.lvitem.View = System.Windows.Forms.View.Details; + this.lvitem.Visible = false; + // + // textBox3 + // + this.textBox3.Location = new System.Drawing.Point(79, 116); + this.textBox3.Name = "textBox3"; + this.textBox3.Size = new System.Drawing.Size(310, 21); + this.textBox3.TabIndex = 8; + this.textBox3.TextChanged += new System.EventHandler(this.textBox3_TextChanged); + // + // textBox4 + // + this.textBox4.Location = new System.Drawing.Point(79, 157); + this.textBox4.Name = "textBox4"; + this.textBox4.Size = new System.Drawing.Size(310, 21); + this.textBox4.TabIndex = 9; + this.textBox4.TextChanged += new System.EventHandler(this.textBox4_TextChanged); + // + // textBox5 + // + this.textBox5.Location = new System.Drawing.Point(79, 198); + this.textBox5.Name = "textBox5"; + this.textBox5.Size = new System.Drawing.Size(310, 21); + this.textBox5.TabIndex = 10; + this.textBox5.TextChanged += new System.EventHandler(this.textBox5_TextChanged); + // + // label2 + // + this.label2.AutoSize = true; + this.label2.Location = new System.Drawing.Point(32, 34); + this.label2.Name = "label2"; + this.label2.Size = new System.Drawing.Size(23, 12); + this.label2.TabIndex = 11; + this.label2.Text = "Pid"; + // + // label3 + // + this.label3.AutoSize = true; + this.label3.Location = new System.Drawing.Point(32, 75); + this.label3.Name = "label3"; + this.label3.Size = new System.Drawing.Size(35, 12); + this.label3.TabIndex = 12; + this.label3.Text = "Pname"; + // + // label4 + // + this.label4.AutoSize = true; + this.label4.Location = new System.Drawing.Point(32, 116); + this.label4.Name = "label4"; + this.label4.Size = new System.Drawing.Size(41, 12); + this.label4.TabIndex = 13; + this.label4.Text = "Pprize"; + // + // label5 + // + this.label5.AutoSize = true; + this.label5.Location = new System.Drawing.Point(31, 157); + this.label5.Name = "label5"; + this.label5.Size = new System.Drawing.Size(35, 12); + this.label5.TabIndex = 14; + this.label5.Text = "Pspec"; + // + // label6 + // + this.label6.AutoSize = true; + this.label6.Location = new System.Drawing.Point(32, 198); + this.label6.Name = "label6"; + this.label6.Size = new System.Drawing.Size(47, 12); + this.label6.TabIndex = 15; + this.label6.Text = "Pamount"; + // + // groupBox1 + // + this.groupBox1.Controls.Add(this.radioButton3); + this.groupBox1.Controls.Add(this.radioButton2); + this.groupBox1.Controls.Add(this.radioButton1); + this.groupBox1.Controls.Add(this.label17); + this.groupBox1.Controls.Add(this.label16); + this.groupBox1.Controls.Add(this.label15); + this.groupBox1.Controls.Add(this.label14); + this.groupBox1.Controls.Add(this.label13); + this.groupBox1.Controls.Add(this.label12); + this.groupBox1.Controls.Add(this.label11); + this.groupBox1.Controls.Add(this.label10); + this.groupBox1.Controls.Add(this.label9); + this.groupBox1.Controls.Add(this.label8); + this.groupBox1.Controls.Add(this.textBox7); + this.groupBox1.Controls.Add(this.listBox1); + this.groupBox1.Controls.Add(this.textBox6); + this.groupBox1.Controls.Add(this.label6); + this.groupBox1.Controls.Add(this.label5); + this.groupBox1.Controls.Add(this.label4); + this.groupBox1.Controls.Add(this.label3); + this.groupBox1.Controls.Add(this.label2); + this.groupBox1.Controls.Add(this.textBox5); + this.groupBox1.Controls.Add(this.textBox4); + this.groupBox1.Controls.Add(this.textBox3); + this.groupBox1.Controls.Add(this.textBox2); + this.groupBox1.Controls.Add(this.textBox1); + this.groupBox1.Location = new System.Drawing.Point(79, 12); + this.groupBox1.Name = "groupBox1"; + this.groupBox1.Size = new System.Drawing.Size(1069, 238); + this.groupBox1.TabIndex = 16; + this.groupBox1.TabStop = false; + this.groupBox1.Text = "InputBox"; + // + // label17 + // + this.label17.AutoSize = true; + this.label17.Location = new System.Drawing.Point(500, 62); + this.label17.Name = "label17"; + this.label17.Size = new System.Drawing.Size(185, 12); + this.label17.TabIndex = 28; + this.label17.Text = "请输入供应商（Johnson indus.）"; + // + // label16 + // + this.label16.AutoSize = true; + this.label16.Location = new System.Drawing.Point(500, 19); + this.label16.Name = "label16"; + this.label16.Size = new System.Drawing.Size(161, 12); + this.label16.TabIndex = 27; + this.label16.Text = "请输入贮藏方法（no light）"; + // + // label15 + // + this.label15.AutoSize = true; + this.label15.Location = new System.Drawing.Point(79, 185); + this.label15.Name = "label15"; + this.label15.Size = new System.Drawing.Size(137, 12); + this.label15.TabIndex = 26; + this.label15.Text = "请输入数字（如：1500）"; + // + // label14 + // + this.label14.AutoSize = true; + this.label14.Location = new System.Drawing.Point(79, 144); + this.label14.Name = "label14"; + this.label14.Size = new System.Drawing.Size(161, 12); + this.label14.TabIndex = 25; + this.label14.Text = "请输入产品信息（10 pills）"; + // + // label13 + // + this.label13.AutoSize = true; + this.label13.Location = new System.Drawing.Point(79, 103); + this.label13.Name = "label13"; + this.label13.Size = new System.Drawing.Size(137, 12); + this.label13.TabIndex = 24; + this.label13.Text = "请输入价格（如：88.5）"; + // + // label12 + // + this.label12.AutoSize = true; + this.label12.Location = new System.Drawing.Point(79, 62); + this.label12.Name = "label12"; + this.label12.Size = new System.Drawing.Size(155, 12); + this.label12.TabIndex = 23; + this.label12.Text = "请输入药名（如：Asprine）"; + // + // label11 + // + this.label11.AutoSize = true; + this.label11.Location = new System.Drawing.Point(79, 16); + this.label11.Name = "label11"; + this.label11.Size = new System.Drawing.Size(131, 12); + this.label11.TabIndex = 22; + this.label11.Text = "请输入数字（如：123）"; + // + // label10 + // + this.label10.AutoSize = true; + this.label10.Location = new System.Drawing.Point(440, 75); + this.label10.Name = "label10"; + this.label10.Size = new System.Drawing.Size(59, 12); + this.label10.TabIndex = 19; + this.label10.Text = "Psupplier"; + // + // label9 + // + this.label9.AutoSize = true; + this.label9.Location = new System.Drawing.Point(438, 34); + this.label9.Name = "label9"; + this.label9.Size = new System.Drawing.Size(53, 12); + this.label9.TabIndex = 18; + this.label9.Text = "Pstorage"; + // + // label8 + // + this.label8.AutoSize = true; + this.label8.Location = new System.Drawing.Point(438, 158); + this.label8.Name = "label8"; + this.label8.Size = new System.Drawing.Size(53, 12); + this.label8.TabIndex = 21; + this.label8.Text = "信息列表"; + this.label8.Click += new System.EventHandler(this.label8_Click); + // + // textBox7 + // + this.textBox7.Location = new System.Drawing.Point(502, 78); + this.textBox7.Name = "textBox7"; + this.textBox7.Size = new System.Drawing.Size(310, 21); + this.textBox7.TabIndex = 17; + this.textBox7.TextChanged += new System.EventHandler(this.textBox7_TextChanged); + // + // listBox1 + // + this.listBox1.FormattingEnabled = true; + this.listBox1.ItemHeight = 12; + this.listBox1.Location = new System.Drawing.Point(500, 158); + this.listBox1.Name = "listBox1"; + this.listBox1.Size = new System.Drawing.Size(310, 64); + this.listBox1.TabIndex = 20; + this.listBox1.SelectedIndexChanged += new System.EventHandler(this.listBox1_SelectedIndexChanged); + // + // textBox6 + // + this.textBox6.Location = new System.Drawing.Point(502, 34); + this.textBox6.Name = "textBox6"; + this.textBox6.Size = new System.Drawing.Size(310, 21); + this.textBox6.TabIndex = 16; + this.textBox6.TextChanged += new System.EventHandler(this.textBox6_TextChanged); + // + // dataGridView1 + // + this.dataGridView1.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize; + this.dataGridView1.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] { + this.Column1, + this.Column3, + this.Column2, + this.Column4, + this.Column5, + this.Column6, + this.Column7}); + this.dataGridView1.Location = new System.Drawing.Point(79, 256); + this.dataGridView1.Name = "dataGridView1"; + this.dataGridView1.RowTemplate.Height = 23; + this.dataGridView1.Size = new System.Drawing.Size(743, 150); + this.dataGridView1.TabIndex = 16; + this.dataGridView1.CellContentClick += new System.Windows.Forms.DataGridViewCellEventHandler(this.dataGridView1_CellContentClick); + // + // Column1 + // + this.Column1.DataPropertyName = "Drug_ID"; + this.Column1.HeaderText = "id"; + this.Column1.Name = "Column1"; + // + // Column3 + // + this.Column3.DataPropertyName = "Drug_name"; + this.Column3.HeaderText = "name"; + this.Column3.Name = "Column3"; + // + // Column2 + // + this.Column2.DataPropertyName = "Drug_price"; + this.Column2.HeaderText = "prize"; + this.Column2.Name = "Column2"; + // + // Column4 + // + this.Column4.DataPropertyName = "Drug_specification"; + this.Column4.HeaderText = "spe"; + this.Column4.Name = "Column4"; + // + // Column5 + // + this.Column5.DataPropertyName = "Drug_supplier"; + this.Column5.HeaderText = "supp"; + this.Column5.Name = "Column5"; + // + // Column6 + // + this.Column6.DataPropertyName = "Drug_storage"; + this.Column6.HeaderText = "stor"; + this.Column6.Name = "Column6"; + // + // Column7 + // + this.Column7.DataPropertyName = "Drug_remain"; + this.Column7.HeaderText = "rema"; + this.Column7.Name = "Column7"; + // + // button3 + // + this.button3.Location = new System.Drawing.Point(419, 416); + this.button3.Name = "button3"; + this.button3.Size = new System.Drawing.Size(75, 23); + this.button3.TabIndex = 17; + this.button3.Text = "check"; + this.button3.UseVisualStyleBackColor = true; + this.button3.Click += new System.EventHandler(this.button3_Click); + // + // label7 + // + this.label7.AutoSize = true; + this.label7.Location = new System.Drawing.Point(132, 462); + this.label7.Name = "label7"; + this.label7.Size = new System.Drawing.Size(29, 12); + this.label7.TabIndex = 18; + this.label7.Text = "none"; + // + // comboBox1 + // + this.comboBox1.FormattingEnabled = true; + this.comboBox1.Location = new System.Drawing.Point(918, 283); + this.comboBox1.Name = "comboBox1"; + this.comboBox1.Size = new System.Drawing.Size(121, 20); + this.comboBox1.TabIndex = 19; + this.comboBox1.Visible = false; + // + // button4 + // + this.button4.Location = new System.Drawing.Point(581, 415); + this.button4.Name = "button4"; + this.button4.Size = new System.Drawing.Size(75, 23); + this.button4.TabIndex = 22; + this.button4.Text = "add"; + this.button4.UseVisualStyleBackColor = true; + this.button4.Click += new System.EventHandler(this.button4_Click); + // + // radioButton1 + // + this.radioButton1.AutoSize = true; + this.radioButton1.Checked = true; + this.radioButton1.Location = new System.Drawing.Point(442, 120); + this.radioButton1.Name = "radioButton1"; + this.radioButton1.Size = new System.Drawing.Size(71, 16); + this.radioButton1.TabIndex = 29; + this.radioButton1.TabStop = true; + this.radioButton1.Text = "药品名称"; + this.radioButton1.UseVisualStyleBackColor = true; + // + // radioButton2 + // + this.radioButton2.AutoSize = true; + this.radioButton2.Location = new System.Drawing.Point(562, 121); + this.radioButton2.Name = "radioButton2"; + this.radioButton2.Size = new System.Drawing.Size(59, 16); + this.radioButton2.TabIndex = 30; + this.radioButton2.TabStop = true; + this.radioButton2.Text = "供应商"; + this.radioButton2.UseVisualStyleBackColor = true; + this.radioButton2.CheckedChanged += new System.EventHandler(this.radioButton2_CheckedChanged); + // + // radioButton3 + // + this.radioButton3.AutoSize = true; + this.radioButton3.Location = new System.Drawing.Point(682, 121); + this.radioButton3.Name = "radioButton3"; + this.radioButton3.Size = new System.Drawing.Size(71, 16); + this.radioButton3.TabIndex = 31; + this.radioButton3.TabStop = true; + this.radioButton3.Text = "药品编号"; + this.radioButton3.UseVisualStyleBackColor = true; + this.radioButton3.CheckedChanged += new System.EventHandler(this.radioButton3_CheckedChanged); + // + // Form1 + // + this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 12F); + this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; + this.ClientSize = new System.Drawing.Size(1189, 485); + this.Controls.Add(this.dataGridView1); + this.Controls.Add(this.button4); + this.Controls.Add(this.comboBox1); + this.Controls.Add(this.label7); + this.Controls.Add(this.button3); + this.Controls.Add(this.groupBox1); + this.Controls.Add(this.lvitem); + this.Controls.Add(this.button2); + this.Controls.Add(this.label1); + this.Controls.Add(this.button1); + this.Name = "Form1"; + this.Text = "Product Input"; + this.Load += new System.EventHandler(this.Form1_Load); + this.groupBox1.ResumeLayout(false); + this.groupBox1.PerformLayout(); + ((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).EndInit(); + this.ResumeLayout(false); + this.PerformLayout(); + + } + + #endregion + + private System.Windows.Forms.Button button1; + private System.Windows.Forms.TextBox textBox1; + private System.Windows.Forms.Label label1; + private System.Windows.Forms.Button button2; + private System.Windows.Forms.TextBox textBox2; + private System.Windows.Forms.ListView lvitem; + private System.Windows.Forms.TextBox textBox3; + private System.Windows.Forms.TextBox textBox4; + private System.Windows.Forms.TextBox textBox5; + private System.Windows.Forms.Label label2; + private System.Windows.Forms.Label label3; + private System.Windows.Forms.Label label4; + private System.Windows.Forms.Label label5; + private System.Windows.Forms.Label label6; + private System.Windows.Forms.GroupBox groupBox1; + private System.Windows.Forms.Button button3; + private System.Windows.Forms.Label label7; + private System.Windows.Forms.DataGridView dataGridView1; + private System.Windows.Forms.ListBox listBox1; + private System.Windows.Forms.Label label8; + private System.Windows.Forms.ComboBox comboBox1; + private System.Windows.Forms.DataGridViewTextBoxColumn Column1; + private System.Windows.Forms.DataGridViewTextBoxColumn Column3; + private System.Windows.Forms.DataGridViewTextBoxColumn Column2; + private System.Windows.Forms.DataGridViewTextBoxColumn Column4; + private System.Windows.Forms.DataGridViewTextBoxColumn Column5; + private System.Windows.Forms.DataGridViewTextBoxColumn Column6; + private System.Windows.Forms.DataGridViewTextBoxColumn Column7; + private System.Windows.Forms.Button button4; + private System.Windows.Forms.TextBox textBox7; + private System.Windows.Forms.TextBox textBox6; + private System.Windows.Forms.Label label10; + private System.Windows.Forms.Label label9; + private System.Windows.Forms.Label label17; + private System.Windows.Forms.Label label16; + private System.Windows.Forms.Label label15; + private System.Windows.Forms.Label label14; + private System.Windows.Forms.Label label13; + private System.Windows.Forms.Label label12; + private System.Windows.Forms.Label label11; + private System.Windows.Forms.RadioButton radioButton3; + private System.Windows.Forms.RadioButton radioButton2; + private System.Windows.Forms.RadioButton radioButton1; + } +} + diff --git a/HospitalManageSys/Form_DrugIm.resx b/HospitalManageSys/Form_DrugIm.resx new file mode 100644 index 0000000..6011b93 --- /dev/null +++ b/HospitalManageSys/Form_DrugIm.resx @@ -0,0 +1,162 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + text/microsoft-resx + + + 2.0 + + + System.Resources.ResXResourceReader, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 + + + System.Resources.ResXResourceWriter, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 + + + True + + + True + + + True + + + True + + + True + + + True + + + True + + + True + + + True + + + True + + + True + + + True + + + True + + + True + + \ No newline at end of file diff --git a/HospitalManageSys/Form_DrugIm_2.cs b/HospitalManageSys/Form_DrugIm_2.cs new file mode 100644 index 0000000..0a16015 --- /dev/null +++ b/HospitalManageSys/Form_DrugIm_2.cs @@ -0,0 +1,88 @@ +using System; +using System.Collections.Generic; +using System.ComponentModel; +using System.Data; +using System.Drawing; +using System.Linq; +using System.Text; +using System.Windows.Forms; +using MySql.Data.MySqlClient; + +namespace HospitalManageSys +{ + public partial class Form_DrugIm_2 : Form + { + public Form_DrugIm_2() + { + InitializeComponent(); + } + DataSet ds = new DataSet(); + MySqlDataAdapter sda; + private void Form2_Load(object sender, EventArgs e) + { + mtbBirthDate.MaskInputRejected += new MaskInputRejectedEventHandler(mtbBirthDate_MaskInputRejected); + string connectionString = "Data Source=localhost;Initial Catalog=hospitalmanagesys;User ID=root;Password=nnnbc4318"; + string query = "insert into hospitalmanagesys.drug value('115','jam','29.0','nothing','ssk','u','19');"; + ds = SelectRows(ds, connectionString, query); + /*MySqlConnection conn = new MySqlConnection(connectionString); + string sql = "select*from drug"; + sda = new MySqlDataAdapter(sql, conn); + sda.Fill(ds); + DataTable dt = new DataTable("childTable"); + DataColumn column = new DataColumn("ChildID", typeof(System.Int32)); + column.AutoIncrement = true; + column.Caption = "ID"; + column.ReadOnly = true; + column.Unique = true; + dt.Columns.Add(column); + DataRow row; + for (int i = 0; i <= 4; i++) + { + row = dt.NewRow(); + row["ChildID"] = i; + dt.Rows.Add(row); + } + ds.Tables.Add(dt); + dataGridView1.DataSource = ds.Tables[0];*/ + + } + private void mtbBirthDate_MaskInputRejected(object sender,MaskInputRejectedEventArgs e) + { + ToolTip toolTip = new ToolTip(); + toolTip.IsBalloon = true; + toolTip.ToolTipIcon = ToolTipIcon.Warning; + toolTip.ToolTipTitle = "system warning"; + toolTip.Show("please input effective number",label1,2000); + } + + private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) + { + + } + private static DataSet SelectRows(DataSet dataset, string connectionString, string queryString) + { + using (MySqlConnection connection = new MySqlConnection(connectionString)) + { + MySqlDataAdapter adapter = new MySqlDataAdapter(); + adapter.SelectCommand = new MySqlCommand(queryString, connection); + adapter.Fill(dataset); + return dataset; + } + } + private void button1_Click(object sender, EventArgs e) + { + DialogResult dr = MessageBox.Show("确定要将修改的数据保存到数据库吗？", "修改提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); + if (dr == DialogResult.OK) + { + MySqlCommandBuilder sb = new MySqlCommandBuilder(sda); + sda.Update(ds); + MessageBox.Show("修改成功", "成功提示"); + } + } + + private void button2_Click(object sender, EventArgs e) + { + + } + } +} diff --git a/HospitalManageSys/Form_DrugIm_2.designer.cs b/HospitalManageSys/Form_DrugIm_2.designer.cs new file mode 100644 index 0000000..0442161 --- /dev/null +++ b/HospitalManageSys/Form_DrugIm_2.designer.cs @@ -0,0 +1,214 @@ +namespace HospitalManageSys +{ + partial class Form_DrugIm_2 + { + /// + /// Required designer variable. + /// + private System.ComponentModel.IContainer components = null; + + /// + /// Clean up any resources being used. + /// + /// true if managed resources should be disposed; otherwise, false. + protected override void Dispose(bool disposing) + { + if (disposing && (components != null)) + { + components.Dispose(); + } + base.Dispose(disposing); + } + + #region Windows Form Designer generated code + + /// + /// Required method for Designer support - do not modify + /// the contents of this method with the code editor. + /// + private void InitializeComponent() + { + this.components = new System.ComponentModel.Container(); + this.mtbBirthDate = new System.Windows.Forms.MaskedTextBox(); + this.maskedTextBox2 = new System.Windows.Forms.MaskedTextBox(); + this.maskedTextBox3 = new System.Windows.Forms.MaskedTextBox(); + this.maskedTextBox4 = new System.Windows.Forms.MaskedTextBox(); + this.maskedTextBox5 = new System.Windows.Forms.MaskedTextBox(); + this.label1 = new System.Windows.Forms.Label(); + this.label2 = new System.Windows.Forms.Label(); + this.label3 = new System.Windows.Forms.Label(); + this.label4 = new System.Windows.Forms.Label(); + this.label5 = new System.Windows.Forms.Label(); + this.toolTip1 = new System.Windows.Forms.ToolTip(this.components); + this.dataGridView1 = new System.Windows.Forms.DataGridView(); + this.button1 = new System.Windows.Forms.Button(); + this.button2 = new System.Windows.Forms.Button(); + ((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).BeginInit(); + this.SuspendLayout(); + // + // mtbBirthDate + // + this.mtbBirthDate.BeepOnError = true; + this.mtbBirthDate.Location = new System.Drawing.Point(202, 58); + this.mtbBirthDate.Mask = "0000-00-00 90:00:00"; + this.mtbBirthDate.Name = "mtbBirthDate"; + this.mtbBirthDate.Size = new System.Drawing.Size(100, 21); + this.mtbBirthDate.TabIndex = 0; + this.mtbBirthDate.ValidatingType = typeof(System.DateTime); + // + // maskedTextBox2 + // + this.maskedTextBox2.BeepOnError = true; + this.maskedTextBox2.Location = new System.Drawing.Point(202, 105); + this.maskedTextBox2.Mask = "000000-00000000-000A"; + this.maskedTextBox2.Name = "maskedTextBox2"; + this.maskedTextBox2.Size = new System.Drawing.Size(100, 21); + this.maskedTextBox2.TabIndex = 1; + // + // maskedTextBox3 + // + this.maskedTextBox3.BeepOnError = true; + this.maskedTextBox3.Location = new System.Drawing.Point(202, 150); + this.maskedTextBox3.Mask = "000-0000-0000"; + this.maskedTextBox3.Name = "maskedTextBox3"; + this.maskedTextBox3.Size = new System.Drawing.Size(100, 21); + this.maskedTextBox3.TabIndex = 2; + // + // maskedTextBox4 + // + this.maskedTextBox4.BeepOnError = true; + this.maskedTextBox4.Location = new System.Drawing.Point(202, 200); + this.maskedTextBox4.Mask = "000000"; + this.maskedTextBox4.Name = "maskedTextBox4"; + this.maskedTextBox4.Size = new System.Drawing.Size(100, 21); + this.maskedTextBox4.TabIndex = 3; + // + // maskedTextBox5 + // + this.maskedTextBox5.BeepOnError = true; + this.maskedTextBox5.Location = new System.Drawing.Point(202, 253); + this.maskedTextBox5.Mask = "0000年90月90日"; + this.maskedTextBox5.Name = "maskedTextBox5"; + this.maskedTextBox5.Size = new System.Drawing.Size(100, 21); + this.maskedTextBox5.TabIndex = 4; + this.maskedTextBox5.ValidatingType = typeof(System.DateTime); + // + // label1 + // + this.label1.AutoSize = true; + this.label1.Location = new System.Drawing.Point(155, 58); + this.label1.Name = "label1"; + this.label1.Size = new System.Drawing.Size(35, 12); + this.label1.TabIndex = 5; + this.label1.Text = "bdate"; + // + // label2 + // + this.label2.AutoSize = true; + this.label2.Location = new System.Drawing.Point(155, 113); + this.label2.Name = "label2"; + this.label2.Size = new System.Drawing.Size(17, 12); + this.label2.TabIndex = 6; + this.label2.Text = "id"; + // + // label3 + // + this.label3.AutoSize = true; + this.label3.Location = new System.Drawing.Point(155, 150); + this.label3.Name = "label3"; + this.label3.Size = new System.Drawing.Size(23, 12); + this.label3.TabIndex = 7; + this.label3.Text = "tel"; + // + // label4 + // + this.label4.AutoSize = true; + this.label4.Location = new System.Drawing.Point(154, 200); + this.label4.Name = "label4"; + this.label4.Size = new System.Drawing.Size(29, 12); + this.label4.TabIndex = 8; + this.label4.Text = "post"; + // + // label5 + // + this.label5.AutoSize = true; + this.label5.Location = new System.Drawing.Point(153, 253); + this.label5.Name = "label5"; + this.label5.Size = new System.Drawing.Size(29, 12); + this.label5.TabIndex = 9; + this.label5.Text = "time"; + // + // dataGridView1 + // + this.dataGridView1.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize; + this.dataGridView1.Location = new System.Drawing.Point(543, 70); + this.dataGridView1.Name = "dataGridView1"; + this.dataGridView1.Size = new System.Drawing.Size(240, 150); + this.dataGridView1.TabIndex = 10; + this.dataGridView1.CellContentClick += new System.Windows.Forms.DataGridViewCellEventHandler(this.dataGridView1_CellContentClick); + // + // button1 + // + this.button1.Location = new System.Drawing.Point(554, 274); + this.button1.Name = "button1"; + this.button1.Size = new System.Drawing.Size(75, 23); + this.button1.TabIndex = 11; + this.button1.Text = "button1"; + this.button1.UseVisualStyleBackColor = true; + this.button1.Click += new System.EventHandler(this.button1_Click); + // + // button2 + // + this.button2.Location = new System.Drawing.Point(719, 274); + this.button2.Name = "button2"; + this.button2.Size = new System.Drawing.Size(75, 23); + this.button2.TabIndex = 12; + this.button2.Text = "button2"; + this.button2.UseVisualStyleBackColor = true; + this.button2.Click += new System.EventHandler(this.button2_Click); + // + // Form2 + // + this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 12F); + this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; + this.ClientSize = new System.Drawing.Size(967, 338); + this.Controls.Add(this.button2); + this.Controls.Add(this.button1); + this.Controls.Add(this.dataGridView1); + this.Controls.Add(this.label5); + this.Controls.Add(this.label4); + this.Controls.Add(this.label3); + this.Controls.Add(this.label2); + this.Controls.Add(this.label1); + this.Controls.Add(this.maskedTextBox5); + this.Controls.Add(this.maskedTextBox4); + this.Controls.Add(this.maskedTextBox3); + this.Controls.Add(this.maskedTextBox2); + this.Controls.Add(this.mtbBirthDate); + this.Name = "Form2"; + this.Text = "Form2"; + this.Load += new System.EventHandler(this.Form2_Load); + ((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).EndInit(); + this.ResumeLayout(false); + this.PerformLayout(); + + } + + #endregion + + private System.Windows.Forms.MaskedTextBox mtbBirthDate; + private System.Windows.Forms.MaskedTextBox maskedTextBox2; + private System.Windows.Forms.MaskedTextBox maskedTextBox3; + private System.Windows.Forms.MaskedTextBox maskedTextBox4; + private System.Windows.Forms.MaskedTextBox maskedTextBox5; + private System.Windows.Forms.Label label1; + private System.Windows.Forms.Label label2; + private System.Windows.Forms.Label label3; + private System.Windows.Forms.Label label4; + private System.Windows.Forms.Label label5; + private System.Windows.Forms.ToolTip toolTip1; + private System.Windows.Forms.DataGridView dataGridView1; + private System.Windows.Forms.Button button1; + private System.Windows.Forms.Button button2; + } +} \ No newline at end of file diff --git a/HospitalManageSys/Form_DrugIm_2.resx b/HospitalManageSys/Form_DrugIm_2.resx new file mode 100644 index 0000000..df8339b --- /dev/null +++ b/HospitalManageSys/Form_DrugIm_2.resx @@ -0,0 +1,123 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + text/microsoft-resx + + + 2.0 + + + System.Resources.ResXResourceReader, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 + + + System.Resources.ResXResourceWriter, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 + + + 17, 17 + + \ No newline at end of file diff --git a/HospitalManageSys/Form_Login.Designer.cs b/HospitalManageSys/Form_Login.Designer.cs new file mode 100644 index 0000000..2c28a4c --- /dev/null +++ b/HospitalManageSys/Form_Login.Designer.cs @@ -0,0 +1,131 @@ +namespace HospitalManageSys +{ + partial class Form_Login + { + /// + /// Required designer variable. + /// + private System.ComponentModel.IContainer components = null; + + /// + /// Clean up any resources being used. + /// + /// true if managed resources should be disposed; otherwise, false. + protected override void Dispose(bool disposing) + { + if (disposing && (components != null)) + { + components.Dispose(); + } + base.Dispose(disposing); + } + + #region Windows Form Designer generated code + + /// + /// Required method for Designer support - do not modify + /// the contents of this method with the code editor. + /// + private void InitializeComponent() + { + this.textBox_ID = new System.Windows.Forms.TextBox(); + this.button_login = new System.Windows.Forms.Button(); + this.label_ID = new System.Windows.Forms.Label(); + this.label_pwd = new System.Windows.Forms.Label(); + this.textBox_pwd = new System.Windows.Forms.TextBox(); + this.button_cancel = new System.Windows.Forms.Button(); + this.SuspendLayout(); + // + // textBox_ID + // + this.textBox_ID.Location = new System.Drawing.Point(93, 31); + this.textBox_ID.Name = "textBox_ID"; + this.textBox_ID.Size = new System.Drawing.Size(100, 21); + this.textBox_ID.TabIndex = 0; + // + // button_login + // + this.button_login.Location = new System.Drawing.Point(93, 85); + this.button_login.Name = "button_login"; + this.button_login.Size = new System.Drawing.Size(75, 23); + this.button_login.TabIndex = 2; + this.button_login.Text = "登录"; + this.button_login.UseVisualStyleBackColor = true; + this.button_login.Click += new System.EventHandler(this.button_login_Click); + // + // label_ID + // + this.label_ID.AutoSize = true; + this.label_ID.Location = new System.Drawing.Point(46, 34); + this.label_ID.Name = "label_ID"; + this.label_ID.Size = new System.Drawing.Size(41, 12); + this.label_ID.TabIndex = 2; + this.label_ID.Text = "账号："; + // + // label_pwd + // + this.label_pwd.AutoSize = true; + this.label_pwd.Location = new System.Drawing.Point(46, 61); + this.label_pwd.Name = "label_pwd"; + this.label_pwd.Size = new System.Drawing.Size(41, 12); + this.label_pwd.TabIndex = 3; + this.label_pwd.Text = "密码："; + // + // textBox_pwd + // + this.textBox_pwd.Location = new System.Drawing.Point(93, 58); + this.textBox_pwd.Name = "textBox_pwd"; + this.textBox_pwd.PasswordChar = '*'; + this.textBox_pwd.ShortcutsEnabled = false; + this.textBox_pwd.Size = new System.Drawing.Size(100, 21); + this.textBox_pwd.TabIndex = 1; + this.textBox_pwd.UseSystemPasswordChar = true; + // + // button_cancel + // + this.button_cancel.Location = new System.Drawing.Point(93, 114); + this.button_cancel.Name = "button_cancel"; + this.button_cancel.Size = new System.Drawing.Size(75, 23); + this.button_cancel.TabIndex = 3; + this.button_cancel.Text = "取消"; + this.button_cancel.UseVisualStyleBackColor = true; + this.button_cancel.Click += new System.EventHandler(this.button_cancel_Click); + // + // Form_Login + // + this.AcceptButton = this.button_login; + this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 12F); + this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; + this.ClientSize = new System.Drawing.Size(237, 138); + this.ControlBox = false; + this.Controls.Add(this.button_cancel); + this.Controls.Add(this.textBox_pwd); + this.Controls.Add(this.label_pwd); + this.Controls.Add(this.label_ID); + this.Controls.Add(this.button_login); + this.Controls.Add(this.textBox_ID); + this.ForeColor = System.Drawing.SystemColors.ControlText; + this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.Fixed3D; + this.MaximizeBox = false; + this.MinimizeBox = false; + this.Name = "Form_Login"; + this.ShowIcon = false; + this.ShowInTaskbar = false; + this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen; + this.Text = "登录"; + this.Load += new System.EventHandler(this.administrator_Load); + this.ResumeLayout(false); + this.PerformLayout(); + + } + + #endregion + + private System.Windows.Forms.TextBox textBox_ID; + private System.Windows.Forms.Button button_login; + private System.Windows.Forms.Label label_ID; + private System.Windows.Forms.Label label_pwd; + private System.Windows.Forms.TextBox textBox_pwd; + private System.Windows.Forms.Button button_cancel; + } +} \ No newline at end of file diff --git a/HospitalManageSys/Form_Login.cs b/HospitalManageSys/Form_Login.cs new file mode 100644 index 0000000..7d234ba --- /dev/null +++ b/HospitalManageSys/Form_Login.cs @@ -0,0 +1,89 @@ +using System; +using System.Collections.Generic; +using System.ComponentModel; +using System.Data; +using System.Drawing; +using System.Linq; +using System.Text; +using System.Windows.Forms; +using MySql.Data.MySqlClient; +using System.IO; + +namespace HospitalManageSys +{ + public partial class Form_Login : Form + { + MySqlConnection con; + MySqlCommand cmd; + MySqlDataAdapter ada; + DataSet ds; + + public Form_Login(MySqlConnection connector) + { + InitializeComponent(); + + con = connector; + + cmd = new MySqlCommand("", con); + ada = new MySqlDataAdapter(cmd); + ds = new DataSet(); + } + + + private void administrator_Load(object sender, EventArgs e) + { + + } + + private void button_login_Click(object sender, EventArgs e) + { + con.Close(); + con.Open(); + cmd.CommandText = "select * from administrator where Admin_ID='" + textBox_ID.Text + "';"; + cmd.ExecuteNonQuery(); + ada.Fill(ds); + con.Close(); + + if (ds.Tables[0].Rows.Count != 0) + { + if (this.textBox_pwd.Text.GetHashCode().Equals(Convert.ToInt32(ds.Tables[0].Rows[0].ItemArray[9]))) + { + HospitalManageSys.SqlCmd.iflogin = true; + HospitalManageSys.SqlCmd.admin_id = ds.Tables[0].Rows[0].ItemArray[0].ToString().PadLeft(11, '0'); + HospitalManageSys.SqlCmd.admin_name = ds.Tables[0].Rows[0].ItemArray[1].ToString(); + HospitalManageSys.SqlCmd.admin_sex = ds.Tables[0].Rows[0].ItemArray[2].ToString(); + HospitalManageSys.SqlCmd.admin_job = ds.Tables[0].Rows[0].ItemArray[3].ToString(); + HospitalManageSys.SqlCmd.capab = (byte)Convert.ToInt16(ds.Tables[0].Rows[0].ItemArray[4]); + HospitalManageSys.SqlCmd.admin_depart = ds.Tables[0].Rows[0].ItemArray[5].ToString(); + + if (ds.Tables[0].Rows[0].ItemArray[8] != System.DBNull.Value)//如果有照片 + { + byte[] images = (byte[])ds.Tables[0].Rows[0].ItemArray[8]; + HospitalManageSys.SqlCmd.memStream = new MemoryStream(images);//字节流转化为内存流 + } + + this.Close(); + } + else + { + textBox_pwd.Clear(); + MessageBox.Show("输入的密码错误！请重新输入！", "提示", MessageBoxButtons.OK); + } + } + else + { + textBox_pwd.Clear(); + MessageBox.Show("账号不存在！请输入正确的账号！", "提示", MessageBoxButtons.OK); + + return; + } + } + + private void button_cancel_Click(object sender, EventArgs e) + { + this.Close(); + } + + + } +} diff --git a/HospitalManageSys/Form_Login.resx b/HospitalManageSys/Form_Login.resx new file mode 100644 index 0000000..1af7de1 --- /dev/null +++ b/HospitalManageSys/Form_Login.resx @@ -0,0 +1,120 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + text/microsoft-resx + + + 2.0 + + + System.Resources.ResXResourceReader, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 + + + System.Resources.ResXResourceWriter, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 + + \ No newline at end of file diff --git a/HospitalManageSys/Form_PWD.Designer.cs b/HospitalManageSys/Form_PWD.Designer.cs new file mode 100644 index 0000000..1bd75c9 --- /dev/null +++ b/HospitalManageSys/Form_PWD.Designer.cs @@ -0,0 +1,156 @@ +namespace HospitalManageSys +{ + partial class Form_PWD + { + /// + /// Required designer variable. + /// + private System.ComponentModel.IContainer components = null; + + /// + /// Clean up any resources being used. + /// + /// true if managed resources should be disposed; otherwise, false. + protected override void Dispose(bool disposing) + { + if (disposing && (components != null)) + { + components.Dispose(); + } + base.Dispose(disposing); + } + + #region Windows Form Designer generated code + + /// + /// Required method for Designer support - do not modify + /// the contents of this method with the code editor. + /// + private void InitializeComponent() + { + this.label1 = new System.Windows.Forms.Label(); + this.label2 = new System.Windows.Forms.Label(); + this.label3 = new System.Windows.Forms.Label(); + this.textBox_prePWD = new System.Windows.Forms.TextBox(); + this.textBox_newPWD = new System.Windows.Forms.TextBox(); + this.textBox_PWDagain = new System.Windows.Forms.TextBox(); + this.button_OK = new System.Windows.Forms.Button(); + this.button_cancel = new System.Windows.Forms.Button(); + this.SuspendLayout(); + // + // label1 + // + this.label1.AutoSize = true; + this.label1.Location = new System.Drawing.Point(77, 56); + this.label1.Name = "label1"; + this.label1.Size = new System.Drawing.Size(53, 12); + this.label1.TabIndex = 0; + this.label1.Text = "原密码："; + // + // label2 + // + this.label2.AutoSize = true; + this.label2.Location = new System.Drawing.Point(77, 105); + this.label2.Name = "label2"; + this.label2.Size = new System.Drawing.Size(53, 12); + this.label2.TabIndex = 0; + this.label2.Text = "新密码："; + // + // label3 + // + this.label3.AutoSize = true; + this.label3.Location = new System.Drawing.Point(53, 132); + this.label3.Name = "label3"; + this.label3.Size = new System.Drawing.Size(77, 12); + this.label3.TabIndex = 0; + this.label3.Text = "重复新密码："; + // + // textBox_prePWD + // + this.textBox_prePWD.Location = new System.Drawing.Point(136, 53); + this.textBox_prePWD.Name = "textBox_prePWD"; + this.textBox_prePWD.PasswordChar = '*'; + this.textBox_prePWD.ShortcutsEnabled = false; + this.textBox_prePWD.Size = new System.Drawing.Size(100, 21); + this.textBox_prePWD.TabIndex = 1; + this.textBox_prePWD.UseSystemPasswordChar = true; + // + // textBox_newPWD + // + this.textBox_newPWD.Location = new System.Drawing.Point(136, 102); + this.textBox_newPWD.Name = "textBox_newPWD"; + this.textBox_newPWD.PasswordChar = '*'; + this.textBox_newPWD.ShortcutsEnabled = false; + this.textBox_newPWD.Size = new System.Drawing.Size(100, 21); + this.textBox_newPWD.TabIndex = 2; + this.textBox_newPWD.UseSystemPasswordChar = true; + // + // textBox_PWDagain + // + this.textBox_PWDagain.Location = new System.Drawing.Point(136, 129); + this.textBox_PWDagain.Name = "textBox_PWDagain"; + this.textBox_PWDagain.PasswordChar = '*'; + this.textBox_PWDagain.ShortcutsEnabled = false; + this.textBox_PWDagain.Size = new System.Drawing.Size(100, 21); + this.textBox_PWDagain.TabIndex = 3; + this.textBox_PWDagain.UseSystemPasswordChar = true; + // + // button_OK + // + this.button_OK.Location = new System.Drawing.Point(243, 163); + this.button_OK.Name = "button_OK"; + this.button_OK.Size = new System.Drawing.Size(75, 23); + this.button_OK.TabIndex = 4; + this.button_OK.Text = "确认"; + this.button_OK.UseVisualStyleBackColor = true; + this.button_OK.Click += new System.EventHandler(this.button_OK_Click); + // + // button_cancel + // + this.button_cancel.Location = new System.Drawing.Point(243, 192); + this.button_cancel.Name = "button_cancel"; + this.button_cancel.Size = new System.Drawing.Size(75, 23); + this.button_cancel.TabIndex = 5; + this.button_cancel.Text = "取消"; + this.button_cancel.UseVisualStyleBackColor = true; + this.button_cancel.Click += new System.EventHandler(this.button_cancel_Click); + // + // Form_PWD + // + this.AcceptButton = this.button_OK; + this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 12F); + this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; + this.ClientSize = new System.Drawing.Size(326, 223); + this.ControlBox = false; + this.Controls.Add(this.button_cancel); + this.Controls.Add(this.button_OK); + this.Controls.Add(this.textBox_PWDagain); + this.Controls.Add(this.textBox_newPWD); + this.Controls.Add(this.textBox_prePWD); + this.Controls.Add(this.label3); + this.Controls.Add(this.label2); + this.Controls.Add(this.label1); + this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.Fixed3D; + this.Name = "Form_PWD"; + this.ShowIcon = false; + this.ShowInTaskbar = false; + this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen; + this.Text = "更换密码"; + this.Load += new System.EventHandler(this.Form_PWD_Load); + this.ResumeLayout(false); + this.PerformLayout(); + + } + + #endregion + + private System.Windows.Forms.Label label1; + private System.Windows.Forms.Label label2; + private System.Windows.Forms.Label label3; + private System.Windows.Forms.TextBox textBox_prePWD; + private System.Windows.Forms.TextBox textBox_newPWD; + private System.Windows.Forms.TextBox textBox_PWDagain; + private System.Windows.Forms.Button button_OK; + private System.Windows.Forms.Button button_cancel; + } +} \ No newline at end of file diff --git a/HospitalManageSys/Form_PWD.cs b/HospitalManageSys/Form_PWD.cs new file mode 100644 index 0000000..a0eb2e5 --- /dev/null +++ b/HospitalManageSys/Form_PWD.cs @@ -0,0 +1,84 @@ +using System; +using System.Collections.Generic; +using System.ComponentModel; +using System.Data; +using System.Drawing; +using System.Linq; +using System.Text; +using System.Windows.Forms; +using MySql.Data.MySqlClient; + +namespace HospitalManageSys +{ + public partial class Form_PWD : Form + { + MySqlConnection con; + MySqlCommand cmd; + MySqlDataAdapter ada; + DataSet ds; + + public Form_PWD(MySqlConnection connector) + { + InitializeComponent(); + + con = connector; + + cmd = new MySqlCommand("select * from administrator where Admin_ID = " + HospitalManageSys.SqlCmd.admin_id, con); + ada = new MySqlDataAdapter(cmd); + ds = new DataSet(); + ada.Fill(ds); + } + + private void button_cancel_Click(object sender, EventArgs e) + { + this.Close(); + } + + private void button_OK_Click(object sender, EventArgs e) + { + if (this.textBox_prePWD.Text.Trim() == string.Empty || this.textBox_newPWD.Text.Trim() == string.Empty || this.textBox_PWDagain.Text.Trim() == string.Empty) + { + MessageBox.Show("密码不能为空！", "提示", MessageBoxButtons.OK); + return; + } + + if (!this.textBox_prePWD.Text.GetHashCode().Equals(Convert.ToInt32(ds.Tables[0].Rows[0].ItemArray[9]))) + { + textBox_prePWD.Clear(); + textBox_newPWD.Clear(); + textBox_PWDagain.Clear(); + MessageBox.Show("原密码不正确！请再次输入！", "提示", MessageBoxButtons.OK); + + return; + } + else + if (!this.textBox_newPWD.Text.Equals(this.textBox_PWDagain.Text)) + { + textBox_newPWD.Clear(); + textBox_PWDagain.Clear(); + MessageBox.Show("两次输入新密码不一样！请重新输入！", "提示", MessageBoxButtons.OK); + + return; + } + else + { + con.Open(); + cmd.CommandText = "update administrator set Admin_password ='" + this.textBox_newPWD.Text.GetHashCode() + + "' where Admin_ID = " + HospitalManageSys.SqlCmd.admin_id; + cmd.ExecuteNonQuery(); + con.Close(); + + MessageBox.Show("密码修改成功！请不要忘记修改后的密码！"); + + this.Close(); + } + + + } + + private void Form_PWD_Load(object sender, EventArgs e) + { + + } + } +} diff --git a/HospitalManageSys/Form_PWD.resx b/HospitalManageSys/Form_PWD.resx new file mode 100644 index 0000000..1af7de1 --- /dev/null +++ b/HospitalManageSys/Form_PWD.resx @@ -0,0 +1,120 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + text/microsoft-resx + + + 2.0 + + + System.Resources.ResXResourceReader, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 + + + System.Resources.ResXResourceWriter, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 + + \ No newline at end of file diff --git a/HospitalManageSys/Form_Registration.cs b/HospitalManageSys/Form_Registration.cs new file mode 100644 index 0000000..818ca28 --- /dev/null +++ b/HospitalManageSys/Form_Registration.cs @@ -0,0 +1,195 @@ +using System; +using System.Collections.Generic; +using System.ComponentModel; +using System.Data; +using System.Drawing; +using System.Linq; +using System.Text; +using System.Windows.Forms; +using MySql.Data.MySqlClient; + +namespace HospitalManageSys +{ + public partial class Form_Registration : Form + { + MySqlConnection con; + MySqlCommand cmd; + DataSet ds; + MySqlDataAdapter ada; + + MainForm mf; + + + public Form_Registration(MySqlConnection connector, MainForm mainform) + { + InitializeComponent(); + + mf = mainform; + + string constr = "server=localhost;database=hospitalmanagesys;uid=huangweiqiang;pwd=hwq123456;"; + //con = new MySqlConnection(constr); + con = connector; + con.Open(); + cmd = new MySqlCommand("select * from administrator", con); + ada = new MySqlDataAdapter(cmd); + ds = new DataSet(); + ada.Fill(ds); + + //textBox8.Text = ds.Tables[0].Rows[0].ItemArray[1].ToString(); + + + string strID = getID(); + + textBox8.Text = strID; + + + + int ds_count = ds.Tables[0].Rows.Count; + for (int i = 0; i < ds_count; i++) + { + comboBox1_doctorID.Items.Add(ds.Tables[0].Rows[i].ItemArray[0].ToString()); + } + } + + + + private void Form1_Load(object sender, EventArgs e) + { + + } + + private void label5_Click(object sender, EventArgs e) + { + + } + + private string getID() + { + string str = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVXYZ"; + int[] iArr = { 0, 1, 2, 3, 4, 5, 6, 7, 8, 9 }; + char[] cArr = str.ToCharArray(); + Random rad =new Random(); + string date = DateTime.Now.ToString("yyyyMMddHHmmss"); + int str_i = rad.Next(cArr.Length); + int i = rad.Next(iArr.Length); + string name = date;//+ " " + cArr[str_i] + iArr[i]; + return name; + + } + + + private void textBox8_Click(object sender, EventArgs e) + { + string strID = getID(); + + textBox8.Text = strID; + } + + private void button1_Click(object sender, EventArgs e) + { + cmd.CommandText = "insert into registration (registration_count,patient_name,patient_sex,patient_insurance,doctor_ID,patient_address,patient_fee) value" + + "('" + textBox8.Text + "','" + textBox_name.Text + "','" + textBox_patientsex.Text + "','" + textBox_patient_insurance.Text + "','" + comboBox1_doctorID.Text + "','" + textBox4_patientaddress.Text + "','" + textBox_patient_fee.Text + "');"; + cmd.ExecuteNonQuery(); + } + + + + private void textBox8_TextChanged(object sender, EventArgs e) + { + string strID=getID(); + + textBox8.Text = strID; + } + + private void listBox1_SelectedIndexChanged_1(object sender, EventArgs e) + { + /* string constr = "server=localhost;database=hospitalmanagesys;uid=huangweiqiang;pwd=hwq123456;"; + con = new MySqlConnection(constr); + con.Open(); + MySqlCommand cm = new MySqlCommand("select admin_name,admin_ID from administrator", con); + + MySqlDataReader dr = cm.ExecuteReader(); + + //绑定 + + this.lbxAdministrator.DataSource = dr; //lbxEmp为ListBox对象 + + this.lbxadministrator.DataTextField = "admin_name"; + + this.lbxadministrator.DataValueField = "admin_ID"; + + this.lbxadministrator.DataBind(); + + dr.Close(); + + con.Close();*/ + } + + + private void cBoxTables_SelectedIndexChanged(object sender, EventArgs e) + { + + } + + + + private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) + { + ds.Clear(); + cmd.CommandText = "select * from administrator where admin_ID='" + comboBox1_doctorID.Text + "';"; + cmd.ExecuteNonQuery(); + ada.Fill(ds); + + + textBox9_doctorname.Text = ds.Tables[0].Rows[0].ItemArray[1].ToString(); + textBox5_doctordepartment.Text = ds.Tables[0].Rows[0].ItemArray[4].ToString(); + textBox7_doctorfee.Text = ds.Tables[0].Rows[0].ItemArray[5].ToString(); + textBox6_doctorcapability.Text = ds.Tables[0].Rows[0].ItemArray[3].ToString(); + + + } + + private void button2_Click(object sender, EventArgs e) + { + cmd.CommandText = "update registration set patient_name = '" + textBox_name.Text + + "',patient_sex = '" + textBox_patientsex.Text + + "',patient_insurance = '" + textBox_patient_insurance.Text + + "',doctor_ID = '" + comboBox1_doctorID.Text + + "',patient_address = '" + textBox4_patientaddress.Text + + "',patient_fee = '" + textBox_patient_fee.Text + + "' where registration_count = " + textBox1.Text; + + cmd.ExecuteNonQuery(); + + + } + + private void button3_Click(object sender, EventArgs e) + { + ds.Clear(); + cmd.CommandText = "select * from registration where registration_count ='" + textBox1.Text + "';"; + cmd.ExecuteNonQuery(); + ada.Fill(ds); + + textBox_name.Text = ds.Tables[0].Rows[0].ItemArray[11].ToString(); + textBox_patient_insurance.Text = ds.Tables[0].Rows[0].ItemArray[12].ToString(); + textBox_patientsex.Text = ds.Tables[0].Rows[0].ItemArray[13].ToString(); + textBox4_patientaddress.Text = ds.Tables[0].Rows[0].ItemArray[15].ToString(); + textBox_patient_fee.Text = ds.Tables[0].Rows[0].ItemArray[16].ToString(); + comboBox1_doctorID.Text = ds.Tables[0].Rows[0].ItemArray[17].ToString(); + + + } + + private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) + { + + } + + + } + + + + } + diff --git a/HospitalManageSys/Form_Registration.designer.cs b/HospitalManageSys/Form_Registration.designer.cs new file mode 100644 index 0000000..a55602e --- /dev/null +++ b/HospitalManageSys/Form_Registration.designer.cs @@ -0,0 +1,373 @@ +namespace HospitalManageSys +{ + partial class Form_Registration + { + /// + /// 必需的设计器变量。 + /// + private System.ComponentModel.IContainer components = null; + + /// + /// 清理所有正在使用的资源。 + /// + /// 如果应释放托管资源，为 true；否则为 false。 + protected override void Dispose(bool disposing) + { + if (disposing && (components != null)) + { + components.Dispose(); + } + base.Dispose(disposing); + } + + #region Windows 窗体设计器生成的代码 + + /// + /// 设计器支持所需的方法 - 不要 + /// 使用代码编辑器修改此方法的内容。 + /// + private void InitializeComponent() + { + this.label1 = new System.Windows.Forms.Label(); + this.label2 = new System.Windows.Forms.Label(); + this.textBox_name = new System.Windows.Forms.TextBox(); + this.label3 = new System.Windows.Forms.Label(); + this.textBox_patientsex = new System.Windows.Forms.TextBox(); + this.label5 = new System.Windows.Forms.Label(); + this.textBox_patient_insurance = new System.Windows.Forms.TextBox(); + this.label6 = new System.Windows.Forms.Label(); + this.label7 = new System.Windows.Forms.Label(); + this.textBox5_doctordepartment = new System.Windows.Forms.TextBox(); + this.label8 = new System.Windows.Forms.Label(); + this.textBox6_doctorcapability = new System.Windows.Forms.TextBox(); + this.label9 = new System.Windows.Forms.Label(); + this.textBox7_doctorfee = new System.Windows.Forms.TextBox(); + this.button1 = new System.Windows.Forms.Button(); + this.label10 = new System.Windows.Forms.Label(); + this.textBox4_patientaddress = new System.Windows.Forms.TextBox(); + this.textBox8 = new System.Windows.Forms.TextBox(); + this.textBox9_doctorname = new System.Windows.Forms.TextBox(); + this.comboBox1_doctorID = new System.Windows.Forms.ComboBox(); + this.label4 = new System.Windows.Forms.Label(); + this.button2 = new System.Windows.Forms.Button(); + this.button3_chazhao = new System.Windows.Forms.Button(); + this.textBox1 = new System.Windows.Forms.TextBox(); + this.label11 = new System.Windows.Forms.Label(); + this.label12 = new System.Windows.Forms.Label(); + this.textBox_patient_fee = new System.Windows.Forms.TextBox(); + this.groupBox1 = new System.Windows.Forms.GroupBox(); + this.groupBox1.SuspendLayout(); + this.SuspendLayout(); + // + // label1 + // + this.label1.AutoSize = true; + this.label1.Location = new System.Drawing.Point(35, 28); + this.label1.Name = "label1"; + this.label1.Size = new System.Drawing.Size(41, 12); + this.label1.TabIndex = 0; + this.label1.Text = "单号："; + // + // label2 + // + this.label2.AutoSize = true; + this.label2.Location = new System.Drawing.Point(35, 63); + this.label2.Name = "label2"; + this.label2.Size = new System.Drawing.Size(41, 12); + this.label2.TabIndex = 2; + this.label2.Text = "姓名："; + // + // textBox_name + // + this.textBox_name.Location = new System.Drawing.Point(100, 60); + this.textBox_name.Name = "textBox_name"; + this.textBox_name.Size = new System.Drawing.Size(100, 21); + this.textBox_name.TabIndex = 3; + // + // label3 + // + this.label3.AutoSize = true; + this.label3.Location = new System.Drawing.Point(233, 63); + this.label3.Name = "label3"; + this.label3.Size = new System.Drawing.Size(41, 12); + this.label3.TabIndex = 4; + this.label3.Text = "性别："; + // + // textBox_patientsex + // + this.textBox_patientsex.Location = new System.Drawing.Point(280, 60); + this.textBox_patientsex.Name = "textBox_patientsex"; + this.textBox_patientsex.Size = new System.Drawing.Size(32, 21); + this.textBox_patientsex.TabIndex = 5; + // + // label5 + // + this.label5.AutoSize = true; + this.label5.Location = new System.Drawing.Point(33, 103); + this.label5.Name = "label5"; + this.label5.Size = new System.Drawing.Size(65, 12); + this.label5.TabIndex = 8; + this.label5.Text = "医保证号："; + this.label5.Click += new System.EventHandler(this.label5_Click); + // + // textBox_patient_insurance + // + this.textBox_patient_insurance.Location = new System.Drawing.Point(100, 100); + this.textBox_patient_insurance.Name = "textBox_patient_insurance"; + this.textBox_patient_insurance.Size = new System.Drawing.Size(100, 21); + this.textBox_patient_insurance.TabIndex = 9; + // + // label6 + // + this.label6.AutoSize = true; + this.label6.Location = new System.Drawing.Point(35, 178); + this.label6.Name = "label6"; + this.label6.Size = new System.Drawing.Size(41, 12); + this.label6.TabIndex = 10; + this.label6.Text = "医生："; + // + // label7 + // + this.label7.AutoSize = true; + this.label7.Location = new System.Drawing.Point(233, 178); + this.label7.Name = "label7"; + this.label7.Size = new System.Drawing.Size(41, 12); + this.label7.TabIndex = 12; + this.label7.Text = "科室："; + // + // textBox5_doctordepartment + // + this.textBox5_doctordepartment.Location = new System.Drawing.Point(280, 175); + this.textBox5_doctordepartment.Name = "textBox5_doctordepartment"; + this.textBox5_doctordepartment.Size = new System.Drawing.Size(100, 21); + this.textBox5_doctordepartment.TabIndex = 13; + // + // label8 + // + this.label8.AutoSize = true; + this.label8.Location = new System.Drawing.Point(209, 219); + this.label8.Name = "label8"; + this.label8.Size = new System.Drawing.Size(65, 12); + this.label8.TabIndex = 14; + this.label8.Text = "门诊类型："; + // + // textBox6_doctorcapability + // + this.textBox6_doctorcapability.Location = new System.Drawing.Point(280, 213); + this.textBox6_doctorcapability.Name = "textBox6_doctorcapability"; + this.textBox6_doctorcapability.Size = new System.Drawing.Size(100, 21); + this.textBox6_doctorcapability.TabIndex = 15; + // + // label9 + // + this.label9.AutoSize = true; + this.label9.Location = new System.Drawing.Point(30, 213); + this.label9.Name = "label9"; + this.label9.Size = new System.Drawing.Size(53, 12); + this.label9.TabIndex = 16; + this.label9.Text = "挂号费："; + // + // textBox7_doctorfee + // + this.textBox7_doctorfee.Location = new System.Drawing.Point(100, 210); + this.textBox7_doctorfee.Name = "textBox7_doctorfee"; + this.textBox7_doctorfee.Size = new System.Drawing.Size(100, 21); + this.textBox7_doctorfee.TabIndex = 17; + // + // button1 + // + this.button1.Location = new System.Drawing.Point(215, 20); + this.button1.Name = "button1"; + this.button1.Size = new System.Drawing.Size(75, 23); + this.button1.TabIndex = 19; + this.button1.Text = "添加\r\n"; + this.button1.UseVisualStyleBackColor = true; + this.button1.Click += new System.EventHandler(this.button1_Click); + // + // label10 + // + this.label10.AutoSize = true; + this.label10.Location = new System.Drawing.Point(233, 103); + this.label10.Name = "label10"; + this.label10.Size = new System.Drawing.Size(41, 12); + this.label10.TabIndex = 20; + this.label10.Text = "单位："; + // + // textBox4_patientaddress + // + this.textBox4_patientaddress.Location = new System.Drawing.Point(280, 100); + this.textBox4_patientaddress.Name = "textBox4_patientaddress"; + this.textBox4_patientaddress.Size = new System.Drawing.Size(209, 21); + this.textBox4_patientaddress.TabIndex = 21; + // + // textBox8 + // + this.textBox8.Location = new System.Drawing.Point(100, 25); + this.textBox8.Name = "textBox8"; + this.textBox8.Size = new System.Drawing.Size(129, 21); + this.textBox8.TabIndex = 22; + this.textBox8.TextChanged += new System.EventHandler(this.textBox8_TextChanged); + // + // textBox9_doctorname + // + this.textBox9_doctorname.Location = new System.Drawing.Point(100, 175); + this.textBox9_doctorname.Name = "textBox9_doctorname"; + this.textBox9_doctorname.Size = new System.Drawing.Size(100, 21); + this.textBox9_doctorname.TabIndex = 23; + // + // comboBox1_doctorID + // + this.comboBox1_doctorID.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList; + this.comboBox1_doctorID.FormattingEnabled = true; + this.comboBox1_doctorID.Location = new System.Drawing.Point(100, 138); + this.comboBox1_doctorID.Name = "comboBox1_doctorID"; + this.comboBox1_doctorID.Size = new System.Drawing.Size(97, 20); + this.comboBox1_doctorID.TabIndex = 25; + this.comboBox1_doctorID.SelectedIndexChanged += new System.EventHandler(this.comboBox1_SelectedIndexChanged); + // + // label4 + // + this.label4.AutoSize = true; + this.label4.Location = new System.Drawing.Point(33, 141); + this.label4.Name = "label4"; + this.label4.Size = new System.Drawing.Size(65, 12); + this.label4.TabIndex = 26; + this.label4.Text = "医生编号："; + // + // button2 + // + this.button2.Location = new System.Drawing.Point(108, 20); + this.button2.Name = "button2"; + this.button2.Size = new System.Drawing.Size(75, 23); + this.button2.TabIndex = 27; + this.button2.Text = "修改"; + this.button2.UseVisualStyleBackColor = true; + this.button2.Click += new System.EventHandler(this.button2_Click); + // + // button3_chazhao + // + this.button3_chazhao.Location = new System.Drawing.Point(6, 20); + this.button3_chazhao.Name = "button3_chazhao"; + this.button3_chazhao.Size = new System.Drawing.Size(75, 23); + this.button3_chazhao.TabIndex = 28; + this.button3_chazhao.Text = "查找"; + this.button3_chazhao.UseVisualStyleBackColor = true; + this.button3_chazhao.Click += new System.EventHandler(this.button3_Click); + // + // textBox1 + // + this.textBox1.Location = new System.Drawing.Point(68, 62); + this.textBox1.Name = "textBox1"; + this.textBox1.Size = new System.Drawing.Size(141, 21); + this.textBox1.TabIndex = 30; + // + // label11 + // + this.label11.AutoSize = true; + this.label11.Location = new System.Drawing.Point(21, 71); + this.label11.Name = "label11"; + this.label11.Size = new System.Drawing.Size(41, 12); + this.label11.TabIndex = 32; + this.label11.Text = "单号："; + // + // label12 + // + this.label12.AutoSize = true; + this.label12.Location = new System.Drawing.Point(351, 63); + this.label12.Name = "label12"; + this.label12.Size = new System.Drawing.Size(65, 12); + this.label12.TabIndex = 33; + this.label12.Text = "预交费用："; + // + // textBox_patient_fee + // + this.textBox_patient_fee.Location = new System.Drawing.Point(424, 60); + this.textBox_patient_fee.Name = "textBox_patient_fee"; + this.textBox_patient_fee.Size = new System.Drawing.Size(65, 21); + this.textBox_patient_fee.TabIndex = 34; + // + // groupBox1 + // + this.groupBox1.Controls.Add(this.textBox1); + this.groupBox1.Controls.Add(this.label11); + this.groupBox1.Controls.Add(this.button3_chazhao); + this.groupBox1.Controls.Add(this.button2); + this.groupBox1.Controls.Add(this.button1); + this.groupBox1.Location = new System.Drawing.Point(32, 261); + this.groupBox1.Name = "groupBox1"; + this.groupBox1.Size = new System.Drawing.Size(309, 100); + this.groupBox1.TabIndex = 35; + this.groupBox1.TabStop = false; + this.groupBox1.Text = "操作"; + // + // Form1 + // + this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 12F); + this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; + this.ClientSize = new System.Drawing.Size(665, 442); + this.Controls.Add(this.groupBox1); + this.Controls.Add(this.textBox_patient_fee); + this.Controls.Add(this.label12); + this.Controls.Add(this.label4); + this.Controls.Add(this.comboBox1_doctorID); + this.Controls.Add(this.textBox9_doctorname); + this.Controls.Add(this.textBox8); + this.Controls.Add(this.textBox4_patientaddress); + this.Controls.Add(this.label10); + this.Controls.Add(this.textBox7_doctorfee); + this.Controls.Add(this.label9); + this.Controls.Add(this.textBox6_doctorcapability); + this.Controls.Add(this.label8); + this.Controls.Add(this.textBox5_doctordepartment); + this.Controls.Add(this.label7); + this.Controls.Add(this.label6); + this.Controls.Add(this.textBox_patient_insurance); + this.Controls.Add(this.label5); + this.Controls.Add(this.textBox_patientsex); + this.Controls.Add(this.label3); + this.Controls.Add(this.textBox_name); + this.Controls.Add(this.label2); + this.Controls.Add(this.label1); + this.Name = "Form1"; + this.Text = "Form1"; + this.Load += new System.EventHandler(this.Form1_Load); + this.groupBox1.ResumeLayout(false); + this.groupBox1.PerformLayout(); + this.ResumeLayout(false); + this.PerformLayout(); + + } + + #endregion + + private System.Windows.Forms.Label label1; + private System.Windows.Forms.Label label2; + private System.Windows.Forms.TextBox textBox_name; + private System.Windows.Forms.Label label3; + private System.Windows.Forms.TextBox textBox_patientsex; + private System.Windows.Forms.Label label5; + private System.Windows.Forms.TextBox textBox_patient_insurance; + private System.Windows.Forms.Label label6; + private System.Windows.Forms.Label label7; + private System.Windows.Forms.TextBox textBox5_doctordepartment; + private System.Windows.Forms.Label label8; + private System.Windows.Forms.TextBox textBox6_doctorcapability; + private System.Windows.Forms.Label label9; + private System.Windows.Forms.TextBox textBox7_doctorfee; + private System.Windows.Forms.Button button1; + private System.Windows.Forms.Label label10; + private System.Windows.Forms.TextBox textBox4_patientaddress; + private System.Windows.Forms.TextBox textBox8; + private System.Windows.Forms.TextBox textBox9_doctorname; + private System.Windows.Forms.ComboBox comboBox1_doctorID; + private System.Windows.Forms.Label label4; + private System.Windows.Forms.Button button2; + private System.Windows.Forms.Button button3_chazhao; + private System.Windows.Forms.TextBox textBox1; + private System.Windows.Forms.Label label11; + private System.Windows.Forms.Label label12; + private System.Windows.Forms.TextBox textBox_patient_fee; + private System.Windows.Forms.GroupBox groupBox1; + } +} + diff --git a/HospitalManageSys/Form_Registration.resx b/HospitalManageSys/Form_Registration.resx new file mode 100644 index 0000000..1af7de1 --- /dev/null +++ b/HospitalManageSys/Form_Registration.resx @@ -0,0 +1,120 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + text/microsoft-resx + + + 2.0 + + + System.Resources.ResXResourceReader, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 + + + System.Resources.ResXResourceWriter, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 + + \ No newline at end of file diff --git a/HospitalManageSys/HospitalManageSys.csproj b/HospitalManageSys/HospitalManageSys.csproj new file mode 100644 index 0000000..d22717e --- /dev/null +++ b/HospitalManageSys/HospitalManageSys.csproj @@ -0,0 +1,245 @@ + + + + Debug + x86 + 8.0.30703 + 2.0 + {EC5DF48B-BBEC-4678-939C-728E4FE1A2B9} + WinExe + Properties + HospitalManageSys + HospitalManageSys + v4.0 + Client + 512 + false + publish\ + true + Disk + false + Foreground + 7 + Days + false + false + true + 2 + 1.0.0.%2a + false + true + true + + + x86 + true + full + false + bin\Debug\ + DEBUG;TRACE + prompt + 4 + + + x86 + pdbonly + true + bin\Release\ + TRACE + prompt + 4 + + + EAF4BE5EEB376CD7E9FAE2562513473C2BD2B4E7 + + + HospitalManageSys_TemporaryKey.pfx + + + true + + + false + + + + False + bin\MySql.Data.dll + + + + + + + + + + + + + + + Form + + + Form_Adminisrtator.cs + + + Form + + + Form_Charge.cs + + + Form + + + Form_DrugEx.cs + + + Form + + + Form_DrugIm.cs + + + Form + + + Form_DrugIm_2.cs + + + Form + + + Form_Login.cs + + + Form + + + Form_Registration.cs + + + Form + + + MainForm.cs + + + Form + + + Form_PWD.cs + + + + + + Form_Adminisrtator.cs + + + Form_Charge.cs + + + Form_DrugEx.cs + + + Form_DrugIm.cs + + + Form_DrugIm_2.cs + + + Form_Login.cs + + + Form_Registration.cs + + + MainForm.cs + + + Form_PWD.cs + + + ResXFileCodeGenerator + Resources.Designer.cs + Designer + + + True + Resources.resx + True + + + SettingsSingleFileGenerator + Settings.Designer.cs + + + True + Settings.settings + True + + + + + False + Microsoft .NET Framework 4 Client Profile %28x86 和 x64%29 + true + + + False + .NET Framework 3.5 SP1 Client Profile + false + + + False + .NET Framework 3.5 SP1 + false + + + False + Windows Installer 3.1 + true + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + \ No newline at end of file diff --git a/HospitalManageSys/HospitalManageSys.csproj.user b/HospitalManageSys/HospitalManageSys.csproj.user new file mode 100644 index 0000000..447d59c --- /dev/null +++ b/HospitalManageSys/HospitalManageSys.csproj.user @@ -0,0 +1,16 @@ + + + + publish\|C:\Users\Batty\Desktop\ + + + + + + zh-CN + false + + + false + + \ No newline at end of file diff --git a/HospitalManageSys/MainForm.Designer.cs b/HospitalManageSys/MainForm.Designer.cs new file mode 100644 index 0000000..a6bb1b8 --- /dev/null +++ b/HospitalManageSys/MainForm.Designer.cs @@ -0,0 +1,629 @@ +namespace HospitalManageSys +{ + partial class MainForm + { + /// + /// 必需的设计器变量。 + /// + private System.ComponentModel.IContainer components = null; + + /// + /// 清理所有正在使用的资源。 + /// + /// 如果应释放托管资源，为 true；否则为 false。 + protected override void Dispose(bool disposing) + { + if (disposing && (components != null)) + { + components.Dispose(); + } + base.Dispose(disposing); + } + + #region Windows 窗体设计器生成的代码 + + /// + /// 设计器支持所需的方法 - 不要 + /// 使用代码编辑器修改此方法的内容。 + /// + private void InitializeComponent() + { + this.components = new System.ComponentModel.Container(); + this.menuStrip = new System.Windows.Forms.MenuStrip(); + this.AdminOperationToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem(); + this.AdminLoginToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem(); + this.AdminLogoutToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem(); + this.AdminSwitchToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem(); + this.AdminPWDToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem(); + this.toolStripSeparator9 = new System.Windows.Forms.ToolStripSeparator(); + this.exitToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem(); + this.windowsMenu = new System.Windows.Forms.ToolStripMenuItem(); + this.cascadeToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem(); + this.tileVerticalToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem(); + this.tileHorizontalToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem(); + this.closeAllToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem(); + this.arrangeIconsToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem(); + this.viewMenu = new System.Windows.Forms.ToolStripMenuItem(); + this.toolBarToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem(); + this.statusBarToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem(); + this.helpMenu = new System.Windows.Forms.ToolStripMenuItem(); + this.aboutToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem(); + this.toolStrip = new System.Windows.Forms.ToolStrip(); + this.toolStripButton_login = new System.Windows.Forms.ToolStripButton(); + this.toolStripButton2 = new System.Windows.Forms.ToolStripSeparator(); + this.toolStripSeparator1 = new System.Windows.Forms.ToolStripSeparator(); + this.toolStripButton_Admin = new System.Windows.Forms.ToolStripButton(); + this.toolStripButton_Registration = new System.Windows.Forms.ToolStripButton(); + this.toolStripButton_Clinic = new System.Windows.Forms.ToolStripButton(); + this.toolStripButton_DrugEx = new System.Windows.Forms.ToolStripButton(); + this.toolStripButton_Charge = new System.Windows.Forms.ToolStripButton(); + this.toolStripButton_DrugIm = new System.Windows.Forms.ToolStripButton(); + this.toolStripButton1 = new System.Windows.Forms.ToolStripSeparator(); + this.toolStripButton3 = new System.Windows.Forms.ToolStripSeparator(); + this.toolStripButton_exit = new System.Windows.Forms.ToolStripButton(); + this.statusStrip = new System.Windows.Forms.StatusStrip(); + this.toolStripStatusLabel = new System.Windows.Forms.ToolStripStatusLabel(); + this.toolTip = new System.Windows.Forms.ToolTip(this.components); + this.groupBox_info = new System.Windows.Forms.GroupBox(); + this.label_job = new System.Windows.Forms.Label(); + this.label5 = new System.Windows.Forms.Label(); + this.pictureBox1 = new System.Windows.Forms.PictureBox(); + this.label1 = new System.Windows.Forms.Label(); + this.label2 = new System.Windows.Forms.Label(); + this.label3 = new System.Windows.Forms.Label(); + this.label4 = new System.Windows.Forms.Label(); + this.label_id = new System.Windows.Forms.Label(); + this.label_name = new System.Windows.Forms.Label(); + this.label_sex = new System.Windows.Forms.Label(); + this.label_depart = new System.Windows.Forms.Label(); + this.label_lflogin = new System.Windows.Forms.Label(); + this.panel_WinArea = new System.Windows.Forms.Panel(); + this.menuStrip.SuspendLayout(); + this.toolStrip.SuspendLayout(); + this.statusStrip.SuspendLayout(); + this.groupBox_info.SuspendLayout(); + ((System.ComponentModel.ISupportInitialize)(this.pictureBox1)).BeginInit(); + this.panel_WinArea.SuspendLayout(); + this.SuspendLayout(); + // + // menuStrip + // + this.menuStrip.Items.AddRange(new System.Windows.Forms.ToolStripItem[] { + this.AdminOperationToolStripMenuItem, + this.windowsMenu, + this.viewMenu, + this.helpMenu}); + this.menuStrip.Location = new System.Drawing.Point(0, 0); + this.menuStrip.MdiWindowListItem = this.windowsMenu; + this.menuStrip.Name = "menuStrip"; + this.menuStrip.Size = new System.Drawing.Size(801, 25); + this.menuStrip.TabIndex = 0; + this.menuStrip.Text = "MenuStrip"; + // + // AdminOperationToolStripMenuItem + // + this.AdminOperationToolStripMenuItem.DropDownItems.AddRange(new System.Windows.Forms.ToolStripItem[] { + this.AdminLoginToolStripMenuItem, + this.AdminLogoutToolStripMenuItem, + this.AdminSwitchToolStripMenuItem, + this.AdminPWDToolStripMenuItem, + this.toolStripSeparator9, + this.exitToolStripMenuItem}); + this.AdminOperationToolStripMenuItem.Name = "AdminOperationToolStripMenuItem"; + this.AdminOperationToolStripMenuItem.Size = new System.Drawing.Size(84, 21); + this.AdminOperationToolStripMenuItem.Text = "用户操作(&A)"; + // + // AdminLoginToolStripMenuItem + // + this.AdminLoginToolStripMenuItem.Name = "AdminLoginToolStripMenuItem"; + this.AdminLoginToolStripMenuItem.Size = new System.Drawing.Size(140, 22); + this.AdminLoginToolStripMenuItem.Text = "用户登录"; + this.AdminLoginToolStripMenuItem.Click += new System.EventHandler(this.AdminLoginToolStripMenuItem_Click); + // + // AdminLogoutToolStripMenuItem + // + this.AdminLogoutToolStripMenuItem.Name = "AdminLogoutToolStripMenuItem"; + this.AdminLogoutToolStripMenuItem.Size = new System.Drawing.Size(140, 22); + this.AdminLogoutToolStripMenuItem.Text = "用户注销"; + this.AdminLogoutToolStripMenuItem.Click += new System.EventHandler(this.AdminLogoutToolStripMenuItem_Click); + // + // AdminSwitchToolStripMenuItem + // + this.AdminSwitchToolStripMenuItem.Name = "AdminSwitchToolStripMenuItem"; + this.AdminSwitchToolStripMenuItem.Size = new System.Drawing.Size(140, 22); + this.AdminSwitchToolStripMenuItem.Text = "用户切换"; + this.AdminSwitchToolStripMenuItem.Click += new System.EventHandler(this.AdminSwitchToolStripMenuItem_Click); + // + // AdminPWDToolStripMenuItem + // + this.AdminPWDToolStripMenuItem.Name = "AdminPWDToolStripMenuItem"; + this.AdminPWDToolStripMenuItem.Size = new System.Drawing.Size(140, 22); + this.AdminPWDToolStripMenuItem.Text = "更换密码"; + this.AdminPWDToolStripMenuItem.Click += new System.EventHandler(this.AdminPWDToolStripMenuItem_Click); + // + // toolStripSeparator9 + // + this.toolStripSeparator9.Name = "toolStripSeparator9"; + this.toolStripSeparator9.Size = new System.Drawing.Size(137, 6); + // + // exitToolStripMenuItem + // + this.exitToolStripMenuItem.Name = "exitToolStripMenuItem"; + this.exitToolStripMenuItem.Size = new System.Drawing.Size(140, 22); + this.exitToolStripMenuItem.Text = "退出系统(&X)"; + this.exitToolStripMenuItem.Click += new System.EventHandler(this.ExitToolsStripMenuItem_Click); + // + // windowsMenu + // + this.windowsMenu.DropDownItems.AddRange(new System.Windows.Forms.ToolStripItem[] { + this.cascadeToolStripMenuItem, + this.tileVerticalToolStripMenuItem, + this.tileHorizontalToolStripMenuItem, + this.closeAllToolStripMenuItem, + this.arrangeIconsToolStripMenuItem}); + this.windowsMenu.Name = "windowsMenu"; + this.windowsMenu.Size = new System.Drawing.Size(64, 21); + this.windowsMenu.Text = "窗口(&W)"; + // + // cascadeToolStripMenuItem + // + this.cascadeToolStripMenuItem.Name = "cascadeToolStripMenuItem"; + this.cascadeToolStripMenuItem.Size = new System.Drawing.Size(141, 22); + this.cascadeToolStripMenuItem.Text = "层叠(&C)"; + this.cascadeToolStripMenuItem.Click += new System.EventHandler(this.CascadeToolStripMenuItem_Click); + // + // tileVerticalToolStripMenuItem + // + this.tileVerticalToolStripMenuItem.Name = "tileVerticalToolStripMenuItem"; + this.tileVerticalToolStripMenuItem.Size = new System.Drawing.Size(141, 22); + this.tileVerticalToolStripMenuItem.Text = "垂直平铺(&V)"; + this.tileVerticalToolStripMenuItem.Click += new System.EventHandler(this.TileVerticalToolStripMenuItem_Click); + // + // tileHorizontalToolStripMenuItem + // + this.tileHorizontalToolStripMenuItem.Name = "tileHorizontalToolStripMenuItem"; + this.tileHorizontalToolStripMenuItem.Size = new System.Drawing.Size(141, 22); + this.tileHorizontalToolStripMenuItem.Text = "水平平铺(&H)"; + this.tileHorizontalToolStripMenuItem.Click += new System.EventHandler(this.TileHorizontalToolStripMenuItem_Click); + // + // closeAllToolStripMenuItem + // + this.closeAllToolStripMenuItem.Name = "closeAllToolStripMenuItem"; + this.closeAllToolStripMenuItem.Size = new System.Drawing.Size(141, 22); + this.closeAllToolStripMenuItem.Text = "全部关闭(&L)"; + this.closeAllToolStripMenuItem.Click += new System.EventHandler(this.CloseAllToolStripMenuItem_Click); + // + // arrangeIconsToolStripMenuItem + // + this.arrangeIconsToolStripMenuItem.Name = "arrangeIconsToolStripMenuItem"; + this.arrangeIconsToolStripMenuItem.Size = new System.Drawing.Size(141, 22); + this.arrangeIconsToolStripMenuItem.Text = "排列图标(&A)"; + this.arrangeIconsToolStripMenuItem.Click += new System.EventHandler(this.ArrangeIconsToolStripMenuItem_Click); + // + // viewMenu + // + this.viewMenu.DropDownItems.AddRange(new System.Windows.Forms.ToolStripItem[] { + this.toolBarToolStripMenuItem, + this.statusBarToolStripMenuItem}); + this.viewMenu.Name = "viewMenu"; + this.viewMenu.Size = new System.Drawing.Size(60, 21); + this.viewMenu.Text = "视图(&V)"; + // + // toolBarToolStripMenuItem + // + this.toolBarToolStripMenuItem.Checked = true; + this.toolBarToolStripMenuItem.CheckOnClick = true; + this.toolBarToolStripMenuItem.CheckState = System.Windows.Forms.CheckState.Checked; + this.toolBarToolStripMenuItem.Name = "toolBarToolStripMenuItem"; + this.toolBarToolStripMenuItem.Size = new System.Drawing.Size(127, 22); + this.toolBarToolStripMenuItem.Text = "工具栏(&T)"; + this.toolBarToolStripMenuItem.Click += new System.EventHandler(this.ToolBarToolStripMenuItem_Click); + // + // statusBarToolStripMenuItem + // + this.statusBarToolStripMenuItem.Checked = true; + this.statusBarToolStripMenuItem.CheckOnClick = true; + this.statusBarToolStripMenuItem.CheckState = System.Windows.Forms.CheckState.Checked; + this.statusBarToolStripMenuItem.Name = "statusBarToolStripMenuItem"; + this.statusBarToolStripMenuItem.Size = new System.Drawing.Size(127, 22); + this.statusBarToolStripMenuItem.Text = "状态栏(&S)"; + this.statusBarToolStripMenuItem.Click += new System.EventHandler(this.StatusBarToolStripMenuItem_Click); + // + // helpMenu + // + this.helpMenu.DropDownItems.AddRange(new System.Windows.Forms.ToolStripItem[] { + this.aboutToolStripMenuItem}); + this.helpMenu.Name = "helpMenu"; + this.helpMenu.Size = new System.Drawing.Size(61, 21); + this.helpMenu.Text = "帮助(&H)"; + // + // aboutToolStripMenuItem + // + this.aboutToolStripMenuItem.Name = "aboutToolStripMenuItem"; + this.aboutToolStripMenuItem.Size = new System.Drawing.Size(142, 22); + this.aboutToolStripMenuItem.Text = "关于(&A) ... ..."; + // + // toolStrip + // + this.toolStrip.Items.AddRange(new System.Windows.Forms.ToolStripItem[] { + this.toolStripButton_login, + this.toolStripButton2, + this.toolStripSeparator1, + this.toolStripButton_Admin, + this.toolStripButton_Registration, + this.toolStripButton_Clinic, + this.toolStripButton_DrugEx, + this.toolStripButton_Charge, + this.toolStripButton_DrugIm, + this.toolStripButton1, + this.toolStripButton3, + this.toolStripButton_exit}); + this.toolStrip.Location = new System.Drawing.Point(0, 25); + this.toolStrip.Name = "toolStrip"; + this.toolStrip.Size = new System.Drawing.Size(801, 40); + this.toolStrip.TabIndex = 1; + this.toolStrip.Text = "ToolStrip"; + // + // toolStripButton_login + // + this.toolStripButton_login.Image = global::HospitalManageSys.Properties.Resources.login; + this.toolStripButton_login.ImageTransparentColor = System.Drawing.Color.Magenta; + this.toolStripButton_login.Name = "toolStripButton_login"; + this.toolStripButton_login.Size = new System.Drawing.Size(36, 37); + this.toolStripButton_login.Text = "登录"; + this.toolStripButton_login.TextDirection = System.Windows.Forms.ToolStripTextDirection.Horizontal; + this.toolStripButton_login.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText; + this.toolStripButton_login.Click += new System.EventHandler(this.AdminLoginToolStripMenuItem_Click); + // + // toolStripButton2 + // + this.toolStripButton2.Name = "toolStripButton2"; + this.toolStripButton2.Size = new System.Drawing.Size(6, 40); + // + // toolStripSeparator1 + // + this.toolStripSeparator1.Name = "toolStripSeparator1"; + this.toolStripSeparator1.Size = new System.Drawing.Size(6, 40); + // + // toolStripButton_Admin + // + this.toolStripButton_Admin.Enabled = false; + this.toolStripButton_Admin.Image = global::HospitalManageSys.Properties.Resources.admin; + this.toolStripButton_Admin.ImageTransparentColor = System.Drawing.Color.Magenta; + this.toolStripButton_Admin.Name = "toolStripButton_Admin"; + this.toolStripButton_Admin.Size = new System.Drawing.Size(60, 37); + this.toolStripButton_Admin.Text = "人事管理"; + this.toolStripButton_Admin.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText; + this.toolStripButton_Admin.Click += new System.EventHandler(this.AdminForm_Click); + // + // toolStripButton_Registration + // + this.toolStripButton_Registration.Enabled = false; + this.toolStripButton_Registration.Image = global::HospitalManageSys.Properties.Resources.registration; + this.toolStripButton_Registration.ImageTransparentColor = System.Drawing.Color.Magenta; + this.toolStripButton_Registration.Name = "toolStripButton_Registration"; + this.toolStripButton_Registration.Size = new System.Drawing.Size(60, 37); + this.toolStripButton_Registration.Text = "门诊挂号"; + this.toolStripButton_Registration.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText; + this.toolStripButton_Registration.Click += new System.EventHandler(this.RegistrationForm_Click); + // + // toolStripButton_Clinic + // + this.toolStripButton_Clinic.Enabled = false; + this.toolStripButton_Clinic.Image = global::HospitalManageSys.Properties.Resources.clinic; + this.toolStripButton_Clinic.ImageTransparentColor = System.Drawing.Color.Magenta; + this.toolStripButton_Clinic.Name = "toolStripButton_Clinic"; + this.toolStripButton_Clinic.Size = new System.Drawing.Size(60, 37); + this.toolStripButton_Clinic.Text = "医生门诊"; + this.toolStripButton_Clinic.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText; + this.toolStripButton_Clinic.Click += new System.EventHandler(this.ClinicForm_Click); + // + // toolStripButton_DrugEx + // + this.toolStripButton_DrugEx.Enabled = false; + this.toolStripButton_DrugEx.Image = global::HospitalManageSys.Properties.Resources.drugEx; + this.toolStripButton_DrugEx.ImageTransparentColor = System.Drawing.Color.Magenta; + this.toolStripButton_DrugEx.Name = "toolStripButton_DrugEx"; + this.toolStripButton_DrugEx.Size = new System.Drawing.Size(60, 37); + this.toolStripButton_DrugEx.Text = "发药系统"; + this.toolStripButton_DrugEx.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText; + this.toolStripButton_DrugEx.Click += new System.EventHandler(this.DrugExForm_Click); + // + // toolStripButton_Charge + // + this.toolStripButton_Charge.Enabled = false; + this.toolStripButton_Charge.Image = global::HospitalManageSys.Properties.Resources.charge; + this.toolStripButton_Charge.ImageTransparentColor = System.Drawing.Color.Magenta; + this.toolStripButton_Charge.Name = "toolStripButton_Charge"; + this.toolStripButton_Charge.Size = new System.Drawing.Size(60, 37); + this.toolStripButton_Charge.Text = "收费系统"; + this.toolStripButton_Charge.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText; + this.toolStripButton_Charge.Click += new System.EventHandler(this.ChargeForm_Click); + // + // toolStripButton_DrugIm + // + this.toolStripButton_DrugIm.Enabled = false; + this.toolStripButton_DrugIm.Image = global::HospitalManageSys.Properties.Resources.drugIm; + this.toolStripButton_DrugIm.ImageTransparentColor = System.Drawing.Color.Magenta; + this.toolStripButton_DrugIm.Name = "toolStripButton_DrugIm"; + this.toolStripButton_DrugIm.Size = new System.Drawing.Size(60, 37); + this.toolStripButton_DrugIm.Text = "药品入库"; + this.toolStripButton_DrugIm.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText; + this.toolStripButton_DrugIm.Click += new System.EventHandler(this.DrugImForm_Click); + // + // toolStripButton1 + // + this.toolStripButton1.Name = "toolStripButton1"; + this.toolStripButton1.Size = new System.Drawing.Size(6, 40); + // + // toolStripButton3 + // + this.toolStripButton3.Name = "toolStripButton3"; + this.toolStripButton3.Size = new System.Drawing.Size(6, 40); + // + // toolStripButton_exit + // + this.toolStripButton_exit.Image = global::HospitalManageSys.Properties.Resources.exit; + this.toolStripButton_exit.ImageTransparentColor = System.Drawing.Color.Magenta; + this.toolStripButton_exit.Name = "toolStripButton_exit"; + this.toolStripButton_exit.Size = new System.Drawing.Size(60, 37); + this.toolStripButton_exit.Text = "退出系统"; + this.toolStripButton_exit.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText; + this.toolStripButton_exit.Click += new System.EventHandler(this.ExitToolsStripMenuItem_Click); + // + // statusStrip + // + this.statusStrip.Items.AddRange(new System.Windows.Forms.ToolStripItem[] { + this.toolStripStatusLabel}); + this.statusStrip.Location = new System.Drawing.Point(0, 547); + this.statusStrip.Name = "statusStrip"; + this.statusStrip.Size = new System.Drawing.Size(801, 22); + this.statusStrip.TabIndex = 2; + this.statusStrip.Text = "StatusStrip"; + // + // toolStripStatusLabel + // + this.toolStripStatusLabel.Name = "toolStripStatusLabel"; + this.toolStripStatusLabel.Size = new System.Drawing.Size(32, 17); + this.toolStripStatusLabel.Text = "状态"; + // + // groupBox_info + // + this.groupBox_info.BackColor = System.Drawing.SystemColors.ScrollBar; + this.groupBox_info.Controls.Add(this.label_job); + this.groupBox_info.Controls.Add(this.label5); + this.groupBox_info.Controls.Add(this.pictureBox1); + this.groupBox_info.Controls.Add(this.label1); + this.groupBox_info.Controls.Add(this.label2); + this.groupBox_info.Controls.Add(this.label3); + this.groupBox_info.Controls.Add(this.label4); + this.groupBox_info.Controls.Add(this.label_id); + this.groupBox_info.Controls.Add(this.label_name); + this.groupBox_info.Controls.Add(this.label_sex); + this.groupBox_info.Controls.Add(this.label_depart); + this.groupBox_info.Location = new System.Drawing.Point(8, 50); + this.groupBox_info.Name = "groupBox_info"; + this.groupBox_info.Size = new System.Drawing.Size(270, 199); + this.groupBox_info.TabIndex = 11; + this.groupBox_info.TabStop = false; + this.groupBox_info.Text = "操作用户"; + this.groupBox_info.Visible = false; + // + // label_job + // + this.label_job.AutoSize = true; + this.label_job.Location = new System.Drawing.Point(53, 173); + this.label_job.Name = "label_job"; + this.label_job.Size = new System.Drawing.Size(35, 12); + this.label_job.TabIndex = 21; + this.label_job.Text = "*job*"; + // + // label5 + // + this.label5.AutoSize = true; + this.label5.Location = new System.Drawing.Point(6, 173); + this.label5.Name = "label5"; + this.label5.Size = new System.Drawing.Size(41, 12); + this.label5.TabIndex = 20; + this.label5.Text = "职位："; + // + // pictureBox1 + // + this.pictureBox1.BackgroundImage = global::HospitalManageSys.Properties.Resources.QQ截图20161101204141; + this.pictureBox1.BackgroundImageLayout = System.Windows.Forms.ImageLayout.Stretch; + this.pictureBox1.Location = new System.Drawing.Point(149, 20); + this.pictureBox1.Name = "pictureBox1"; + this.pictureBox1.Size = new System.Drawing.Size(115, 165); + this.pictureBox1.TabIndex = 19; + this.pictureBox1.TabStop = false; + // + // label1 + // + this.label1.AutoSize = true; + this.label1.Location = new System.Drawing.Point(6, 30); + this.label1.Name = "label1"; + this.label1.Size = new System.Drawing.Size(41, 12); + this.label1.TabIndex = 11; + this.label1.Text = "编号："; + // + // label2 + // + this.label2.AutoSize = true; + this.label2.Location = new System.Drawing.Point(6, 65); + this.label2.Name = "label2"; + this.label2.Size = new System.Drawing.Size(41, 12); + this.label2.TabIndex = 12; + this.label2.Text = "姓名："; + // + // label3 + // + this.label3.AutoSize = true; + this.label3.Location = new System.Drawing.Point(6, 104); + this.label3.Name = "label3"; + this.label3.Size = new System.Drawing.Size(41, 12); + this.label3.TabIndex = 13; + this.label3.Text = "性别："; + // + // label4 + // + this.label4.AutoSize = true; + this.label4.Location = new System.Drawing.Point(6, 141); + this.label4.Name = "label4"; + this.label4.Size = new System.Drawing.Size(41, 12); + this.label4.TabIndex = 14; + this.label4.Text = "部门："; + // + // label_id + // + this.label_id.AutoSize = true; + this.label_id.Location = new System.Drawing.Point(53, 30); + this.label_id.Name = "label_id"; + this.label_id.Size = new System.Drawing.Size(29, 12); + this.label_id.TabIndex = 15; + this.label_id.Text = "*ID*"; + // + // label_name + // + this.label_name.AutoSize = true; + this.label_name.Location = new System.Drawing.Point(53, 65); + this.label_name.Name = "label_name"; + this.label_name.Size = new System.Drawing.Size(41, 12); + this.label_name.TabIndex = 16; + this.label_name.Text = "*name*"; + // + // label_sex + // + this.label_sex.AutoSize = true; + this.label_sex.Location = new System.Drawing.Point(53, 104); + this.label_sex.Name = "label_sex"; + this.label_sex.Size = new System.Drawing.Size(35, 12); + this.label_sex.TabIndex = 17; + this.label_sex.Text = "*sex*"; + // + // label_depart + // + this.label_depart.AutoSize = true; + this.label_depart.Location = new System.Drawing.Point(53, 141); + this.label_depart.Name = "label_depart"; + this.label_depart.Size = new System.Drawing.Size(77, 12); + this.label_depart.TabIndex = 18; + this.label_depart.Text = "*department*"; + // + // label_lflogin + // + this.label_lflogin.AutoSize = true; + this.label_lflogin.BackColor = System.Drawing.SystemColors.ScrollBar; + this.label_lflogin.Font = new System.Drawing.Font("宋体", 21.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); + this.label_lflogin.ForeColor = System.Drawing.Color.Red; + this.label_lflogin.Location = new System.Drawing.Point(3, 50); + this.label_lflogin.Name = "label_lflogin"; + this.label_lflogin.Size = new System.Drawing.Size(187, 29); + this.label_lflogin.TabIndex = 4; + this.label_lflogin.Text = "请登录账号！"; + // + // panel_WinArea + // + this.panel_WinArea.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) + | System.Windows.Forms.AnchorStyles.Right))); + this.panel_WinArea.BackColor = System.Drawing.SystemColors.ScrollBar; + this.panel_WinArea.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle; + this.panel_WinArea.Controls.Add(this.groupBox_info); + this.panel_WinArea.Controls.Add(this.label_lflogin); + this.panel_WinArea.Location = new System.Drawing.Point(515, 28); + this.panel_WinArea.Name = "panel_WinArea"; + this.panel_WinArea.Size = new System.Drawing.Size(286, 541); + this.panel_WinArea.TabIndex = 15; + // + // MainForm + // + this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 12F); + this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; + this.BackColor = System.Drawing.SystemColors.Control; + this.BackgroundImage = global::HospitalManageSys.Properties.Resources.background; + this.BackgroundImageLayout = System.Windows.Forms.ImageLayout.Stretch; + this.ClientSize = new System.Drawing.Size(801, 569); + this.ControlBox = false; + this.Controls.Add(this.toolStrip); + this.Controls.Add(this.menuStrip); + this.Controls.Add(this.statusStrip); + this.Controls.Add(this.panel_WinArea); + this.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); + this.ForeColor = System.Drawing.SystemColors.ControlText; + this.IsMdiContainer = true; + this.MainMenuStrip = this.menuStrip; + this.Name = "MainForm"; + this.Text = "医院管理系统"; + this.WindowState = System.Windows.Forms.FormWindowState.Maximized; + this.Load += new System.EventHandler(this.MainForm_Load); + this.menuStrip.ResumeLayout(false); + this.menuStrip.PerformLayout(); + this.toolStrip.ResumeLayout(false); + this.toolStrip.PerformLayout(); + this.statusStrip.ResumeLayout(false); + this.statusStrip.PerformLayout(); + this.groupBox_info.ResumeLayout(false); + this.groupBox_info.PerformLayout(); + ((System.ComponentModel.ISupportInitialize)(this.pictureBox1)).EndInit(); + this.panel_WinArea.ResumeLayout(false); + this.panel_WinArea.PerformLayout(); + this.ResumeLayout(false); + this.PerformLayout(); + + } + #endregion + + + private System.Windows.Forms.MenuStrip menuStrip; + private System.Windows.Forms.ToolStrip toolStrip; + private System.Windows.Forms.StatusStrip statusStrip; + private System.Windows.Forms.ToolStripSeparator toolStripSeparator1; + private System.Windows.Forms.ToolStripStatusLabel toolStripStatusLabel; + private System.Windows.Forms.ToolStripMenuItem aboutToolStripMenuItem; + private System.Windows.Forms.ToolStripMenuItem tileHorizontalToolStripMenuItem; + private System.Windows.Forms.ToolStripMenuItem viewMenu; + private System.Windows.Forms.ToolStripMenuItem toolBarToolStripMenuItem; + private System.Windows.Forms.ToolStripMenuItem statusBarToolStripMenuItem; + private System.Windows.Forms.ToolStripMenuItem windowsMenu; + private System.Windows.Forms.ToolStripMenuItem cascadeToolStripMenuItem; + private System.Windows.Forms.ToolStripMenuItem tileVerticalToolStripMenuItem; + private System.Windows.Forms.ToolStripMenuItem closeAllToolStripMenuItem; + private System.Windows.Forms.ToolStripMenuItem arrangeIconsToolStripMenuItem; + private System.Windows.Forms.ToolStripMenuItem helpMenu; + private System.Windows.Forms.ToolTip toolTip; + private System.Windows.Forms.GroupBox groupBox_info; + private System.Windows.Forms.Label label1; + private System.Windows.Forms.Label label2; + private System.Windows.Forms.Label label3; + private System.Windows.Forms.Label label4; + private System.Windows.Forms.Label label_id; + private System.Windows.Forms.Label label_name; + private System.Windows.Forms.Label label_sex; + private System.Windows.Forms.Label label_depart; + private System.Windows.Forms.PictureBox pictureBox1; + private System.Windows.Forms.ToolStripMenuItem AdminOperationToolStripMenuItem; + private System.Windows.Forms.ToolStripMenuItem AdminSwitchToolStripMenuItem; + private System.Windows.Forms.ToolStripMenuItem AdminLogoutToolStripMenuItem; + private System.Windows.Forms.ToolStripMenuItem AdminLoginToolStripMenuItem; + private System.Windows.Forms.ToolStripButton toolStripButton_login; + private System.Windows.Forms.ToolStripSeparator toolStripSeparator9; + private System.Windows.Forms.ToolStripMenuItem exitToolStripMenuItem; + private System.Windows.Forms.Label label_lflogin; + private System.Windows.Forms.Panel panel_WinArea; + private System.Windows.Forms.ToolStripButton toolStripButton_Registration; + private System.Windows.Forms.ToolStripSeparator toolStripButton1; + private System.Windows.Forms.ToolStripButton toolStripButton_exit; + private System.Windows.Forms.ToolStripButton toolStripButton_Admin; + private System.Windows.Forms.ToolStripButton toolStripButton_Charge; + private System.Windows.Forms.ToolStripButton toolStripButton_Clinic; + private System.Windows.Forms.ToolStripButton toolStripButton_DrugEx; + private System.Windows.Forms.ToolStripButton toolStripButton_DrugIm; + private System.Windows.Forms.ToolStripSeparator toolStripButton2; + private System.Windows.Forms.ToolStripSeparator toolStripButton3; + private System.Windows.Forms.ToolStripMenuItem AdminPWDToolStripMenuItem; + private System.Windows.Forms.Label label_job; + private System.Windows.Forms.Label label5; + } +} + + + diff --git a/HospitalManageSys/MainForm.cs b/HospitalManageSys/MainForm.cs new file mode 100644 index 0000000..0fa4065 --- /dev/null +++ b/HospitalManageSys/MainForm.cs @@ -0,0 +1,227 @@ +using System; +using System.Collections.Generic; +using System.ComponentModel; +using System.Data; +using System.Drawing; +using System.Linq; +using System.Text; +using System.Windows.Forms; +using MySql.Data.MySqlClient; +using System.IO; + +namespace HospitalManageSys +{ + public partial class MainForm : Form + { + private MySqlConnection con; + private MySqlCommand cmd; + private MySqlDataAdapter ada; + private DataSet ds; + + public MainForm() + { + InitializeComponent(); + + //创建连接数据库路径 + con = new MySqlConnection(HospitalManageSys.SqlCmd.strcon); + //con.Open(); + + cmd = new MySqlCommand("", con); + ada = new MySqlDataAdapter(cmd); + ds = new DataSet(); + + //con.Close(); + } + + #region 窗口处理 + //退出系统事件 + private void ExitToolsStripMenuItem_Click(object sender, EventArgs e) + { + this.Close(); + } + + //工具栏打开关闭事件 + private void ToolBarToolStripMenuItem_Click(object sender, EventArgs e) + { + toolStrip.Visible = toolBarToolStripMenuItem.Checked; + } + + //状态栏打开关闭事件 + private void StatusBarToolStripMenuItem_Click(object sender, EventArgs e) + { + statusStrip.Visible = statusBarToolStripMenuItem.Checked; + } + + //子窗口均层叠 + private void CascadeToolStripMenuItem_Click(object sender, EventArgs e) + { + LayoutMdi(MdiLayout.Cascade); + } + + //子窗口垂直平铺 + private void TileVerticalToolStripMenuItem_Click(object sender, EventArgs e) + { + LayoutMdi(MdiLayout.TileVertical); + } + + //子窗口水平平铺 + private void TileHorizontalToolStripMenuItem_Click(object sender, EventArgs e) + { + LayoutMdi(MdiLayout.TileHorizontal); + } + + //子图标均排列 + private void ArrangeIconsToolStripMenuItem_Click(object sender, EventArgs e) + { + LayoutMdi(MdiLayout.ArrangeIcons); + } + + //关闭所有子窗口 + private void CloseAllToolStripMenuItem_Click(object sender, EventArgs e) + { + foreach (Form childForm in MdiChildren) + { + childForm.Close(); + } + } + #endregion + + //权限使能，控制各模块的访问能力 + private void Capability(byte capab) + { + toolStripButton_Admin.Enabled = (capab & 0x01).Equals(0x01); + toolStripButton_Registration.Enabled = (capab & 0x02).Equals(0x02); + toolStripButton_Clinic.Enabled = (capab & 0x04).Equals(0x04); + toolStripButton_DrugEx.Enabled = (capab & 0x08).Equals(0x08); + toolStripButton_Charge.Enabled = (capab & 0x10).Equals(0x10); + toolStripButton_DrugIm.Enabled = (capab & 0x20).Equals(0x20); + } + + //打开修改密码窗口 + private void AdminPWDToolStripMenuItem_Click(object sender, EventArgs e) + { + Form_PWD form_pwd = new Form_PWD(con); + form_pwd.ShowDialog(); + } + + //主窗口加载,用户登录刷新 + private void MainForm_Load(object sender, EventArgs e) + { + Form_Login form_admin = new Form_Login(con); + form_admin.ShowDialog(); + + if (HospitalManageSys.SqlCmd.iflogin) //登录成功 + { + label_id.Text = HospitalManageSys.SqlCmd.admin_id; + label_name.Text = HospitalManageSys.SqlCmd.admin_name; + label_sex.Text = HospitalManageSys.SqlCmd.admin_sex; + label_depart.Text = HospitalManageSys.SqlCmd.admin_depart; + label_job.Text = HospitalManageSys.SqlCmd.admin_job; + if (HospitalManageSys.SqlCmd.memStream != null) + { + this.pictureBox1.Image = Image.FromStream(HospitalManageSys.SqlCmd.memStream); + } + + Capability(HospitalManageSys.SqlCmd.capab); + + this.groupBox_info.Show(); + this.AdminLoginToolStripMenuItem.Enabled = false; + this.AdminLogoutToolStripMenuItem.Enabled = true; + this.AdminSwitchToolStripMenuItem.Enabled = true; + this.AdminPWDToolStripMenuItem.Enabled = true; + this.toolStripButton_login.Enabled = false; + } + else //登录失败 + { + Capability(0); + + this.AdminLogoutToolStripMenuItem.Enabled = false; + this.AdminSwitchToolStripMenuItem.Enabled = false; + this.AdminPWDToolStripMenuItem.Enabled = false; + } + } + + #region 登录相关 + //用户登录事件 + private void AdminLoginToolStripMenuItem_Click(object sender, EventArgs e) + { + this.MainForm_Load(sender, e); + } + + //用户注销事件 + private void AdminLogoutToolStripMenuItem_Click(object sender, EventArgs e) + { + CloseAllToolStripMenuItem_Click(sender, e); + this.groupBox_info.Hide(); + HospitalManageSys.SqlCmd.iflogin = false; + + Capability(0); + + this.AdminLoginToolStripMenuItem.Enabled = true; + this.AdminLogoutToolStripMenuItem.Enabled = false; + this.AdminSwitchToolStripMenuItem.Enabled = false; + this.AdminPWDToolStripMenuItem.Enabled = false; + this.toolStripButton_login.Enabled = true; + } + + //用户切换事件 + private void AdminSwitchToolStripMenuItem_Click(object sender, EventArgs e) + { + this.AdminLogoutToolStripMenuItem_Click(sender, e); + this.MainForm_Load(sender, e); + } + #endregion + + #region 打开模块 + //打开模块--人事管理 + private void AdminForm_Click(object sender, EventArgs e) + { + Form_Adminisrtator form_administrator = new Form_Adminisrtator(con, this); + form_administrator.MdiParent = this; + form_administrator.Show(); + } + + //打开模块--门诊挂号 + private void RegistrationForm_Click(object sender, EventArgs e) + { + Form_Registration form_registration = new Form_Registration(con, this); + form_registration.MdiParent = this; + form_registration.Show(); + } + + //打开模块--医生门诊 + private void ClinicForm_Click(object sender, EventArgs e) + { + + } + + //打开模块--发药系统 + private void DrugExForm_Click(object sender, EventArgs e) + { + Form_DrugEx form_drugex = new Form_DrugEx(con, this); + form_drugex.MdiParent=this; + form_drugex.Show(); + } + + //打开模块--收费系统 + private void ChargeForm_Click(object sender, EventArgs e) + { + Form_Charge form_charge = new Form_Charge(con, this); + form_charge.MdiParent = this; + form_charge.Show(); + } + + //打开模块--药品入库 + private void DrugImForm_Click(object sender, EventArgs e) + { + Form_DrugIm form_drugim = new Form_DrugIm(con, this); + form_drugim.MdiParent = this; + form_drugim.Show(); + } + #endregion + + + + + } +} diff --git a/HospitalManageSys/MainForm.resx b/HospitalManageSys/MainForm.resx new file mode 100644 index 0000000..068de24 --- /dev/null +++ b/HospitalManageSys/MainForm.resx @@ -0,0 +1,135 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + text/microsoft-resx + + + 2.0 + + + System.Resources.ResXResourceReader, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 + + + System.Resources.ResXResourceWriter, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 + + + 224, 17 + + + 337, 17 + + + 17, 17 + + + 131, 17 + + + 51 + + \ No newline at end of file diff --git a/HospitalManageSys/Program.cs b/HospitalManageSys/Program.cs new file mode 100644 index 0000000..7b9224f --- /dev/null +++ b/HospitalManageSys/Program.cs @@ -0,0 +1,21 @@ +using System; +using System.Collections.Generic; +using System.Linq; +using System.Windows.Forms; + +namespace HospitalManageSys +{ + static class Program + { + /// + /// 应用程序的主入口点。 + /// + [STAThread] + static void Main() + { + Application.EnableVisualStyles(); + Application.SetCompatibleTextRenderingDefault(false); + Application.Run(new MainForm()); + } + } +} diff --git a/HospitalManageSys/Properties/AssemblyInfo.cs b/HospitalManageSys/Properties/AssemblyInfo.cs new file mode 100644 index 0000000..f6b9eca --- /dev/null +++ b/HospitalManageSys/Properties/AssemblyInfo.cs @@ -0,0 +1,36 @@ +using System.Reflection; +using System.Runtime.CompilerServices; +using System.Runtime.InteropServices; + +// 有关程序集的常规信息通过以下 +// 特性集控制。更改这些特性值可修改 +// 与程序集关联的信息。 +[assembly: AssemblyTitle("HospitalManageSys")] +[assembly: AssemblyDescription("")] +[assembly: AssemblyConfiguration("")] +[assembly: AssemblyCompany("")] +[assembly: AssemblyProduct("HospitalManageSys")] +[assembly: AssemblyCopyright("Copyright © 2016")] +[assembly: AssemblyTrademark("")] +[assembly: AssemblyCulture("")] + +// 将 ComVisible 设置为 false 使此程序集中的类型 +// 对 COM 组件不可见。如果需要从 COM 访问此程序集中的类型， +// 则将该类型上的 ComVisible 特性设置为 true。 +[assembly: ComVisible(false)] + +// 如果此项目向 COM 公开，则下列 GUID 用于类型库的 ID +[assembly: Guid("fc5e559e-1a62-4810-84b2-aa92b29dfb61")] + +// 程序集的版本信息由下面四个值组成: +// +// 主版本 +// 次版本 +// 内部版本号 +// 修订号 +// +// 可以指定所有这些值，也可以使用“内部版本号”和“修订号”的默认值， +// 方法是按如下所示使用“*”: +// [assembly: AssemblyVersion("1.0.*")] +[assembly: AssemblyVersion("1.0.0.0")] +[assembly: AssemblyFileVersion("1.0.0.0")] diff --git a/HospitalManageSys/Properties/Resources.Designer.cs b/HospitalManageSys/Properties/Resources.Designer.cs new file mode 100644 index 0000000..93d2cc2 --- /dev/null +++ b/HospitalManageSys/Properties/Resources.Designer.cs @@ -0,0 +1,163 @@ +//------------------------------------------------------------------------------ +// +// 此代码由工具生成。 +// 运行时版本:4.0.30319.42000 +// +// 对此文件的更改可能会导致不正确的行为，并且如果 +// 重新生成代码，这些更改将会丢失。 +// +//------------------------------------------------------------------------------ + +namespace HospitalManageSys.Properties { + using System; + + + /// + /// 一个强类型的资源类，用于查找本地化的字符串等。 + /// + // 此类是由 StronglyTypedResourceBuilder + // 类通过类似于 ResGen 或 Visual Studio 的工具自动生成的。 + // 若要添加或移除成员，请编辑 .ResX 文件，然后重新运行 ResGen + // (以 /str 作为命令选项)，或重新生成 VS 项目。 + [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Resources.Tools.StronglyTypedResourceBuilder", "4.0.0.0")] + [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] + [global::System.Runtime.CompilerServices.CompilerGeneratedAttribute()] + internal class Resources { + + private static global::System.Resources.ResourceManager resourceMan; + + private static global::System.Globalization.CultureInfo resourceCulture; + + [global::System.Diagnostics.CodeAnalysis.SuppressMessageAttribute("Microsoft.Performance", "CA1811:AvoidUncalledPrivateCode")] + internal Resources() { + } + + /// + /// 返回此类使用的缓存的 ResourceManager 实例。 + /// + [global::System.ComponentModel.EditorBrowsableAttribute(global::System.ComponentModel.EditorBrowsableState.Advanced)] + internal static global::System.Resources.ResourceManager ResourceManager { + get { + if (object.ReferenceEquals(resourceMan, null)) { + global::System.Resources.ResourceManager temp = new global::System.Resources.ResourceManager("HospitalManageSys.Properties.Resources", typeof(Resources).Assembly); + resourceMan = temp; + } + return resourceMan; + } + } + + /// + /// 使用此强类型资源类，为所有资源查找 + /// 重写当前线程的 CurrentUICulture 属性。 + /// + [global::System.ComponentModel.EditorBrowsableAttribute(global::System.ComponentModel.EditorBrowsableState.Advanced)] + internal static global::System.Globalization.CultureInfo Culture { + get { + return resourceCulture; + } + set { + resourceCulture = value; + } + } + + /// + /// 查找 System.Drawing.Bitmap 类型的本地化资源。 + /// + internal static System.Drawing.Bitmap admin { + get { + object obj = ResourceManager.GetObject("admin", resourceCulture); + return ((System.Drawing.Bitmap)(obj)); + } + } + + /// + /// 查找 System.Drawing.Bitmap 类型的本地化资源。 + /// + internal static System.Drawing.Bitmap background { + get { + object obj = ResourceManager.GetObject("background", resourceCulture); + return ((System.Drawing.Bitmap)(obj)); + } + } + + /// + /// 查找 System.Drawing.Bitmap 类型的本地化资源。 + /// + internal static System.Drawing.Bitmap charge { + get { + object obj = ResourceManager.GetObject("charge", resourceCulture); + return ((System.Drawing.Bitmap)(obj)); + } + } + + /// + /// 查找 System.Drawing.Bitmap 类型的本地化资源。 + /// + internal static System.Drawing.Bitmap clinic { + get { + object obj = ResourceManager.GetObject("clinic", resourceCulture); + return ((System.Drawing.Bitmap)(obj)); + } + } + + /// + /// 查找 System.Drawing.Bitmap 类型的本地化资源。 + /// + internal static System.Drawing.Bitmap drugEx { + get { + object obj = ResourceManager.GetObject("drugEx", resourceCulture); + return ((System.Drawing.Bitmap)(obj)); + } + } + + /// + /// 查找 System.Drawing.Bitmap 类型的本地化资源。 + /// + internal static System.Drawing.Bitmap drugIm { + get { + object obj = ResourceManager.GetObject("drugIm", resourceCulture); + return ((System.Drawing.Bitmap)(obj)); + } + } + + /// + /// 查找 System.Drawing.Bitmap 类型的本地化资源。 + /// + internal static System.Drawing.Bitmap exit { + get { + object obj = ResourceManager.GetObject("exit", resourceCulture); + return ((System.Drawing.Bitmap)(obj)); + } + } + + /// + /// 查找 System.Drawing.Bitmap 类型的本地化资源。 + /// + internal static System.Drawing.Bitmap login { + get { + object obj = ResourceManager.GetObject("login", resourceCulture); + return ((System.Drawing.Bitmap)(obj)); + } + } + + /// + /// 查找 System.Drawing.Bitmap 类型的本地化资源。 + /// + internal static System.Drawing.Bitmap QQ截图20161101204141 { + get { + object obj = ResourceManager.GetObject("QQ截图20161101204141", resourceCulture); + return ((System.Drawing.Bitmap)(obj)); + } + } + + /// + /// 查找 System.Drawing.Bitmap 类型的本地化资源。 + /// + internal static System.Drawing.Bitmap registration { + get { + object obj = ResourceManager.GetObject("registration", resourceCulture); + return ((System.Drawing.Bitmap)(obj)); + } + } + } +} diff --git a/HospitalManageSys/Properties/Resources.resx b/HospitalManageSys/Properties/Resources.resx new file mode 100644 index 0000000..34808fe --- /dev/null +++ b/HospitalManageSys/Properties/Resources.resx @@ -0,0 +1,151 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + text/microsoft-resx + + + 2.0 + + + System.Resources.ResXResourceReader, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 + + + System.Resources.ResXResourceWriter, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 + + + + ..\Resources\admin.png;System.Drawing.Bitmap, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a + + + ..\Resources\background.jpg;System.Drawing.Bitmap, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a + + + ..\Resources\charge.png;System.Drawing.Bitmap, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a + + + ..\Resources\clinic.jpg;System.Drawing.Bitmap, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a + + + ..\Resources\drugEx.png;System.Drawing.Bitmap, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a + + + ..\Resources\drugIm.png;System.Drawing.Bitmap, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a + + + ..\Resources\exit.gif;System.Drawing.Bitmap, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a + + + ..\Resources\login.png;System.Drawing.Bitmap, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a + + + ..\Resources\QQ截图20161101204141.png;System.Drawing.Bitmap, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a + + + ..\Resources\registration.png;System.Drawing.Bitmap, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a + + \ No newline at end of file diff --git a/HospitalManageSys/Properties/Settings.Designer.cs b/HospitalManageSys/Properties/Settings.Designer.cs new file mode 100644 index 0000000..5b9e10e --- /dev/null +++ b/HospitalManageSys/Properties/Settings.Designer.cs @@ -0,0 +1,30 @@ +//------------------------------------------------------------------------------ +// +// This code was generated by a tool. +// Runtime Version:4.0.30319.42000 +// +// Changes to this file may cause incorrect behavior and will be lost if +// the code is regenerated. +// +//------------------------------------------------------------------------------ + +namespace HospitalManageSys.Properties +{ + + + [global::System.Runtime.CompilerServices.CompilerGeneratedAttribute()] + [global::System.CodeDom.Compiler.GeneratedCodeAttribute("Microsoft.VisualStudio.Editors.SettingsDesigner.SettingsSingleFileGenerator", "10.0.0.0")] + internal sealed partial class Settings : global::System.Configuration.ApplicationSettingsBase + { + + private static Settings defaultInstance = ((Settings)(global::System.Configuration.ApplicationSettingsBase.Synchronized(new Settings()))); + + public static Settings Default + { + get + { + return defaultInstance; + } + } + } +} diff --git a/HospitalManageSys/Properties/Settings.settings b/HospitalManageSys/Properties/Settings.settings new file mode 100644 index 0000000..3964565 --- /dev/null +++ b/HospitalManageSys/Properties/Settings.settings @@ -0,0 +1,7 @@ + + + + + + + diff --git "a/HospitalManageSys/Resources/QQ\346\210\252\345\233\27620161101204141.png" "b/HospitalManageSys/Resources/QQ\346\210\252\345\233\27620161101204141.png" new file mode 100644 index 0000000..307f9ad Binary files /dev/null and "b/HospitalManageSys/Resources/QQ\346\210\252\345\233\27620161101204141.png" differ diff --git a/HospitalManageSys/Resources/admin.png b/HospitalManageSys/Resources/admin.png new file mode 100644 index 0000000..7d86a58 Binary files /dev/null and b/HospitalManageSys/Resources/admin.png differ diff --git a/HospitalManageSys/Resources/background.jpg b/HospitalManageSys/Resources/background.jpg new file mode 100644 index 0000000..41325be Binary files /dev/null and b/HospitalManageSys/Resources/background.jpg differ diff --git a/HospitalManageSys/Resources/charge.png b/HospitalManageSys/Resources/charge.png new file mode 100644 index 0000000..cff99ee Binary files /dev/null and b/HospitalManageSys/Resources/charge.png differ diff --git a/HospitalManageSys/Resources/clinic.jpg b/HospitalManageSys/Resources/clinic.jpg new file mode 100644 index 0000000..a565cba Binary files /dev/null and b/HospitalManageSys/Resources/clinic.jpg differ diff --git a/HospitalManageSys/Resources/drugEx.png b/HospitalManageSys/Resources/drugEx.png new file mode 100644 index 0000000..e56ddfc Binary files /dev/null and b/HospitalManageSys/Resources/drugEx.png differ diff --git a/HospitalManageSys/Resources/drugIm.png b/HospitalManageSys/Resources/drugIm.png new file mode 100644 index 0000000..01b8610 Binary files /dev/null and b/HospitalManageSys/Resources/drugIm.png differ diff --git a/HospitalManageSys/Resources/exit.gif b/HospitalManageSys/Resources/exit.gif new file mode 100644 index 0000000..81a22e3 Binary files /dev/null and b/HospitalManageSys/Resources/exit.gif differ diff --git a/HospitalManageSys/Resources/login.png b/HospitalManageSys/Resources/login.png new file mode 100644 index 0000000..7254401 Binary files /dev/null and b/HospitalManageSys/Resources/login.png differ diff --git a/HospitalManageSys/Resources/registration.png b/HospitalManageSys/Resources/registration.png new file mode 100644 index 0000000..8887f8b Binary files /dev/null and b/HospitalManageSys/Resources/registration.png differ diff --git a/HospitalManageSys/SqlCmd.cs b/HospitalManageSys/SqlCmd.cs new file mode 100644 index 0000000..24bf10c --- /dev/null +++ b/HospitalManageSys/SqlCmd.cs @@ -0,0 +1,22 @@ +using System; +using System.Collections.Generic; +using System.Linq; +using System.Text; +using System.IO; + +namespace HospitalManageSys +{ + class SqlCmd + { + public static bool iflogin = false; + public static string admin_id; + public static string admin_name; + public static string admin_sex; + public static string admin_job; + public static byte capab=0x00; + public static string admin_depart; + public static MemoryStream memStream = null; + + public const string strcon = "Server=localhost;Database=HospitalManageSys;Uid=root;Pwd=zixue788634;"; + } +} diff --git a/HospitalManageSys/bin/Debug/HospitalManageSys.application b/HospitalManageSys/bin/Debug/HospitalManageSys.application new file mode 100644 index 0000000..80a2257 --- /dev/null +++ b/HospitalManageSys/bin/Debug/HospitalManageSys.application @@ -0,0 +1,22 @@ + + + + + + + + + + + + + + + + + + PT90JctC5o54IIBsKmzS99iDEUM= + + + + \ No newline at end of file diff --git a/HospitalManageSys/bin/Debug/HospitalManageSys.exe b/HospitalManageSys/bin/Debug/HospitalManageSys.exe new file mode 100644 index 0000000..9eef4ea Binary files /dev/null and b/HospitalManageSys/bin/Debug/HospitalManageSys.exe differ diff --git a/HospitalManageSys/bin/Debug/HospitalManageSys.exe.manifest b/HospitalManageSys/bin/Debug/HospitalManageSys.exe.manifest new file mode 100644 index 0000000..dcea6c3 --- /dev/null +++ b/HospitalManageSys/bin/Debug/HospitalManageSys.exe.manifest @@ -0,0 +1,68 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + DYwgLJgP3b5tF2oVnxEfLMwgcM0= + + + + + + + + + + + + ZzSpy3SIUxHuh/0rTLHDuIuNPmM= + + + + \ No newline at end of file diff --git a/HospitalManageSys/bin/Debug/HospitalManageSys.pdb b/HospitalManageSys/bin/Debug/HospitalManageSys.pdb new file mode 100644 index 0000000..265485a Binary files /dev/null and b/HospitalManageSys/bin/Debug/HospitalManageSys.pdb differ diff --git a/HospitalManageSys/bin/Debug/MySql.Data.dll b/HospitalManageSys/bin/Debug/MySql.Data.dll new file mode 100644 index 0000000..b732da4 Binary files /dev/null and b/HospitalManageSys/bin/Debug/MySql.Data.dll differ diff --git a/HospitalManageSys/bin/Debug/app.publish/HospitalManageSys.exe b/HospitalManageSys/bin/Debug/app.publish/HospitalManageSys.exe new file mode 100644 index 0000000..9eef4ea Binary files /dev/null and b/HospitalManageSys/bin/Debug/app.publish/HospitalManageSys.exe differ diff --git a/HospitalManageSys/bin/MySql.Data.dll b/HospitalManageSys/bin/MySql.Data.dll new file mode 100644 index 0000000..b732da4 Binary files /dev/null and b/HospitalManageSys/bin/MySql.Data.dll differ diff --git a/HospitalManageSys/obj/x86/Debug/CoreCompileInputs.cache b/HospitalManageSys/obj/x86/Debug/CoreCompileInputs.cache new file mode 100644 index 0000000..c28747d --- /dev/null +++ b/HospitalManageSys/obj/x86/Debug/CoreCompileInputs.cache @@ -0,0 +1 @@ +5467d65bed357e183553c2c20842ca84a07cbb84 diff --git a/HospitalManageSys/obj/x86/Debug/DesignTimeResolveAssemblyReferences.cache b/HospitalManageSys/obj/x86/Debug/DesignTimeResolveAssemblyReferences.cache new file mode 100644 index 0000000..eb06afa Binary files /dev/null and b/HospitalManageSys/obj/x86/Debug/DesignTimeResolveAssemblyReferences.cache differ diff --git a/HospitalManageSys/obj/x86/Debug/DesignTimeResolveAssemblyReferencesInput.cache b/HospitalManageSys/obj/x86/Debug/DesignTimeResolveAssemblyReferencesInput.cache new file mode 100644 index 0000000..6c92c43 Binary files /dev/null and b/HospitalManageSys/obj/x86/Debug/DesignTimeResolveAssemblyReferencesInput.cache differ diff --git a/HospitalManageSys/obj/x86/Debug/HospitalManageSys.Form_Adminisrtator.resources b/HospitalManageSys/obj/x86/Debug/HospitalManageSys.Form_Adminisrtator.resources new file mode 100644 index 0000000..6c05a97 Binary files /dev/null and b/HospitalManageSys/obj/x86/Debug/HospitalManageSys.Form_Adminisrtator.resources differ diff --git a/HospitalManageSys/obj/x86/Debug/HospitalManageSys.Form_Charge.resources b/HospitalManageSys/obj/x86/Debug/HospitalManageSys.Form_Charge.resources new file mode 100644 index 0000000..6c05a97 Binary files /dev/null and b/HospitalManageSys/obj/x86/Debug/HospitalManageSys.Form_Charge.resources differ diff --git a/HospitalManageSys/obj/x86/Debug/HospitalManageSys.Form_DrugEx.resources b/HospitalManageSys/obj/x86/Debug/HospitalManageSys.Form_DrugEx.resources new file mode 100644 index 0000000..6c05a97 Binary files /dev/null and b/HospitalManageSys/obj/x86/Debug/HospitalManageSys.Form_DrugEx.resources differ diff --git a/HospitalManageSys/obj/x86/Debug/HospitalManageSys.Form_DrugIm.resources b/HospitalManageSys/obj/x86/Debug/HospitalManageSys.Form_DrugIm.resources new file mode 100644 index 0000000..6c05a97 Binary files /dev/null and b/HospitalManageSys/obj/x86/Debug/HospitalManageSys.Form_DrugIm.resources differ diff --git a/HospitalManageSys/obj/x86/Debug/HospitalManageSys.Form_DrugIm_2.resources b/HospitalManageSys/obj/x86/Debug/HospitalManageSys.Form_DrugIm_2.resources new file mode 100644 index 0000000..6c05a97 Binary files /dev/null and b/HospitalManageSys/obj/x86/Debug/HospitalManageSys.Form_DrugIm_2.resources differ diff --git a/HospitalManageSys/obj/x86/Debug/HospitalManageSys.Form_Login.resources b/HospitalManageSys/obj/x86/Debug/HospitalManageSys.Form_Login.resources new file mode 100644 index 0000000..6c05a97 Binary files /dev/null and b/HospitalManageSys/obj/x86/Debug/HospitalManageSys.Form_Login.resources differ diff --git a/HospitalManageSys/obj/x86/Debug/HospitalManageSys.Form_PWD.resources b/HospitalManageSys/obj/x86/Debug/HospitalManageSys.Form_PWD.resources new file mode 100644 index 0000000..6c05a97 Binary files /dev/null and b/HospitalManageSys/obj/x86/Debug/HospitalManageSys.Form_PWD.resources differ diff --git a/HospitalManageSys/obj/x86/Debug/HospitalManageSys.Form_Registration.resources b/HospitalManageSys/obj/x86/Debug/HospitalManageSys.Form_Registration.resources new file mode 100644 index 0000000..6c05a97 Binary files /dev/null and b/HospitalManageSys/obj/x86/Debug/HospitalManageSys.Form_Registration.resources differ diff --git a/HospitalManageSys/obj/x86/Debug/HospitalManageSys.MainForm.resources b/HospitalManageSys/obj/x86/Debug/HospitalManageSys.MainForm.resources new file mode 100644 index 0000000..6c05a97 Binary files /dev/null and b/HospitalManageSys/obj/x86/Debug/HospitalManageSys.MainForm.resources differ diff --git a/HospitalManageSys/obj/x86/Debug/HospitalManageSys.Properties.Resources.resources b/HospitalManageSys/obj/x86/Debug/HospitalManageSys.Properties.Resources.resources new file mode 100644 index 0000000..76d4a69 Binary files /dev/null and b/HospitalManageSys/obj/x86/Debug/HospitalManageSys.Properties.Resources.resources differ diff --git a/HospitalManageSys/obj/x86/Debug/HospitalManageSys.application b/HospitalManageSys/obj/x86/Debug/HospitalManageSys.application new file mode 100644 index 0000000..80a2257 --- /dev/null +++ b/HospitalManageSys/obj/x86/Debug/HospitalManageSys.application @@ -0,0 +1,22 @@ + + + + + + + + + + + + + + + + + + PT90JctC5o54IIBsKmzS99iDEUM= + + + + \ No newline at end of file diff --git a/HospitalManageSys/obj/x86/Debug/HospitalManageSys.csproj.FileListAbsolute.txt b/HospitalManageSys/obj/x86/Debug/HospitalManageSys.csproj.FileListAbsolute.txt new file mode 100644 index 0000000..fdaf30a --- /dev/null +++ b/HospitalManageSys/obj/x86/Debug/HospitalManageSys.csproj.FileListAbsolute.txt @@ -0,0 +1,56 @@ +F:\VSprojects\HospitalManageSys\HospitalManageSys\bin\Debug\HospitalManageSys.exe +F:\VSprojects\HospitalManageSys\HospitalManageSys\bin\Debug\HospitalManageSys.pdb +F:\VSprojects\HospitalManageSys\HospitalManageSys\bin\Debug\HospitalManageSys.exe.manifest +F:\VSprojects\HospitalManageSys\HospitalManageSys\bin\Debug\HospitalManageSys.application +F:\VSprojects\HospitalManageSys\HospitalManageSys\bin\Debug\MySql.Data.dll +F:\VSprojects\HospitalManageSys\HospitalManageSys\obj\x86\Debug\HospitalManageSys.csprojResolveAssemblyReference.cache +F:\VSprojects\HospitalManageSys\HospitalManageSys\obj\x86\Debug\HospitalManageSys.Form_Adminisrtator.resources +F:\VSprojects\HospitalManageSys\HospitalManageSys\obj\x86\Debug\HospitalManageSys.Form_Charge.resources +F:\VSprojects\HospitalManageSys\HospitalManageSys\obj\x86\Debug\HospitalManageSys.Form_Login.resources +F:\VSprojects\HospitalManageSys\HospitalManageSys\obj\x86\Debug\HospitalManageSys.Form_Registration.resources +F:\VSprojects\HospitalManageSys\HospitalManageSys\obj\x86\Debug\HospitalManageSys.MainForm.resources +F:\VSprojects\HospitalManageSys\HospitalManageSys\obj\x86\Debug\HospitalManageSys.Form_PWD.resources +F:\VSprojects\HospitalManageSys\HospitalManageSys\obj\x86\Debug\HospitalManageSys.Properties.Resources.resources +F:\VSprojects\HospitalManageSys\HospitalManageSys\obj\x86\Debug\HospitalManageSys.csproj.GenerateResource.Cache +F:\VSprojects\HospitalManageSys\HospitalManageSys\obj\x86\Debug\HospitalManageSys.exe.manifest +F:\VSprojects\HospitalManageSys\HospitalManageSys\obj\x86\Debug\HospitalManageSys.application +F:\VSprojects\HospitalManageSys\HospitalManageSys\obj\x86\Debug\HospitalManageSys.exe +F:\VSprojects\HospitalManageSys\HospitalManageSys\obj\x86\Debug\HospitalManageSys.pdb +F:\VSprojects\HospitalManageSys\HospitalManageSys\obj\x86\Debug\HospitalManageSys.Form_DrugIm.resources +F:\VSprojects\HospitalManageSys\HospitalManageSys\obj\x86\Debug\HospitalManageSys.Form_DrugIm_2.resources +F:\VSprojects\HospitalManageSys\HospitalManageSys\obj\x86\Debug\HospitalManageSys.Form_DrugEx.resources +D:\Projects\HospitalManageSys\HospitalManageSys\obj\x86\Debug\HospitalManageSys.csprojResolveAssemblyReference.cache +D:\Projects\HospitalManageSys\HospitalManageSys\obj\x86\Debug\HospitalManageSys.Form_Adminisrtator.resources +D:\Projects\HospitalManageSys\HospitalManageSys\obj\x86\Debug\HospitalManageSys.Form_Charge.resources +D:\Projects\HospitalManageSys\HospitalManageSys\obj\x86\Debug\HospitalManageSys.Form_DrugEx.resources +D:\Projects\HospitalManageSys\HospitalManageSys\obj\x86\Debug\HospitalManageSys.Form_DrugIm.resources +D:\Projects\HospitalManageSys\HospitalManageSys\obj\x86\Debug\HospitalManageSys.Form_DrugIm_2.resources +D:\Projects\HospitalManageSys\HospitalManageSys\obj\x86\Debug\HospitalManageSys.Form_Login.resources +D:\Projects\HospitalManageSys\HospitalManageSys\obj\x86\Debug\HospitalManageSys.Form_Registration.resources +D:\Projects\HospitalManageSys\HospitalManageSys\obj\x86\Debug\HospitalManageSys.MainForm.resources +D:\Projects\HospitalManageSys\HospitalManageSys\obj\x86\Debug\HospitalManageSys.Form_PWD.resources +D:\Projects\HospitalManageSys\HospitalManageSys\obj\x86\Debug\HospitalManageSys.Properties.Resources.resources +D:\Projects\HospitalManageSys\HospitalManageSys\obj\x86\Debug\HospitalManageSys.csproj.GenerateResource.Cache +D:\Projects\HospitalManageSys\HospitalManageSys\obj\x86\Debug\HospitalManageSys.exe +D:\Projects\HospitalManageSys\HospitalManageSys\obj\x86\Debug\HospitalManageSys.pdb +D:\旧世\Lok'Tar\Projects\HospitalManageSys\HospitalManageSys\obj\x86\Debug\HospitalManageSys.csprojResolveAssemblyReference.cache +D:\旧世\Lok'Tar\Projects\HospitalManageSys\HospitalManageSys\obj\x86\Debug\HospitalManageSys.Form_Adminisrtator.resources +D:\旧世\Lok'Tar\Projects\HospitalManageSys\HospitalManageSys\obj\x86\Debug\HospitalManageSys.Form_Charge.resources +D:\旧世\Lok'Tar\Projects\HospitalManageSys\HospitalManageSys\obj\x86\Debug\HospitalManageSys.Form_DrugEx.resources +D:\旧世\Lok'Tar\Projects\HospitalManageSys\HospitalManageSys\obj\x86\Debug\HospitalManageSys.Form_DrugIm.resources +D:\旧世\Lok'Tar\Projects\HospitalManageSys\HospitalManageSys\obj\x86\Debug\HospitalManageSys.Form_DrugIm_2.resources +D:\旧世\Lok'Tar\Projects\HospitalManageSys\HospitalManageSys\obj\x86\Debug\HospitalManageSys.Form_Login.resources +D:\旧世\Lok'Tar\Projects\HospitalManageSys\HospitalManageSys\obj\x86\Debug\HospitalManageSys.Form_Registration.resources +D:\旧世\Lok'Tar\Projects\HospitalManageSys\HospitalManageSys\obj\x86\Debug\HospitalManageSys.MainForm.resources +D:\旧世\Lok'Tar\Projects\HospitalManageSys\HospitalManageSys\obj\x86\Debug\HospitalManageSys.Form_PWD.resources +D:\旧世\Lok'Tar\Projects\HospitalManageSys\HospitalManageSys\obj\x86\Debug\HospitalManageSys.Properties.Resources.resources +D:\旧世\Lok'Tar\Projects\HospitalManageSys\HospitalManageSys\obj\x86\Debug\HospitalManageSys.csproj.GenerateResource.Cache +D:\旧世\Lok'Tar\Projects\HospitalManageSys\HospitalManageSys\obj\x86\Debug\HospitalManageSys.exe +D:\旧世\Lok'Tar\Projects\HospitalManageSys\HospitalManageSys\obj\x86\Debug\HospitalManageSys.pdb +D:\旧世\Lok'Tar\Projects\HospitalManageSys\HospitalManageSys\bin\Debug\HospitalManageSys.exe.manifest +D:\旧世\Lok'Tar\Projects\HospitalManageSys\HospitalManageSys\bin\Debug\HospitalManageSys.application +D:\旧世\Lok'Tar\Projects\HospitalManageSys\HospitalManageSys\bin\Debug\HospitalManageSys.exe +D:\旧世\Lok'Tar\Projects\HospitalManageSys\HospitalManageSys\bin\Debug\HospitalManageSys.pdb +D:\旧世\Lok'Tar\Projects\HospitalManageSys\HospitalManageSys\bin\Debug\MySql.Data.dll +D:\旧世\Lok'Tar\Projects\HospitalManageSys\HospitalManageSys\obj\x86\Debug\HospitalManageSys.exe.manifest +D:\旧世\Lok'Tar\Projects\HospitalManageSys\HospitalManageSys\obj\x86\Debug\HospitalManageSys.application diff --git a/HospitalManageSys/obj/x86/Debug/HospitalManageSys.csproj.GenerateResource.Cache b/HospitalManageSys/obj/x86/Debug/HospitalManageSys.csproj.GenerateResource.Cache new file mode 100644 index 0000000..75dfa68 Binary files /dev/null and b/HospitalManageSys/obj/x86/Debug/HospitalManageSys.csproj.GenerateResource.Cache differ diff --git a/HospitalManageSys/obj/x86/Debug/HospitalManageSys.csprojResolveAssemblyReference.cache b/HospitalManageSys/obj/x86/Debug/HospitalManageSys.csprojResolveAssemblyReference.cache new file mode 100644 index 0000000..505abd8 Binary files /dev/null and b/HospitalManageSys/obj/x86/Debug/HospitalManageSys.csprojResolveAssemblyReference.cache differ diff --git a/HospitalManageSys/obj/x86/Debug/HospitalManageSys.exe b/HospitalManageSys/obj/x86/Debug/HospitalManageSys.exe new file mode 100644 index 0000000..9eef4ea Binary files /dev/null and b/HospitalManageSys/obj/x86/Debug/HospitalManageSys.exe differ diff --git a/HospitalManageSys/obj/x86/Debug/HospitalManageSys.exe.manifest b/HospitalManageSys/obj/x86/Debug/HospitalManageSys.exe.manifest new file mode 100644 index 0000000..dcea6c3 --- /dev/null +++ b/HospitalManageSys/obj/x86/Debug/HospitalManageSys.exe.manifest @@ -0,0 +1,68 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + DYwgLJgP3b5tF2oVnxEfLMwgcM0= + + + + + + + + + + + + ZzSpy3SIUxHuh/0rTLHDuIuNPmM= + + + + \ No newline at end of file diff --git a/HospitalManageSys/obj/x86/Debug/HospitalManageSys.pdb b/HospitalManageSys/obj/x86/Debug/HospitalManageSys.pdb new file mode 100644 index 0000000..265485a Binary files /dev/null and b/HospitalManageSys/obj/x86/Debug/HospitalManageSys.pdb differ diff --git a/HospitalManageSys/obj/x86/Debug/TempPE/Properties.Resources.Designer.cs.dll b/HospitalManageSys/obj/x86/Debug/TempPE/Properties.Resources.Designer.cs.dll new file mode 100644 index 0000000..8d40d9a Binary files /dev/null and b/HospitalManageSys/obj/x86/Debug/TempPE/Properties.Resources.Designer.cs.dll differ diff --git a/HospitalManageSys/publish/Application Files/HospitalManageSys_1_0_0_1/HospitalManageSys.application b/HospitalManageSys/publish/Application Files/HospitalManageSys_1_0_0_1/HospitalManageSys.application new file mode 100644 index 0000000..c77d233 --- /dev/null +++ b/HospitalManageSys/publish/Application Files/HospitalManageSys_1_0_0_1/HospitalManageSys.application @@ -0,0 +1,22 @@ + + + + + + + + + + + + + + + + + + dnFNks1vVC2TLM35bZlJNz0HV9M= + + + +dOWn5IfXkqCYKO+XNSWEfKki8UU=fqN9sEjvWX2Wgzao2mLL3K7fOFXM/zoE671+sMxVFaygfyxT1EoC+PuiWhfhW2InA8n9LYMpprjguX0AZqzdblXMwOXSla3KnGn0klE8qbpB246QxwTrsRpJrwt0RILJoyj0MMj16cu0mAMaZVWLuDEVbLBrnfGkxj1zP7Dez2Y=xKBWjcArF+kTUz+C1cpshuginXmu6eVDvMEtjykpVZ5P7I0Aa8bVoDTRa5w1r+GbUhIpuclwgB0ngu3uHWQmou4+G7Elx9etMNdlJKkKvQDJDjP/ZntD5ipszZ8tlbp8Qa1tvAHu5f56GhsG+LGbrcYohDzL6MHGHi0RfAX8cks=AQABCN=嗯哼\BattyoIY7rHohfUeGcXBXz6GF96Z3mIY=kpiZUNcnZMCiV1MD/I/R/faH75x/6RWf73j1jod9wEtAcWe7MBDqEiOjJrlmVwqAWMioijuxezVDnHUS4lLYp+6jR8CznftBztRvmWtMB0paqBw4AZHEL4TK64MEgkxm+Wcf/WdZLRC58ISttGeDIrhxYDAoTQbDGZq/1GCctfw=xKBWjcArF+kTUz+C1cpshuginXmu6eVDvMEtjykpVZ5P7I0Aa8bVoDTRa5w1r+GbUhIpuclwgB0ngu3uHWQmou4+G7Elx9etMNdlJKkKvQDJDjP/ZntD5ipszZ8tlbp8Qa1tvAHu5f56GhsG+LGbrcYohDzL6MHGHi0RfAX8cks=AQABMIIBuTCCASKgAwIBAgIQWbo0ueUlBYhGInFFKc/7cTANBgkqhkiG9w0BAQUFADAbMRkwFwYDVQQDHhBV71T8AFwAQgBhAHQAdAB5MB4XDTE2MTExNjA4MzgxN1oXDTE3MTExNjE0MzgxN1owGzEZMBcGA1UEAx4QVe9U/ABcAEIAYQB0AHQAeTCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEAxKBWjcArF+kTUz+C1cpshuginXmu6eVDvMEtjykpVZ5P7I0Aa8bVoDTRa5w1r+GbUhIpuclwgB0ngu3uHWQmou4+G7Elx9etMNdlJKkKvQDJDjP/ZntD5ipszZ8tlbp8Qa1tvAHu5f56GhsG+LGbrcYohDzL6MHGHi0RfAX8cksCAwEAATANBgkqhkiG9w0BAQUFAAOBgQBzx4gy4tyZ7Gn2h+leYuTv/07aViWX8+ltcKDccD30DXgInn6OYYwmFoeKf8JJJQSYb/h9wDU8Vmk2wDvuhqcUVslh2XoLlHg99EuSETkJ5UB5ilqEZEc7SwjP+axad9en315VXcxdXvlugjj1E+8FwM6nn47hRN/ECBLOeI8Tmw== \ No newline at end of file diff --git a/HospitalManageSys/publish/Application Files/HospitalManageSys_1_0_0_1/HospitalManageSys.exe.deploy b/HospitalManageSys/publish/Application Files/HospitalManageSys_1_0_0_1/HospitalManageSys.exe.deploy new file mode 100644 index 0000000..3fd4657 Binary files /dev/null and b/HospitalManageSys/publish/Application Files/HospitalManageSys_1_0_0_1/HospitalManageSys.exe.deploy differ diff --git a/HospitalManageSys/publish/Application Files/HospitalManageSys_1_0_0_1/HospitalManageSys.exe.manifest b/HospitalManageSys/publish/Application Files/HospitalManageSys_1_0_0_1/HospitalManageSys.exe.manifest new file mode 100644 index 0000000..e1db34c --- /dev/null +++ b/HospitalManageSys/publish/Application Files/HospitalManageSys_1_0_0_1/HospitalManageSys.exe.manifest @@ -0,0 +1,68 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + RKTk1clHFw+Q0kvJjKXhsiIT3zs= + + + + + + + + + + + + ZzSpy3SIUxHuh/0rTLHDuIuNPmM= + + + +y7E2FIV9HHuVn8d/nAevf4TD28o=t14wrA2X7SHp5BkOF0Rf7r2mTa/Bie4woWLl84fH796u2U68yRaqYWKOv6K3SgHp1K41JSSiR11yFFAZf+Vyc6ai8QtfLsAevDda2GnxAgPxVWTYcUqpZVP0Rdmvn8qfp2QxhJmIfV8uGqlB/rwAWPSpuvJ/SlbpviPutC5X6io=xKBWjcArF+kTUz+C1cpshuginXmu6eVDvMEtjykpVZ5P7I0Aa8bVoDTRa5w1r+GbUhIpuclwgB0ngu3uHWQmou4+G7Elx9etMNdlJKkKvQDJDjP/ZntD5ipszZ8tlbp8Qa1tvAHu5f56GhsG+LGbrcYohDzL6MHGHi0RfAX8cks=AQABCN=嗯哼\BattyIDB71Z1U3W4retyHtYP9laorK+g=VHYyzw95c+zivkV/fSUKthSroGUpYDVRLyes/ZptD8flAT8zsKdLygaoyq+wzoFqXkDwBl7hhth5JIbKKjFrrHbSoysGUJYM3GeFcMxh+UAxUM1zfel+gKxDn1BiqCey7b76Uc4EPAlMPnYTfJB3LULZW0Py4MyQwEM6nnO8DtE=xKBWjcArF+kTUz+C1cpshuginXmu6eVDvMEtjykpVZ5P7I0Aa8bVoDTRa5w1r+GbUhIpuclwgB0ngu3uHWQmou4+G7Elx9etMNdlJKkKvQDJDjP/ZntD5ipszZ8tlbp8Qa1tvAHu5f56GhsG+LGbrcYohDzL6MHGHi0RfAX8cks=AQABMIIBuTCCASKgAwIBAgIQWbo0ueUlBYhGInFFKc/7cTANBgkqhkiG9w0BAQUFADAbMRkwFwYDVQQDHhBV71T8AFwAQgBhAHQAdAB5MB4XDTE2MTExNjA4MzgxN1oXDTE3MTExNjE0MzgxN1owGzEZMBcGA1UEAx4QVe9U/ABcAEIAYQB0AHQAeTCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEAxKBWjcArF+kTUz+C1cpshuginXmu6eVDvMEtjykpVZ5P7I0Aa8bVoDTRa5w1r+GbUhIpuclwgB0ngu3uHWQmou4+G7Elx9etMNdlJKkKvQDJDjP/ZntD5ipszZ8tlbp8Qa1tvAHu5f56GhsG+LGbrcYohDzL6MHGHi0RfAX8cksCAwEAATANBgkqhkiG9w0BAQUFAAOBgQBzx4gy4tyZ7Gn2h+leYuTv/07aViWX8+ltcKDccD30DXgInn6OYYwmFoeKf8JJJQSYb/h9wDU8Vmk2wDvuhqcUVslh2XoLlHg99EuSETkJ5UB5ilqEZEc7SwjP+axad9en315VXcxdXvlugjj1E+8FwM6nn47hRN/ECBLOeI8Tmw== \ No newline at end of file diff --git a/HospitalManageSys/publish/Application Files/HospitalManageSys_1_0_0_1/MySql.Data.dll.deploy b/HospitalManageSys/publish/Application Files/HospitalManageSys_1_0_0_1/MySql.Data.dll.deploy new file mode 100644 index 0000000..b732da4 Binary files /dev/null and b/HospitalManageSys/publish/Application Files/HospitalManageSys_1_0_0_1/MySql.Data.dll.deploy differ diff --git a/HospitalManageSys/publish/HospitalManageSys.application b/HospitalManageSys/publish/HospitalManageSys.application new file mode 100644 index 0000000..c77d233 --- /dev/null +++ b/HospitalManageSys/publish/HospitalManageSys.application @@ -0,0 +1,22 @@ + + + + + + + + + + + + + + + + + + dnFNks1vVC2TLM35bZlJNz0HV9M= + + + +dOWn5IfXkqCYKO+XNSWEfKki8UU=fqN9sEjvWX2Wgzao2mLL3K7fOFXM/zoE671+sMxVFaygfyxT1EoC+PuiWhfhW2InA8n9LYMpprjguX0AZqzdblXMwOXSla3KnGn0klE8qbpB246QxwTrsRpJrwt0RILJoyj0MMj16cu0mAMaZVWLuDEVbLBrnfGkxj1zP7Dez2Y=xKBWjcArF+kTUz+C1cpshuginXmu6eVDvMEtjykpVZ5P7I0Aa8bVoDTRa5w1r+GbUhIpuclwgB0ngu3uHWQmou4+G7Elx9etMNdlJKkKvQDJDjP/ZntD5ipszZ8tlbp8Qa1tvAHu5f56GhsG+LGbrcYohDzL6MHGHi0RfAX8cks=AQABCN=嗯哼\BattyoIY7rHohfUeGcXBXz6GF96Z3mIY=kpiZUNcnZMCiV1MD/I/R/faH75x/6RWf73j1jod9wEtAcWe7MBDqEiOjJrlmVwqAWMioijuxezVDnHUS4lLYp+6jR8CznftBztRvmWtMB0paqBw4AZHEL4TK64MEgkxm+Wcf/WdZLRC58ISttGeDIrhxYDAoTQbDGZq/1GCctfw=xKBWjcArF+kTUz+C1cpshuginXmu6eVDvMEtjykpVZ5P7I0Aa8bVoDTRa5w1r+GbUhIpuclwgB0ngu3uHWQmou4+G7Elx9etMNdlJKkKvQDJDjP/ZntD5ipszZ8tlbp8Qa1tvAHu5f56GhsG+LGbrcYohDzL6MHGHi0RfAX8cks=AQABMIIBuTCCASKgAwIBAgIQWbo0ueUlBYhGInFFKc/7cTANBgkqhkiG9w0BAQUFADAbMRkwFwYDVQQDHhBV71T8AFwAQgBhAHQAdAB5MB4XDTE2MTExNjA4MzgxN1oXDTE3MTExNjE0MzgxN1owGzEZMBcGA1UEAx4QVe9U/ABcAEIAYQB0AHQAeTCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEAxKBWjcArF+kTUz+C1cpshuginXmu6eVDvMEtjykpVZ5P7I0Aa8bVoDTRa5w1r+GbUhIpuclwgB0ngu3uHWQmou4+G7Elx9etMNdlJKkKvQDJDjP/ZntD5ipszZ8tlbp8Qa1tvAHu5f56GhsG+LGbrcYohDzL6MHGHi0RfAX8cksCAwEAATANBgkqhkiG9w0BAQUFAAOBgQBzx4gy4tyZ7Gn2h+leYuTv/07aViWX8+ltcKDccD30DXgInn6OYYwmFoeKf8JJJQSYb/h9wDU8Vmk2wDvuhqcUVslh2XoLlHg99EuSETkJ5UB5ilqEZEc7SwjP+axad9en315VXcxdXvlugjj1E+8FwM6nn47hRN/ECBLOeI8Tmw== \ No newline at end of file diff --git a/HospitalManageSys/publish/setup.exe b/HospitalManageSys/publish/setup.exe new file mode 100644 index 0000000..0a21237 Binary files /dev/null and b/HospitalManageSys/publish/setup.exe differ diff --git a/Image/admin.png b/Image/admin.png new file mode 100644 index 0000000..7d86a58 Binary files /dev/null and b/Image/admin.png differ diff --git a/Image/background.jpg b/Image/background.jpg new file mode 100644 index 0000000..41325be Binary files /dev/null and b/Image/background.jpg differ diff --git a/Image/charge.png b/Image/charge.png new file mode 100644 index 0000000..cff99ee Binary files /dev/null and b/Image/charge.png differ diff --git a/Image/clinic.jpg b/Image/clinic.jpg new file mode 100644 index 0000000..a565cba Binary files /dev/null and b/Image/clinic.jpg differ diff --git a/Image/drugEx.png b/Image/drugEx.png new file mode 100644 index 0000000..e56ddfc Binary files /dev/null and b/Image/drugEx.png differ diff --git a/Image/drugIm.png b/Image/drugIm.png new file mode 100644 index 0000000..01b8610 Binary files /dev/null and b/Image/drugIm.png differ diff --git a/Image/exit.gif b/Image/exit.gif new file mode 100644 index 0000000..81a22e3 Binary files /dev/null and b/Image/exit.gif differ diff --git a/Image/login.png b/Image/login.png new file mode 100644 index 0000000..7254401 Binary files /dev/null and b/Image/login.png differ diff --git a/Image/registration.png b/Image/registration.png new file mode 100644 index 0000000..8887f8b Binary files /dev/null and b/Image/registration.png differ