public int XoaDuLieu(EC_tblChiNhanh et)
{
return(sql.XoaDuLieu(et));
}
public int ThemDuLieu(EC_tblChiNhanh et)
{
return(sql.ThemDuLieu(et));
}
public int SuaDuLieu(EC_tblChiNhanh et)
{
return(sql.SuaDuLieu(et));
}
public string XoaDuLieu_CoThongBao(EC_tblChiNhanh et)
{
return(sql.XoaDuLieu_CoThongBao(et));
}
public string XoaDuLieu_CoThongBao(EC_tblChiNhanh et)
{
return(cn.ThucThiCauLenhSQL_CoThongBao(@"DELETE FROM tblChiNhanh where MaCN=N'" + et.MaCN + "'"));
}
public int XoaDuLieu(EC_tblChiNhanh et)
{
return(cn.ThucThiCauLenhSQL(@"DELETE FROM tblChiNhanh where MaCN=N'" + et.MaCN + "'"));
}
public int SuaDuLieu(EC_tblChiNhanh et)
{
return(cn.ThucThiCauLenhSQL(@"UPDATE tblChiNhanh SET TenCN =N'" + et.TenCN + "', DiaChi =N'" + et.DiaChi + "', SDT ='" + et.SDT + "' where MaNC= '" + et.MaCN + "'"));
}
public int ThemDuLieu(EC_tblChiNhanh et)
{
return(cn.ThucThiCauLenhSQL(@"INSERT INTO tblChiNhanh (MaCN,TenCN,DiaChi,SDT)
VALUES(N'" + et.MaCN + "', N'" + et.TenCN + "',N'" + et.DiaChi + "', " + et.SDT + ")"));
}
