public int UpdateCacLoaiVang(CacLoaiVangDTO _cacLoaiVangDTO)
{
List <SqlParameter> paramlist = new List <SqlParameter>();
SqlParameter item = new SqlParameter();
item = new SqlParameter("@MaCacLoaiVang", SqlDbType.Int)
{
Value = _cacLoaiVangDTO.MaCacLoaiVang
};
paramlist.Add(item);
item = new SqlParameter("@MoTa", SqlDbType.NVarChar)
{
Value = _cacLoaiVangDTO.MoTa.Replace("'", "''")
};
paramlist.Add(item);
item = new SqlParameter("@KyHieu", SqlDbType.NVarChar)
{
Value = _cacLoaiVangDTO.KyHieu.Replace("'", "''")
};
paramlist.Add(item);
item = new SqlParameter("@SuDung", SqlDbType.Bit)
{
Value = _cacLoaiVangDTO.SuDung
};
paramlist.Add(item);
return(this.dbHelper.ExecuteNonQuery("CACLOAIVANG_update", paramlist));
}
public DataTable CacLoaiVang_getByMaCacLoaiVang(CacLoaiVangDTO _cacLoaiVangDTO)
{
List <SqlParameter> sqlParams = new List <SqlParameter> {
new SqlParameter("@MaCacLoaiVang", _cacLoaiVangDTO.MaCacLoaiVang)
};
return(base.executeNonQuerya("CacLoaiVang_get", sqlParams));
}
public void XoaCacLoaiVang(CacLoaiVangDTO _cacLoaiVangDTO)
{
List <SqlParameter> sqlParams = new List <SqlParameter> {
new SqlParameter("@MaCacLoaiVang", _cacLoaiVangDTO.MaCacLoaiVang)
};
base.Procedure("CACLOAIVANG_delete", sqlParams);
}
public void ThemCacLoaiVang(CacLoaiVangDTO _cacLoaiVangDTO)
{
List <SqlParameter> sqlParams = new List <SqlParameter> {
new SqlParameter("@MaCacLoaiVang", _cacLoaiVangDTO.MaCacLoaiVang),
new SqlParameter("@MoTa", _cacLoaiVangDTO.MoTa),
new SqlParameter("@KyHieu", _cacLoaiVangDTO.KyHieu),
new SqlParameter("@SuDung", _cacLoaiVangDTO.SuDung)
};
base.Procedure("CACLOAIVANG_add", sqlParams);
}
public ArrayList loadCacLoaiVangLenCombobox()
{
SqlDataReader reader = this.dbHelper.ExecuteQuery("CACLOAIVANG_getall");
ArrayList list = new ArrayList();
while (reader.Read())
{
CacLoaiVangDTO gdto = new CacLoaiVangDTO(reader.GetString(0), reader.GetString(1), reader.GetString(2), reader.GetBoolean(3));
list.Add(gdto);
}
reader.Close();
return(list);
}
public void Xoa_CacLoaiVang(CacLoaiVangDTO _cacLoaiVangDTO)
{
this._cacLoaiVangDAL.XoaCacLoaiVang(_cacLoaiVangDTO);
}
public bool UpdateCacLoaiVang(CacLoaiVangDTO _cacLoaiVangDTO)
{
return(this._cacLoaiVangDAL.UpdateCacLoaiVang(_cacLoaiVangDTO) > 0);
}
public void Them_CacLoaiVang(CacLoaiVangDTO _cacLoaiVangDTO)
{
this._cacLoaiVangDAL.ThemCacLoaiVang(_cacLoaiVangDTO);
}
public void Sua_CacLoaiVang(CacLoaiVangDTO _cacLoaiVangDTO)
{
this._cacLoaiVangDAL.SuaCacLoaiVang(_cacLoaiVangDTO);
}
public bool InsertCacLoaiVang(CacLoaiVangDTO _cacLoaiVangDTO)
{
return(this._cacLoaiVangDAL.InsertCacLoaiVang(_cacLoaiVangDTO) > 0);
}
public DataTable CacLoaiVangGetByMaCacLoaiVang(CacLoaiVangDTO _cacLoaiVangDTO)
{
return(this._cacLoaiVangDAL.CacLoaiVang_getByMaCacLoaiVang(_cacLoaiVangDTO));
}
