c#进销存
职工信息的增删改查
zhigong.cs
using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using DZY; using MySql.Data.MySqlClient; namespace DZY { public partial class cZhigong : Form { public cZhigong() { InitializeComponent(); } getZhigong Emp = new getZhigong(); wZhigong Emply = new wZhigong(); public static int intFalg = 0; int G_Int_status; public int getPan() { int intFalg1 = 0; if (intFalg != 3) { if (txtEmpName.Text == "") { MessageBox.Show("员工姓名不能为空！", "提示"); txtEmpName.Focus(); return intFalg1; } if (txtEmpLoginName.Text == "") { MessageBox.Show("登录名称不能为空！", "提示"); return intFalg1; } if (intFalg != 2) { if (txtEmpLoginPwd.Text == "") { MessageBox.Show("登录密码不能为空！", "提示"); return intFalg1; } } if (intFalg == 2) { Emp.getEmpId = this.dataGridView1[0, this.dataGridView1.CurrentCell.RowIndex].Value.ToString(); } else { Emp.getEmpId = Emply.EmpInfoID(); } } else { if (txtEmpName.Text == "") { MessageBox.Show("请在下面选择要删除的记录", "提示"); return intFalg1; } else { Emp.getEmpId = this.dataGridView1[0, this.dataGridView1.CurrentCell.RowIndex].Value.ToString(); Emp.getEmpId = this.dataGridView1[0, this.dataGridView1.CurrentCell.RowIndex].Value.ToString(); } } Emp.getEmpName = txtEmpName.Text; Emp.getEmpLoginName = txtEmpLoginName.Text; Emp.getEmpLoginPwd = txtEmpLoginPwd.Text; Emp.getEmpSex = comboBox2.Text; Emp.getEmpBirthday = daEmpBirthday.Value; Emp.getEmpPhone = txtEmpPhone.Text; if (intFalg != 3) { Emp.getEmpFalg = 0; } else { Emp.getEmpFalg = 1; } intFalg1 = 1; return intFalg1; } /// <summary> /// 将控件恢复到原始状态 /// </summary> private void ClearControls() { txtEmpLoginName.Text = ""; txtEmpLoginPwd.Text = ""; txtEmpName.Text = ""; txtEmpPhone.Text = ""; comboBox2.SelectedIndex = 0; this.daEmpBirthday.Value = DateTime.Now; } private void frmEmpInfo_Load(object sender, EventArgs e) { Emply.EmpInfoFind("", 5, dataGridView1); } private void toolAdd_Click(object sender, EventArgs e) { ClearControls(); intFalg = 1; } private void toolAmend_Click(object sender, EventArgs e) { intFalg = 2; } private void toolrefesh_Click(object sender, EventArgs e) { ClearControls(); } private void toolCancel_Click(object sender, EventArgs e) { ClearControls(); } private void toolSave_Click(object sender, EventArgs e) { if (getPan() == 1) { if (intFalg == 1) { if (Emply.EmpInfoFind(txtEmpLoginName.Text, "", 1) == 1) { MessageBox.Show("登录名称已被占用!！"); txtEmpLoginName.Text = ""; txtEmpLoginName.Focus(); return; } if (Emply.EmpInfoAdd(Emp) == 1) { MessageBox.Show("添加成功"); intFalg = 0; Emply.EmpInfoFind("", 5, dataGridView1); ClearControls(); } else { MessageBox.Show("添加成功"); intFalg = 0; ClearControls(); } } if (intFalg == 2) { if (Emply.EmpInfoUpdate(Emp) == 1) { MessageBox.Show("修改成功"); intFalg = 0; Emply.EmpInfoFind("", 5, dataGridView1); ClearControls(); } else { MessageBox.Show("修改成功"); intFalg = 0; //Emply.tb_EmpInfoFind("2",dataGridView1); ClearControls(); } } if (intFalg == 3) { if (Emply.EmpInfoDelete(Emp) == 1) { MessageBox.Show("删除成功"); intFalg = 0; Emply.EmpInfoFind("", 5, dataGridView1); ClearControls(); } else { MessageBox.Show("删除成功"); intFalg = 0; ClearControls(); } } } } private void FillControls() { try { MySqlDataReader sqldr = Emply.EmpInfoFind(this.dataGridView1[0, this.dataGridView1.CurrentCell.RowIndex].Value.ToString(), 1); sqldr.Read(); if (sqldr.HasRows) { txtEmpLoginName.Text = sqldr[2].ToString(); txtEmpName.Text = sqldr[1].ToString(); comboBox2.Text = sqldr[4].ToString(); daEmpBirthday.Value = Convert.ToDateTime(sqldr[5].ToString()); txtEmpPhone.Text = sqldr[6].ToString(); } } catch (Exception ee) { MessageBox.Show(ee.ToString()); } } private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e) { if (intFalg == 2 || intFalg == 3) { FillControls(); } } private void toolExit_Click(object sender, EventArgs e) { this.Close(); } private void toolDelete_Click(object sender, EventArgs e) { intFalg = 3; } private void label12_Click(object sender, EventArgs e) { } private void daEmpBirthday_ValueChanged(object sender, EventArgs e) { } private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { } private void txtEmpName_TextChanged(object sender, EventArgs e) { } } }using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using DZY; using MySql.Data.MySqlClient; namespace DZY { public partial class cZhigong : Form { public cZhigong() { InitializeComponent(); } getZhigong Emp = new getZhigong(); wZhigong Emply = new wZhigong(); public static int intFalg = 0; int G_Int_status; public int getPan() { int intFalg1 = 0; if (intFalg != 3) { if (txtEmpName.Text == "") { MessageBox.Show("员工姓名不能为空！", "提示"); txtEmpName.Focus(); return intFalg1; } if (txtEmpLoginName.Text == "") { MessageBox.Show("登录名称不能为空！", "提示"); return intFalg1; } if (intFalg != 2) { if (txtEmpLoginPwd.Text == "") { MessageBox.Show("登录密码不能为空！", "提示"); return intFalg1; } } if (intFalg == 2) { Emp.getEmpId = this.dataGridView1[0, this.dataGridView1.CurrentCell.RowIndex].Value.ToString(); } else { Emp.getEmpId = Emply.EmpInfoID(); } } else { if (txtEmpName.Text == "") { MessageBox.Show("请在下面选择要删除的记录", "提示"); return intFalg1; } else { Emp.getEmpId = this.dataGridView1[0, this.dataGridView1.CurrentCell.RowIndex].Value.ToString(); Emp.getEmpId = this.dataGridView1[0, this.dataGridView1.CurrentCell.RowIndex].Value.ToString(); } } Emp.getEmpName = txtEmpName.Text; Emp.getEmpLoginName = txtEmpLoginName.Text; Emp.getEmpLoginPwd = txtEmpLoginPwd.Text; Emp.getEmpSex = comboBox2.Text; Emp.getEmpBirthday = daEmpBirthday.Value; Emp.getEmpPhone = txtEmpPhone.Text; if (intFalg != 3) { Emp.getEmpFalg = 0; } else { Emp.getEmpFalg = 1; } intFalg1 = 1; return intFalg1; } /// <summary> /// 将控件恢复到原始状态 /// </summary> private void ClearControls() { txtEmpLoginName.Text = ""; txtEmpLoginPwd.Text = ""; txtEmpName.Text = ""; txtEmpPhone.Text = ""; comboBox2.SelectedIndex = 0; this.daEmpBirthday.Value = DateTime.Now; } private void frmEmpInfo_Load(object sender, EventArgs e) { Emply.EmpInfoFind("", 5, dataGridView1); } private void toolAdd_Click(object sender, EventArgs e) { ClearControls(); intFalg = 1; } private void toolAmend_Click(object sender, EventArgs e) { intFalg = 2; } private void toolrefesh_Click(object sender, EventArgs e) { ClearControls(); } private void toolCancel_Click(object sender, EventArgs e) { ClearControls(); } private void toolSave_Click(object sender, EventArgs e) { if (getPan() == 1) { if (intFalg == 1) { if (Emply.EmpInfoFind(txtEmpLoginName.Text, "", 1) == 1) { MessageBox.Show("登录名称已被占用!！"); txtEmpLoginName.Text = ""; txtEmpLoginName.Focus(); return; } if (Emply.EmpInfoAdd(Emp) == 1) { MessageBox.Show("添加成功"); intFalg = 0; Emply.EmpInfoFind("", 5, dataGridView1); ClearControls(); } else { MessageBox.Show("添加成功"); intFalg = 0; ClearControls(); } } if (intFalg == 2) { if (Emply.EmpInfoUpdate(Emp) == 1) { MessageBox.Show("修改成功"); intFalg = 0; Emply.EmpInfoFind("", 5, dataGridView1); ClearControls(); } else { MessageBox.Show("修改成功"); intFalg = 0; //Emply.tb_EmpInfoFind("2",dataGridView1); ClearControls(); } } if (intFalg == 3) { if (Emply.EmpInfoDelete(Emp) == 1) { MessageBox.Show("删除成功"); intFalg = 0; Emply.EmpInfoFind("", 5, dataGridView1); ClearControls(); } else { MessageBox.Show("删除成功"); intFalg = 0; ClearControls(); } } } } private void FillControls() { try { MySqlDataReader sqldr = Emply.EmpInfoFind(this.dataGridView1[0, this.dataGridView1.CurrentCell.RowIndex].Value.ToString(), 1); sqldr.Read(); if (sqldr.HasRows) { txtEmpLoginName.Text = sqldr[2].ToString(); txtEmpName.Text = sqldr[1].ToString(); comboBox2.Text = sqldr[4].ToString(); daEmpBirthday.Value = Convert.ToDateTime(sqldr[5].ToString()); txtEmpPhone.Text = sqldr[6].ToString(); } } catch (Exception ee) { MessageBox.Show(ee.ToString()); } } private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e) { if (intFalg == 2 || intFalg == 3) { FillControls(); } } private void toolExit_Click(object sender, EventArgs e) { this.Close(); } private void toolDelete_Click(object sender, EventArgs e) { intFalg = 3; } private void label12_Click(object sender, EventArgs e) { } private void daEmpBirthday_ValueChanged(object sender, EventArgs e) { } private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { } private void txtEmpName_TextChanged(object sender, EventArgs e) { } } }
主界面
index.cs
using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using DZY; namespace DZY { public partial class cIndex : Form { public cIndex() { InitializeComponent(); } public cIndex(string strName) { InitializeComponent(); SendNameValue = strName; } public string SendNameValue; private void menuGoodsIn_Click(object sender, EventArgs e) { //进货信息 cJinhuo jh = new cJinhuo(); jh.Owner = this; jh.ShowDialog(); } private void menuEmployee_Click(object sender, EventArgs e) { //员工信息 cZhigong emp = new cZhigong(); emp.Owner = this; emp.ShowDialog(); } private void menuCompany_Click(object sender, EventArgs e) { //供应商信息 cGongying com = new cGongying(); com.Owner = this; com.ShowDialog(); } private void menuFind_Click(object sender, EventArgs e) { //商品信息查查询 cChajin ch = new cChajin(); ch.Owner = this; ch.ShowDialog(); } private void menuDepotFind_Click(object sender, EventArgs e) { //库存查询 cChaku ckc = new cChaku(); ckc.Owner = this; ckc.ShowDialog(); } private void menuSellGoods_Click(object sender, EventArgs e) { //商品销售信息 cMaihuo mh = new cMaihuo(); mh.Owner = this; mh.ShowDialog(); } private void menuSellFind_Click(object sender, EventArgs e) { //出售商品查询信息 cMaicha cmh = new cMaicha(); cmh.Owner = this; cmh.ShowDialog(); } private void menuDepotAlarm_Click(object sender, EventArgs e) { //库存管理信息 cKucun cmh = new cKucun(); cmh.Owner = this; cmh.ShowDialog(); } private void Main_Load(object sender, EventArgs e) { timer2.Enabled = true; } private void timer2_Tick(object sender, EventArgs e) { this.statusTime.Text = "当前时间：" + DateTime.Now.ToString(); } private void Main_FormClosing(object sender, FormClosingEventArgs e) { Application.Exit(); } private void 重新登陆ToolStripMenuItem_Click(object sender, EventArgs e) { cDenglu frm = new cDenglu(); frm.Show(); this.Hide(); } private void 直接退出ToolStripMenuItem_Click(object sender, EventArgs e) { Application.Exit(); } private void menuBaseManage_Click(object sender, EventArgs e) { } } }
