private void buttonX_Add_Click(object sender, EventArgs e)
{
HienthiCTdathang();
if (c2.sosanhMSP(textBoxX_msp.Text.Trim())) //neu msp da ton tai thuc hien add
{
if (nh != null)
{
SP s = new SP();
s = s.SetSP(textBoxX_msp.Text, int.Parse(textBoxX_soluong.Text));
SP sp = nh.AddSP(s);
DataRow dr = DtableMuahang.NewRow();
dr["msp"] = sp.GetMSP();
dr["tensp"] = sp.GetTensp();
dr["giamua"] = sp.GetGiaMua();
dr["slnhap"] = sp.GetSoluong();
dr["thanhtien"] = sp.GetThanhtien();
DtableMuahang.Rows.Add(dr);
deleteRow(dataGridViewX1, "Column_msp");
}
}
else
{
MessageBox.Show("Hãy thêm Sp mới vào");
frSanpham frsp = new frSanpham();
frsp.Show();
}
}
public Boolean InsertSP(SP s)
{
connect();
if (con.State == ConnectionState.Closed)
{
con.Open();
}
try
{
SqlCommand insert_sp = new SqlCommand("INSERT_SANPHAM", con);
insert_sp.Parameters.Add("@MSP", SqlDbType.Char, 10).Value = s.GetMSP();
insert_sp.Parameters.Add("@ML", SqlDbType.Char, 10).Value = s.GetML();
insert_sp.Parameters.Add("@MNSX", SqlDbType.Char, 10).Value = s.GetMNSX();
insert_sp.Parameters.Add("@TENSP", SqlDbType.VarChar).Value = s.GetTensp();
// insert_sp.Parameters.Add("@HSD", SqlDbType.DateTime).Value = s.GetHSD();
insert_sp.Parameters.Add("@DVT", SqlDbType.Char, 10).Value = s.GetDVT();
insert_sp.Parameters.Add("@GIAMUA", SqlDbType.Money).Value = s.GetGiaMua();
insert_sp.Parameters.Add("@GIABAN", SqlDbType.Money).Value = s.GetGiaban();
insert_sp.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
return(false);
}
finally
{
con.Dispose();
}
}
private void buttonX_add_Click(object sender, EventArgs e)
{
if (dh == null)
{
MessageBox.Show("Ban phai dien thong tin phieu dat hang truoc ");
}
else
{
SP s = new SP(textBoxX_msp.Text, int.Parse(textBoxX_sl.Text));
if (s.GetStatus() == 0)//san pham la ok
{
SP sp = dh.AddSP(s);
///
HienthiCTdathang();
DataRow dr = DtableMuahang.NewRow();
dr["msp"] = sp.GetMSP();
dr["tensp"] = sp.GetMSP();
dr["gia"] = sp.GetGiaban();
dr["sl"] = sp.GetSoluong();// textBoxX_soluong.Text;//Int32.Parse(textBoxX_sl.Text.ToString());
dr["thanhtien"] = sp.GetThanhtien();
DtableMuahang.Rows.Add(dr);
//MessageBox.Show("xoa");
deleteRow(dataGridViewX1, "ColumnMsp");
}
}
}
private void buttonX_add_Click(object sender, EventArgs e)
{
if (hd == null)
{
MessageBox.Show("Ban phai lap phieu mua truoc");
}
else
{
hd.SetMKH(textBoxX_makh3.Text);// yes or no
SP s = new SP(textBoxX_msp.Text, int.Parse(textBoxX_soluong.Text));
if (s.GetStatus() == 0) //san pham la ok
{
SP sp = hd.AddSP(s); //them moi san pham !! kiem tra san pham bi trungs
HienthiCTmuahang();
DataRow dr = DtableMuahang.NewRow();
dr["msp"] = sp.GetMSP();
dr["tensp"] = sp.GetMSP();
dr["gia"] = sp.GetGiaban();
dr["sl"] = sp.GetSoluong();// textBoxX_soluong.Text;//Int32.Parse(textBoxX_sl.Text.ToString());
dr["thanhtien"] = sp.GetThanhtien();
DtableMuahang.Rows.Add(dr);
deleteRow(dataGridViewX1, "ColumnMsp");
}
}
}
private void DuyetGridView2()
{
foreach (DataGridViewRow dr in dataGridViewX2.Rows)
{
String s2 = dr.Cells["Cl_msp"].Value.ToString();
int s4 = int.Parse(dr.Cells["Cl_soluong"].Value.ToString());
SP sp = new SP(s2, s4);
hd.AddSP(sp);
}
}
public SP AddSP(SP s) //san pham da ton tai
{
foreach (SP ss in sp)
{
if (s.GetMSP().Equals(ss.GetMSP()))
{
// MessageBox.Show(s.GetMSP());
ss.SetSoluong(s.GetSoluong() + ss.GetSoluong());
ss.SetThanhtien(ss.GetSoluong(), ss.GetGiaban());
return(ss);
}
}
sp.Add(s);
return(s);
}
