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