//---------------------------------------------------------------------------------------------------------//
private static ESANPHAM GetOneSANPHAM(IDataReader idr)
{
ESANPHAM OSANPHAM = new ESANPHAM();
if (idr["MASP"] != DBNull.Value)
{
OSANPHAM.MASP = (string)idr["MASP"];
}
if (idr["TENSP"] != DBNull.Value)
{
OSANPHAM.TENSP = (string)idr["TENSP"];
}
if (idr["MAL"] != DBNull.Value)
{
OSANPHAM.MAL = (string)idr["MAL"];
}
if (idr["DONGIA"] != DBNull.Value)
{
OSANPHAM.DONGIA = (float)idr["DONGIA"];
}
if (idr["MOTA"] != DBNull.Value)
{
OSANPHAM.MOTA = (string)idr["MOTA"];
}
return(OSANPHAM);
}
public static void Update(ESANPHAM OSANPHAM)
{
SqlParameter[] pr = new SqlParameter[5];
pr[0] = new SqlParameter(@"MASP", OSANPHAM.MASP);
pr[1] = new SqlParameter(@"TENSP", OSANPHAM.TENSP);
pr[2] = new SqlParameter(@"MAL", OSANPHAM.MAL);
pr[3] = new SqlParameter(@"DONGIA", OSANPHAM.DONGIA);
pr[4] = new SqlParameter(@"MOTA", OSANPHAM.MOTA);
SqlHelper.ExecuteNonQuery(CommandType.StoredProcedure, "SANPHAM_Update", pr);
}
//---------------------------------------------------------------------------------------------------------//
public static void Insert(ESANPHAM OSANPHAM)
{
SqlParameter[] pr = new SqlParameter[5];
pr[0] = new SqlParameter(@"MASP", OSANPHAM.MASP);
pr[1] = new SqlParameter(@"TENSP", OSANPHAM.TENSP);
pr[2] = new SqlParameter(@"MAL", OSANPHAM.MAL);
pr[3] = new SqlParameter(@"DONGIA", OSANPHAM.DONGIA);
pr[4] = new SqlParameter(@"MOTA", OSANPHAM.MOTA);
DataAccseL.ExecuteNonQuery(CommandType.StoredProcedure, "SANPHAM_Insert", pr);
}
private void btnSua_Click(object sender, EventArgs e)
{
ESANPHAM esp = new ESANPHAM();
esp.MASP = txtma.Text.Trim();
esp.TENSP = txtten.Text.Trim();
esp.MAL = txtmal.Text.Trim();
esp.DONGIA = float.Parse(txtgia.Text.Trim());
esp.MOTA = txtmota.Text.Trim();
BSANPHAM.Update(esp);
FormSanPham_Load(sender, e);
}
public static ESANPHAM SelectByID(string MASP)
{
ESANPHAM OSANPHAM = new ESANPHAM();
SqlParameter[] pr = new SqlParameter[1];
pr[0] = new SqlParameter(@"MASP", MASP);
IDataReader idr = SqlHelper.ExecuteReader(CommandType.StoredProcedure, "SANPHAM_SelectByID", pr);
if (idr.Read())
{
OSANPHAM = GetOneSANPHAM(idr);
}
idr.Close();
idr.Dispose();
return(OSANPHAM);
}
