public static void SuaHDB(DTO_HDB hdb)
{
SqlCommand cmd = new SqlCommand("sp_suaHDB", DataProvider.con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@mahdb", SqlDbType.VarChar, 50);
cmd.Parameters.Add("@manv", SqlDbType.VarChar, 50);
cmd.Parameters.Add("@makh", SqlDbType.VarChar, 50);
cmd.Parameters.Add("@ngaylaphd", SqlDbType.DateTime, 50);
cmd.Parameters.Add("@sl", SqlDbType.VarChar, 100);
cmd.Parameters.Add("@tongtien", SqlDbType.VarChar, 100);
cmd.Parameters.Add("@hinhthuctt", SqlDbType.NVarChar, 100);
cmd.Parameters.Add("@dathanhtoan", SqlDbType.VarChar, 100);
cmd.Parameters.Add("@conno", SqlDbType.NVarChar, 100);
//Gan gia tri
cmd.Parameters["@mahdb"].Value = hdb.Mahbd;
cmd.Parameters["@manv"].Value = hdb.Manv;
cmd.Parameters["@makh"].Value = hdb.Makh;
cmd.Parameters["@ngaylaphd"].Value = hdb.Ngaylaphd;
cmd.Parameters["@sl"].Value = hdb.Sl;
cmd.Parameters["@tongtien"].Value = hdb.Tongtien;
cmd.Parameters["@hinhthuctt"].Value = hdb.Hinhthuctt;
cmd.Parameters["@dathanhtoan"].Value = hdb.Dathanhtoan;
cmd.Parameters["@conno"].Value = hdb.Conno;
if (DataProvider.con.State == ConnectionState.Closed)
{
DataProvider.con.Open();
}
cmd.ExecuteNonQuery();
DataProvider.disconnect();
}
public static void suaHDB(DTO_HDB hdb)
{
DAO_HDB.SuaHDB(hdb);
}
public static void themHDB(DTO_HDB hdb)
{
DAO_HDB.ThemHDB(hdb);
}
