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