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