/// <summary> /// Lấy danh sách Hàng hóa trong Kho theo Khóa phụ /// </summary> /// <param name="FK_iNhomhangID">Mã Nhóm hàng</param> /// <returns>List<tblHanghoa></returns> public List <tblHanghoa> tblHanghoa_SelectByFK(int FK_iNhomhangID) { List <tblHanghoa> listKho = new List <tblHanghoa>(); using (SqlConnection cnn = new SqlConnection(connectionString)) { using (SqlCommand cmd = new SqlCommand("sp_tblHanghoa_SelectByFK", cnn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@FK_iNhomhangID", FK_iNhomhangID); cnn.Open(); using (SqlDataReader rd = cmd.ExecuteReader()) { if (rd.HasRows) { while (rd.Read()) { tblHanghoa hanghoa = new tblHanghoa(); hanghoa.iHanghoaID = Convert.ToInt32(rd["PK_iHanghoaID"].ToString()); hanghoa.iNhomhangID = Convert.ToInt32(rd["FK_iNhomhangID"].ToString()); hanghoa.sTenHanghoa = rd["sTenHanghoa"].ToString(); hanghoa.sNhacungcap = rd["sNhacungcap"].ToString(); hanghoa.iSoluong = Convert.ToInt32(rd["iSoluong"].ToString()); hanghoa.iDongia = Convert.ToInt32(rd["iDongia"].ToString()); hanghoa.iThoigianbaohanh = Convert.ToInt32(rd["iThoigianbaohanh"].ToString()); listKho.Add(hanghoa); } rd.Close(); } cnn.Close(); return(listKho); } } } }
private void buttonMua_Click(object sender, EventArgs e) { //if (!string.IsNullOrEmpty(txtSoluongban.Text.Trim())) //{ // if (Convert.ToInt32(txtSoluongban.Text.Trim()) > hanghoa[0].iSoluong) // { // MessageBox.Show("Kho không đủ hàng! Chỉ còn: " + hanghoa[0].iSoluong); // return; // } // else // { // errorProviderSoluongban.Clear(); // } //} int kiemtramuahang = 0; DataRow dataRow = table.NewRow(); tblHanghoa hb = new tblHanghoa(); hb = hanghoa[0]; // lấy thông tin hàng hóa vừa nhập dataRow["iHanghoaID"] = hb.iHanghoaID; dataRow["iNhomhangID"] = hb.iNhomhangID; dataRow["sTenNhomhang"] = new XuLy_tblNhomhang().tblNhomhang_Select(hb.iNhomhangID)[0].sTenNhomhang; dataRow["sTenHanghoa"] = hb.sTenHanghoa; dataRow["sNhacungcap"] = hb.sNhacungcap; dataRow["iThoigianbaohanh"] = hb.iThoigianbaohanh; dataRow["iDongia"] = hb.iDongia; dataRow["iSoluongban"] = txtSoluongban.Text.Trim(); dataRow["iThanhtien"] = (Convert.ToInt32(dataRow["iDongia"]) * Convert.ToInt32(dataRow["iSoluongban"])).ToString(); //foreach (DataRow r in table.Rows) //{ // if (Convert.ToInt32(r["iHanghoaID"]) == hb.iHanghoaID) // { // r["iSoluongban"] = Convert.ToInt32(r["iSoluongban"]) + Convert.ToInt32(txtSoluongban.Text.Trim()); // r["iThanhtien"] = Convert.ToInt32(r["iDongia"]) * Convert.ToInt32(r["iSoluongban"]); // kiemtramuahang++; // } //} if (kiemtramuahang == 0) { table.Rows.Add(dataRow); } dataGridViewtblHangban.DataSource = table; TinhTongtien(); txtHanghoaID.Clear(); txtSoluongban.Clear(); }
/// <summary> /// Cập nhật Hàng hóa trong Kho /// </summary> /// <param name="hanghoa">tblHanghoa</param> /// <returns>bool</returns> public bool tblHanghoa_Update(tblHanghoa hanghoa) { using (SqlConnection cnn = new SqlConnection(connectionString)) { using (SqlCommand cmd = new SqlCommand("sp_tblHanghoa_Update", cnn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@PK_iHanghoaID", hanghoa.iHanghoaID); cmd.Parameters.AddWithValue("@FK_iNhomhangID", hanghoa.iNhomhangID); cmd.Parameters.AddWithValue("@sTenHanghoa", hanghoa.sTenHanghoa); cmd.Parameters.AddWithValue("@sNhacungcap", hanghoa.sNhacungcap); cmd.Parameters.AddWithValue("@iSoluong", hanghoa.iSoluong); cmd.Parameters.AddWithValue("@iDongia", hanghoa.iDongia); cmd.Parameters.AddWithValue("@iThoigianbaohanh", hanghoa.iThoigianbaohanh); cnn.Open(); int i = cmd.ExecuteNonQuery(); cnn.Close(); return(i > 0); } } }