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