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