进销存管理系统.doc

登陆界面核心代码:private void btnLoad_Click(object sender, EventArgs e) try string load = string.Format(select Password,EmpJob from Employe where EmpID=0, int.Parse(tBxEmpID.Text); ConDatabase con = new ConDatabase(); DataTable dtPWD = con.CheckSQL(load); if (dtPWD.Rows00.ToString().Equals(tBxPwd.Text.Trim() & cbBxName.SelectedItem.ToString().Trim().Equals(dtPWD.Rows01.ToString().Trim() this.Hide();/隐t藏?父?窗体? Context context = new Context(); Context.strid = this.tBxEmpID.Text.Trim(); context.messageEmp(tBxEmpID.Text, cbBxName.SelectedItem.ToString(); context.ShowDialog(); / 登?陆?成功|显?示?hello else tBxPwd.Text = ; MessageBox.Show(账?号?或密码?错误); catch MessageBox.Show(账?号?或密码?错误); 后台员工资料核心代码public EmpMessage() InitializeComponent(); this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.None; EmpMessages(); public void EmpMessages() ConDatabase con = new ConDatabase(); string select = select EmpID,EmpName ,Address ,E_mail ,EmpEb ,School ,Phone ,Password,EmpJob from Employe ; DataTable dt = con.CheckSQL(select); dGwEmployee.DataSource = dt.DefaultView; #region 添加员工信?息 private void btnAdd_Click(object sender, EventArgs e) try ConDatabase con = new ConDatabase(); string sqlInsert = string.Format(insert into Employe(EmpName,Address,E_mail,EmpEb,School,Phone,Password,EmpID,EmpJob) values (0,1,2,3,4,5,6,7,8), tBxEmpname.Text, tBxaddress.Text, tBxEmail.Text, tBxxueli.Text, tBxCollage.Text, tBxPhone.Text, tBxpwd.Text, int.Parse(tBxEmpID.Text), cbBxName.SelectedItem.ToString(); int m = con.AddMessage(sqlInsert); string select = select EmpID as 工号? ,EmpName as 员工名? ,Address as 家庭住?址 ,E_mail as 邮编 ,EmpEb as 学历 ,School as 毕?业学校 ,Phone 电?话号?码? ,Password as 密码? from Employe ; DataTable dt = con.CheckSQL(select); EmpMessages(); if (m 0) tBxEmpname.Text = ; tBxaddress.Text = ; tBxEmail.Text = ; tBxxueli.Text = ; tBxCollage.Text = ; tBxPhone.Text = ; tBxpwd.Text = ; tBxEmpID.Text = ; MessageBox.Show(添加成功|); else MessageBox.Show(添加失败); catch MessageBox.Show(添加有D误); #endregion #region 员工信?息查找 private void btnCheck_Click(object sender, EventArgs e) try FunCheck funcheck = new FunCheck(); funcheck.ShowDialog(); string name = funcheck.Funcheck(); ConDatabase con = new ConDatabase(); string select = string.Format(select EmpID as 工号? ,EmpName as 员工名? ,Address as 家庭住?址 ,E_mail as 邮编 ,EmpEb as 学历 ,School as 毕?业学校 ,Phone 电?话号?码? ,Password as 密码? ,EmpJob as 角?色? from Employe where EmpName like %0%, name); DataTable dt = con.CheckSQL(select); dGwEmployee.DataSource = dt.DefaultView; catch (Exception) MessageBox.Show(查找有D误); #endregion #region 删?除y private void btnDelete_Click(object sender, EventArgs e) try DialogResult result = MessageBox.Show(确定要a删?除y吗e？?, , MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question); if (result = DialogResult.Yes) int pk = int.Parse(dGwEmployee.RowsdGwEmployee.CurrentCell.RowIndex.Cells0.Value.ToString(); ConDatabase con = new ConDatabase(); string selectBills = string.Format(select BillsID from Bills where EmpID = 0,pk); DataTable dt = con.CheckSQL(selectBills); for (int i = 0,j=dt.Rows.Count; i 0) EmpMessages(); MessageBox.Show(修T改?成功|); catch MessageBox.Show(操作有D误); #endregion private void EmpMessage_Load(object sender, EventArgs e) cbBxName.Text = Admin; 进货销售销售统计挂单以取单 #region 挂单 ArrayList arr = new ArrayList(); / ArrayList ComBoxArr = new ArrayList(); int comBox = 0;/顾?客数y private void btnGuadan_Click(object sender, EventArgs e) try if (table.Rows00 != null) comBox+; DataTable GuaDan = null; if (c = 0) GuaDan = QuGuaTable; else GuaDan = table; arr.Add(GuaDan); / ComBoxArr.Add(顾?客+comBox); yifu = 0;/清?空?上?位?顾?客的?价?钱? InitDataTable();/重?新?分?配?空?间? c = -1; dataGridView1.DataSource = table.DefaultView; catch MessageBox.Show(信?息为a空?); #endregion #region 取?单 DataTable QuGuaTable = null; private void btnQugua_Click(object sender, EventArgs e) GuaDanXuanXiang gua = new GuaDanXuanXiang(); gua.message(arr); if (comBox 0) gua.ShowDialog(); int GuestDan = gua.ResultValue(); c = GuestDan; QuGuaTable = (DataTable)arrGuestDan; yifu = 0; for (int i = 0, j = QuGuaTable.Rows.Count; i j; i+) yifu += (decimal.Parse(QuGuaTable.Rowsi2.ToString() * decimal.Parse(QuGuaTable