public List <HangTonKho> GetHangTonKho(string sql)
{
dp.connect();
List <HangTonKho> list = new List <HangTonKho>();
{
int thang, nam, thoigiantonkho;
string maxe;
try
{
SqlDataReader dr = dp.ExecuteReader(sql);
while (dr.Read())
{
thang = dr.GetInt32(0);
nam = dr.GetInt32(1);
maxe = dr.GetString(2);
thoigiantonkho = dr.GetInt32(3);
HangTonKho em = new HangTonKho(thang, nam, maxe, thoigiantonkho);
list.Add(em);
}
dr.Close();
return(list);
}
catch (SqlException ex)
{
throw ex;
}
finally { dp.disconnect(); }
}
}
private void HTKbtn_Click(object sender, EventArgs e)
{
DetailPanel.Controls.Clear();
if (hangtonkho == null)
{
hangtonkho = new HangTonKho();
}
DetailPanel.Controls.Add(hangtonkho);
}
public int Add(HangTonKho emp)
{
//ktra rang buoc tự nhiên
if (emp.Thang == 0 || emp.Nam == 0)
{
return(-2); // khong thanh cong se return -2, thành công sẽ return 1 trong DataProvider
}
try
{
return(new HangTonKhoDAO().Add(emp));
}
catch (SqlException ex)
{
throw ex;
}
}
public int Add(HangTonKho emp)
{
List <SqlParameter> paras = new List <SqlParameter>();
paras.Add(new SqlParameter("@thang", emp.Thang));
paras.Add(new SqlParameter("@nam", emp.Nam));
paras.Add(new SqlParameter("@maxe", emp.MaXe));
paras.Add(new SqlParameter("@thoigiantonkho", emp.ThoiGianTonKho));
try
{
return(dp.ExcuteNonQuery("ThemHangTonKho", System.Data.CommandType.StoredProcedure, paras));
// " ten thu tuc " , loại , danh sach
}
catch (SqlException ex)
{
throw ex;
}
}
private void btThem_Click(object sender, EventArgs e)
{
string maxe;
int thang, nam, thoigiantonkho;
thang = int.Parse(txtThang.Text.Trim());
nam = int.Parse(txtNam.Text.Trim());
maxe = txtMaXe.Text.Trim();
thoigiantonkho = int.Parse(txtThoiGianTonKho.Text.Trim());
HangTonKho emp = new HangTonKho(thang, nam, maxe, thoigiantonkho);
try
{
int i = new HangTonKhoBUS().Add(emp);
dgvHangTonKho.DataSource = GetHangTonKho();
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message);
}
}
