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