public void XoaDonVi(string madonvi) { string query = "XoaDonVi"; string[] para = { "@maDonVi" }; string[] value = { madonvi }; connection Connection = new connection(); Connection.Excute_Sql_Node(query, CommandType.StoredProcedure, para, value, showResultDeleteFromSql); }
public void ChinhSuaDonVi(string madonvi, string tendonvi, string duongdananh) { string query = "ChinhSuaDonVi"; string[] para = { "@maDonVi", "@tenDonVi", "@duongDanAnh" }; string[] value = { madonvi, tendonvi, duongdananh }; connection Connection = new connection(); Connection.Excute_Sql_Node(query, CommandType.StoredProcedure, para, value, showResultChangeDVFromSql); }
public void XoaBinhChung(string mabinhchung) { string query = "XoaBinhChung"; string[] para = { "@maBinhChung" }; string[] value = { mabinhchung }; connection Connection = new connection(); Connection.Excute_Sql_Node(query, CommandType.StoredProcedure, para, value, showResultDeleteFromSql); }
public void ThemDonVi(string madonvi, string tendonvi, string duongdananh, string mabinhchung) { string query = "ThemDonVi"; string[] para = { "@maDonVi", "@tenDonVi", "@duongDanAnh", "@maBinhChung" }; string[] value = { madonvi, tendonvi, duongdananh, mabinhchung }; connection Connection = new connection(); Connection.Excute_Sql_Node(query, CommandType.StoredProcedure, para, value, showResultFromSql); }
public void ChinhSuaBinhChung(string s1, string s2) { string query = "ChinhSuaBinhChung"; string[] para = { "@maBinhChung", "@tenBinhChung" }; string[] value = { s1, s2 }; connection Connection = new connection(); Connection.Excute_Sql_Node(query, CommandType.StoredProcedure, para, value, showResultChangeBCFromSql); }