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("请输入删除条件");
}
}
