public CommodityClassMangmentForm() { InitializeComponent(); SuperMarketDataClassesDataContext db = new SuperMarketDataClassesDataContext(); dataGridView1.DataSource = db.SISM_commodityclass; }
//添加 private void button1_Click(object sender, EventArgs e) { SuperMarketDataClassesDataContext db = new SuperMarketDataClassesDataContext(); SISM_commodityclass scc = new SISM_commodityclass(); if (textBox4.Text != "") { scc.SId = int.Parse(textBox4.Text); scc.SName = textBox2.Text; scc.SNote = textBox3.Text; db.SISM_commodityclass.InsertOnSubmit(scc); try { db.SubmitChanges(); dataGridView1.DataSource = db.SISM_commodityclass; MessageBox.Show("添加成功!"); clear(); } catch (Exception ex) { } } else { MessageBox.Show("请输入添加信息!"); } }
//查询 private void button3_Click(object sender, EventArgs e) { SuperMarketDataClassesDataContext db = new SuperMarketDataClassesDataContext(); if (radioButton1.Checked) { var q = (from m in db.SISM_commodityclass where m.SId == int.Parse(textBox1.Text) select m); foreach (var c in q) { textBox4.Text = c.SId.ToString(); textBox2.Text = c.SName; textBox3.Text = c.SNote; } } else if (radioButton2.Checked) { var q = (from m in db.SISM_commodityclass where m.SName == textBox1.Text select m); foreach (var name in q) { textBox4.Text = name.SId.ToString(); textBox2.Text = name.SName; textBox3.Text = name.SNote; } } else { MessageBox.Show("请输入查询条件!"); } }
private void revise_Click(object sender, EventArgs e) { SuperMarketDataClassesDataContext db = new SuperMarketDataClassesDataContext(); var q = (from m in db.SIMS_user where m.userName == userName.Text select m); foreach (var c in q) { c.userName = userName.Text; c.userPwd = passWord.Text; if (radioButton1.Checked) { c.userSex = "男"; } else if (radioButton2.Checked) { c.userSex = "女"; } c.userPhone = phone.Text; c.note = remarks.Text; try { db.SubmitChanges(); MessageBox.Show("更新成功!"); dataGridView1.DataSource = db.SIMS_user; } catch (Exception ex) { } } }
//添加 private void button1_Click(object sender, EventArgs e) { SuperMarketDataClassesDataContext db = new SuperMarketDataClassesDataContext(); SIMS_commodity sc = new SIMS_commodity(); if (textBox7.Text != "") { sc.CId = int.Parse(textBox7.Text); sc.CName = textBox1.Text; sc.CBuyPrice = textBox2.Text; sc.CSalePrice = textBox3.Text; sc.CQty = textBox4.Text; sc.CNote = textBox5.Text; sc.CPicture = sPicture; sc.CType = comboBox1.Text; db.SIMS_commodity.InsertOnSubmit(sc); try { db.SubmitChanges(); dataGridView1.DataSource = db.SIMS_commodity; MessageBox.Show("添加成功!"); clear(); } catch (Exception ex) { } } else { MessageBox.Show("请输入添加信息!"); } }
private void add_Click(object sender, EventArgs e) { SuperMarketDataClassesDataContext db = new SuperMarketDataClassesDataContext(); SIMS_user user = new SIMS_user(); user.userName = userName.Text; user.userPwd = passWord.Text; if (radioButton1.Checked) { user.userSex = "男"; } else if (radioButton2.Checked) { user.userSex = "女"; } user.userPhone = phone.Text; user.note = remarks.Text; db.SIMS_user.InsertOnSubmit(user); try { db.SubmitChanges(); MessageBox.Show("添加成功!"); dataGridView1.DataSource = db.SIMS_user; } catch (Exception ex) { } }
public FormUserMangment() { InitializeComponent(); SuperMarketDataClassesDataContext db = new SuperMarketDataClassesDataContext(); dataGridView1.DataSource = db.SIMS_user; }
private string UserName;//当前用户 public FormInstock(string UserName1) { InitializeComponent(); this.UserName = UserName1; SuperMarketDataClassesDataContext db = new SuperMarketDataClassesDataContext(); dataGridView1.DataSource = db.SISM_console; }
private void button1_Click(object sender, EventArgs e) { SuperMarketDataClassesDataContext db = new SuperMarketDataClassesDataContext(); SISM_console sc = new SISM_console(); //查询是否存在该编号商品 var num = (from m in db.SIMS_commodity where m.CId == int.Parse(textBox1.Text) select m).Count(); //存在 if (num > 0) { //查询 var q = (from m in db.SIMS_commodity where m.CId == int.Parse(textBox1.Text) select m); foreach (var c in q) { sc.Number = textBox2.Text; int number; //存放当前库存数目 number = int.Parse(c.CQty) + int.Parse(sc.Number); c.CQty = number.ToString(); db.SubmitChanges(); label5.Text = "商品编号:" + c.CId + "\n" + "剩余库存:" + number + "\n" + "操作人:" + UserName; //添加开始 sc.CId = int.Parse(textBox1.Text); sc.Number = textBox2.Text; sc.Price = textBox3.Text; sc.Choose = "入库"; sc.UserName = UserName; db.SISM_console.InsertOnSubmit(sc); try { db.SubmitChanges(); dataGridView1.DataSource = db.SISM_console; MessageBox.Show("入库成功!"); } catch (Exception ex) { } //添加结束 clean(); } } else { MessageBox.Show("没有此编号商品!"); } }
public FormCommodityMangment() { InitializeComponent(); SuperMarketDataClassesDataContext db = new SuperMarketDataClassesDataContext(); dataGridView1.DataSource = db.SIMS_commodity; var q = (from m in db.SISM_commodityclass select m ); foreach (var c in q) { comboBox1.Items.Add(c.SName); } }
//查询 private void button3_Click(object sender, EventArgs e) { SuperMarketDataClassesDataContext db = new SuperMarketDataClassesDataContext(); if (radioButton1.Checked) { var q = (from m in db.SIMS_commodity where m.CId == int.Parse(textBox6.Text) select m); foreach (var c in q) { textBox7.Text = c.CId.ToString(); textBox1.Text = c.CName; textBox2.Text = c.CBuyPrice; textBox3.Text = c.CSalePrice; textBox4.Text = c.CQty; textBox5.Text = c.CNote; comboBox1.Text = c.CType; sPicture = c.CPicture; } } else if (radioButton2.Checked) { var q = (from m in db.SIMS_commodity where m.CName == textBox6.Text select m); foreach (var c in q) { textBox7.Text = c.CId.ToString(); textBox1.Text = c.CName; textBox2.Text = c.CBuyPrice; textBox3.Text = c.CSalePrice; textBox4.Text = c.CQty; textBox5.Text = c.CNote; comboBox1.Text = c.CType; sPicture = c.CPicture; } } else { MessageBox.Show("请选择查询条件!"); } pictureBox1.Image.Dispose(); pictureBox1.Image = Image.FromFile(sPicture); }
//更新 private void button2_Click(object sender, EventArgs e) { SuperMarketDataClassesDataContext db = new SuperMarketDataClassesDataContext(); if (textBox7.Text != "") { var q = (from m in db.SIMS_commodity where m.CId == int.Parse(textBox7.Text) select m); foreach (var c in q) { c.CId = int.Parse(textBox7.Text); c.CName = textBox1.Text; c.CBuyPrice = textBox2.Text; c.CSalePrice = textBox3.Text; c.CQty = textBox4.Text; c.CNote = textBox5.Text; c.CPicture = sPicture; c.CType = comboBox1.Text; } var num = (from m in db.SIMS_commodity where m.CId == int.Parse(textBox7.Text) select m).Count(); if (num > 0) { try { db.SubmitChanges(); MessageBox.Show("更新成功!"); dataGridView1.DataSource = db.SIMS_commodity; } catch (Exception ex) { } } } else { MessageBox.Show("请输入需更新的商品编号!"); } }
private void delete_Click(object sender, EventArgs e) { SuperMarketDataClassesDataContext db = new SuperMarketDataClassesDataContext(); var q = (from m in db.SIMS_user where m.userName == userName.Text select m); foreach (var user in q) { db.SIMS_user.DeleteOnSubmit(user); } try { db.SubmitChanges(); MessageBox.Show("删除成功!"); dataGridView1.DataSource = db.SIMS_user; } catch (Exception ex) { } }
private void button1_Click(object sender, EventArgs e) { SuperMarketDataClassesDataContext db = new SuperMarketDataClassesDataContext(); var q = (from m in db.SIMS_user where m.userName == userName.Text select m); foreach (var c in q) { userName.Text = c.userName; passWord.Text = c.userPwd; phone.Text = c.userPhone; remarks.Text = c.note; if (c.userSex == "男") { radioButton1.Checked = true; } if (c.userSex == "女") { radioButton2.Checked = true; } } }
//更新 private void button2_Click(object sender, EventArgs e) { SuperMarketDataClassesDataContext db = new SuperMarketDataClassesDataContext(); if (textBox4.Text != "") { var q = (from m in db.SISM_commodityclass where m.SId == int.Parse(textBox4.Text) select m); foreach (var c in q) { c.SId = int.Parse(textBox4.Text); c.SName = textBox2.Text; c.SNote = textBox3.Text; } var num = (from m in db.SISM_commodityclass where m.SId == int.Parse(textBox4.Text) select m).Count(); if (num > 0) { try { db.SubmitChanges(); MessageBox.Show("更新成功!"); dataGridView1.DataSource = db.SISM_commodityclass; } catch (Exception ex) { } } } else { MessageBox.Show("请输入需更新的类别编号!"); } }
//删除 private void button4_Click(object sender, EventArgs e) { SuperMarketDataClassesDataContext db = new SuperMarketDataClassesDataContext(); //id删除 if (textBox4.Text != "") { var q = (from m in db.SISM_commodityclass where m.SId == int.Parse(textBox4.Text) select m); foreach (var id in q) { db.SISM_commodityclass.DeleteOnSubmit(id); } var num = (from m in db.SISM_commodityclass where m.SId == int.Parse(textBox4.Text) select m).Count(); if (num > 0) { try { db.SubmitChanges(); MessageBox.Show("删除成功!"); dataGridView1.DataSource = db.SISM_commodityclass; clear(); } catch (Exception ex) { } } else { MessageBox.Show("没有此类别号的商品!"); } } else if (textBox2.Text != "") { //根据名称删除 var p = (from m in db.SISM_commodityclass where m.SName == textBox2.Text select m); foreach (var name in p) { db.SISM_commodityclass.DeleteOnSubmit(name); } var num = (from m in db.SISM_commodityclass where m.SName == textBox2.Text select m).Count(); if (num > 0) { try { db.SubmitChanges(); MessageBox.Show("删除成功!"); dataGridView1.DataSource = db.SISM_commodityclass; clear(); } catch (Exception ex) { } } else { MessageBox.Show("没有此类别的商品!"); } } else { MessageBox.Show("请输入删除条件"); } }