public static void SuaNQH(DTO_NQH nqh)
{
SqlCommand cmd = new SqlCommand("sp_suaNQH", DataProvider.con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@manqh", SqlDbType.VarChar, 50);
cmd.Parameters.Add("@tennqh", SqlDbType.NVarChar, 500);
cmd.Parameters.Add("@mota", SqlDbType.NVarChar, 500);
cmd.Parameters.Add("@danhmuctc", SqlDbType.NVarChar, 500);
cmd.Parameters.Add("@quyendm", SqlDbType.NVarChar, 500);
//Gan gia tri
cmd.Parameters["@manqh"].Value = nqh.Manqh;
cmd.Parameters["@tennqh"].Value = nqh.Tennqh;
cmd.Parameters["@mota"].Value = nqh.Mota;
cmd.Parameters["@danhmuctc"].Value = nqh.Danhmuctc;
cmd.Parameters["@quyendm"].Value = nqh.Quyendm;
if (DataProvider.con.State == ConnectionState.Closed)
{
DataProvider.con.Open();
}
cmd.ExecuteNonQuery();
DataProvider.disconnect();
}
public static void suaNQH(DTO_NQH nqh)
{
DAO_NQH.SuaNQH(nqh);
}
public static void themNQH(DTO_NQH nqh)
{
DAO_NQH.Themnqh(nqh);
}
