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);
}
}