private void button1_Click(object sender, EventArgs e) { try { if (textBox1.Text.Trim() != "55555") { MessageBox.Show("密码错误"); textBox1.Focus(); textBox1.SelectAll(); return; } if (ClassDB.getDataSet("select * from 用户表").Tables[0].Rows.Count > 0) { ClassDB.ExcuteSql("update 用户表 set 用户密码='" + ClassDB.Encrypt(textBox1.Text.Trim()) + "',次数期限='" + ClassDB.Encrypt(textBox2.Text.Trim()) + "'"); } else { ClassDB.ExcuteSql("insert into 用户表(用户密码,次数期限) values('" + ClassDB.Encrypt(textBox1.Text.Trim()) + "','" + ClassDB.Encrypt(textBox2.Text.Trim()) + "')"); } this.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
// 验证是否能够通过 private void FormMain_Load(object sender, EventArgs e) { try { toolStripStatusLabel1.Text = " 欢饮您!" + username; if (usertype == "普通用户") { //toolStripButton4.Visible = false; toolStripButton5.Visible = false; //toolStripLabel5.Visible = false; toolStripLabel4.Visible = false; } DataSet ds = ClassDB.getDataSet("select * from 用户表"); // 没有用户 用户密码错误 用户次数小于1 if (ds.Tables[0].Rows.Count < 1 || ClassDB.Decrypt(ds.Tables[0].Rows[0]["用户密码"].ToString()) != "55555" || long.Parse(ClassDB.Decrypt(ds.Tables[0].Rows[0]["次数期限"].ToString())) < 1) { // 验证不通过 FormPassowrd pass = new FormPassowrd(); // 锁定 pass.ShowDialog(); } else { string sql = "update 用户表 set 次数期限='" + ClassDB.Encrypt((long.Parse(ClassDB.Decrypt(ds.Tables[0].Rows[0]["次数期限"].ToString())) - 1).ToString()) + "'"; ClassDB.ExcuteSql(sql); } } catch { FormPassowrd pass = new FormPassowrd(); // 锁定 pass.ShowDialog(); } }
private void 除ToolStripMenuItem_Click(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count < 1) { MessageBox.Show("请选择需要删除的订单"); return; } if (MessageBox.Show("是否确定要删除订单" + dataGridView1.SelectedRows[0].Cells["订单流水号"].Value.ToString() + "?\r\n删除不可恢复!", "确认", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No) { return; } try { string sql = "delete from 订单表 where 订单编号='" + dataGridView1.SelectedRows[0].Cells["订单流水号"].Value.ToString() + "'"; ClassDB.ExcuteSql(sql); sql = "delete from 订单详单表 where 订单编号='" + dataGridView1.SelectedRows[0].Cells["订单流水号"].Value.ToString() + "'"; ClassDB.ExcuteSql(sql); MessageBox.Show("删除成功"); refresh(); } catch (Exception ex) { MessageBox.Show("Error Info:" + ex.Message); } }
private void button2_Click(object sender, EventArgs e) { if (textBox1.Text.Trim() == "") { MessageBox.Show("不能为空"); textBox1.SelectAll(); textBox1.Focus(); return; } if (comboBox1.SelectedIndex < 0) { MessageBox.Show("请选择产品类别"); return; } try { string sql = "select * from 产品名称 where 产品名称='" + textBox1.Text.Trim() + "' and 产品类别='" + comboBox1.SelectedItem.ToString() + "'"; if (ClassDB.getDataSet(sql).Tables[0].Rows.Count > 0) { MessageBox.Show(textBox1.Text.Trim() + " 已存在,请修改"); textBox1.SelectAll(); textBox1.Focus(); return; } sql = "insert into 产品名称(产品名称,产品类别) values('" + textBox1.Text.Trim() + "','" + comboBox1.SelectedItem.ToString() + "')"; ClassDB.ExcuteSql(sql); textBox1.Text = ""; bingdata(); MessageBox.Show("添加完成"); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void buttonAdd_Click(object sender, EventArgs e) { if (textBoxDHDW.Text.Trim() == "") { MessageBox.Show("不能为空"); textBoxDHDW.SelectAll(); textBoxDHDW.Focus(); return; } try { string sql = "select * from 订货单位 where 订货单位='" + textBoxDHDW.Text.Trim() + "'"; if (ClassDB.getDataSet(sql).Tables[0].Rows.Count > 0) { MessageBox.Show(textBoxDHDW.Text.Trim() + " 已存在,请修改"); textBoxDHDW.SelectAll(); textBoxDHDW.Focus(); return; } sql = "insert into 订货单位(订货单位) values('" + textBoxDHDW.Text.Trim() + "')"; ClassDB.ExcuteSql(sql); textBoxDHDW.Text = ""; bingdata(); MessageBox.Show("添加完成"); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void button3_Click(object sender, EventArgs e) { if (dataGridView1.SelectedCells.Count == 0) { MessageBox.Show("请选择要删除的用户", "提示", //弹出消息对话框 MessageBoxButtons.OK, MessageBoxIcon.Information); return; //退出事件 } else { try { string username1 = dataGridView1.SelectedCells[0].Value.ToString(); //得到用户名 string strsql = //创建SQL字符串 "delete from 权限表 where 用户名='" + username1 + "'"; ClassDB.ExcuteSql(strsql); //删除数据库中指定记录 MessageBox.Show("删除成功!", "提示", //弹出消息对话框 MessageBoxButtons.OK, MessageBoxIcon.Information); ShowUserInfo(); } catch (Exception ex) { MessageBox.Show("数据库错误\r\n" + ex.Message); } } }
private void button2_Click(object sender, EventArgs e) { if (textBox1.Text.Trim() == "") { MessageBox.Show("不能为空"); textBox1.SelectAll(); textBox1.Focus(); return; } try { string sql = "select * from 产品类别 where 产品类别='" + textBox1.Text.Trim() + "'"; if (ClassDB.getDataSet(sql).Tables[0].Rows.Count > 0) { MessageBox.Show(textBox1.Text.Trim() + " 已存在,请修改"); textBox1.SelectAll(); textBox1.Focus(); return; } sql = "insert into 产品类别(产品类别) values('" + textBox1.Text.Trim() + "')"; ClassDB.ExcuteSql(sql); MessageBox.Show("添加完成"); this.Close(); ((FormSysSet)this.Owner).bingCPLB(textBox1.Text.Trim()); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void button2_Click(object sender, EventArgs e) { if (txtOUser.Text.Trim() == "" || txtOPwd.Text.Trim() == "") { MessageBox.Show("请填写完整用户信息!", "提示",//弹出消息对话框 MessageBoxButtons.OK, MessageBoxIcon.Information); txtOUser.Focus(); return;//退出事件 } try { string str =//创建SQL字符串 "select * from 权限表 where 用户名='" + txtOUser.Text.Trim() + "'"; DataSet ds = ClassDB.getDataSet(str); if (ds.Tables[0].Rows.Count > 0) { MessageBox.Show("用户已存在!", "提示",//弹出消息对话框 MessageBoxButtons.OK, MessageBoxIcon.Information); txtOUser.Focus(); return;//退出事件 } else { if (txtOPwd.Text.Length < 6) { MessageBox.Show("请确保密码大于6位字符"); txtOPwd.Focus(); return; } str =//创建SQL字符串 "insert into 权限表 values('" + txtOUser.Text.Trim() + "','" + txtOPwd.Text.Trim() + "','" + type.SelectedItem.ToString() + "')"; ClassDB.ExcuteSql(str); MessageBox.Show("添加成功!", "提示",//弹出消息对话框 MessageBoxButtons.OK, MessageBoxIcon.Information); ShowUserInfo(); } } catch (Exception ex) { MessageBox.Show("添加用户失败!" + ex.Message, "提示",//弹出消息对话框 MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void button1_Click(object sender, EventArgs e) { if (MessageBox.Show("是否确定要清空数据库?", "确认", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No) { return; } try { string sql = "delete from 订单表 wher"; ClassDB.ExcuteSql(sql); sql = "delete from 订单详单表"; ClassDB.ExcuteSql(sql); MessageBox.Show("清空完成"); } catch (Exception ex) { MessageBox.Show("Error Info:" + ex.Message); } }
private void button11_Click(object sender, EventArgs e) { if (listBox6.SelectedIndex < 0) { MessageBox.Show("请选择需要删除的一项"); return; } try { string sql = "delete from 产品类别 where 产品类别='" + listBox6.SelectedItem.ToString() + "'"; ClassDB.ExcuteSql(sql); bingdata(); MessageBox.Show("删除完成"); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void button4_Click(object sender, EventArgs e) { if (txtOUser.Text.Trim() == "" || txtOPwd.Text.Trim() == "") { MessageBox.Show("请填写完整用户信息!", "提示",//弹出消息对话框 MessageBoxButtons.OK, MessageBoxIcon.Information); txtOUser.Focus(); return;//退出事件 } if (txtOPwd.Text.Length < 6) { MessageBox.Show("请确保密码大于6位字符"); txtOPwd.Focus(); return; } try { string str =//创建SQL字符串 "select * from 权限表 where 用户名='" + txtOUser.Text.Trim() + "'"; DataSet ds = ClassDB.getDataSet(str); if (ds.Tables[0].Rows.Count > 0) { str = //创建SQL字符串 "update 权限表 set 用户密码='" + txtOPwd.Text.Trim() + "',用户类型='" + type.SelectedItem.ToString() + "' where 用户名='" + txtOUser.Text.Trim() + "'"; ClassDB.ExcuteSql(str); //更新数据库信息 MessageBox.Show("修改成功!", "提示", //弹出消息对话框 MessageBoxButtons.OK, MessageBoxIcon.Information); ShowUserInfo(); } else { MessageBox.Show("指定用户不存在!", "提示",//弹出消息对话框 MessageBoxButtons.OK, MessageBoxIcon.Information); txtOUser.Focus(); } } catch (Exception ex) { MessageBox.Show("数据库错误\r\n" + ex.Message); } }
private void buttonOK_Click(object sender, EventArgs e) { if (DWMC.Text.Trim() == "") { MessageBox.Show("单位名称不能为空"); DWMC.Focus(); return; } try { string sql; if (this.Text == "修改客户") { sql = "delete from 客户表 where 单位名称='" + DWMC.Text.Trim() + "'"; ClassDB.ExcuteSql(sql); } else if (this.Text == "添加客户") { sql = "select 单位名称 from 客户表 where 单位名称='" + DWMC.Text.Trim() + "'"; if (ClassDB.getDataSet(sql).Tables[0].Rows.Count > 0) { MessageBox.Show("客户" + DWMC.Text.Trim() + "已经存在,请修改"); return; } } sql = "insert into 客户表 values('" + DWMC.Text.Trim() + "','" + DWDZ.Text.Trim() + "','" + FZR.Text + "','" + LXFS.Text.Trim() + "','" + JYXM.Text.Trim() + "','" + BZ.Text.Trim() + "','" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss") + "')"; ClassDB.ExcuteSql(sql); MessageBox.Show("保存完成"); this.Close(); } catch (Exception ex) { MessageBox.Show("Error Info:" + ex.Message); } }
private void buttonOK_Click(object sender, EventArgs e) { if (DDBH.Text.Trim() == "") { MessageBox.Show("订货编号不能空"); DDBH.Focus(); return; } if (DHDW.Text.Trim() == "") { MessageBox.Show("订货单位不能空"); DHDW.Focus(); return; } if (dt.Rows.Count < 1) { MessageBox.Show("产品详单不能空"); return; } if (SHR.Text.Trim() == "") { MessageBox.Show("收货人不能空"); SHDZ.Focus(); return; } if (LXFS.Text.Trim() == "") { MessageBox.Show("联系方式不能空"); LXFS.Focus(); return; } if (DHQD.Text.Trim() == "") { MessageBox.Show("订货渠道不能空"); DHQD.Focus(); return; } if (JBR.Text.Trim() == "") { MessageBox.Show("经办人不能空"); JBR.Focus(); return; } if (THFS.Text.Trim() == "") { MessageBox.Show("提货方式不能空"); THFS.Focus(); return; } try { int counts = 0; string sql; int i = 0; if (this.Text == "修改订单") { sql = "delete from 订单表 where 订单编号='" + DDBH.Text.Trim() + "'"; ClassDB.ExcuteSql(sql); sql = "delete from 订单详单表 where 订单编号='" + DDBH.Text.Trim() + "'"; ClassDB.ExcuteSql(sql); } else if (this.Text == "添加订单") { sql = "select 订单编号 from 订单表 where 订单编号='" + DDBH.Text.Trim() + "'"; if (ClassDB.getDataSet(sql).Tables[0].Rows.Count > 0) { MessageBox.Show("订单流水号已经被使用过,请修改"); return; } } while (i < dataGridView1.Rows.Count) { sql = "insert into 订单详单表 values('" + DDBH.Text.Trim() + "','" + dataGridView1.Rows[i].Cells["产品类别"].Value.ToString() + "','" + dataGridView1.Rows[i].Cells["产品名称"].Value.ToString() + "','" + dataGridView1.Rows[i].Cells["数量"].Value.ToString() + "','" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss") + "','" + dataGridView1.Rows[i].Cells["产品单位"].Value.ToString() + "')"; ClassDB.ExcuteSql(sql); //更新订单 counts += int.Parse(dataGridView1.Rows[i].Cells["数量"].Value.ToString()); i++; } sql = "insert into 订单表(订单编号,订货单位,订货时间,送货地址,收货人,联系方式,产品合计,订货渠道,经办人,提货方式,备注) values('" + DDBH.Text.Trim() + "','" + DHDW.Text.Trim() + "','" + DHSJ.Value.ToString("yyyy-MM-dd hh:mm:ss") + "','" + SHDZ.Text.Trim() + "','" + SHR.Text.Trim() + "','" + LXFS.Text.Trim() + "','" + counts.ToString() + "','" + DHQD.Text.Trim() + "','" + JBR.Text.Trim() + "','" + THFS.Text.Trim() + "','" + BZ.Text.Trim() + "')"; ClassDB.ExcuteSql(sql); //更新订单 parent.refresh(); MessageBox.Show("提交完成"); this.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }