public DataTable CreateTbDVT(EC_DonViTinh _dvt)
{
string sqlquery = "SELECT * FROM tb_Donvitinh where madonvi like N'%{0}%' and tendonvi like N'%{1}%'";
sqlquery = string.Format(sqlquery, _dvt.MaDonViTinh, _dvt.TenDonViTinh);
return(Connect.CreateTable(sqlquery));
}
public void AddDonViTinh(EC_DonViTinh _donvi)
{
if (!sqldonvi.CheckDonViTinh(_donvi.MaDonViTinh))
{
sqldonvi.AddDonViTinh(_donvi);
}
else
{
MessageBox.Show("Mã này đã tồn tại,xin chọn Mã khác", "Chú Ý", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
public void AddDonViTinh(EC_DonViTinh _newdonvi)
{
try
{
Connect.SqlConnect.Open();
string sqlquery = @"INSERT INTO tb_Donvitinh
(madonvi, tendonvi)
VALUES (N'{0}',N'{1}')" ;
sqlquery = string.Format(sqlquery, _newdonvi.MaDonViTinh, _newdonvi.TenDonViTinh);
SqlCommand cmd = new SqlCommand(sqlquery, Connect.SqlConnect);
cmd.ExecuteNonQuery();
Connect.SqlConnect.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void UpdateDonViTinh(EC_DonViTinh _donvi)
{
try
{
Connect.SqlConnect.Open();
string sqlquery = @"UPDATE tb_Donvitinh
SET tendonvi =N'{0}' where madonvi =N'{1}'" ;
string.Format(sqlquery, _donvi.TenDonViTinh, _donvi.MaDonViTinh);
SqlCommand cmd = new SqlCommand(sqlquery, Connect.SqlConnect);
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
Connect.SqlConnect.Close();
}
}
public void DeleteDonViTinh(EC_DonViTinh _donvi)
{
Connect.ExcuteNonQuery("DELETE FROM [tb_Donvitinh] WHERE madonvi=N'" + _donvi.MaDonViTinh + "'");
}
public void DeleteDonViTinh(EC_DonViTinh _donvi)
{
sqldonvi.DeleteDonViTinh(_donvi);
}
public void UpdateDonViTinh(EC_DonViTinh _donvi)
{
sqldonvi.UpdateDonViTinh(_donvi);
}
public DataTable CreateTbDVT(EC_DonViTinh _dvt)
{
return(sqldonvi.CreateTbDVT(_dvt));
}
